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_FIN_PLAN_UTILS2 dependencies on PA_NUM_TBL_TYPE

Line 83: ,p_inventory_item_id_tab IN SYSTEM.PA_NUM_TBL_TYPE

79: * NOTE: Since this is PLSQL table LOOPING , this api should be called in batch of 100 records only
80: */
81: PROCEDURE Get_UOM_RateBasedFlag (
82: p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
83: ,p_inventory_item_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
84: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
85: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
86: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
87: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 84: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE

80: */
81: PROCEDURE Get_UOM_RateBasedFlag (
82: p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
83: ,p_inventory_item_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
84: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
85: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
86: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
87: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
88: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

Line 402: l_tab_project_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

398: ,x_other_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
399: ,x_return_status OUT NOCOPY Varchar2
400: ) IS
401: l_stage VARCHAR2(2000);
402: l_tab_project_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
403: l_tab_budget_version_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
404: l_tab_res_assignment_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
405: l_tab_period_name SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
406: l_tab_start_date SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 403: l_tab_budget_version_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

399: ,x_return_status OUT NOCOPY Varchar2
400: ) IS
401: l_stage VARCHAR2(2000);
402: l_tab_project_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
403: l_tab_budget_version_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
404: l_tab_res_assignment_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
405: l_tab_period_name SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
406: l_tab_start_date SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
407: l_tab_end_date SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 404: l_tab_res_assignment_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

400: ) IS
401: l_stage VARCHAR2(2000);
402: l_tab_project_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
403: l_tab_budget_version_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
404: l_tab_res_assignment_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
405: l_tab_period_name SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
406: l_tab_start_date SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
407: l_tab_end_date SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
408: l_tab_cost_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 1059: l_resource_assignment_tab system.pa_num_tbl_type := system.pa_num_tbl_type();

1055: l_project_id Number := 0;
1056: l_etc_start_date Date;
1057: l_plan_version_type Varchar2(100);
1058:
1059: l_resource_assignment_tab system.pa_num_tbl_type := system.pa_num_tbl_type();
1060: l_txn_currency_code_tab system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1061: l_line_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1062: l_line_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1063:

Line 2263: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE

2259: ,p_source_context IN VARCHAR2
2260: ,p_project_id IN NUMBER
2261: ,p_project_type IN VARCHAR2
2262: ,p_budget_version_id IN NUMBER
2263: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2264: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2265: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2264: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE

2260: ,p_project_id IN NUMBER
2261: ,p_project_type IN VARCHAR2
2262: ,p_budget_version_id IN NUMBER
2263: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2264: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2265: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE

2262: ,p_budget_version_id IN NUMBER
2263: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2264: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2265: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE

2263: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2264: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2265: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2271: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2271: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2272: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2273: ,x_return_status OUT NOCOPY VARCHAR2
2274: ) IS

Line 2271: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2271: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2272: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2273: ,x_return_status OUT NOCOPY VARCHAR2
2274: ) IS
2275:

Line 2272: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2271: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2272: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2273: ,x_return_status OUT NOCOPY VARCHAR2
2274: ) IS
2275:
2276: --Start of variables for Variable for Resource Attributes

Line 2279: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2275:
2276: --Start of variables for Variable for Resource Attributes
2277: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2278: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2279: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2280: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2281: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2282: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2283: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2282: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2278: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2279: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2280: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2281: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2282: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2283: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2284: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2285: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2286: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2283: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2279: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2280: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2281: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2282: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2283: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2284: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2285: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2286: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2287: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();

Line 2286: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2282: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2283: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2284: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2285: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2286: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2287: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
2288: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2289: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2290: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2288: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2284: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2285: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2286: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2287: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
2288: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2289: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2290: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2291: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2292: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2289: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2285: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2286: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2287: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
2288: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2289: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2290: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2291: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2292: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2293: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2290: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2286: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2287: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
2288: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2289: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2290: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2291: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2292: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2293: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2294: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2291: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2287: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
2288: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2289: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2290: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2291: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2292: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2293: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2294: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2295: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2297: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2293: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2294: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2295: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2296: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2297: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2298: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2299: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2300: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2301: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2299: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2295: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2296: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2297: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2298: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2299: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2300: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2301: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2302: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 2301: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2297: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2298: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2299: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2300: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2301: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2302: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2304: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2305: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2305: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2301: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2302: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2304: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2305: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2306: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2307: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2308: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2309: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2306: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2302: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2304: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2305: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2306: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2307: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2308: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2309: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2310: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2310: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2306: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2307: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2308: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2309: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2310: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2311: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
2312: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2313: l_resource_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2314: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 2317: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2313: l_resource_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2314: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
2315: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
2316: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2317: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2318: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2319: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2320: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2321: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2321: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2317: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2318: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2319: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2320: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2321: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2322: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2323: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2324: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2325: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2323: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2319: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2320: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2321: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2322: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2323: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2324: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2325: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2326: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2327: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2324: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2320: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2321: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2322: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2323: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2324: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2325: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2326: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2327: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2328: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 2325: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2321: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2322: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2323: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2324: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2325: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2326: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2327: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2328: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
2329: --End of variables for Variable for Resource Attributes

Line 2469: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE

2465: ,p_source_context IN VARCHAR2
2466: ,p_project_id IN NUMBER
2467: ,p_project_type IN VARCHAR2
2468: ,p_budget_version_id IN NUMBER
2469: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2470: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2471: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2470: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE

2466: ,p_project_id IN NUMBER
2467: ,p_project_type IN VARCHAR2
2468: ,p_budget_version_id IN NUMBER
2469: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2470: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2471: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE

2468: ,p_budget_version_id IN NUMBER
2469: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2470: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2471: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE

2469: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2470: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2471: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2477: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2477: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2478: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2479: ,x_return_status OUT NOCOPY VARCHAR2
2480: ) IS

Line 2477: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2477: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2478: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2479: ,x_return_status OUT NOCOPY VARCHAR2
2480: ) IS
2481:

Line 2478: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2477: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2478: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2479: ,x_return_status OUT NOCOPY VARCHAR2
2480: ) IS
2481:
2482: BEGIN

Line 2580: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

2576: ( p_calling_module IN VARCHAR2 := 'MSP'
2577: ,p_source_context IN VARCHAR2 := 'RLMI'
2578: ,p_project_id IN NUMBER
2579: ,p_budget_version_id IN NUMBER
2580: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2581: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2582: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 2581: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

2577: ,p_source_context IN VARCHAR2 := 'RLMI'
2578: ,p_project_id IN NUMBER
2579: ,p_budget_version_id IN NUMBER
2580: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2581: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2582: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()

Line 2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

2579: ,p_budget_version_id IN NUMBER
2580: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2581: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2582: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

2580: ,p_resource_assignment_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2581: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2582: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

2582: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2590: ,x_resource_list_member_Id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2591: ,x_expenditure_ou_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2599: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2592: ,x_raw_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2599: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2600: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

2593: ,x_burden_cost_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2599: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2600: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2601: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 2609: l_plsql_index_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2605: ,x_msg_data OUT NOCOPY VARCHAR2
2606: ,x_msg_count OUT NOCOPY NUMBER
2607: ) IS
2608:
2609: l_plsql_index_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2610: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2610: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2606: ,x_msg_count OUT NOCOPY NUMBER
2607: ) IS
2608:
2609: l_plsql_index_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2610: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2607: ) IS
2608:
2609: l_plsql_index_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2610: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2608:
2609: l_plsql_index_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2610: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2609: l_plsql_index_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2610: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2621: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

Line 2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2621: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
2622: x_rw_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2621: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
2622: x_rw_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2623: x_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2622: x_rw_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2621: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
2622: x_rw_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2623: x_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2624: x_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2625:
2626: p_activity_code Varchar2(100) := 'CALCULATE';

Line 2623: x_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2621: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
2622: x_rw_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2623: x_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2624: x_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2625:
2626: p_activity_code Varchar2(100) := 'CALCULATE';
2627: l_return_status VArchar2(1) := 'S';

Line 2624: x_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2620: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2621: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
2622: x_rw_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2623: x_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2624: x_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2625:
2626: p_activity_code Varchar2(100) := 'CALCULATE';
2627: l_return_status VArchar2(1) := 'S';
2628: l_billable_flag Varchar2(1) := 'Y';

Line 3085: x_resource_assignment_id_tab := SYSTEM.PA_NUM_TBL_TYPE();

3081: ELSIF rate_rec.fp_budget_version_type = 'ALL' THEN
3082: l_calculate_mode := 'COST_REVENUE';
3083: END IF;
3084:
3085: x_resource_assignment_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3086: x_resource_list_member_Id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();

Line 3086: x_resource_list_member_Id_tab := SYSTEM.PA_NUM_TBL_TYPE();

3082: l_calculate_mode := 'COST_REVENUE';
3083: END IF;
3084:
3085: x_resource_assignment_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3086: x_resource_list_member_Id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();

Line 3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();

3083: END IF;
3084:
3085: x_resource_assignment_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3086: x_resource_list_member_Id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();

Line 3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();

3084:
3085: x_resource_assignment_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3086: x_resource_list_member_Id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();

Line 3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();

3085: x_resource_assignment_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3086: x_resource_list_member_Id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();

3086: x_resource_list_member_Id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3094: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();

3087: x_raw_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3094: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3095: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();

3088: x_burden_cost_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3094: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3095: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3096: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3099: x_expenditure_ou_tab := SYSTEM.PA_NUM_TBL_TYPE();

3095: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3096: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3097: x_burden_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3098: x_revenue_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3099: x_expenditure_ou_tab := SYSTEM.PA_NUM_TBL_TYPE();
3100: /* loop through the tmp table and call rate api for each line */
3101: l_Cntr := 0;
3102: FOR z IN CUR_RateApi_Attrbs LOOP --{
3103: /* Initialize the out params */