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_NUM_TBL_TYPE

Line 1744: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1740: l_rt_exp_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
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();

Line 1747: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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();
1751: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();

Line 1748: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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();
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();

Line 1749: l_rt_person_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();
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();

Line 1752: l_rt_bom_resource_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();
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();

Line 1753: l_rt_inventory_item_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();
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();

Line 1754: l_rt_item_category_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();
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();

Line 1755: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();
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();

Line 1758: l_rt_rate_exp_org_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();
1761: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1759: l_rt_res_format_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();
1761: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();

Line 1760: l_rt_res_list_member_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();
1761: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1764: l_mfc_cost_source CONSTANT NUMBER := 2;

Line 1761: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();
1761: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1764: l_mfc_cost_source CONSTANT NUMBER := 2;
1765: l_txn_currency_code VARCHAR2(100);

Line 1762: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();
1761: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1764: l_mfc_cost_source CONSTANT NUMBER := 2;
1765: l_txn_currency_code VARCHAR2(100);
1766:

Line 1767: l_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1763: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_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();

Line 1769: l_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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();
1773: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1771: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

Line 1772: l_bl_TXN_BURDENED_COST_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();
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();

Line 1773: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();
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();

Line 1774: l_bl_BILL_MARKUP_PERCENT_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();
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();

Line 1778: l_bl_COST_IND_C_SET_ID_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();
1782: l_rej_txn_currency_code_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();

Line 1780: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();
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 ------------------------------------------

Line 1848: l_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1844:
1845: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1846:
1847: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1848: l_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1849: l_total_plan_quantity number;
1850: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1851:
1852: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

Line 1860: l_proj_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1856: l_proj_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
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;

Line 1924: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1920: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1921: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1922: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1923: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1924: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1925: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1925: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1921: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1922: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1923: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1924: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1925: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1922: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1923: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1924: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1925: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1923: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1924: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1925: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1924: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1925: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1925: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1926: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1927: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1928: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1936:

Line 1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1929: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1936:
1937:

Line 1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1930: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1936:
1937:
1938: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1931: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1932: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1933: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1936:
1937:
1938: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1939: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1938: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1934: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1936:
1937:
1938: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1939: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1940: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1941: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1942:

Line 1939: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1935: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1936:
1937:
1938: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1939: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1940: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1941: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1942:
1943: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

Line 2009: l_t_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2005: l_t_burdened_rate_adj_pct NUMBER := NULL;
2006: l_t_bill_rate_adj_pct NUMBER := NULL;
2007: l_t_source_context pa_fp_res_assignments_tmp.source_context%TYPE := 'RESOURCE_ASSIGNMENT';
2008:
2009: l_t_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2010: l_t_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2011: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2012: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2013: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

Line 2014: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2010: l_t_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2011: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2012: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2013: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2014: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2015: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2015: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2011: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2012: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2013: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2014: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2015: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2012: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2013: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2014: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2015: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2013: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2014: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2015: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2014: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2015: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2015: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2016: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2017: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2018: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2026:

Line 2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2019: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2026:
2027:

Line 2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2020: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2026:
2027:
2028: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2021: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2022: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2023: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2026:
2027:
2028: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2029: l_t_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2028: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2024: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2026:
2027:
2028: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2029: l_t_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2030: l_t_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2031: l_t_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2032:

Line 2029: l_t_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2025: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2026:
2027:
2028: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2029: l_t_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2030: l_t_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2031: l_t_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2032:
2033: l_bl_count NUMBER;

Line 2051: l_upd_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2047:
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();

Line 2053: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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();
2057: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 2055: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

Line 2056: l_upd_bl_TXN_BURDENED_COST_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();
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();

Line 2057: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_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();
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();

Line 2058: l_upd_bl_BILL_MARKUP_PRCNT_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();
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();

Line 2062: l_upd_bl_COST_IND_C_SET_ID_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;
2066: l_rej_code_txn_currency_tab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 4763: l_da_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

4759: l_msg_index_out NUMBER:=0;
4760: l_project_id NUMBER(15);
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;

Line 4766: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;

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;
4770: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4768: l_da_person_id_tab 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;
4772: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4769: l_da_job_id_tab SYSTEM.PA_NUM_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;
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;

Line 4772: l_da_bom_resource_id_tab SYSTEM.PA_NUM_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;
4775: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4776: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4774: l_da_inventory_item_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;
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;

Line 4775: l_da_item_category_id_tab SYSTEM.PA_NUM_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;
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;

Line 4776: l_da_project_role_id_tab SYSTEM.PA_NUM_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;
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;

Line 4777: l_da_organization_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;
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;

Line 4783: l_da_supplier_id_tab SYSTEM.PA_NUM_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;
4787: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 4784: l_da_spread_curve_id_tab SYSTEM.PA_NUM_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;
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;

Line 4786: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_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;
4790: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4789: l_da_incur_by_role_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;
4793: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4791: l_da_org_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;
4795: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4811: l_Cbs_Element_Id_tab SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); -- bug#16200605

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
4815: BEGIN

Line 6833: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6829:
6830: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP';
6831:
6832: /*local variable for calling get planning rates*/
6833: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6834: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6835: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6836: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

Line 6834: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6830: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP';
6831:
6832: /*local variable for calling get planning rates*/
6833: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6834: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6835: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6836: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 6913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6909:
6910: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6911: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6912: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6910: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6911: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6912: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6911: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6912: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6912: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6924: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6924: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6925: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6924: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6925: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6926: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

Line 6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6924: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6925: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6926: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6927: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

Line 6924: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6924: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6925: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6926: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6927: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6928: /*end variable for calculate*/

Line 6925: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

6921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6924: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6925: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6926: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6927: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6928: /*end variable for calculate*/
6929:

Line 7379: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7375: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
7376: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';
7377:
7378: /*local variable for calling get planning rates*/
7379: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7380: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7381: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7382: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

Line 7380: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7376: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';
7377:
7378: /*local variable for calling get planning rates*/
7379: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7380: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7381: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7382: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 7459: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7455:
7456: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
7457: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
7458: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7459: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7460: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7460: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7456: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
7457: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
7458: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7459: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7460: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7457: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
7458: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7459: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7460: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7458: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7459: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7460: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7459: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7460: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7460: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7461: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7462: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7470: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7463: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7470: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7471: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7464: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7470: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7471: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7472: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

Line 7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7465: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7470: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7471: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7472: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
7473: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

Line 7470: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7466: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7470: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7471: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7472: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
7473: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
7474: /*end variable for calculate*/

Line 7471: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

7467: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7468: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7469: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7470: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7471: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7472: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
7473: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
7474: /*end variable for calculate*/
7475: