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 1941: l_project_id_tbl system.pa_num_tbl_type;

1937: l_program_id number;
1938: l_rbs_header_id number;
1939: l_rbs_version_id number;
1940: l_prj_index number;
1941: l_project_id_tbl system.pa_num_tbl_type;
1942: l_count number;
1943: l_rowid rowid;
1944: l_return_status varchar2(255);
1945: l_error_code varchar2(255);

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

1970:
1971: l_rbs_header_id := -1;
1972: l_rbs_version_id := -1;
1973: l_prj_index := 1;
1974: l_project_id_tbl := system.pa_num_tbl_type();
1975: l_project_id_tbl.delete;
1976:
1977: for c in rbs_prg_full(p_worker_id) loop
1978:

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

2137: l_program_id := -1;
2138: l_rbs_header_id := -1;
2139: l_rbs_version_id := -1;
2140: l_prj_index := 1;
2141: l_project_id_tbl := system.pa_num_tbl_type();
2142: l_project_id_tbl.delete;
2143:
2144: for c in rbs_prg(p_worker_id) loop
2145:

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

2265:
2266: l_rbs_header_id := -1;
2267: l_rbs_version_id := -1;
2268: l_prj_index := 1;
2269: l_project_id_tbl := system.pa_num_tbl_type();
2270: l_project_id_tbl.delete;
2271:
2272: for c in rbs_assoc(p_worker_id) loop
2273:

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

2375:
2376: l_rbs_header_id := -1;
2377: l_rbs_version_id := -1;
2378: l_prj_index := 1;
2379: l_project_id_tbl := system.pa_num_tbl_type();
2380: l_project_id_tbl.delete;
2381:
2382: for c in rbs_push(p_worker_id) loop
2383:

Line 2512: l_project_id_tbl system.pa_num_tbl_type;

2508: l_program_id number;
2509: l_rbs_header_id number;
2510: l_rbs_version_id number;
2511: l_prj_index number;
2512: l_project_id_tbl system.pa_num_tbl_type;
2513: l_count number;
2514: l_rowid rowid;
2515: l_return_status varchar2(255);
2516: l_error_code varchar2(255);

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

2845: l_program_id := -1;
2846: l_rbs_header_id := -1;
2847: l_rbs_version_id := -1;
2848: l_prj_index := 1;
2849: l_project_id_tbl := system.pa_num_tbl_type();
2850: l_project_id_tbl.delete;
2851:
2852: for c in (select
2853: distinct

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

16327: l_created_by number;
16328: l_last_update_login number;
16329:
16330: l_count number;
16331: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
16332:
16333: begin
16334:
16335: l_last_update_date := sysdate;

Line 17159: l_project_id_tbl system.pa_num_tbl_type;

17155: l_process varchar2(30);
17156: l_extraction_type varchar2(30);
17157: l_extraction_type_wp varchar2(30);
17158:
17159: l_project_id_tbl system.pa_num_tbl_type;
17160: l_prj_index number;
17161: l_return_status varchar2(255);
17162: l_msg_count number;
17163: l_msg_data varchar2(2000);

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

17184: FROM DUAL;
17185:
17186: LOOP
17187:
17188: l_project_id_tbl := system.pa_num_tbl_type();
17189: l_project_id_tbl.delete;
17190: l_prj_index := 1;
17191:
17192: for c in project_list(p_worker_id) loop

Line 17320: l_project_id_tbl system.pa_num_tbl_type;

17316:
17317: l_process varchar2(30);
17318: l_extraction_type varchar2(30);
17319:
17320: l_project_id_tbl system.pa_num_tbl_type;
17321: l_prg_level_tbl system.pa_num_tbl_type;
17322: l_prj_index number;
17323: l_return_status varchar2(255);
17324: l_msg_count number;

Line 17321: l_prg_level_tbl system.pa_num_tbl_type;

17317: l_process varchar2(30);
17318: l_extraction_type varchar2(30);
17319:
17320: l_project_id_tbl system.pa_num_tbl_type;
17321: l_prg_level_tbl system.pa_num_tbl_type;
17322: l_prj_index number;
17323: l_return_status varchar2(255);
17324: l_msg_count number;
17325: l_msg_data varchar2(2000);

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

17349: and PLAN_VERSION_ID = -1);
17350:
17351: end if;
17352:
17353: l_project_id_tbl := system.pa_num_tbl_type();
17354: l_project_id_tbl.delete;
17355: l_prg_level_tbl := system.pa_num_tbl_type();
17356: l_prg_level_tbl.delete;
17357: l_prj_index := 1;

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

17351: end if;
17352:
17353: l_project_id_tbl := system.pa_num_tbl_type();
17354: l_project_id_tbl.delete;
17355: l_prg_level_tbl := system.pa_num_tbl_type();
17356: l_prg_level_tbl.delete;
17357: l_prj_index := 1;
17358:
17359: for c in project_list(p_worker_id) loop