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_FP_WEBADI_PKG dependencies on PA_VARCHAR2_1_TBL_TYPE

Line 1685: x_delete_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895

1681: x_spread_curve_name_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE, --File.Sql.39 bug 4440895
1682: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895
1683: x_etc_method_name_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE, --File.Sql.39 bug 4440895
1684: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1685: x_delete_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1686: x_ra_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1687: x_res_class_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1688: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1689: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1688: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895

1684: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1685: x_delete_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1686: x_ra_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1687: x_res_class_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1688: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1689: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1690: x_cbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, -- cbs enhancement changes bug#16445106
1691: x_amt_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1692: x_first_pd_bf_pm_en_dt OUT NOCOPY DATE, --File.Sql.39 bug 4440895

Line 1840: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

1836: l_uom_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
1837: l_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1838: l_delete_flag VARCHAR2(1);
1839: l_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1840: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1841: l_spread_curve_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1842: l_etc_method_code_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
1843: l_mfc_cost_type_name_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
1844: l_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 1972: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

1968: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1969:
1970: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1971: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1972: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1973: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1974:
1975: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106
1976: l_cbs_elem_id pa_resource_assignments.cbs_element_id%TYPE;-- cbs enhancement changes bug#16445106

Line 6805: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,

6801: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type,
6802: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6803: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type,
6804: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6805: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6806: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type,
6807: p_cbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type, -- cbs enhancement changes bug#16445106
6808: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6809: x_task_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895

Line 6808: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,

6804: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6805: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6806: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type,
6807: p_cbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type, -- cbs enhancement changes bug#16445106
6808: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6809: x_task_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6810: x_rlm_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6811: x_cbs_element_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- cbs enhancement changes bug#16445106
6812: x_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895

Line 6841: x_delete_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895

6837: x_pfunc_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6838: x_pfunc_rev_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6839: x_pfunc_rev_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6840: x_pfunc_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6841: x_delete_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
6842: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6843: x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6844: x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6845: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

Line 6847: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type , --File.Sql.39 bug 4440895

6843: x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6844: x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6845: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6846: x_res_class_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6847: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type , --File.Sql.39 bug 4440895
6848: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6849: x_change_reason_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, --File.Sql.39 bug 4440895
6850: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895
6851: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 7102: x_delete_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();

7098: x_pfunc_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7099: x_pfunc_rev_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7100: x_pfunc_rev_rate_tbl := SYSTEM.pa_num_tbl_type();
7101: x_pfunc_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7102: x_delete_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7103: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
7104: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
7105: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7106: x_sp_fixed_date_tbl := SYSTEM.pa_date_tbl_type();

Line 7108: x_rate_based_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();

7104: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
7105: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7106: x_sp_fixed_date_tbl := SYSTEM.pa_date_tbl_type();
7107: x_res_class_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7108: x_rate_based_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7109: x_rbs_elem_id_tbl := SYSTEM.pa_num_tbl_type();
7110: x_change_reason_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7111: x_description_tbl := SYSTEM.pa_varchar2_2000_tbl_type();
7112:

Line 8131: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),

8127: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8128: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8129: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8130: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8131: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8132: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8133: p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type(),
8134: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8135: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

Line 8163: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),

8159: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8160: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8161: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8162: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type(),
8163: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8164: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8165: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8166: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8167: )

Line 8192: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

8188: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8189: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8190: l_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8191: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8192: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8193: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8194: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8195: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8196: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8236: l_df_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

8232: l_df_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8233: l_df_etc_method_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8234: l_df_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8235: l_df_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8236: l_df_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8237: l_df_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8238: l_df_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8239: l_df_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8240: l_df_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8393: l_upd_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

8389: l_upd_txn_init_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8390: l_upd_txn_init_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8391: l_upd_txn_init_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8392: l_upd_budget_line_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8393: l_upd_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8394: l_upd_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8395: l_upd_pj_cost_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8396: l_upd_pj_cost_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8397: l_upd_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8419: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

8415: l_chg_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8416: l_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8417:
8418: --bug 5962744
8419: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8420: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8421: l_ex_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8422: l_ra_exists VARCHAR2(1);
8423: l_extra_bls_exists VARCHAR2(1);

Line 10340: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

10336:
10337: l_set_ppc_flag_on_err VARCHAR2(1);
10338:
10339: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;
10340: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10341: l_delete_flag_tbl_1 SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10342:
10343: i INTEGER;
10344: l_error_indicator_flag VARCHAR2(1);

Line 10341: l_delete_flag_tbl_1 SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

10337: l_set_ppc_flag_on_err VARCHAR2(1);
10338:
10339: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;
10340: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10341: l_delete_flag_tbl_1 SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10342:
10343: i INTEGER;
10344: l_error_indicator_flag VARCHAR2(1);
10345:

Line 10393: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

10389: l_etc_raw_cost_tbl SYSTEM.pa_num_tbl_type;
10390: l_etc_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
10391: l_etc_revenue_tbl SYSTEM.pa_num_tbl_type;
10392: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10393: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10394: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10395: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type; -- cbs enhancement changes bug#16445106
10396: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10397: l_prc_ra_id_tbl SYSTEM.pa_num_tbl_type;

Line 10399: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

10395: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type; -- cbs enhancement changes bug#16445106
10396: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10397: l_prc_ra_id_tbl SYSTEM.pa_num_tbl_type;
10398: l_prc_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10399: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
10400: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10401: l_prc_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type;-- cbs enhancement changes bug#16445106
10402:
10403: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,