首页 > 代码库 > PA 项目创建任务
PA 项目创建任务
---- 创建任务 DECLARE p_project_id NUMBER := 155233; p_task_number VARCHAR2(240) := 'CXYTEST0001'; p_task_name VARCHAR2(240) := '接口测试CXYTEST0001'; p_task_description VARCHAR2(240) := 'TASKCXYTEST0001'; p_scheduled_start_date DATE := SYSDATE + 1; p_scheduled_finish_date DATE := SYSDATE + 10; P_PARENT_TASK_ID NUMBER := 244637; -- x_return_status VARCHAR2(240); x_msg_count NUMBER; x_msg_data VARCHAR2(30000); x_project_id NUMBER; x_project_number VARCHAR2(240); x_task_id NUMBER; l_msg_index NUMBER; BEGIN fnd_global.apps_initialize(user_id => 0 ,resp_id => 52998 ,resp_appl_id => 275); mo_global.init('M'); pa_project_pub.add_task(p_api_version_number => 1.0 ,p_init_msg_list => 'T' ,p_msg_count => x_msg_count ,p_msg_data => x_msg_data ,p_return_status => x_return_status ,p_pm_product_code => NULL ,p_pa_project_id => p_project_id ,p_pm_task_reference => p_task_number ,p_pa_task_number => p_task_number ,p_task_name => p_task_name ,p_task_description => p_task_description ,p_scheduled_start_date => p_scheduled_start_date ,p_scheduled_finish_date => p_scheduled_finish_date ,p_pa_parent_task_id => p_parent_task_id ,p_pa_project_id_out => x_project_id ,p_pa_project_number_out => x_project_number ,p_task_id => x_task_id); dbms_output.put_line('x_project_id: ' || x_project_id); dbms_output.put_line('x_project_number: ' || x_project_number); dbms_output.put_line('x_task_id: ' || x_task_id); dbms_output.put_line('x_msg_data: ' || x_msg_data); dbms_output.put_line('x_return_status: ' || x_return_status); dbms_output.put_line('x_msg_count: ' || x_msg_count); FOR i IN 1 .. fnd_msg_pub.count_msg LOOP fnd_msg_pub.get(p_msg_index => i ,p_encoded => fnd_api.g_false ,p_data => x_msg_data ,p_msg_index_out => l_msg_index); dbms_output.put_line('x_msg_data: ' || x_msg_data); END LOOP; END;
PA 项目创建任务
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。