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_FM_XBS_ACCUM_UTILS dependencies on PA_NUM_TBL_TYPE

Line 357: p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

353:
354:
355:
356: PROCEDURE get_summarized_data (
357: p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
358: p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
359: p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
360: p_start_date IN DATE := NULL,
361: p_end_date IN SYSTEM.pa_date_tbl_type := system.pa_date_tbl_type(),

Line 358: p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

354:
355:
356: PROCEDURE get_summarized_data (
357: p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
358: p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
359: p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
360: p_start_date IN DATE := NULL,
361: p_end_date IN SYSTEM.pa_date_tbl_type := system.pa_date_tbl_type(),
362: p_start_period_name IN VARCHAR2 := NULL,

Line 359: p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

355:
356: PROCEDURE get_summarized_data (
357: p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
358: p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
359: p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
360: p_start_date IN DATE := NULL,
361: p_end_date IN SYSTEM.pa_date_tbl_type := system.pa_date_tbl_type(),
362: p_start_period_name IN VARCHAR2 := NULL,
363: p_end_period_name IN VARCHAR2 := NULL,

Line 377: l_end_period_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Added for workplan progress */

373: l_end_period_id NUMBER;
374: l_period_type_id NUMBER;
375: l_org_id NUMBER;
376: End of workplan progress */
377: l_end_period_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Added for workplan progress */
378: l_currency_mask NUMBER;
379: l_period_type_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/*Added for workplan progress */
380: l_periodic_flag VARCHAR2(1);
381: l_planres_level_flag VARCHAR2(1);

Line 379: l_period_type_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/Added for workplan progress /

375: l_org_id NUMBER;
376: End of workplan progress */
377: l_end_period_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Added for workplan progress */
378: l_currency_mask NUMBER;
379: l_period_type_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/*Added for workplan progress */
380: l_periodic_flag VARCHAR2(1);
381: l_planres_level_flag VARCHAR2(1);
382: l_task_level_flag VARCHAR2(1);
383: l_task_rollup_flag VARCHAR2(1);

Line 388: l_org_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/Added for workplan progress /

384: l_proj_level_flag VARCHAR2(1);
385: l_summarized_flag VARCHAR2(1);
386: l_msg_count NUMBER;
387: l_calendar_type SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
388: l_org_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/*Added for workplan progress */
389: l_map_resource_list EXCEPTION;
390: l_get_summarized_data varchar2(1) :='Y';
391: l_summ_hasrun varchar2(1) :='N';
392:

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

2316: p_program_rollup_flag IN VARCHAR2 := 'N',
2317: x_return_status OUT NOCOPY VARCHAR2,
2318: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2319:
2320: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2321: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2322: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2323: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2324: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 2321: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2317: x_return_status OUT NOCOPY VARCHAR2,
2318: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2319:
2320: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2321: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2322: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2323: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2324: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2325: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 2322: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2318: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2319:
2320: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2321: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2322: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2323: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2324: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2325: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2326: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 2323: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2319:
2320: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2321: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2322: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2323: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2324: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2325: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2326: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2327:

Line 2325: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2321: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2322: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2323: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2324: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2325: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2326: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2327:
2328: l_org_id NUMBER;
2329: l_return_status VARCHAR2(1);

Line 2326: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2322: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2323: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2324: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2325: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2326: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2327:
2328: l_org_id NUMBER;
2329: l_return_status VARCHAR2(1);
2330:

Line 3491: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3487: AND fpo.fin_plan_option_level_code = 'PLAN_VERSION'
3488: AND bv.version_type IN ( 'ALL' , 'COST' , 'REVENUE')
3489: AND fpo.RBS_VERSION_ID = l_rbs_version_id;
3490:
3491: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3492: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3493: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3494: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3495:

Line 3492: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3488: AND bv.version_type IN ( 'ALL' , 'COST' , 'REVENUE')
3489: AND fpo.RBS_VERSION_ID = l_rbs_version_id;
3490:
3491: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3492: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3493: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3494: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3495:
3496: BEGIN

Line 3493: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3489: AND fpo.RBS_VERSION_ID = l_rbs_version_id;
3490:
3491: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3492: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3493: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3494: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3495:
3496: BEGIN
3497:

Line 3494: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3490:
3491: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3492: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3493: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3494: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3495:
3496: BEGIN
3497:
3498: x_msg_count := 0;

Line 3581: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

3577: x_return_status OUT NOCOPY VARCHAR2,
3578: x_msg_code OUT NOCOPY VARCHAR2) IS
3579:
3580: l_struct_element_id NUMBER;
3581: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3582: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3583: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3584: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type :=
3585: SYSTEM.pa_varchar2_1_tbl_type();

Line 3582: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

3578: x_msg_code OUT NOCOPY VARCHAR2) IS
3579:
3580: l_struct_element_id NUMBER;
3581: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3582: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3583: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3584: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type :=
3585: SYSTEM.pa_varchar2_1_tbl_type();
3586: l_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 3583: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

3579:
3580: l_struct_element_id NUMBER;
3581: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3582: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3583: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3584: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type :=
3585: SYSTEM.pa_varchar2_1_tbl_type();
3586: l_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3587: