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 1684: x_delete_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895

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

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

1683: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1684: x_delete_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1685: x_ra_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1686: x_res_class_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1687: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1688: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1689: x_amt_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1690: x_first_pd_bf_pm_en_dt OUT NOCOPY DATE, --File.Sql.39 bug 4440895
1691: x_last_pd_af_pm_st_dt OUT NOCOPY DATE, --File.Sql.39 bug 4440895

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

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

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

1962: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1963:
1964: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1965: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1966: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1967: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1968:
1969: l_min_ra_plan_start_date DATE;
1970: l_max_ra_plan_end_date DATE;

Line 6698: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,

6694: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type,
6695: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6696: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type,
6697: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6698: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6699: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type,
6700: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6701: x_task_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6702: x_rlm_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895

Line 6700: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,

6696: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type,
6697: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6698: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6699: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type,
6700: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6701: x_task_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6702: x_rlm_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6703: x_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6704: x_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type , --File.Sql.39 bug 4440895

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

6728: x_pfunc_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6729: x_pfunc_rev_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6730: x_pfunc_rev_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6731: x_pfunc_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6732: x_delete_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
6733: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6734: x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6735: x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6736: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

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

6734: x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6735: x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6736: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6737: x_res_class_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6738: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type , --File.Sql.39 bug 4440895
6739: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6740: x_change_reason_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, --File.Sql.39 bug 4440895
6741: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895
6742: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

6975: x_pfunc_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6976: x_pfunc_rev_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6977: x_pfunc_rev_rate_tbl := SYSTEM.pa_num_tbl_type();
6978: x_pfunc_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();
6979: x_delete_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
6980: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
6981: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6982: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6983: x_sp_fixed_date_tbl := SYSTEM.pa_date_tbl_type();

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

6981: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6982: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6983: x_sp_fixed_date_tbl := SYSTEM.pa_date_tbl_type();
6984: x_res_class_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6985: x_rate_based_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
6986: x_rbs_elem_id_tbl := SYSTEM.pa_num_tbl_type();
6987: x_change_reason_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6988: x_description_tbl := SYSTEM.pa_varchar2_2000_tbl_type();
6989:

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

7977: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7978: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
7979: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
7980: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
7981: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
7982: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7983: p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type(),
7984: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
7985: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

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

8009: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8010: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8011: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8012: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type(),
8013: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8014: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8015: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8016: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8017: )

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

8037: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8038: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8039: l_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8040: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8041: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8042: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8043: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8044: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8045: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

8080: l_df_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8081: l_df_etc_method_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8082: l_df_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8083: l_df_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8084: l_df_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8085: l_df_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8086: l_df_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8087: l_df_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8088: l_df_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

8236: l_upd_txn_init_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8237: l_upd_txn_init_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8238: l_upd_txn_init_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8239: l_upd_budget_line_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8240: l_upd_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8241: l_upd_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8242: l_upd_pj_cost_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8243: l_upd_pj_cost_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8244: l_upd_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

8262: l_chg_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8263: l_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8264:
8265: --bug 5962744
8266: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8267: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8268: l_ex_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8269: l_ra_exists VARCHAR2(1);
8270: l_extra_bls_exists VARCHAR2(1);

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

10157:
10158: l_set_ppc_flag_on_err VARCHAR2(1);
10159:
10160: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;
10161: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10162: l_delete_flag_tbl_1 SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10163:
10164: i INTEGER;
10165: l_error_indicator_flag VARCHAR2(1);

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

10158: l_set_ppc_flag_on_err VARCHAR2(1);
10159:
10160: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;
10161: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10162: l_delete_flag_tbl_1 SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10163:
10164: i INTEGER;
10165: l_error_indicator_flag VARCHAR2(1);
10166:

Line 10214: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

10210: l_etc_raw_cost_tbl SYSTEM.pa_num_tbl_type;
10211: l_etc_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
10212: l_etc_revenue_tbl SYSTEM.pa_num_tbl_type;
10213: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10214: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10215: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10216: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10217: l_prc_ra_id_tbl SYSTEM.pa_num_tbl_type;
10218: l_prc_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 10219: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

10215: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10216: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10217: l_prc_ra_id_tbl SYSTEM.pa_num_tbl_type;
10218: l_prc_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10219: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
10220: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10221:
10222: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10223: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,