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_30_TBL_TYPE

Line 1733: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1729: l_rt_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1730:
1731: -- M-closeout: Bill Rate Override ER ------------------------------------------
1732: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1733: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1734: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1735: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1736: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1734: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1730:
1731: -- M-closeout: Bill Rate Override ER ------------------------------------------
1732: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1733: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1734: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1735: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1736: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1734: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1735: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1736: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1739: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();

Line 1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();

Line 1756: l_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1752: l_mfc_cost_source CONSTANT NUMBER := 2;
1753: l_txn_currency_code VARCHAR2(100);
1754:
1755: l_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1756: l_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1757: l_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1758: l_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1759: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1760: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1758: l_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1754:
1755: l_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1756: l_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1757: l_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1758: l_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1759: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1760: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1761: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1763: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1759: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1760: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1761: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1764: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1765: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1766: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1767:

Line 1764: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1760: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1761: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1764: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1765: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1766: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1767:
1768: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1765: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1761: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1764: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1765: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1766: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1767:
1768: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1769: l_rej_start_date_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 1769: l_rej_start_date_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1765: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1766: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1767:
1768: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1769: l_rej_start_date_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1770: l_rej_txn_currency_code_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1771: l_rej_revenue_rej_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1772: -- END OF M-closeout: Bill Rate Override ER ------------------------------------------
1773:

Line 1771: l_rej_revenue_rej_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1767:
1768: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1769: l_rej_start_date_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1770: l_rej_txn_currency_code_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1771: l_rej_revenue_rej_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1772: -- END OF M-closeout: Bill Rate Override ER ------------------------------------------
1773:
1774: l_rt_exp_func_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1775: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1849: l_proj_bill_rate_cur_ovrd_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1845: l_proj_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1846: l_proj_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1847: -- M-Closeout ER: Bill Rate Override ER
1848: l_proj_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1849: l_proj_bill_rate_cur_ovrd_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1850: l_calculate_mode VARCHAR2(30);
1851: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
1852: l_bill_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
1853: l_cost_sch_type VARCHAR2(30) := 'COST';

Line 2040: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

2036: -- Bug 4549862: Added pl/sql tables for budget line update.
2037: l_upd_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2038: l_upd_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2039: l_upd_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2040: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2041: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2042: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2043: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2044: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2042: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

2038: l_upd_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2039: l_upd_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2040: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2041: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2042: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2043: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2044: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2045: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2046: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2047: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

2043: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2044: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2045: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2046: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2047: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2048: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2049: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2050: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2051:

Line 2048: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

2044: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2045: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2046: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2047: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2048: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2049: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2050: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2051:
2052: -- Bug 4549862: PL/SQL tables for rejection code processing

Line 2049: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

2045: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2046: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2047: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2048: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2049: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2050: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2051:
2052: -- Bug 4549862: PL/SQL tables for rejection code processing
2053: l_rej_code_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 4596: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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;
4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4598: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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;
4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4601: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4602: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 4601: l_da_person_type_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;
4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4601: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4602: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4604: l_da_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
4605: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4605: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4606: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4606: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4614: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_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;

Line 4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_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;

Line 4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_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;

Line 4616: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_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;

Line 4619: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_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;
4623: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 4621: l_da_unit_of_measure_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;
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;

Line 4624: l_da_rate_expenditure_type_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:
4628: /* Performance-Variables to replace the literals in the Insert into

Line 4625: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_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:
4628: /* Performance-Variables to replace the literals in the Insert into
4629: pa_resource_assignments stmts. */

Line 4626: l_da_incur_by_res_type_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:
4628: /* Performance-Variables to replace the literals in the Insert into
4629: pa_resource_assignments stmts. */
4630: l_task_id_01 NUMBER:=0;

Line 4641: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4637: l_wp_version_flag pa_budget_Versions.wp_version_flag%TYPE;
4638: l_gen_src_code pa_proj_fp_options.gen_all_src_code%TYPE := null;
4639:
4640: --Bug 4052036. This tbl will hold the ra ids that are inserted in this API
4641: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4642: BEGIN
4643: X_MSG_COUNT := 0;
4644: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4645: