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 1745: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1741: l_rt_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1742:
1743: -- M-closeout: Bill Rate Override ER ------------------------------------------
1744: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1745: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1746: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1747: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1742:
1743: -- M-closeout: Bill Rate Override ER ------------------------------------------
1744: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1745: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1746: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1747: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1750: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

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

1746: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1747: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1750: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1751: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1752: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1753: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1754: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1752: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1753: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1754: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1755: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1756: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1757: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1758: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1759: l_rt_res_format_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1760: l_rt_res_list_member_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1764: l_mfc_cost_source CONSTANT NUMBER := 2;
1765: l_txn_currency_code VARCHAR2(100);
1766:
1767: l_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1768: l_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1769: l_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1770: l_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1771: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1772: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1766:
1767: l_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1768: l_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1769: l_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1770: l_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1771: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1772: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1773: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1774: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1771: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1772: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1773: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1774: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1775: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1776: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1777: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1778: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1779:

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

1772: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1773: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1774: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1775: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1776: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1777: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1778: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1779:
1780: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1773: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1774: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1775: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1776: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1777: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1778: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1779:
1780: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1781: l_rej_start_date_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

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

1777: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1778: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1779:
1780: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1781: l_rej_start_date_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1782: l_rej_txn_currency_code_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1783: l_rej_revenue_rej_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1784: -- END OF M-closeout: Bill Rate Override ER ------------------------------------------
1785:

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

1779:
1780: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1781: l_rej_start_date_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1782: l_rej_txn_currency_code_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1783: l_rej_revenue_rej_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1784: -- END OF M-closeout: Bill Rate Override ER ------------------------------------------
1785:
1786: l_rt_exp_func_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1787: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

1857: l_proj_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1858: l_proj_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1859: -- M-Closeout ER: Bill Rate Override ER
1860: l_proj_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1861: l_proj_bill_rate_cur_ovrd_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1862: l_calculate_mode VARCHAR2(30);
1863: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
1864: l_bill_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
1865: l_cost_sch_type VARCHAR2(30) := 'COST';

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

2048: -- Bug 4549862: Added pl/sql tables for budget line update.
2049: l_upd_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2050: l_upd_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2051: l_upd_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2052: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2053: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2054: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2055: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2056: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2050: l_upd_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2051: l_upd_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2052: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2053: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2054: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2055: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2056: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2057: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2058: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2055: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2056: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2057: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2058: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2059: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2060: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2061: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2062: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2063:

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

2056: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2057: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2058: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2059: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2060: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2061: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2062: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2063:
2064: -- Bug 4549862: PL/SQL tables for rejection code processing

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

2057: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2058: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2059: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2060: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2061: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2062: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2063:
2064: -- Bug 4549862: PL/SQL tables for rejection code processing
2065: l_rej_code_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 4765: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4761:
4762: --Local Variables for calling get_resource_defaults API
4763: l_da_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
4764: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4765: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4766: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4767: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4768: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4769: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4767: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4763: l_da_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
4764: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4765: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4766: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4767: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4768: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4769: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4770: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4771: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 4770: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4766: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4767: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4768: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4769: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4770: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4771: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
4772: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4773: l_da_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
4774: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4778: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4774: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4775: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4776: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4777: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4778: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4779: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4780: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4781: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4782: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4779: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4775: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4776: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4777: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4778: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4779: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4780: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4781: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4782: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4783: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4780: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4776: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4777: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4778: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4779: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4780: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4781: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4782: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4783: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4784: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4781: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4777: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4778: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4779: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4780: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4781: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4782: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4783: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4784: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4785: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4782: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4778: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4779: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4780: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4781: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4782: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4783: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4784: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4785: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4786: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4785: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4781: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4782: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4783: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4784: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4785: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4786: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4787: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4788: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4789: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4788: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4784: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4785: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4786: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4787: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4788: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4789: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4790: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4791: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4792: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 4790: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4786: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4787: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4788: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4789: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4790: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4791: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4792: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4793: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4794: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4793: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4789: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4790: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4791: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4792: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4793: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4794: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4795: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4796:
4797: /* Performance-Variables to replace the literals in the Insert into

Line 4794: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4790: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4791: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4792: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4793: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4794: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4795: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4796:
4797: /* Performance-Variables to replace the literals in the Insert into
4798: pa_resource_assignments stmts. */

Line 4795: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4791: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4792: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4793: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4794: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4795: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4796:
4797: /* Performance-Variables to replace the literals in the Insert into
4798: pa_resource_assignments stmts. */
4799: l_task_id_01 NUMBER:=0;

Line 4810: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

4806: l_wp_version_flag pa_budget_Versions.wp_version_flag%TYPE;
4807: l_gen_src_code pa_proj_fp_options.gen_all_src_code%TYPE := null;
4808:
4809: --Bug 4052036. This tbl will hold the ra ids that are inserted in this API
4810: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4811: l_Cbs_Element_Id_tab SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); -- bug#16200605
4812: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16200605
4813: l_cbs_element_id NUMBER; -- bug#16200605
4814: l_cbs_ele_ids PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605