169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
190: l_cp_structure VARCHAR2(30);
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
190: l_cp_structure VARCHAR2(30);
191: l_cost_base VARCHAR2(30);
192: /* EOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
190: l_cp_structure VARCHAR2(30);
191: l_cost_base VARCHAR2(30);
192: /* EOM Bug# 5743708 */
193:
3197: IS
3198: l_program_id NUMBER;
3199: l_program_application_id NUMBER;
3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:
3198: l_program_id NUMBER;
3199: l_program_application_id NUMBER;
3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:
3206:
3199: l_program_application_id NUMBER;
3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:
3206:
3207:
3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:
3206:
3207:
3208: BEGIN