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_VARCHAR2_30_TBL_TYPE

Line 2431: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

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,
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,

Line 2433: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2437: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2434: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_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,
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,

Line 2437: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2441: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2445: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2449: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2446: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2449: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2450: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2447: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
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,

Line 2448: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
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,

Line 2449: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
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,

Line 2452: X_etc_method_code 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,
2456: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2455: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2458: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2459: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

Line 2457: X_unit_of_measure 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,
2461: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 2460: X_rate_expenditure_type 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,
2463: X_msg_data OUT NOCOPY VARCHAR2,
2464: X_msg_count OUT NOCOPY NUMBER,

Line 2461: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2463: X_msg_data OUT NOCOPY VARCHAR2,
2464: X_msg_count OUT NOCOPY NUMBER,
2465: X_return_status OUT NOCOPY VARCHAR2)

Line 2470: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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;
2473: l_job_id SYSTEM.PA_NUM_TBL_TYPE;
2474: l_person_type_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2474: l_person_type_code SYSTEM.PA_VARCHAR2_30_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;
2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2475: l_named_role 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;
2478: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2479: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2482: l_fc_res_type_code SYSTEM.PA_VARCHAR2_30_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;
2486: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 2483: l_expenditure_type SYSTEM.PA_VARCHAR2_30_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;
2486: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2487: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2484: l_expenditure_category SYSTEM.PA_VARCHAR2_30_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;
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;

Line 2485: l_event_type SYSTEM.PA_VARCHAR2_30_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;
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;

Line 2486: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_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;
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;

Line 2489: l_etc_method_code 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;
2493: l_incur_by_role_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2492: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_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;
2495: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;
2496: l_rate_based_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 2494: l_rate_expenditure_type 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;
2498: l_last_analyzed all_tables.last_analyzed%TYPE;

Line 5380: l_cost_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_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();
5382: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5383:
5384: -- Bug 7457385

Line 5381: l_burden_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_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();
5382: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5383:
5384: -- Bug 7457385
5385: CURSOR cur_proj_is_template(c_project_id NUMBER)

Line 5382: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_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();
5382: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5383:
5384: -- Bug 7457385
5385: CURSOR cur_proj_is_template(c_project_id NUMBER)
5386: IS