DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on TASK_OUT_OBJ_TBL

Line 77: i_task_out_tbl SYSTEM.task_out_obj_tbl;

73: l_delete_task_ver_id_tbl g_num_tbl;
74:
75:
76: i_task_out_obj SYSTEM.task_out_obj;
77: i_task_out_tbl SYSTEM.task_out_obj_tbl;
78:
79: i_del_task_out_obj SYSTEM.delete_task_out_obj;
80: i_del_task_out_obj_tbl SYSTEM.delete_task_out_obj_tbl;
81: i_del_task_status varchar2(1);

Line 80: i_del_task_out_obj_tbl SYSTEM.delete_task_out_obj_tbl;

76: i_task_out_obj SYSTEM.task_out_obj;
77: i_task_out_tbl SYSTEM.task_out_obj_tbl;
78:
79: i_del_task_out_obj SYSTEM.delete_task_out_obj;
80: i_del_task_out_obj_tbl SYSTEM.delete_task_out_obj_tbl;
81: i_del_task_status varchar2(1);
82: i_del_task_msg_data varchar2(2000);
83:
84: t_crt_count NUMBER; -- Bug 10077151

Line 219: i_task_out_tbl := SYSTEM.task_out_obj_tbl();

215: L_PROJECT_OUT_TBL.extend(p_projects_in.count);
216:
217: L_PROJECT_OUT_OBJ := SYSTEM.project_out_obj(null,null,null,null,null,null,null,null,null,null,null,null,null,null);
218:
219: i_task_out_tbl := SYSTEM.task_out_obj_tbl();
220:
221: i_task_out_obj := SYSTEM.task_out_obj(null,null,null,null,null);
222:
223:

Line 226: i_del_task_out_obj_tbl := SYSTEM.delete_task_out_obj_tbl();

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);
229:
230: l_res_asgmt_obj := null;

Line 313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;

309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
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:

Line 416: i_del_task_out_obj_tbl.delete;

412: log_pvt('MAIN_DEL',' l_del_res_msg_data '||l_del_res_msg_data);
413:
414: end if;
415:
416: i_del_task_out_obj_tbl.delete;
417: i_del_task_out_obj_tbl.extend(l_delete_task_id_tbl.count);
418:
419: DELETE_TASK_PVT(
420: p_project_in_rec => L_PROJECT_IN_REC,

Line 417: i_del_task_out_obj_tbl.extend(l_delete_task_id_tbl.count);

413:
414: end if;
415:
416: i_del_task_out_obj_tbl.delete;
417: i_del_task_out_obj_tbl.extend(l_delete_task_id_tbl.count);
418:
419: DELETE_TASK_PVT(
420: p_project_in_rec => L_PROJECT_IN_REC,
421: p_structure_in_rec => L_STRUCTURE_IN_REC,

Line 424: x_del_task_out_obj_tbl => i_del_task_out_obj_tbl ,

420: p_project_in_rec => L_PROJECT_IN_REC,
421: p_structure_in_rec => L_STRUCTURE_IN_REC,
422: p_delete_task_id_tbl => l_delete_task_id_tbl,
423: p_delete_task_ver_id_tbl => l_delete_task_ver_id_tbl,
424: x_del_task_out_obj_tbl => i_del_task_out_obj_tbl ,
425: x_del_task_status => i_del_task_status,
426: x_del_task_msg_data => i_del_task_msg_data );
427:
428: L_PROJECT_OUT_OBJ.P_DELETE_TASK_OUT_OBJ_TBL := i_del_task_out_obj_tbl;

Line 428: L_PROJECT_OUT_OBJ.P_DELETE_TASK_OUT_OBJ_TBL := i_del_task_out_obj_tbl;

424: x_del_task_out_obj_tbl => i_del_task_out_obj_tbl ,
425: x_del_task_status => i_del_task_status,
426: x_del_task_msg_data => i_del_task_msg_data );
427:
428: L_PROJECT_OUT_OBJ.P_DELETE_TASK_OUT_OBJ_TBL := i_del_task_out_obj_tbl;
429: L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS := i_del_task_status;
430: L_PROJECT_OUT_OBJ.del_task_msg_data := i_del_task_msg_data;
431:
432: commit;

Line 552: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;

548: end if;
549: end if;
550:
551: log_pvt('MAIN','after task_table ');
552: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;
553:
554: EXCEPTION
555:
556: WHEN OTHERS THEN

Line 2684: x_del_task_out_obj_tbl OUT NOCOPY SYSTEM.delete_TASK_OUT_obj_TBL,

2680: p_project_in_rec IN pa_project_pub.project_in_rec_type,
2681: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
2682: p_delete_task_ver_id_tbl IN G_NUM_TBL,
2683: p_delete_task_id_tbl IN G_NUM_TBL,
2684: x_del_task_out_obj_tbl OUT NOCOPY SYSTEM.delete_TASK_OUT_obj_TBL,
2685: x_del_task_status OUT NOCOPY varchar2,
2686: x_del_task_msg_data OUT NOCOPY varchar2
2687: ) IS
2688:

Line 2690: l_del_task_out_obj_tbl SYSTEM.delete_task_out_obj_tbl;

2686: x_del_task_msg_data OUT NOCOPY varchar2
2687: ) IS
2688:
2689: l_del_task_out_obj SYSTEM.delete_task_out_obj;
2690: l_del_task_out_obj_tbl SYSTEM.delete_task_out_obj_tbl;
2691: l_del_task_status varchar2(1);
2692:
2693: X_MSG_COUNT NUMBER;
2694: X_MSG_DATA VARCHAR2(2000);

Line 2708: l_del_task_out_obj_tbl := SYSTEM.delete_task_out_obj_tbl();

2704: begin
2705:
2706: x_del_task_status := 'S';
2707:
2708: l_del_task_out_obj_tbl := SYSTEM.delete_task_out_obj_tbl();
2709: l_del_task_out_obj := SYSTEM.delete_task_out_obj(null,null,null);
2710:
2711: l_del_task_out_obj_tbl.delete;
2712:

Line 2711: l_del_task_out_obj_tbl.delete;

2707:
2708: l_del_task_out_obj_tbl := SYSTEM.delete_task_out_obj_tbl();
2709: l_del_task_out_obj := SYSTEM.delete_task_out_obj(null,null,null);
2710:
2711: l_del_task_out_obj_tbl.delete;
2712:
2713: if ( p_delete_task_id_tbl.count > 0 ) then
2714:
2715: l_del_task_out_obj_tbl.extend( p_delete_task_id_tbl.count);

Line 2715: l_del_task_out_obj_tbl.extend( p_delete_task_id_tbl.count);

2711: l_del_task_out_obj_tbl.delete;
2712:
2713: if ( p_delete_task_id_tbl.count > 0 ) then
2714:
2715: l_del_task_out_obj_tbl.extend( p_delete_task_id_tbl.count);
2716:
2717: for i in p_delete_task_id_tbl.first .. p_delete_task_id_tbl.last loop
2718:
2719: log_pvt('DELETE',' p_delete_task_id_tbl(i) '|| p_delete_task_id_tbl(i));

Line 2781: l_del_task_out_obj_tbl(i) := l_del_task_out_obj;

2777: l_del_task_out_obj.deleted_status := 'E';
2778: x_del_task_status := 'E';
2779: end;
2780:
2781: l_del_task_out_obj_tbl(i) := l_del_task_out_obj;
2782:
2783: end loop;
2784: end if ;
2785:

Line 3047: l_plan_task_OUT_TBL SYSTEM.plan_task_OUT_OBJ_TBL;

3043:
3044: l_task_line_out_obj SYSTEM.task_line_out_obj;
3045: l_task_line_OUT_TBL SYSTEM.task_line_OUT_OBJ_TBL;
3046: l_plan_task_out_obj SYSTEM.plan_task_out_obj;
3047: l_plan_task_OUT_TBL SYSTEM.plan_task_OUT_OBJ_TBL;
3048:
3049: CURSOR l_period_date_csr
3050: (p_date DATE
3051: ,p_period_type_code VARCHAR2 )

Line 3623: l_plan_task_OUT_TBL := SYSTEM.plan_task_OUT_OBJ_TBL();

3619: end loop;
3620: end if; -- budget type code calling;
3621:
3622:
3623: l_plan_task_OUT_TBL := SYSTEM.plan_task_OUT_OBJ_TBL();
3624:
3625: if ( ( l_Plan_Task_OBJ_tbl is not null ) and ( l_budget_out_obj.return_status = 'S' ) ) then
3626:
3627: if ( l_Plan_Task_OBJ_tbl.count > 0 ) then