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

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

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

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

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

1732: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1733: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1734: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1735: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1736: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1739: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1733: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1734: l_rt_res_class_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1735: l_rt_organization_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1736: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1739: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1741: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1736: l_rt_job_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1739: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1741: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1742: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1743: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 1741: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1737: l_rt_person_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1739: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1741: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1742: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1743: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

Line 1742: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1738: l_rt_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1739: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1741: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1742: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1743: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1743: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1739: l_rt_non_labor_resource_tab SYSTEM.pa_varchar2_20_tbl_type:=SYSTEM.pa_varchar2_20_tbl_type();
1740: l_rt_bom_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1741: l_rt_inventory_item_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1742: l_rt_item_category_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1743: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1747: l_rt_res_format_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

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

1743: l_rt_mfc_cost_type_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1747: l_rt_res_format_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_res_list_member_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1750: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1751: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();

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

1744: l_rt_rate_expenditure_type_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1747: l_rt_res_format_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_res_list_member_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1750: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1751: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1752: l_mfc_cost_source CONSTANT NUMBER := 2;

Line 1749: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1745: l_rt_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1747: l_rt_res_format_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_res_list_member_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1750: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1751: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1752: l_mfc_cost_source CONSTANT NUMBER := 2;
1753: l_txn_currency_code VARCHAR2(100);

Line 1750: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1746: l_rt_rate_exp_org_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1747: l_rt_res_format_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1748: l_rt_res_list_member_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1749: l_rt_resource_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1750: l_rt_resource_list_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1751: l_rt_alias_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1752: l_mfc_cost_source CONSTANT NUMBER := 2;
1753: l_txn_currency_code VARCHAR2(100);
1754:

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

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

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

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

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

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

Line 1760: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1756: l_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1757: l_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1758: l_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1759: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1760: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1761: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1764: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 1761: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

1757: l_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1758: l_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1759: l_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1760: l_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1761: l_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1762: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1763: l_bl_COST_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1764: l_bl_BURDEN_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1765: l_bl_REV_REJECTION_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 1762: l_bl_BILL_MARKUP_PERCENT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

Line 1766: l_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

Line 1768: l_rej_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

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

1832:
1833: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1834:
1835: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1836: l_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1837: l_total_plan_quantity number;
1838: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1839:
1840: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

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

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

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

1908: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1909: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1910: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1911: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1912: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1909: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1910: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1911: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1912: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1910: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1911: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1912: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1911: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1912: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1912: l_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1913: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1914: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1915: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1916: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1924:

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

1917: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1924:
1925:

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

1918: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1924:
1925:
1926: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1919: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1920: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1921: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1924:
1925:
1926: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1922: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1924:
1925:
1926: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1929: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1930:

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

1923: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1924:
1925:
1926: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1927: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1929: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1930:
1931: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

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

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

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

1998: l_t_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1999: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2000: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2001: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2002: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2003: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2004: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

1999: l_t_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2000: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2001: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2002: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2003: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2004: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2000: l_t_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2001: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2002: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2003: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2004: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2001: l_t_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
2002: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2003: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2004: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2002: l_t_total_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2003: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2004: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2003: l_t_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2004: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2011: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2004: l_t_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2011: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2012: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2005: l_t_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2011: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2012: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2013: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2006: l_t_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2011: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2012: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2013: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2014:

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

2007: l_t_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2011: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2012: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2013: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2014:
2015:

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

2008: l_t_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2011: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2012: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2013: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2014:
2015:
2016: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2009: l_t_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2010: l_t_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2011: l_t_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2012: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2013: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2014:
2015:
2016: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

2012: l_t_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2013: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2014:
2015:
2016: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2019: l_t_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2020:

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

2013: l_t_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2014:
2015:
2016: l_t_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2017: l_t_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2018: l_t_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2019: l_t_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
2020:
2021: l_bl_count NUMBER;

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

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

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

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

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

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

Line 2044: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2040: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2041: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2042: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2043: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2044: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2045: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2046: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2047: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2048: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 2045: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

2041: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2042: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2043: l_upd_bl_TXN_RAW_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2044: l_upd_bl_TXN_BURDENED_COST_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2045: l_upd_bl_TXN_REVENUE_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2046: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2047: l_upd_bl_COST_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2048: l_upd_bl_BURDEN_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2049: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 2046: l_upd_bl_BILL_MARKUP_PRCNT_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

Line 2050: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

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

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

Line 4597: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4593: --Local Variables for calling get_resource_defaults API
4594: l_da_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
4595: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4596: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4597: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4598: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4599: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4601: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4599: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4595: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4596: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4597: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4598: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4599: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4601: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4602: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4596: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4597: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4598: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4599: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4601: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4602: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4604: l_da_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;

Line 4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4599: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4600: l_da_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4601: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4602: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4604: l_da_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
4605: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4606: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 4605: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4601: l_da_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4602: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4604: l_da_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
4605: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4606: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4606: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4602: l_da_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4604: l_da_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
4605: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4606: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4603: l_da_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4604: l_da_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
4605: l_da_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4606: l_da_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4607: l_da_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4609: l_da_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4608: l_da_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;

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

Line 4614: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4610: l_da_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4614: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4615: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4616: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4617: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4618: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 4615: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4611: l_da_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4612: l_da_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4613: l_da_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4614: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4615: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4616: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4617: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4618: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4619: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4617: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;

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

Line 4620: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

4616: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4617: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4618: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4619: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4620: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4621: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4622: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
4623: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
4624: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4622: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;

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

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

6172:
6173: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP';
6174:
6175: /*local variable for calling get planning rates*/
6176: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6177: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6178: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6179: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6180: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

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

6173: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP';
6174:
6175: /*local variable for calling get planning rates*/
6176: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6177: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6178: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6179: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6180: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6181: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

6252:
6253: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6254: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6255: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6256: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6253: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6254: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6255: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6256: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6254: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6255: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6256: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6255: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6256: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6256: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6257: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6258: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6266: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6259: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6266: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6267: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6260: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6266: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6267: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6268: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6261: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6266: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6267: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6268: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6269: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

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

6262: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6266: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6267: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6268: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6269: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6270: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

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

6263: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6266: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6267: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6268: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6269: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6270: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6271: /*end variable for calculate*/

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

6264: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6265: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6266: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6267: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6268: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6269: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6270: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6271: /*end variable for calculate*/
6272:

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

6718: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6719: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';
6720:
6721: /*local variable for calling get planning rates*/
6722: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6723: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6724: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

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

6719: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';
6720:
6721: /*local variable for calling get planning rates*/
6722: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6723: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6724: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6727: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

6798:
6799: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6800: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6801: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6802: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6799: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6800: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6801: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6802: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6800: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
6801: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6802: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6801: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6802: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6802: l_addl_qty_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6803: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6804: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6812: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6805: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6812: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6813: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6806: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6812: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6813: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6814: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6807: l_total_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6812: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6813: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6814: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6815: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

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

6808: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6812: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6813: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6814: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6815: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6816: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

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

6809: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6812: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6813: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6814: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6815: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6816: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6817: /*end variable for calculate*/

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

6810: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6811: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6812: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6813: l_bill_rate_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6814: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6815: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6816: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
6817: /*end variable for calculate*/
6818: