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.PJI_PJP_SUM_ROLLUP dependencies on PA_NUM_TBL_TYPE

Line 5135: l_project_id_tbl system.pa_num_tbl_type;

5131: l_program_id number;
5132: l_rbs_header_id number;
5133: l_rbs_version_id number;
5134: l_prj_index number;
5135: l_project_id_tbl system.pa_num_tbl_type;
5136: l_count number;
5137: l_rowid rowid;
5138: l_return_status varchar2(255);
5139: l_error_code varchar2(255);

Line 5168: l_project_id_tbl := system.pa_num_tbl_type();

5164:
5165: l_rbs_header_id := -1;
5166: l_rbs_version_id := -1;
5167: l_prj_index := 1;
5168: l_project_id_tbl := system.pa_num_tbl_type();
5169: l_project_id_tbl.delete;
5170:
5171: for c in rbs_prg_full(p_worker_id) loop
5172:

Line 5335: l_project_id_tbl := system.pa_num_tbl_type();

5331: l_program_id := -1;
5332: l_rbs_header_id := -1;
5333: l_rbs_version_id := -1;
5334: l_prj_index := 1;
5335: l_project_id_tbl := system.pa_num_tbl_type();
5336: l_project_id_tbl.delete;
5337:
5338: for c in rbs_prg(p_worker_id) loop
5339:

Line 5463: l_project_id_tbl := system.pa_num_tbl_type();

5459:
5460: l_rbs_header_id := -1;
5461: l_rbs_version_id := -1;
5462: l_prj_index := 1;
5463: l_project_id_tbl := system.pa_num_tbl_type();
5464: l_project_id_tbl.delete;
5465:
5466: for c in rbs_assoc(p_worker_id) loop
5467:

Line 5573: l_project_id_tbl := system.pa_num_tbl_type();

5569:
5570: l_rbs_header_id := -1;
5571: l_rbs_version_id := -1;
5572: l_prj_index := 1;
5573: l_project_id_tbl := system.pa_num_tbl_type();
5574: l_project_id_tbl.delete;
5575:
5576: for c in rbs_push(p_worker_id) loop
5577:

Line 5706: l_project_id_tbl system.pa_num_tbl_type;

5702: l_program_id number;
5703: l_rbs_header_id number;
5704: l_rbs_version_id number;
5705: l_prj_index number;
5706: l_project_id_tbl system.pa_num_tbl_type;
5707: l_count number;
5708: l_rowid rowid;
5709: l_return_status varchar2(255);
5710: l_error_code varchar2(255);

Line 6103: l_project_id_tbl := system.pa_num_tbl_type();

6099: l_program_id := -1;
6100: l_rbs_header_id := -1;
6101: l_rbs_version_id := -1;
6102: l_prj_index := 1;
6103: l_project_id_tbl := system.pa_num_tbl_type();
6104: l_project_id_tbl.delete;
6105:
6106: for c in (select
6107: distinct

Line 18511: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

18507: l_created_by number;
18508: l_last_update_login number;
18509:
18510: l_count number;
18511: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
18512:
18513: begin
18514:
18515: l_last_update_date := sysdate;

Line 19440: l_project_id_tbl system.pa_num_tbl_type;

19436: l_process varchar2(30);
19437: l_extraction_type varchar2(30);
19438: l_extraction_type_wp varchar2(30);
19439:
19440: l_project_id_tbl system.pa_num_tbl_type;
19441: l_prj_index number;
19442: l_return_status varchar2(255);
19443: l_msg_count number;
19444: l_msg_data varchar2(2000);

Line 19469: l_project_id_tbl := system.pa_num_tbl_type();

19465: FROM DUAL;
19466:
19467: LOOP
19468:
19469: l_project_id_tbl := system.pa_num_tbl_type();
19470: l_project_id_tbl.delete;
19471: l_prj_index := 1;
19472:
19473: for c in project_list(p_worker_id) loop

Line 19603: l_project_id_tbl system.pa_num_tbl_type;

19599:
19600: l_process varchar2(30);
19601: l_extraction_type varchar2(30);
19602:
19603: l_project_id_tbl system.pa_num_tbl_type;
19604: l_prg_level_tbl system.pa_num_tbl_type;
19605: l_prj_index number;
19606: l_return_status varchar2(255);
19607: l_msg_count number;

Line 19604: l_prg_level_tbl system.pa_num_tbl_type;

19600: l_process varchar2(30);
19601: l_extraction_type varchar2(30);
19602:
19603: l_project_id_tbl system.pa_num_tbl_type;
19604: l_prg_level_tbl system.pa_num_tbl_type;
19605: l_prj_index number;
19606: l_return_status varchar2(255);
19607: l_msg_count number;
19608: l_msg_data varchar2(2000);

Line 19636: l_project_id_tbl := system.pa_num_tbl_type();

19632: and PLAN_VERSION_ID = -1);
19633:
19634: end if;
19635:
19636: l_project_id_tbl := system.pa_num_tbl_type();
19637: l_project_id_tbl.delete;
19638: l_prg_level_tbl := system.pa_num_tbl_type();
19639: l_prg_level_tbl.delete;
19640: l_prj_index := 1;

Line 19638: l_prg_level_tbl := system.pa_num_tbl_type();

19634: end if;
19635:
19636: l_project_id_tbl := system.pa_num_tbl_type();
19637: l_project_id_tbl.delete;
19638: l_prg_level_tbl := system.pa_num_tbl_type();
19639: l_prg_level_tbl.delete;
19640: l_prj_index := 1;
19641:
19642: for c in project_list(p_worker_id) loop