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

Line 861: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(p_budget_version_id);

857:
858: /* FP M - Reporting lines integration */
859:
860: DECLARE
861: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(p_budget_version_id);
862: BEGIN
863: pa_debug.write('Mark_As_Original','Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_ORIGINAL ' ,5);
864: pa_debug.write('Mark_As_Original','p_baseline_version_id '|| p_budget_version_id,5);
865: PJI_FM_XBS_ACCUM_MAINT.PLAN_ORIGINAL (

Line 935: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

931: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
932: l_exists varchar2(1);
933: l_module_name VARCHAR2(100):='PAFPPUBB.delete_version';
934: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
935: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
936:
937: /* Bug 2688610 - Add the following two locals*/
938: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
939: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 1995: l_source_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

1991: -- Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------
1992:
1993:
1994:
1995: l_source_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
1996:
1997: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
1998:
1999: l_source_ver_type_tbl SYSTEM.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 1997: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

1993:
1994:
1995: l_source_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
1996:
1997: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
1998:
1999: l_source_ver_type_tbl SYSTEM.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
2000:
2001: l_dest_ver_type_tbl SYSTEM.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 2025: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

2021: l_src_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2022: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
2023: l_src_version_type VARCHAR2(15);
2024: l_target_version_type VARCHAR2(15);
2025: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2026: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2027: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2028: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2029: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

Line 2027: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

2023: l_src_version_type VARCHAR2(15);
2024: l_target_version_type VARCHAR2(15);
2025: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2026: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2027: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2028: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2029: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2030: l_debug_level5 NUMBER:=5;
2031:

Line 2028: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

2024: l_target_version_type VARCHAR2(15);
2025: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2026: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2027: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2028: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2029: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2030: l_debug_level5 NUMBER:=5;
2031:
2032: /* Bug 5099353 Start */

Line 2029: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

2025: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2026: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2027: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2028: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2029: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2030: l_debug_level5 NUMBER:=5;
2031:
2032: /* Bug 5099353 Start */
2033: l_is_eligible_for_rollup VARCHAR2(1);

Line 5290: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5286: l_pa_start_date VARCHAR2(100);
5287: l_plan_version_exists_flag VARCHAR2(1);
5288: l_prj_start_date VARCHAR2(100);
5289: l_prj_end_date VARCHAR2(100);
5290: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5291:
5292: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5293: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5294:

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

5415: l_copy_res_assmt_from_cwv_flag VARCHAR2(1);
5416: -- ---------------------------------------------------------------------------
5417: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5418:
5419: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5420: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5423: l_pji_rollup_required VARCHAR2(1);

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

5416: -- ---------------------------------------------------------------------------
5417: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5418:
5419: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5420: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5423: l_pji_rollup_required VARCHAR2(1);
5424:

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

5417: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5418:
5419: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5420: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5423: l_pji_rollup_required VARCHAR2(1);
5424:
5425:

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

5418:
5419: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5420: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5422: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5423: l_pji_rollup_required VARCHAR2(1);
5424:
5425:
5426:

Line 6325: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_new_budget_version_id);

6321: IF l_pji_rollup_required = 'Y' THEN --for Bug 4200168
6322: IF p_ci_id IS NULL THEN
6323: /* FP M - Reporting lines integration */
6324: l_budget_version_ids.delete;
6325: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_new_budget_version_id);
6326:
6327: IF P_PA_DEBUG_MODE = 'Y' THEN
6328: pa_debug.write('Create_Version: ' || l_module_name,'Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE ' ,5);
6329: pa_debug.write('Create_Version: ' || l_module_name,'p_fp_version_ids count '|| l_budget_version_ids.count(),5);

Line 8464: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */

8460:
8461: PROCEDURE create_default_plan_txn_rec
8462: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8463: p_calling_module IN VARCHAR2,
8464: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */
8465: p_curr_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(), /* 7161809 */
8466: x_return_status OUT NOCOPY VARCHAR2,
8467: x_msg_count OUT NOCOPY NUMBER,
8468: x_msg_data OUT NOCOPY VARCHAR2)

Line 8488: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

8484: FROM pa_resource_asgn_curr rac
8485: WHERE rac.resource_assignment_id = ra.resource_assignment_id
8486: AND rac.budget_version_id = ra.budget_version_id);
8487:
8488: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8489: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8490: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8491:
8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;