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

Line 2387: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,

2383: * Added parameter x_incur_by_res_type, to get the res_type_code
2384: * for incur by resource.
2385: **********************************************************/
2386: PROCEDURE get_resource_defaults (
2387: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
2388: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2389: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2390: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2391: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2391: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2387: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
2388: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2389: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2390: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2391: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2392: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2393: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2394: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2395: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2394: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2390: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2391: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2392: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2393: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2394: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2395: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2396: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2397: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2398: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2395: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2391: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2392: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2393: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2394: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2395: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2396: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2397: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2398: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2399: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,

Line 2398: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2394: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2395: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2396: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2397: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2398: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2399: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2400: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2401: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2402: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2400: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2396: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2397: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2398: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2399: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2400: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2401: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2402: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2403: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2404: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2401: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2397: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2398: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2399: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2400: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2401: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2402: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2403: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2404: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2405: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2402: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2398: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2399: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2400: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2401: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2402: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2403: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2404: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2405: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2406: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2403: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2399: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2400: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2401: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2402: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2403: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2404: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2405: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2406: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2407: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2409: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2405: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2406: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2407: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2408: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2409: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2410: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2411: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2412: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2413: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

Line 2410: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2406: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2407: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2408: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2409: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2410: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2411: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2412: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2413: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2414: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2412: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2408: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2409: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2410: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2411: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2412: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2413: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2414: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2415: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2416: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2415: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2411: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2412: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2413: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2414: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2415: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2416: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2417: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2418: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2419: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2417: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2413: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2414: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2415: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2416: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2417: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2418: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2419: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2420: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2421: -- X_rate_incurred_by_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2421: -- X_rate_incurred_by_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2417: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2418: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2419: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2420: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2421: -- X_rate_incurred_by_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2422: X_msg_data OUT NOCOPY VARCHAR2,
2423: X_msg_count OUT NOCOPY NUMBER,
2424: X_return_status OUT NOCOPY VARCHAR2)
2425: IS

Line 2427: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

2423: X_msg_count OUT NOCOPY NUMBER,
2424: X_return_status OUT NOCOPY VARCHAR2)
2425: IS
2426: --Declaration of Tables used for Bulk Fetch
2427: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
2428: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2429: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2430: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2431: l_person_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2430: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;

2426: --Declaration of Tables used for Bulk Fetch
2427: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
2428: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2429: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2430: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2431: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2432: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2433: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2434: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2431: l_person_id SYSTEM.PA_NUM_TBL_TYPE;

2427: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
2428: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2429: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2430: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2431: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2432: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2433: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2434: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2435: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2432: l_job_id SYSTEM.PA_NUM_TBL_TYPE;

2428: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2429: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2430: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2431: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2432: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2433: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2434: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2435: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2436: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;

Line 2435: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;

2431: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2432: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2433: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2434: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2435: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2436: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2437: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2438: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2439: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2437: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;

2433: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2434: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2435: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2436: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2437: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2438: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2439: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2440: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2441: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2438: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;

2434: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2435: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2436: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2437: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2438: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2439: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2440: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2441: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2442: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2439: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;

2435: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2436: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2437: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2438: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2439: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2440: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2441: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2442: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2443: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2440: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;

2436: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2437: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2438: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2439: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2440: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2441: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2442: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2443: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2444: l_event_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2446: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;

2442: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2443: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2444: l_event_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2445: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2446: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;
2447: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;
2448: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2449: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2450: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 2447: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;

2443: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2444: l_event_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2445: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2446: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;
2447: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;
2448: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2449: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2450: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2451: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2449: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;

2445: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2446: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;
2447: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;
2448: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2449: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2450: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2451: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2452: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;
2453: l_rate_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2452: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;

2448: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2449: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2450: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2451: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2452: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;
2453: l_rate_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2454: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;
2455: l_rate_based_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2456: l_exception EXCEPTION;

Line 2454: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;

2450: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2451: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2452: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;
2453: l_rate_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2454: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;
2455: l_rate_based_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2456: l_exception EXCEPTION;
2457: l_last_analyzed all_tables.last_analyzed%TYPE;
2458: l_pa_schema VARCHAR2(30);

Line 5241: -- P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE REQUIRED --Resource List Member Id

5237: -- Type : Procedure
5238: -- Pre-reqs : None
5239: -- Function : To get the Resource Rate and Currency attributes.
5240: -- Prameters
5241: -- P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE REQUIRED --Resource List Member Id
5242: -- P_project_id IN NUMBER REQUIRED
5243: -- History
5244: -- 05-MAR-04 Vgade -Created
5245: --

Line 5248: P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

5244: -- 05-MAR-04 Vgade -Created
5245: --
5246: /*----------------------------------------------------------------------------*/
5247: Procedure Get_Resource_Cost_Rate(
5248: P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5249: ,P_project_id IN pa_projects_all.project_id%type
5250: ,p_structure_type IN VARCHAR2
5251: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5252: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 5253: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

5249: ,P_project_id IN pa_projects_all.project_id%type
5250: ,p_structure_type IN VARCHAR2
5251: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5252: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5253: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5254: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5255: ) AS
5256: --Start of variables used for debugging
5257: l_msg_count NUMBER :=0;

Line 5254: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

5250: ,p_structure_type IN VARCHAR2
5251: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5252: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5253: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5254: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5255: ) AS
5256: --Start of variables used for debugging
5257: l_msg_count NUMBER :=0;
5258: l_data VARCHAR2(2000);

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

5306: l_wp_versioning Varchar2(1);
5307: l_wp_vers_id Number;
5308: l_budget_version_id Number;
5309:
5310: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5311: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5312: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5313:
5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

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

5307: l_wp_vers_id Number;
5308: l_budget_version_id Number;
5309:
5310: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5311: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5312: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5313:
5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5315: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

Line 5312: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

5308: l_budget_version_id Number;
5309:
5310: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5311: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5312: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5313:
5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5315: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5316: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

Line 5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

5310: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5311: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5312: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5313:
5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5315: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5316: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5317: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5318: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 5315: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

5311: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5312: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5313:
5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5315: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5316: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5317: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5318: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5319: l_rev_txn_curr_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 5316: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

5312: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5313:
5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5315: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5316: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5317: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5318: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5319: l_rev_txn_curr_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5320: l_cost_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 5317: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

5313:
5314: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5315: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5316: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5317: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5318: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5319: l_rev_txn_curr_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5320: l_cost_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5321: l_burden_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();