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

Line 1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

1741: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1742: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1743: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1747: l_rt_res_format_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_res_list_member_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1908: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

1904: l_burdened_rate_adj_pct NUMBER := NULL;
1905: l_bill_rate_adj_pct NUMBER := NULL;
1906: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
1907:
1908: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1909: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1910: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1911: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1912: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1909: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

1905: l_bill_rate_adj_pct NUMBER := NULL;
1906: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
1907:
1908: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1909: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1910: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1911: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1912: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1998: l_t_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

1994: l_t_bill_rate_adj_pct NUMBER := NULL;
1995: l_t_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
1996:
1997: l_t_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1998: l_t_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1999: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2000: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2001: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2002: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1999: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

1995: l_t_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
1996:
1997: l_t_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1998: l_t_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1999: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2000: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2001: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2002: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2003: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2026: l_calc_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

2022: l_transaction_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;
2023:
2024: -- Bug 4548733: Added new pl/sql table to hold billability flag values for
2025: -- Calculate API. Corresponds to p_fp_task_billable_flag_tab IN parameter.
2026: l_calc_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2027:
2028: -- Bug 4549862: Added counter to track unique budget_line_id values for
2029: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and
2030: -- then incremented by 1 prior to each Insert to the temp table.

Line 4595: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

4591: l_project_id NUMBER(15);
4592:
4593: --Local Variables for calling get_resource_defaults API
4594: l_da_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
4595: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4596: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4597: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4598: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4599: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4618: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

4614: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4615: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4616: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4617: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4618: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4619: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4620: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4621: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4622: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4623: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

4619: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4620: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4621: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4622: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4623: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4624: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4625: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4626: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4627:

Line 6253: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

6249: l_burdened_rate_adj_pct NUMBER := NULL;
6250: l_bill_rate_adj_pct NUMBER := NULL;
6251: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
6252:
6253: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6254: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6255: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6256: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6254: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

6250: l_bill_rate_adj_pct NUMBER := NULL;
6251: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
6252:
6253: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6254: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6255: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6256: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6799: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

6795: l_burdened_rate_adj_pct NUMBER := NULL;
6796: l_bill_rate_adj_pct NUMBER := NULL;
6797: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
6798:
6799: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6800: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6801: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6802: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6800: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

6796: l_bill_rate_adj_pct NUMBER := NULL;
6797: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
6798:
6799: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6800: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6801: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6802: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();