DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on DELETE_RES_ASGMT_OUT_OBJ_TBL

Line 147: l_del_res_asgmt_tbl SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL;

143: l_res_asgmt_obj_tbl SYSTEM.RES_ASGMT_OUT_OBJ_TBL;
144:
145: l_res_out_counter number;
146:
147: l_del_res_asgmt_tbl SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL;
148: l_del_res_asgm_status varchar2(3);
149: l_del_res_msg_data varchar2(2000);
150:
151: -- out variable ----

Line 224: l_del_res_asgmt_tbl := SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL();

220:
221: i_task_out_obj := SYSTEM.task_out_obj(null,null,null,null,null);
222:
223:
224: l_del_res_asgmt_tbl := SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL();
225:
226: i_del_task_out_obj_tbl := SYSTEM.delete_task_out_obj_tbl();
227:
228: i_del_task_out_obj := SYSTEM.delete_task_out_obj(null,null,null);

Line 404: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);

400:
401: log_pvt('MAIN_DEL',' after the api call ');
402: if ( l_del_res_asgmt_tbl is not null ) then
403:
404: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
405:
406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;
407: L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status := l_del_res_asgm_status;
408: L_PROJECT_OUT_OBJ.del_res_msg_data := l_del_res_msg_data;

Line 406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;

402: if ( l_del_res_asgmt_tbl is not null ) then
403:
404: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
405:
406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;
407: L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status := l_del_res_asgm_status;
408: L_PROJECT_OUT_OBJ.del_res_msg_data := l_del_res_msg_data;
409:
410: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);

Line 410: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);

406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;
407: L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status := l_del_res_asgm_status;
408: L_PROJECT_OUT_OBJ.del_res_msg_data := l_del_res_msg_data;
409:
410: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
411: log_pvt('MAIN_DEL',' p_delete_res_asgmt_status '||l_del_res_asgm_status);
412: log_pvt('MAIN_DEL',' l_del_res_msg_data '||l_del_res_msg_data);
413:
414: end if;

Line 2499: x_DEL_RES_ASGMT_OBJ_TBL OUT NOCOPY SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL,

2495: procedure DELETE_RES_ASSGN_PVT (
2496: p_project_in_rec IN pa_project_pub.project_in_rec_type,
2497: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
2498: p_res_pa_task_assignment_id IN g_num,
2499: x_DEL_RES_ASGMT_OBJ_TBL OUT NOCOPY SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL,
2500: x_DEL_RES_ASSGMT_STATUS OUT NOCOPY varchar2,
2501: x_del_res_msg_data OUT NOCOPY varchar2
2502: ) IS
2503:

Line 2512: l_del_res_asgmt_obj_tbl SYSTEM.delete_res_asgmt_out_obj_tbl;

2508: l_cnt number;
2509: l_res_id_tbl g_num_tbl;
2510:
2511: l_del_res_asgmt_obj SYSTEM.delete_RES_ASGMT_OUT_OBJ;
2512: l_del_res_asgmt_obj_tbl SYSTEM.delete_res_asgmt_out_obj_tbl;
2513:
2514: l_del_res_asgmt_rec PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_IN_REC_TYPE;
2515: l_del_res_asgmt_rec_tbl PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_IN_TBL_TYPE;
2516:

Line 2528: l_del_res_asgmt_obj_tbl := SYSTEM.delete_res_asgmt_out_obj_tbl();

2524:
2525: Begin
2526: null;
2527:
2528: l_del_res_asgmt_obj_tbl := SYSTEM.delete_res_asgmt_out_obj_tbl();
2529: l_del_res_asgmt_obj := SYSTEM.delete_RES_ASGMT_OUT_OBJ(null,null,null);
2530:
2531: l_del_res_asgmt_obj_tbl.delete;
2532: