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_1_TBL_TYPE

Line 2430: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

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

Line 2454: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_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,
2458: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 2459: X_rate_based_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,
2463: X_msg_data OUT NOCOPY VARCHAR2,

Line 2469: l_resource_class_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

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

Line 2491: l_incurred_by_res_flag SYSTEM.PA_VARCHAR2_1_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;
2495: l_rate_incurred_by_org_id SYSTEM.PA_NUM_TBL_TYPE;

Line 2496: l_rate_based_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);
2500: /*********************************************