eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on TASK_OUT_OBJ

Line 51: --L_TASKS_OUT_REC task_out_obj;

47: l_res_com_id_tbl task_com_id_tbl_type ;
48: l_res_id_ref_tbl task_id_ref_tbl_type ;
49:
50: --L_TASKS_IN_REC TASK_IN_REC_TYPE;
51: --L_TASKS_OUT_REC task_out_obj;
52: --L_STRUCTURE_IN_REC STRUCTURE_IN_REC_TYPE;
53:
54: --Objects
55:

Line 62: --L_TASKS_OUT_OBJ TASK_OUT_OBJ;

58:
59: L_PROJECT_OUT_TBL SYSTEM.PROJECT_OUT_OBJ_TBL;
60:
61: --L_TASKS_IN_OBJ TASK_IN_OBJ;
62: --L_TASKS_OUT_OBJ TASK_OUT_OBJ;
63: --L_STRUCTURE_IN_OBJ STRUCTURE_IN_OBJ;
64: -- Tables
65:
66: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;

Line 76: i_task_out_obj SYSTEM.task_out_obj;

72: l_delete_task_id_tbl g_num_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;

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 79: i_del_task_out_obj SYSTEM.delete_task_out_obj;

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);
82: i_del_task_msg_data varchar2(2000);
83:

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 221: i_task_out_obj := SYSTEM.task_out_obj(null,null,null,null,null);

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:
224: l_del_res_asgmt_tbl := SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL();
225:

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 228: i_del_task_out_obj := SYSTEM.delete_task_out_obj(null,null,null);

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;
231:
232: l_res_asgmt_obj := SYSTEM.RES_ASGMT_OUT_OBJ(null,null,null,null,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 532: i_task_out_obj.pa_task_id := L_TASK_OUT_REC.pa_task_id;

528: log_pvt('OUT','L_TASK_OUT_REC.task_version_id '||L_TASK_OUT_REC.task_version_id);
529: log_pvt('OUT','l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference) '||l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference));
530: log_pvt('OUT','l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference)) '||l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference)));
531:
532: i_task_out_obj.pa_task_id := L_TASK_OUT_REC.pa_task_id;
533: log_pvt('OUT','Step 1 ');
534: i_task_out_obj.pm_task_reference := L_TASK_OUT_REC.pm_task_reference;
535: log_pvt('OUT','Step 2');
536: i_task_out_obj.return_status := L_TASK_OUT_REC.return_status;

Line 534: i_task_out_obj.pm_task_reference := L_TASK_OUT_REC.pm_task_reference;

530: log_pvt('OUT','l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference)) '||l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference)));
531:
532: i_task_out_obj.pa_task_id := L_TASK_OUT_REC.pa_task_id;
533: log_pvt('OUT','Step 1 ');
534: i_task_out_obj.pm_task_reference := L_TASK_OUT_REC.pm_task_reference;
535: log_pvt('OUT','Step 2');
536: i_task_out_obj.return_status := L_TASK_OUT_REC.return_status;
537: log_pvt('OUT','Step 3 ');
538: i_task_out_obj.task_version_id := L_TASK_OUT_REC.task_version_id;

Line 536: i_task_out_obj.return_status := L_TASK_OUT_REC.return_status;

532: i_task_out_obj.pa_task_id := L_TASK_OUT_REC.pa_task_id;
533: log_pvt('OUT','Step 1 ');
534: i_task_out_obj.pm_task_reference := L_TASK_OUT_REC.pm_task_reference;
535: log_pvt('OUT','Step 2');
536: i_task_out_obj.return_status := L_TASK_OUT_REC.return_status;
537: log_pvt('OUT','Step 3 ');
538: i_task_out_obj.task_version_id := L_TASK_OUT_REC.task_version_id;
539: log_pvt('OUT','Step 4 ');
540: i_task_out_obj.aia_common_id := l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference));

Line 538: i_task_out_obj.task_version_id := L_TASK_OUT_REC.task_version_id;

534: i_task_out_obj.pm_task_reference := L_TASK_OUT_REC.pm_task_reference;
535: log_pvt('OUT','Step 2');
536: i_task_out_obj.return_status := L_TASK_OUT_REC.return_status;
537: log_pvt('OUT','Step 3 ');
538: i_task_out_obj.task_version_id := L_TASK_OUT_REC.task_version_id;
539: log_pvt('OUT','Step 4 ');
540: i_task_out_obj.aia_common_id := l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference));
541: log_pvt('OUT','Step 5 ');
542:

Line 540: i_task_out_obj.aia_common_id := l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference));

536: i_task_out_obj.return_status := L_TASK_OUT_REC.return_status;
537: log_pvt('OUT','Step 3 ');
538: i_task_out_obj.task_version_id := L_TASK_OUT_REC.task_version_id;
539: log_pvt('OUT','Step 4 ');
540: i_task_out_obj.aia_common_id := l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference));
541: log_pvt('OUT','Step 5 ');
542:
543: i_task_out_tbl(l1) := i_task_out_obj;
544: log_pvt('OUT','Step 6 ');

Line 543: i_task_out_tbl(l1) := i_task_out_obj;

539: log_pvt('OUT','Step 4 ');
540: i_task_out_obj.aia_common_id := l_task_com_id_tbl(l_task_id_ref_tbl(L_TASK_OUT_REC.pm_task_reference));
541: log_pvt('OUT','Step 5 ');
542:
543: i_task_out_tbl(l1) := i_task_out_obj;
544: log_pvt('OUT','Step 6 ');
545:
546: end loop;
547: end if;

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 2689: l_del_task_out_obj SYSTEM.delete_task_out_obj;

2685: x_del_task_status OUT NOCOPY varchar2,
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;

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 2709: l_del_task_out_obj := SYSTEM.delete_task_out_obj(null,null,null);

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:
2713: if ( p_delete_task_id_tbl.count > 0 ) then

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 2721: l_del_task_out_obj.pa_task_id := p_delete_task_id_tbl(i);

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));
2720:
2721: l_del_task_out_obj.pa_task_id := p_delete_task_id_tbl(i);
2722:
2723: begin
2724:
2725:

Line 2763: l_del_task_out_obj.error_message := l_data;

2759:
2760: -- dbms_output.put_line ('Error Message: ' ||l_data);
2761: log_pvt('DELETE','ERORRS : '||l_data);
2762: -- l_project_out_obj.msg_data := l_data;
2763: l_del_task_out_obj.error_message := l_data;
2764: x_del_task_msg_data := l_data;
2765: end loop;
2766:
2767:

Line 2768: l_del_task_out_obj.deleted_status := l_return_status;

2764: x_del_task_msg_data := l_data;
2765: end loop;
2766:
2767:
2768: l_del_task_out_obj.deleted_status := l_return_status;
2769:
2770: if ( x_del_task_status = 'S' ) then
2771: x_del_task_status := l_return_status;
2772: end if;

Line 2777: l_del_task_out_obj.deleted_status := 'E';

2773:
2774: null;
2775: exception
2776: when others then
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;

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 3046: l_plan_task_out_obj SYSTEM.plan_task_out_obj;

3042: l_cost_time_phased_code varchar2(3);
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

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

Line 3630: l_plan_task_out_obj := SYSTEM.plan_task_out_obj(null,null,null);

3626:
3627: if ( l_Plan_Task_OBJ_tbl.count > 0 ) then
3628:
3629: l_plan_task_OUT_TBL.extend(l_Plan_Task_OBJ_tbl.count);
3630: l_plan_task_out_obj := SYSTEM.plan_task_out_obj(null,null,null);
3631:
3632: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3633:
3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);

Line 3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;

3633:
3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3636: null;
3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;
3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;
3639:
3640: l_task_line_OUT_TBL := SYSTEM.task_line_OUT_OBJ_TBL();
3641:

Line 3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;

3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3636: null;
3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;
3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;
3639:
3640: l_task_line_OUT_TBL := SYSTEM.task_line_OUT_OBJ_TBL();
3641:
3642:

Line 3662: l_plan_task_out_obj.o_task_line_tbl := l_task_line_OUT_TBL;

3658: end loop;
3659: end if;
3660: end if;
3661:
3662: l_plan_task_out_obj.o_task_line_tbl := l_task_line_OUT_TBL;
3663: l_plan_task_OUT_TBL(j) := l_plan_task_out_obj;
3664:
3665: end loop;
3666: end if;

Line 3663: l_plan_task_OUT_TBL(j) := l_plan_task_out_obj;

3659: end if;
3660: end if;
3661:
3662: l_plan_task_out_obj.o_task_line_tbl := l_task_line_OUT_TBL;
3663: l_plan_task_OUT_TBL(j) := l_plan_task_out_obj;
3664:
3665: end loop;
3666: end if;
3667: end if;