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 2390: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

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

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

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

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

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

Line 2405: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2408: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2409: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

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

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

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

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

Line 2414: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2417: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2418: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

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

Line 2419: X_rate_expenditure_type 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,
2422: X_msg_data OUT NOCOPY VARCHAR2,
2423: X_msg_count OUT NOCOPY NUMBER,

Line 2420: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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,
2422: X_msg_data OUT NOCOPY VARCHAR2,
2423: X_msg_count OUT NOCOPY NUMBER,
2424: X_return_status OUT NOCOPY VARCHAR2)

Line 2429: l_resource_class_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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

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

Line 2434: l_named_role 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;
2437: l_inventory_item_id SYSTEM.PA_NUM_TBL_TYPE;
2438: l_item_category_id SYSTEM.PA_NUM_TBL_TYPE;

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

Line 2442: l_expenditure_type SYSTEM.PA_VARCHAR2_30_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;
2445: l_revenue_category_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
2446: l_supplier_id SYSTEM.PA_NUM_TBL_TYPE;

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

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

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

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

Line 2451: l_incur_by_res_class_code SYSTEM.PA_VARCHAR2_30_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;
2454: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;
2455: l_rate_based_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

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

Line 5320: l_cost_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_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();
5322: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5323:
5324:

Line 5321: l_burden_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_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();
5322: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5323:
5324:
5325: Begin

Line 5322: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_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();
5322: l_revenue_rejection_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5323:
5324:
5325: Begin
5326: IF p_structure_type = 'WORKPLAN' THEN