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 2428: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,

2424: * Added parameter x_incur_by_res_type, to get the res_type_code
2425: * for incur by resource.
2426: **********************************************************/
2427: PROCEDURE get_resource_defaults (
2428: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
2429: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2430: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2431: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2432: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2432: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2428: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
2429: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2430: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2431: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2432: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2433: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2434: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2435: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2436: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2435: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2431: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2432: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2433: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2434: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2435: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2436: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2437: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2438: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2439: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2436: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2432: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2433: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2434: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2435: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2436: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2437: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2438: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2439: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2440: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,

Line 2439: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2435: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2436: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2437: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2438: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2439: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2440: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2441: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2442: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2443: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2441: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2437: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2438: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2439: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2440: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2441: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2442: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2443: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2444: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2445: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2442: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2438: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
2439: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2440: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2441: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2442: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2443: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2444: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2445: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2446: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2443: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2439: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2440: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2441: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2442: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2443: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2444: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2445: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2446: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2447: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2444: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2440: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
2441: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2442: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2443: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2444: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2445: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2446: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2447: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2448: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2450: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2446: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2447: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2448: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2449: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2450: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2451: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2452: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2453: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2454: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

Line 2451: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2447: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2448: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2449: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2450: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2451: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2452: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2453: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2454: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2455: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2453: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2449: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2450: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2451: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2452: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2453: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2454: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2455: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2456: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2457: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2456: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2452: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2453: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2454: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2455: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2456: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2457: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2458: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2459: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2460: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2458: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

2454: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2455: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2456: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2457: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2458: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2459: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2460: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2461: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2462: -- X_rate_incurred_by_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

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

2458: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2459: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2460: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2461: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2462: -- X_rate_incurred_by_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2463: X_msg_data OUT NOCOPY VARCHAR2,
2464: X_msg_count OUT NOCOPY NUMBER,
2465: X_return_status OUT NOCOPY VARCHAR2)
2466: IS

Line 2468: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

2464: X_msg_count OUT NOCOPY NUMBER,
2465: X_return_status OUT NOCOPY VARCHAR2)
2466: IS
2467: --Declaration of Tables used for Bulk Fetch
2468: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
2469: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2470: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2471: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2472: l_person_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2471: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;

2467: --Declaration of Tables used for Bulk Fetch
2468: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
2469: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2470: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2471: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2472: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2473: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2474: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2475: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2472: l_person_id SYSTEM.PA_NUM_TBL_TYPE;

2468: l_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
2469: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2470: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2471: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2472: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2473: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2474: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2475: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2476: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2473: l_job_id SYSTEM.PA_NUM_TBL_TYPE;

2469: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2470: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2471: l_resource_class_id SYSTEM.PA_NUM_TBL_TYPE;
2472: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2473: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2474: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2475: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2476: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2477: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;

Line 2476: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;

2472: l_person_id SYSTEM.PA_NUM_TBL_TYPE;
2473: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2474: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2475: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2476: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2477: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2479: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2480: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;

2474: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2475: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2476: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2477: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2479: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2480: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2481: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2482: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2479: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;

2475: l_named_role SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2476: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2477: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2479: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2480: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2481: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2482: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2483: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2480: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;

2476: l_bom_resource_id SYSTEM.PA_NUM_TBL_TYPE;
2477: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2479: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2480: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2481: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2482: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2483: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2484: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2481: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;

2477: l_non_labor_resource SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2479: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;
2480: l_project_role_id SYSTEM.PA_NUM_TBL_TYPE;
2481: l_organization_id SYSTEM.PA_NUM_TBL_TYPE;
2482: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2483: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2484: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2485: l_event_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2487: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;

2483: l_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2484: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2485: l_event_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2486: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2487: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;
2488: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;
2489: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2490: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2491: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 2488: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;

2484: l_expenditure_category SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2485: l_event_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2486: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2487: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;
2488: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;
2489: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2490: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2491: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2492: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2490: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;

2486: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2487: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;
2488: l_spread_curve_id SYSTEM.PA_NUM_TBL_TYPE;
2489: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2490: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2491: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2492: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2493: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;
2494: l_rate_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2493: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;

2489: l_etc_method_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2490: l_mfc_cost_type_id SYSTEM.PA_NUM_TBL_TYPE;
2491: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2492: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2493: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;
2494: l_rate_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2495: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;
2496: l_rate_based_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2497: l_exception EXCEPTION;

Line 2495: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;

2491: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2492: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2493: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;
2494: l_rate_expenditure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2495: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;
2496: l_rate_based_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
2497: l_exception EXCEPTION;
2498: l_last_analyzed all_tables.last_analyzed%TYPE;
2499: l_pa_schema VARCHAR2(30);

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

5297: -- Type : Procedure
5298: -- Pre-reqs : None
5299: -- Function : To get the Resource Rate and Currency attributes.
5300: -- Prameters
5301: -- P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE REQUIRED --Resource List Member Id
5302: -- P_project_id IN NUMBER REQUIRED
5303: -- History
5304: -- 05-MAR-04 Vgade -Created
5305: --

Line 5308: P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

5304: -- 05-MAR-04 Vgade -Created
5305: --
5306: /*----------------------------------------------------------------------------*/
5307: Procedure Get_Resource_Cost_Rate(
5308: P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5309: ,P_project_id IN pa_projects_all.project_id%type
5310: ,p_structure_type IN VARCHAR2
5311: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5312: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 5313: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

5309: ,P_project_id IN pa_projects_all.project_id%type
5310: ,p_structure_type IN VARCHAR2
5311: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5312: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5313: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5314: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5315: ) AS
5316: --Start of variables used for debugging
5317: l_msg_count NUMBER :=0;

Line 5314: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

5310: ,p_structure_type IN VARCHAR2
5311: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5312: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5313: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5314: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5315: ) AS
5316: --Start of variables used for debugging
5317: l_msg_count NUMBER :=0;
5318: l_data VARCHAR2(2000);

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

5366: l_wp_versioning Varchar2(1);
5367: l_wp_vers_id Number;
5368: l_budget_version_id Number;
5369:
5370: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5371: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5372: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5373:
5374: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

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

5367: l_wp_vers_id Number;
5368: l_budget_version_id Number;
5369:
5370: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5371: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5372: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5373:
5374: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5375: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

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

5368: l_budget_version_id Number;
5369:
5370: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5371: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5372: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5373:
5374: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5375: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5376: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();

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

5370: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5371: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5372: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5373:
5374: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5375: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5376: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5377: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5378: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

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

5371: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5372: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5373:
5374: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5375: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5376: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5377: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5378: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5379: l_rev_txn_curr_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

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

5372: l_expenditure_ou_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5373:
5374: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5375: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5376: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5377: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5378: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5379: l_rev_txn_curr_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5380: l_cost_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

5373:
5374: l_burden_multiplier_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5375: l_ind_compiled_set_id_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5376: l_bill_rate_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5377: l_markup_percent_tab SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
5378: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5379: l_rev_txn_curr_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5380: l_cost_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5381: l_burden_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();