DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on RES_ASGMT_OUT_OBJ

Line 142: l_res_asgmt_obj SYSTEM.RES_ASGMT_OUT_OBJ;

138:
139: u_res_counter number;
140:
141:
142: l_res_asgmt_obj SYSTEM.RES_ASGMT_OUT_OBJ;
143: l_res_asgmt_obj_tbl SYSTEM.RES_ASGMT_OUT_OBJ_TBL;
144:
145: l_res_out_counter number;
146:

Line 143: l_res_asgmt_obj_tbl SYSTEM.RES_ASGMT_OUT_OBJ_TBL;

139: u_res_counter number;
140:
141:
142: l_res_asgmt_obj SYSTEM.RES_ASGMT_OUT_OBJ;
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;

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 232: l_res_asgmt_obj := SYSTEM.RES_ASGMT_OUT_OBJ(null,null,null,null,null);

228: i_del_task_out_obj := SYSTEM.delete_task_out_obj(null,null,null);
229:
230: l_res_asgmt_obj := null;
231:
232: l_res_asgmt_obj := SYSTEM.RES_ASGMT_OUT_OBJ(null,null,null,null,null);
233:
234: L_RES_ASGMT_OBJ_TBL := SYSTEM.RES_ASGMT_OUT_OBJ_TBL();
235:
236: FOR i in P_PROJECTS_IN.first .. P_PROJECTS_IN.last LOOP

Line 234: L_RES_ASGMT_OBJ_TBL := SYSTEM.RES_ASGMT_OUT_OBJ_TBL();

230: l_res_asgmt_obj := null;
231:
232: l_res_asgmt_obj := SYSTEM.RES_ASGMT_OUT_OBJ(null,null,null,null,null);
233:
234: L_RES_ASGMT_OBJ_TBL := SYSTEM.RES_ASGMT_OUT_OBJ_TBL();
235:
236: FOR i in P_PROJECTS_IN.first .. P_PROJECTS_IN.last LOOP
237:
238: log_pvt('MAIN','LOOP :Start ');

Line 314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;

310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
312:
313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;
314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;
315:
316: L_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
317:
318: L_PROJECT_OUT_TBL(i) := L_PROJECT_OUT_OBJ;

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 1306: l_res_asgmt_obj := SYSTEM.RES_ASGMT_OUT_OBJ(null,null,null,null,null);

1302: log_pvt('MAIN','updating resource assignments: after fetch '||ou_task_asgmt_index.COUNT);
1303:
1304: l_res_asgmt_obj_tbl.extend(ou_task_asgmt_index.COUNT);
1305:
1306: l_res_asgmt_obj := SYSTEM.RES_ASGMT_OUT_OBJ(null,null,null,null,null);
1307: log_pvt('MAIN','updating resource assignments: after fetch '||ou_task_asgmt_index.COUNT);
1308:
1309: FOR j in 1..u_res_counter LOOP
1310: -- FOR j in 1..ou_task_asgmt_index.COUNT LOOP

Line 1399: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;

1395: ------- Project Resource Assignment Creation / Update End -------------------------------
1396:
1397: log_pvt('MAIN','BEFORE END ');
1398:
1399: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;
1400:
1401: /* Commit issue changes Start */
1402:
1403: if ( p_sync_mode = 'D' ) then

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 2511: l_del_res_asgmt_obj SYSTEM.delete_RES_ASGMT_OUT_OBJ;

2507:
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;

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:

Line 2529: l_del_res_asgmt_obj := SYSTEM.delete_RES_ASGMT_OUT_OBJ(null,null,null);

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:
2533: l_cnt := 0;