[Home] [Help]
95: li_return_message varchar2(200);
96:
97: ----------- res assignment --------------------------------
98:
99: c_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
100: u_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
101:
102: c_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
96:
97: ----------- res assignment --------------------------------
98:
99: c_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
100: u_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
101:
102: c_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
98:
99: c_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
100: u_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
101:
102: c_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
99: c_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
100: u_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
101:
102: c_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
100: u_res_currency_code PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
101:
102: c_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
101:
102: c_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
102: c_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
103: c_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
104: c_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
105: c_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
106: c_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
107: c_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
115: c_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
108: c_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
115: c_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
116: c_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
109: c_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
115: c_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
116: c_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
117: c_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
110: c_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
115: c_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
116: c_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
117: c_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
118:
111: c_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
115: c_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
116: c_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
117: c_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
118:
119: c_res_counter number;
112: c_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
115: c_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
116: c_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
117: c_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
118:
119: c_res_counter number;
120:
113: c_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
114: c_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
115: c_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
116: c_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
117: c_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
118:
119: c_res_counter number;
120:
121:
118:
119: c_res_counter number;
120:
121:
122: u_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
123: u_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
124: u_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
119: c_res_counter number;
120:
121:
122: u_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
123: u_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
124: u_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
120:
121:
122: u_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
123: u_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
124: u_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
121:
122: u_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
123: u_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
124: u_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
122: u_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
123: u_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
124: u_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
123: u_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
124: u_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
124: u_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
125: u_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
126: u_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
127: u_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
135: u_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
128: u_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
135: u_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
136: u_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
129: u_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
135: u_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
136: u_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
137: u_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
130: u_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
135: u_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
136: u_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
137: u_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
138:
131: u_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
135: u_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
136: u_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
137: u_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
138:
139: u_res_counter number;
132: u_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
135: u_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
136: u_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
137: u_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
138:
139: u_res_counter number;
140:
133: u_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
134: u_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
135: u_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
136: u_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
137: u_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
138:
139: u_res_counter number;
140:
141:
149: l_del_res_msg_data varchar2(2000);
150:
151: -- out variable ----
152:
153: o_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
154: o_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
155: o_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
156: o_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
157: o_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
150:
151: -- out variable ----
152:
153: o_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
154: o_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
155: o_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
156: o_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
157: o_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
158: o_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
151: -- out variable ----
152:
153: o_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
154: o_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
155: o_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
156: o_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
157: o_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
158: o_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
159: o_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
152:
153: o_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
154: o_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
155: o_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
156: o_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
157: o_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
158: o_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
159: o_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
160:
153: o_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
154: o_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
155: o_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
156: o_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
157: o_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
158: o_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
159: o_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
160:
161:
154: o_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
155: o_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
156: o_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
157: o_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
158: o_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
159: o_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
160:
161:
162: ou_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
155: o_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
156: o_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
157: o_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
158: o_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
159: o_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
160:
161:
162: ou_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
163: ou_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
158: o_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
159: o_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
160:
161:
162: ou_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
163: ou_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
164: ou_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
165: ou_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
166: ou_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
159: o_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
160:
161:
162: ou_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
163: ou_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
164: ou_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
165: ou_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
166: ou_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
167: ou_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
160:
161:
162: ou_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
163: ou_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
164: ou_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
165: ou_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
166: ou_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
167: ou_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
168: ou_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
161:
162: ou_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
163: ou_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
164: ou_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
165: ou_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
166: ou_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
167: ou_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
168: ou_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
169:
162: ou_task_asgmt_index pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
163: ou_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
164: ou_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
165: ou_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
166: ou_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
167: ou_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
168: ou_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
169:
170: type num_tbl_c is table of number index by varchar2(30);
163: ou_pm_task_asgmt_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
164: ou_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
165: ou_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
166: ou_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
167: ou_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
168: ou_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
169:
170: type num_tbl_c is table of number index by varchar2(30);
171: type num_tbl is table of number index by binary_integer;
164: ou_pa_task_assignment_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
165: ou_pm_task_reference pa_vc_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
166: ou_pa_task_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
167: ou_resource_alias pa_vc_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
168: ou_resource_list_member_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
169:
170: type num_tbl_c is table of number index by varchar2(30);
171: type num_tbl is table of number index by binary_integer;
172: type var_tbl is table of varchar2(30) index by binary_integer;
198: IS
199: select org_id from pa_projects_all where project_id = c_project_id;
200:
201: -- Added for CBS, it is just a place holder , as Primavera does not support CBS 16598322
202: o_cbs_element_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
203: BEGIN
204:
205: log_pvt('MAIN', 'START INTEGRATION p_sync_mode : '|| p_sync_mode);
206:
321:
322: IF ( li_return_status = 'S' ) THEN
323: BEGIN
324:
325: IF ( nvl(L_PROJECT_IN_REC.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
326: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
327:
328: /* COMMIT_ISSUE Start Change */
329: if ( p_sync_mode <> 'D') then
322: IF ( li_return_status = 'S' ) THEN
323: BEGIN
324:
325: IF ( nvl(L_PROJECT_IN_REC.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
326: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
327:
328: /* COMMIT_ISSUE Start Change */
329: if ( p_sync_mode <> 'D') then
330: /* COMMIT_ISSUE End Change */
493: if ( x_msg_count > 10 ) then
494: x_msg_count := 10;
495: end if;
496: for i in 1..x_msg_count loop
497: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
498: ,p_msg_index => x_msg_count
499: ,p_data => l_data
500: ,p_msg_index_out => l_msg_index_out
501: );
784: --L_PROJECT_OUT_OBJ.msg_data := 'PA_PLAN_MC_NOT_ENABLED';
785: --RAISE;
786: for i in 1..x_msg_count loop
787:
788: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
789: ,p_msg_index => x_msg_count
790: ,p_data => l_data
791: ,p_msg_index_out => l_msg_index_out
792: );
811: for i in g_res_pm_project_reference.first .. g_res_pm_project_reference.last loop
812:
813: /******* Bug 10077151 changes start ******************/
814:
815: if (nvl(g_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
816: <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
817:
818: select count(*) into t_crt_count
819: from pa_resource_assignments
812:
813: /******* Bug 10077151 changes start ******************/
814:
815: if (nvl(g_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
816: <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
817:
818: select count(*) into t_crt_count
819: from pa_resource_assignments
820: where resource_assignment_id = g_res_pa_task_assignment_id(i);
832: /******* Bug 10077151 changes end *******************/
833:
834: log_pvt('MAIN','LOOP : g_res_pa_task_assignment_id(i) '||g_res_pa_task_assignment_id(i));
835:
836: if ( nvl(g_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
837: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
838:
839: c_res_counter := c_res_counter + 1;
840:
833:
834: log_pvt('MAIN','LOOP : g_res_pa_task_assignment_id(i) '||g_res_pa_task_assignment_id(i));
835:
836: if ( nvl(g_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
837: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
838:
839: c_res_counter := c_res_counter + 1;
840:
841: c_res_currency_code.extend(1);
902: end if;
903:
904: log_pvt('MAIN',' After Create If ');
905:
906: if ( nvl(g_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
907: <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
908:
909:
910: u_res_counter := u_res_counter + 1;
903:
904: log_pvt('MAIN',' After Create If ');
905:
906: if ( nvl(g_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
907: <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
908:
909:
910: u_res_counter := u_res_counter + 1;
911:
1057: x_msg_count := 10;
1058: end if;
1059: for i in 1..x_msg_count loop
1060:
1061: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
1062: ,p_msg_index => x_msg_count
1063: ,p_data => l_data
1064: ,p_msg_index_out => l_msg_index_out
1065: );
1261: x_msg_count := 10;
1262: end if;
1263: for i in 1..x_msg_count loop
1264:
1265: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
1266: ,p_msg_index => x_msg_count
1267: ,p_data => l_data
1268: ,p_msg_index_out => l_msg_index_out
1269: );
1525: --------START Convert fnd_api.g_miss* to pa g_miss -----------------------------
1526:
1527: if ( l_project_in_obj.PA_PROJECT_ID = FND_API.G_MISS_NUM ) then
1528:
1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1530:
1531: end if;
1532:
1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1531: end if;
1532:
1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1534:
1535: l_project_in_obj.PA_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1536:
1537: end if;
1538:
1539:
1538:
1539:
1540: if ( l_project_in_obj.PROJECT_NAME = FND_API.G_MISS_CHAR ) then
1541:
1542: l_project_in_obj.PROJECT_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1543:
1544: end if;
1545:
1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then
1544: end if;
1545:
1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then
1547:
1548: l_project_in_obj.pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1549:
1550: end if;
1551:
1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then
1550: end if;
1551:
1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then
1553:
1554: l_project_in_obj.DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1555:
1556: end if;
1557:
1558: --log_pvt('LOAD_PROEJCT','init 01 ');
1558: --log_pvt('LOAD_PROEJCT','init 01 ');
1559:
1560: if ( l_project_in_obj.PROJECT_STATUS = FND_API.G_MISS_CHAR ) then
1561:
1562: l_project_in_obj.PROJECT_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1563:
1564: end if;
1565:
1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then
1564: end if;
1565:
1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then
1567:
1568: l_project_in_obj.START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1569:
1570: end if;
1571:
1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then
1570: end if;
1571:
1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then
1573:
1574: l_project_in_obj.COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1575:
1576: end if;
1577:
1578: --log_pvt('LOAD_PROEJCT','init 02 ');
1578: --log_pvt('LOAD_PROEJCT','init 02 ');
1579:
1580: if ( l_project_in_obj.ACTUAL_START_DATE = FND_API.G_MISS_DATE ) then
1581:
1582: l_project_in_obj.ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1583:
1584: end if;
1585:
1586:
1585:
1586:
1587: if ( l_project_in_obj.ACTUAL_FINISH_DATE = FND_API.G_MISS_DATE ) then
1588:
1589: l_project_in_obj.ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1590:
1591: end if;
1592:
1593:
1592:
1593:
1594: if ( l_project_in_obj.EARLY_START_DATE = FND_API.G_MISS_DATE ) then
1595:
1596: l_project_in_obj.EARLY_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1597:
1598: end if;
1599:
1600:
1599:
1600:
1601: if ( l_project_in_obj.EARLY_FINISH_DATE = FND_API.G_MISS_DATE ) then
1602:
1603: l_project_in_obj.EARLY_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1604:
1605: end if;
1606:
1607:
1607:
1608: --log_pvt('LOAD_PROEJCT','init 03 ');
1609: if ( l_project_in_obj.MAX_WBS_LEVEL = FND_API.G_MISS_NUM ) then
1610:
1611: l_project_in_obj.MAX_WBS_LEVEL := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1612:
1613: end if;
1614:
1615: --log_pvt('LOAD_PROEJCT','init 03a ');
1615: --log_pvt('LOAD_PROEJCT','init 03a ');
1616:
1617: if ( l_project_in_obj.COST_CHG_QTY_INDICATOR = FND_API.G_MISS_CHAR ) then
1618:
1619: l_project_in_obj.COST_CHG_QTY_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1620:
1621: end if;
1622:
1623: --log_pvt('LOAD_PROEJCT','init 03b ');
1623: --log_pvt('LOAD_PROEJCT','init 03b ');
1624:
1625: if ( l_project_in_obj.CREATED_FROM_PROJECT_ID = FND_API.G_MISS_NUM ) then
1626:
1627: l_project_in_obj.CREATED_FROM_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1628:
1629: end if;
1630:
1631: --log_pvt('LOAD_PROEJCT','init 03 c');
1630:
1631: --log_pvt('LOAD_PROEJCT','init 03 c');
1632: if ( l_project_in_obj.CREATED_FROM_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1633:
1634: l_project_in_obj.CREATED_FROM_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1635:
1636: end if;
1637:
1638: --log_pvt('LOAD_PROEJCT','init 03 d');
1637:
1638: --log_pvt('LOAD_PROEJCT','init 03 d');
1639: if ( l_project_in_obj.PROJECT_ORGANIZATION_ID = FND_API.G_MISS_NUM ) then
1640:
1641: l_project_in_obj.PROJECT_ORGANIZATION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1642:
1643: end if;
1644:
1645: --log_pvt('LOAD_PROEJCT','init 03 e');
1644:
1645: --log_pvt('LOAD_PROEJCT','init 03 e');
1646: if ( l_project_in_obj.ORG_ID = FND_API.G_MISS_NUM ) then
1647:
1648: l_project_in_obj.ORG_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1649:
1650: end if;
1651:
1652: --log_pvt('LOAD_PROEJCT','init 03 fa');
1652: --log_pvt('LOAD_PROEJCT','init 03 fa');
1653:
1654: if ( l_project_in_obj.EPS_CLASS_CODE = FND_API.G_MISS_CHAR ) then
1655:
1656: l_project_in_obj.EPS_CLASS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1657:
1658: end if;
1659:
1660:
1660:
1661: --log_pvt('LOAD_PROEJCT','init 03 ');
1662: if ( l_project_in_obj.PROJECT_TYPE_CODE = FND_API.G_MISS_CHAR ) then
1663:
1664: l_project_in_obj.PROJECT_TYPE_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1665:
1666: end if;
1667:
1668: --log_pvt('LOAD_PROEJCT','init 04 ');
1667:
1668: --log_pvt('LOAD_PROEJCT','init 04 ');
1669: if ( l_project_in_obj.ORIGINAL_BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1670:
1671: l_project_in_obj.ORIGINAL_BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1672:
1673: end if;
1674:
1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1673: end if;
1674:
1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1676:
1677: l_project_in_obj.BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1678:
1679: end if;
1680:
1681:
1680:
1681:
1682: if ( l_project_in_obj.PROJECT_CURRENCY_CODE = FND_API.G_MISS_CHAR ) then
1683:
1684: l_project_in_obj.PROJECT_CURRENCY_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1685:
1686: end if;
1687:
1688:
1687:
1688:
1689: if ( l_project_in_obj.ACTIVITY_TRACKING_INDICATOR = FND_API.G_MISS_CHAR ) then
1690:
1691: l_project_in_obj.ACTIVITY_TRACKING_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1692:
1693: end if;
1694:
1695:
1694:
1695:
1696: if ( l_project_in_obj.RES_ASS_TRACK_LEV_CODE = FND_API.G_MISS_CHAR ) then
1697:
1698: l_project_in_obj.RES_ASS_TRACK_LEV_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1699:
1700: end if;
1701:
1702: --log_pvt('LOAD_PROEJCT','init 05 ');
1709:
1710: l_return_status := 'S';
1711: l_return_message := null;
1712:
1713: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1714: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1715:
1716: begin
1717: select project_id into l_create_from_project_id
1710: l_return_status := 'S';
1711: l_return_message := null;
1712:
1713: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1714: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1715:
1716: begin
1717: select project_id into l_create_from_project_id
1718: from pa_projects_all
1742: if ( l_return_status = 'S' ) then
1743: begin
1744:
1745: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1746: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1747: AND l_return_status = 'S' ) then
1748:
1749: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN(l_PROJECT_IN_OBJ.PA_PROJECT_ID ), 'N',
1750: 'FINANCIAL', structure_type), receive_task , structure_type
1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;
1814:
1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1816: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1817:
1818: L_PROJECT_IN_REC.PROJECT_CURRENCY_CODE := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1819: END IF;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;
1814:
1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1816: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1817:
1818: L_PROJECT_IN_REC.PROJECT_CURRENCY_CODE := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1819: END IF;
1820: gl_currency_code := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1844: L_STRUCTURE_IN_REC.STRUCTURE_TYPE := l_struct_type;
1845:
1846: if ( L_STRUCTURE_IN_REC.DESCRIPTION = FND_API.G_MISS_CHAR ) then
1847:
1848: L_STRUCTURE_IN_REC.DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1849:
1850: end if;
1851:
1852:
1852:
1853: L_STRUCTURE_IN_REC.DESCRIPTION := L_STRUCTURE_IN_OBJ.DESCRIPTION;
1854:
1855:
1856: L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1857:
1858: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1859: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1860:
1855:
1856: L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1857:
1858: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1859: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1860:
1861: begin
1862:
1863: if ( l_setup_struct_type = 'FINANCIAL') then
1949:
1950: /**
1951:
1952: if ( L_TASK_in_obj.PA_TASK_ID = FND_API.G_MISS_NUM ) then
1953: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1954: else
1955: L_TASK_IN_REC.PA_TASK_ID := L_TASK_IN_OBJ.PA_TASK_ID;
1956: end if;
1957: **/
1955: L_TASK_IN_REC.PA_TASK_ID := L_TASK_IN_OBJ.PA_TASK_ID;
1956: end if;
1957: **/
1958:
1959: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1960:
1961:
1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then
1963: L_TASK_IN_REC.TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1959: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1960:
1961:
1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then
1963: L_TASK_IN_REC.TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1964: else
1965: L_TASK_IN_REC.TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1966: L_TASK_IN_REC.LONG_TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1967: end if;
1968:
1969: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_NAME '|| L_TASK_IN_REC.TASK_NAME);
1970:
1971: if ( L_TASK_in_obj.PA_TASK_NUMBER = FND_API.G_MISS_CHAR ) then
1972: L_TASK_IN_REC.PA_TASK_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1973: else
1974: L_TASK_IN_REC.PA_TASK_NUMBER := L_TASK_IN_OBJ.PA_TASK_NUMBER;
1975: end if;
1976:
1975: end if;
1976:
1977: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PA_TASK_NUMBER '|| L_TASK_IN_REC.PA_TASK_NUMBER);
1978: if ( L_TASK_in_obj.TASK_DESCRIPTION = FND_API.G_MISS_CHAR ) then
1979: L_TASK_IN_REC.TASK_DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1980: else
1981: L_TASK_IN_REC.TASK_DESCRIPTION := L_TASK_IN_OBJ.TASK_DESCRIPTION;
1982: end if;
1983:
1982: end if;
1983:
1984: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_DESCRIPTION '|| L_TASK_IN_REC.TASK_DESCRIPTION);
1985: if ( L_TASK_in_obj.PM_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1986: L_TASK_IN_REC.PM_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1987: else
1988: L_TASK_IN_REC.PM_TASK_REFERENCE := L_TASK_IN_OBJ.PM_TASK_REFERENCE;
1989: end if;
1990:
1989: end if;
1990:
1991: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_TASK_REFERENCE '|| L_TASK_IN_REC.PM_TASK_REFERENCE);
1992: if ( L_TASK_in_obj.PM_PARENT_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1993: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1994: else
1995: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := L_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
1996: end if;
1997:
1997:
1998: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE '||L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE);
1999: /**
2000: if ( L_TASK_in_obj.PA_PARENT_TASK_ID = FND_API.G_MISS_NUM ) then
2001: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2002: else
2003: L_TASK_IN_REC.PA_PARENT_TASK_ID := L_TASK_IN_OBJ.PA_PARENT_TASK_ID;
2004: end if;
2005: **/
2003: L_TASK_IN_REC.PA_PARENT_TASK_ID := L_TASK_IN_OBJ.PA_PARENT_TASK_ID;
2004: end if;
2005: **/
2006:
2007: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2008:
2009:
2010: if ( L_TASK_in_obj.TASK_START_DATE = FND_API.G_MISS_DATE ) then
2011: L_TASK_IN_REC.TASK_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2007: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2008:
2009:
2010: if ( L_TASK_in_obj.TASK_START_DATE = FND_API.G_MISS_DATE ) then
2011: L_TASK_IN_REC.TASK_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2012: else
2013: L_TASK_IN_REC.TASK_START_DATE := trunc(L_TASK_IN_OBJ.TASK_START_DATE);
2014: end if;
2015:
2015:
2016: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_START_DATE '|| L_TASK_IN_REC.TASK_START_DATE);
2017:
2018: if ( L_TASK_in_obj.TASK_COMPLETION_DATE = FND_API.G_MISS_DATE ) then
2019: L_TASK_IN_REC.TASK_COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2020: else
2021: L_TASK_IN_REC.TASK_COMPLETION_DATE := trunc(nvl(trunc(L_TASK_IN_OBJ.TASK_COMPLETION_DATE), L_PROJECT_IN_REC.COMPLETION_DATE));
2022: end if;
2023:
2029: L_TASK_EST_OBJECT := l_task_in_obj.task_est_object;
2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;
2031:
2032: -- Never to update EAC values for current working version. AMEHROTR. Bug 8790577.
2033: L_TASK_EST_OBJECT.EAC_LABOR_QTY := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2034: L_TASK_EST_OBJECT.EAC_LABOR_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2035:
2036:
2037: --L_TASK_IN_REC.actual_start_date :=
2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;
2031:
2032: -- Never to update EAC values for current working version. AMEHROTR. Bug 8790577.
2033: L_TASK_EST_OBJECT.EAC_LABOR_QTY := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2034: L_TASK_EST_OBJECT.EAC_LABOR_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2035:
2036:
2037: --L_TASK_IN_REC.actual_start_date :=
2038: --L_TASK_IN_REC.actual_finish_date :=
2040: /* Bug 12986544: Added trunc for Early Start Date, Early Finish Date,
2041: Late Start Date and Late Finish Date since these were showing incorrect dates in Ebiz*/
2042:
2043: if ( trunc(l_planned_object.early_start_date) = FND_API.G_MISS_DATE ) then
2044: L_TASK_IN_REC.early_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2045: else
2046: L_TASK_IN_REC.early_start_date := trunc(l_planned_object.EARLY_START_DATE);
2047: end if;
2048:
2047: end if;
2048:
2049: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.early_start_date '|| L_TASK_IN_REC.early_start_date);
2050: if ( trunc(l_planned_object.early_finish_date) = FND_API.G_MISS_DATE ) then
2051: L_TASK_IN_REC.early_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2052: else
2053: L_TASK_IN_REC.early_finish_date := trunc(l_planned_object.early_finish_date);
2054: end if;
2055:
2054: end if;
2055:
2056: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.early_finish_date '|| L_TASK_IN_REC.early_finish_date);
2057: if ( trunc(l_planned_object.late_start_date) = FND_API.G_MISS_DATE ) then
2058: L_TASK_IN_REC.late_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2059: else
2060: L_TASK_IN_REC.late_start_date := trunc(l_planned_object.late_start_date);
2061: end if;
2062:
2061: end if;
2062:
2063: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.late_start_date '|| L_TASK_IN_REC.late_start_date);
2064: if ( trunc(l_planned_object.late_finish_date) = FND_API.G_MISS_DATE ) then
2065: L_TASK_IN_REC.late_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2066: else
2067: L_TASK_IN_REC.late_finish_date := trunc(l_planned_object.late_finish_date);
2068: end if;
2069:
2068: end if;
2069:
2070: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.late_finish_date '|| L_TASK_IN_REC.late_finish_date);
2071: if ( l_planned_object.PLANNED_START_DATE = FND_API.G_MISS_DATE ) then
2072: L_TASK_IN_REC.scheduled_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2073: else
2074: L_TASK_IN_REC.scheduled_start_date := trunc(nvl(nvl(trunc(l_planned_object.PLANNED_START_DATE),L_TASK_IN_REC.TASK_START_DATE),L_PROJECT_IN_REC.START_DATE));
2075: end if;
2076:
2075: end if;
2076:
2077: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.scheduled_start_date '|| L_TASK_IN_REC.scheduled_start_date);
2078: if ( l_planned_object.PLANNED_COMPL_DATE = FND_API.G_MISS_DATE ) then
2079: L_TASK_IN_REC.scheduled_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2080: else
2081: L_TASK_IN_REC.scheduled_finish_date := trunc(nvl(nvl(trunc(l_planned_object.PLANNED_COMPL_DATE),L_TASK_IN_REC.TASK_COMPLETION_DATE),L_PROJECT_IN_REC.COMPLETION_DATE));
2082: end if;
2083:
2082: end if;
2083:
2084: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.scheduled_finish_date '|| L_TASK_IN_REC.scheduled_finish_date);
2085: if ( l_planned_object.BASELINE_START_DATE = FND_API.G_MISS_DATE ) then
2086: L_TASK_IN_REC.BASELINE_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2087: else
2088: L_TASK_IN_REC.BASELINE_START_DATE := TRUNC(NVL(trunc(l_planned_object.BASELINE_START_DATE), L_TASK_IN_REC.TASK_START_DATE));
2089: end if;
2090:
2089: end if;
2090:
2091: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.BASELINE_START_DATE '|| L_TASK_IN_REC.BASELINE_START_DATE);
2092: if ( l_planned_object.BASELINE_FINISH_DATE = FND_API.G_MISS_DATE ) then
2093: L_TASK_IN_REC.BASELINE_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2094: else
2095: L_TASK_IN_REC.BASELINE_FINISH_DATE := trunc(nvl(trunc(l_planned_object.BASELINE_FINISH_DATE), L_TASK_IN_REC.TASK_COMPLETION_DATE));
2096: end if;
2097:
2097:
2098:
2099: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.BASELINE_FINISH_DATE '|| L_TASK_IN_REC.BASELINE_FINISH_DATE);
2100: if ( l_planned_object.planned_duration = FND_API.G_MISS_NUM ) then
2101: L_TASK_IN_REC.ext_act_duration := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2102: else
2103: L_TASK_IN_REC.ext_act_duration := l_planned_object.planned_duration;
2104: end if;
2105:
2105:
2106:
2107: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.ext_act_duration '|| L_TASK_IN_REC.ext_act_duration);
2108: if ( l_task_est_object.remaining_duration = FND_API.G_MISS_NUM ) then
2109: L_TASK_IN_REC.ext_remain_duration := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2110: else
2111: L_TASK_IN_REC.ext_remain_duration := l_task_est_object.remaining_duration;
2112: end if;
2113:
2112: end if;
2113:
2114: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.ext_remain_duration '|| L_TASK_IN_REC.ext_remain_duration);
2115: if ( l_task_est_object.etc_labor_qty = FND_API.G_MISS_NUM ) then
2116: L_TASK_IN_REC.etc_effort := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2117: else
2118: L_TASK_IN_REC.etc_effort := l_task_est_object.etc_labor_qty;
2119: end if;
2120:
2119: end if;
2120:
2121: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.etc_effort '|| L_TASK_IN_REC.etc_effort);
2122: if ( l_task_per_comp_object.physical_percent_comp = FND_API.G_MISS_NUM ) then
2123: L_TASK_IN_REC.percent_complete := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2124: else
2125: L_TASK_IN_REC.percent_complete := l_task_per_comp_object.physical_percent_comp;
2126: end if;
2127:
2187:
2188:
2189:
2190: if ( l_res_assign.PM_RES_ASSIGN_REFERENCE = FND_API.G_MISS_CHAR ) then
2191: g_res_pm_task_asgmt_reference(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
2192: else
2193: g_res_pm_task_asgmt_reference(g_res_counter) := l_res_assign.PM_RES_ASSIGN_REFERENCE;
2194: end if;
2195:
2193: g_res_pm_task_asgmt_reference(g_res_counter) := l_res_assign.PM_RES_ASSIGN_REFERENCE;
2194: end if;
2195:
2196: if ( l_res_assign.RESOURCE_ASSIGNMENT_ID = FND_API.G_MISS_NUM ) then
2197: g_res_pa_task_assignment_id(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2198: else
2199: g_res_pa_task_assignment_id(g_res_counter) := l_res_assign.RESOURCE_ASSIGNMENT_ID;
2200: end if;
2201:
2201:
2202: log_pvt('LOAD_PROJECT',' g_res_pa_task_assignment_id(g_res_counter) '||g_res_pa_task_assignment_id(g_res_counter));
2203:
2204: if ( l_res_assign.RESOURCE_NAME = FND_API.G_MISS_CHAR ) then
2205: g_res_resource_alias(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
2206: else
2207: g_res_resource_alias(g_res_counter) := l_res_assign.RESOURCE_NAME;
2208: end if;
2209:
2209:
2210: log_pvt('LOAD_PROJECT',' g_res_resource_alias(g_res_counter) '||g_res_resource_alias(g_res_counter));
2211:
2212: if ( l_res_assign.RESOURCE_LIST_MEMBER_ID = FND_API.G_MISS_NUM ) then
2213: g_res_resource_list_member_id(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2214: else
2215: g_res_resource_list_member_id(g_res_counter) := l_res_assign.RESOURCE_LIST_MEMBER_ID;
2216: end if;
2217:
2217:
2218: log_pvt('LOAD_PROJECT',' g_res_resource_list_member_id(g_res_counter) '||g_res_resource_list_member_id(g_res_counter));
2219:
2220: if ( l_res_assign.PLANNED_QTY = FND_API.G_MISS_NUM ) then
2221: g_res_planned_quantity(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2222: else
2223: g_res_planned_quantity(g_res_counter) := l_res_assign.PLANNED_QTY;
2224: end if;
2225: log_pvt('LOAD_PROJECT',' g_res_planned_quantity(g_res_counter) '||g_res_planned_quantity(g_res_counter));
2237: end if;
2238:
2239:
2240: if ( l_res_assign.START_DATE = FND_API.G_MISS_DATE ) then
2241: g_res_start_date(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2242: else
2243: g_res_start_date(g_res_counter) := trunc(nvl(g_res_start_date(g_res_counter),l_res_assign.START_DATE));
2244: end if;
2245:
2243: g_res_start_date(g_res_counter) := trunc(nvl(g_res_start_date(g_res_counter),l_res_assign.START_DATE));
2244: end if;
2245:
2246: if ( l_res_assign.COMPLETION_DATE = FND_API.G_MISS_DATE ) then
2247: g_res_end_date(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2248: else
2249: g_res_end_date(g_res_counter) := trunc(nvl(g_res_end_date(g_res_counter),l_res_assign.COMPLETION_DATE));
2250: end if;
2251:
2253: log_pvt('LOAD_PROJECT',' g_res_start_date(g_res_counter) '||g_res_start_date(g_res_counter));
2254: log_pvt('LOAD_PROJECT',' g_res_end_date(g_res_counter) '||g_res_end_date(g_res_counter));
2255:
2256: if ( l_res_assign.PLANNED_COST = FND_API.G_MISS_NUM ) then
2257: g_res_planned_total_raw_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2258: g_res_planned_total_bur_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2259: else
2260: g_res_planned_total_raw_cost(g_res_counter) := l_res_assign.PLANNED_COST;
2261: -- assigned null value this to help use burdening in EBS.
2254: log_pvt('LOAD_PROJECT',' g_res_end_date(g_res_counter) '||g_res_end_date(g_res_counter));
2255:
2256: if ( l_res_assign.PLANNED_COST = FND_API.G_MISS_NUM ) then
2257: g_res_planned_total_raw_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2258: g_res_planned_total_bur_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2259: else
2260: g_res_planned_total_raw_cost(g_res_counter) := l_res_assign.PLANNED_COST;
2261: -- assigned null value this to help use burdening in EBS.
2262: g_res_planned_total_bur_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM; -- Perf Change 8894180
2258: g_res_planned_total_bur_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2259: else
2260: g_res_planned_total_raw_cost(g_res_counter) := l_res_assign.PLANNED_COST;
2261: -- assigned null value this to help use burdening in EBS.
2262: g_res_planned_total_bur_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM; -- Perf Change 8894180
2263: end if;
2264:
2265: log_pvt('LOAD_PROJECT',' g_res_planned_total_raw_cost(g_res_counter) '||g_res_planned_total_raw_cost(g_res_counter));
2266:
2405: -- log_pvt('WBS_ORDER','001');
2406: -- Finding tasks that need to be deleted .......
2407:
2408: IF ( P_PROJECT_IN_REC.PA_PROJECT_ID IS NOT NULL
2409: AND P_PROJECT_IN_REC.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) THEN
2410:
2411:
2412: begin
2413:
2537: if ( p_res_pa_task_assignment_id.count > 0 ) then
2538:
2539: FOR i in p_res_pa_task_assignment_id.first .. p_res_pa_task_assignment_id.last loop
2540:
2541: if ( nvl(p_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2542: <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
2543:
2544: l_cnt := l_cnt + 1;
2545: l_res_id_tbl(l_cnt) := p_res_pa_task_assignment_id(i);
2538:
2539: FOR i in p_res_pa_task_assignment_id.first .. p_res_pa_task_assignment_id.last loop
2540:
2541: if ( nvl(p_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2542: <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
2543:
2544: l_cnt := l_cnt + 1;
2545: l_res_id_tbl(l_cnt) := p_res_pa_task_assignment_id(i);
2546:
2651: x_msg_count := 10;
2652: end if;
2653: for i in 1..x_msg_count loop
2654:
2655: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
2656: ,p_msg_index => x_msg_count
2657: ,p_data => l_data
2658: ,p_msg_index_out => l_msg_index_out
2659: );
2729: ,p_msg_count => x_msg_count
2730: ,p_msg_data => x_msg_data
2731: ,p_return_status => l_return_status
2732: ,p_pm_product_code => 'PRIMAVERA'
2733: -- ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2734: ,p_pa_project_id => p_project_in_rec.pa_project_id
2735: -- ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2736: ,p_pa_task_id => p_delete_task_id_tbl(i)
2737: ,p_cascaded_delete_flag => 'N'
2731: ,p_return_status => l_return_status
2732: ,p_pm_product_code => 'PRIMAVERA'
2733: -- ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2734: ,p_pa_project_id => p_project_in_rec.pa_project_id
2735: -- ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2736: ,p_pa_task_id => p_delete_task_id_tbl(i)
2737: ,p_cascaded_delete_flag => 'N'
2738: ,p_project_id => l_project_id
2739: ,p_task_id => l_task_id
2750: x_msg_count := 10;
2751: end if;
2752: for i in 1..x_msg_count loop
2753:
2754: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
2755: ,p_msg_index => x_msg_count
2756: ,p_data => l_data
2757: ,p_msg_index_out => l_msg_index_out
2758: );
2973: ,p_value1 => p_CREATED_FROM_PROJECT_NUMBER
2974: );
2975: X_MSG_COUNT := FND_MSG_PUB.count_msg ;
2976: for i in 1..x_msg_count loop
2977: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
2978: ,p_msg_index => x_msg_count
2979: ,p_data => l_data
2980: ,p_msg_index_out => l_msg_index_out
2981: );
3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3154: l_budget_in_obj.Description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3154: l_budget_in_obj.Description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3155: end if;
3156:
3157: l_budget_out_obj.AIA_COMMON_ID := l_budget_in_obj.AIA_COMMON_ID;
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3154: l_budget_in_obj.Description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3155: end if;
3156:
3157: l_budget_out_obj.AIA_COMMON_ID := l_budget_in_obj.AIA_COMMON_ID;
3158: l_budget_out_obj.budget_id := l_budget_in_obj.project_id;
3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3369: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3369: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3370: end if;
3371:
3372: log_pvt('BUDGET_DATA',' AFTER LINE task_id '||l_plan_task_obj.task_id);
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3369: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3370: end if;
3371:
3372: log_pvt('BUDGET_DATA',' AFTER LINE task_id '||l_plan_task_obj.task_id);
3373: log_pvt('BUDGET_DATA',' AFTER LINE plan_task_id '||l_plan_task_obj.plan_task_id);
3427: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_task_line_obj.TOTAL_RAW_COST);
3428: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_task_line_obj.TOTAL_BURDENED_COST);
3429:
3430:
3431: if ( nvl(l_task_line_obj.task_line_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3432: l_task_line_obj.task_line_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3433: end if;
3434:
3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3428: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_task_line_obj.TOTAL_BURDENED_COST);
3429:
3430:
3431: if ( nvl(l_task_line_obj.task_line_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3432: l_task_line_obj.task_line_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3433: end if;
3434:
3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3436: l_task_line_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3431: if ( nvl(l_task_line_obj.task_line_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3432: l_task_line_obj.task_line_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3433: end if;
3434:
3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3436: l_task_line_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3437: end if;
3438:
3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3432: l_task_line_obj.task_line_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3433: end if;
3434:
3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3436: l_task_line_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3437: end if;
3438:
3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3440: l_task_line_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3436: l_task_line_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3437: end if;
3438:
3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3440: l_task_line_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3441: end if;
3442:
3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3436: l_task_line_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3437: end if;
3438:
3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3440: l_task_line_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3441: end if;
3442:
3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3444: l_task_line_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3440: l_task_line_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3441: end if;
3442:
3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3444: l_task_line_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3445: end if;
3446:
3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3440: l_task_line_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3441: end if;
3442:
3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3444: l_task_line_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3445: end if;
3446:
3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3448: l_task_line_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3444: l_task_line_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3445: end if;
3446:
3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3448: l_task_line_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3449: end if;
3450:
3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3444: l_task_line_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3445: end if;
3446:
3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3448: l_task_line_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3449: end if;
3450:
3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3452: l_task_line_obj.RESOURCE_LIST_MEMBER_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3448: l_task_line_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3449: end if;
3450:
3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3452: l_task_line_obj.RESOURCE_LIST_MEMBER_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3453: end if;
3454:
3455: if ( nvl(l_task_line_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3448: l_task_line_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3449: end if;
3450:
3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3452: l_task_line_obj.RESOURCE_LIST_MEMBER_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3453: end if;
3454:
3455: if ( nvl(l_task_line_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3456: l_task_line_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3452: l_task_line_obj.RESOURCE_LIST_MEMBER_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3453: end if;
3454:
3455: if ( nvl(l_task_line_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3456: l_task_line_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3457: end if;
3458:
3459:
3452: l_task_line_obj.RESOURCE_LIST_MEMBER_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3453: end if;
3454:
3455: if ( nvl(l_task_line_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3456: l_task_line_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3457: end if;
3458:
3459:
3460: l_budget_line_in_rec.resource_list_member_id := l_task_line_obj.RESOURCE_LIST_MEMBER_ID;
3557: if ( x_msg_count > 10 ) then
3558: x_msg_count := 10;
3559: end if;
3560: for i in 1..x_msg_count loop
3561: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
3562: ,p_msg_index => x_msg_count
3563: ,p_data => l_data
3564: ,p_msg_index_out => l_msg_index_out
3565: );
3606: if ( x_msg_count > 10 ) then
3607: x_msg_count := 10;
3608: end if;
3609: for i in 1..x_msg_count loop
3610: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
3611: ,p_msg_index => x_msg_count
3612: ,p_data => l_data
3613: ,p_msg_index_out => l_msg_index_out
3614: );