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 2011: l_source_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

2007: -- Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------
2008:
2009:
2010:
2011: l_source_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2012:
2013: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2014:
2015: l_source_ver_type_tbl SYSTEM.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

2009:
2010:
2011: l_source_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2012:
2013: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2014:
2015: l_source_ver_type_tbl SYSTEM.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
2016:
2017: l_dest_ver_type_tbl SYSTEM.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

2037: l_src_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2038: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
2039: l_src_version_type VARCHAR2(15);
2040: l_target_version_type VARCHAR2(15);
2041: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2042: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2043: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2044: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2045: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();

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

2039: l_src_version_type VARCHAR2(15);
2040: l_target_version_type VARCHAR2(15);
2041: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2042: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2043: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2044: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2045: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2046: l_debug_level5 NUMBER:=5;
2047:

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

2040: l_target_version_type VARCHAR2(15);
2041: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2042: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2043: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2044: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2045: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2046: l_debug_level5 NUMBER:=5;
2047:
2048: /* Bug 5099353 Start */

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

2041: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2042: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2043: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2044: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2045: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2046: l_debug_level5 NUMBER:=5;
2047:
2048: /* Bug 5099353 Start */
2049: l_is_eligible_for_rollup VARCHAR2(1);

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

5302: l_pa_start_date VARCHAR2(100);
5303: l_plan_version_exists_flag VARCHAR2(1);
5304: l_prj_start_date VARCHAR2(100);
5305: l_prj_end_date VARCHAR2(100);
5306: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5307:
5308: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5309: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5310:

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

5432: l_copy_res_assmt_from_cwv_flag VARCHAR2(1);
5433: -- ---------------------------------------------------------------------------
5434: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5435:
5436: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5437: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5438: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5439: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5440: l_pji_rollup_required VARCHAR2(1);

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

5433: -- ---------------------------------------------------------------------------
5434: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5435:
5436: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5437: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5438: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5439: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5440: l_pji_rollup_required VARCHAR2(1);
5441:

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

5434: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5435:
5436: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5437: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5438: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5439: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5440: l_pji_rollup_required VARCHAR2(1);
5441:
5442:

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

5435:
5436: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5437: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5438: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5439: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5440: l_pji_rollup_required VARCHAR2(1);
5441:
5442:
5443:

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

6341: IF l_pji_rollup_required = 'Y' THEN --for Bug 4200168
6342: IF p_ci_id IS NULL THEN
6343: /* FP M - Reporting lines integration */
6344: l_budget_version_ids.delete;
6345: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_new_budget_version_id);
6346:
6347: IF P_PA_DEBUG_MODE = 'Y' THEN
6348: pa_debug.write('Create_Version: ' || l_module_name,'Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE ' ,5);
6349: pa_debug.write('Create_Version: ' || l_module_name,'p_fp_version_ids count '|| l_budget_version_ids.count(),5);

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

8480:
8481: PROCEDURE create_default_plan_txn_rec
8482: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8483: p_calling_module IN VARCHAR2,
8484: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */
8485: p_curr_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(), /* 7161809 */
8486: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(), /* Enc */
8487: x_return_status OUT NOCOPY VARCHAR2,
8488: x_msg_count OUT NOCOPY NUMBER,

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

8517: pa_resource_asgn_curr_tmp pract
8518: WHERE prac.resource_assignment_id = pract.resource_assignment_id
8519: and prac.budget_version_id = pract.budget_version_id;
8520:
8521: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8522: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8523: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8524: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); /* EnC */
8525: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;

Line 8538: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

8534: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
8535: l_debug_level5 NUMBER:=5;
8536:
8537: --Bug 8223977
8538: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8539: l_burd_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8540: l_raw_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8541: l_bill_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8542:

Line 8539: l_burd_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

8535: l_debug_level5 NUMBER:=5;
8536:
8537: --Bug 8223977
8538: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8539: l_burd_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8540: l_raw_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8541: l_bill_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8542:
8543: BEGIN

Line 8540: l_raw_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

8536:
8537: --Bug 8223977
8538: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8539: l_burd_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8540: l_raw_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8541: l_bill_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8542:
8543: BEGIN
8544: x_msg_count := 0;

Line 8541: l_bill_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

8537: --Bug 8223977
8538: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8539: l_burd_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8540: l_raw_cost_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8541: l_bill_rate_ovr_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8542:
8543: BEGIN
8544: x_msg_count := 0;
8545: x_msg_data := NULL;