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_CREATE_RESOURCE dependencies on PA_RESOURCE_TYPES

Line 41: l_res_type_code pa_resource_types.resource_type_code%TYPE;

37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
41: l_res_type_code pa_resource_types.resource_type_code%TYPE;
42:
43: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS
44: SELECT prta.person_id,
45: prta.job_id,

Line 62: PA_RESOURCE_TYPES PRT

58: prt.resource_type_id,
59: prt.resource_type_code
60: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
61: PA_RESOURCES PR,
62: PA_RESOURCE_TYPES PRT
63: WHERE prta.resource_id = pr.resource_id
64: AND pr.resource_id =P_RESOURCE_ID
65: AND pr.resource_type_id= prt.resource_type_id;
66:

Line 105: pa_resource_types_active_v

101: CURSOR c_resource_types_csr IS
102: SELECT
103: resource_type_code
104: FROM
105: pa_resource_types_active_v
106: WHERE resource_type_id = l_resource_type_id;
107:
108: CURSOR c_revenue_categ_csr IS -- changed for perf bug 4887375
109: /*SELECT

Line 187: p_err_stage := ' Select resource_type_code from pa_resource_types';

183: IF (p_sort_order IS NULL OR p_sort_order = 0) THEN
184: l_get_new_sort_order := 'TRUE';
185: END IF;
186:
187: p_err_stage := ' Select resource_type_code from pa_resource_types';
188: OPEN c_resource_types_csr;
189: FETCH c_resource_types_csr INTO
190: l_resource_type_code;
191: IF c_resource_types_csr%NOTFOUND THEN

Line 567: l_resource_type_code pa_resource_types.resource_type_code%TYPE;

563: l_Uom VARCHAR2(30);
564: l_track_as_labor_flag VARCHAR2(1);
565: l_rollup_qty_flag VARCHAR2(1);
566: l_resource_id NUMBER := NULL;
567: l_resource_type_code pa_resource_types.resource_type_code%TYPE;
568: l_job_group_id NUMBER := NULL; --Added for Bug 2486405.
569: l_msg_count NUMBER;
570: l_record_version_number NUMBER := NULL;
571: l_return_status VARCHAR2(1);

Line 638: FROM pa_resources pr, pa_resource_types prt

634: -- Start of change
635:
636: CURSOR Cur_Unclassified_Resource_List IS
637: SELECT prt.resource_type_id,prt.resource_type_code
638: FROM pa_resources pr, pa_resource_types prt
639: WHERE prt.resource_type_code='UNCLASSIFIED'
640: AND pr.resource_type_id = prt.resource_type_id;
641:
642:

Line 1805: pa_resource_types_active_v

1801: CURSOR c_res_types_csr IS
1802: SELECT
1803: resource_class_code
1804: FROM
1805: pa_resource_types_active_v
1806: WHERE
1807: resource_type_code = p_resource_type_code;
1808:
1809: CURSOR c_res_format_csr IS

Line 1840: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';

1836: p_err_stack :=
1837: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_txn_Attribute';
1838:
1839:
1840: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';
1841:
1842: OPEN c_res_types_csr;
1843: FETCH c_res_types_csr INTO l_resource_class_code;
1844: IF c_res_types_csr%NOTFOUND THEN

Line 2055: pa_resource_types_active_v

2051: CURSOR c_resource_types_csr IS
2052: SELECT
2053: resource_type_code
2054: FROM
2055: pa_resource_types_active_v
2056: WHERE resource_type_id = l_grouped_resource_type_id;
2057:
2058: CURSOR c_rev_category_csr IS -- changed for perf bug 4887375
2059: /*SELECT

Line 2189: -- from pa_resource_types using group_resource_type_id

2185: END IF;
2186: IF l_grouped_resource_type_id <> 0 THEN
2187: -- the resource list has been grouped
2188: -- get the resource_type_code into grouped_by_resource_type_code
2189: -- from pa_resource_types using group_resource_type_id
2190:
2191: p_err_stage := 'Select resource_type_code from pa_resource_types ';
2192: OPEN c_resource_types_csr;
2193: FETCH c_resource_types_csr INTO

Line 2191: p_err_stage := 'Select resource_type_code from pa_resource_types ';

2187: -- the resource list has been grouped
2188: -- get the resource_type_code into grouped_by_resource_type_code
2189: -- from pa_resource_types using group_resource_type_id
2190:
2191: p_err_stage := 'Select resource_type_code from pa_resource_types ';
2192: OPEN c_resource_types_csr;
2193: FETCH c_resource_types_csr INTO
2194: l_grouped_resource_type_code;
2195: IF c_resource_types_csr%NOTFOUND THEN

Line 2628: pa_resource_types_active_v

2624: CURSOR c_resource_types_csr IS
2625: SELECT
2626: resource_type_id
2627: FROM
2628: pa_resource_types_active_v
2629: WHERE resource_type_code = p_resource_type_code;
2630:
2631: CURSOR c_resource_seq_csr IS
2632: SELECT

Line 2655: p_err_stage := 'Select resource_type_id from pa_resource_types_active_v ';

2651: p_err_stage := 'PA_RL_RES_TYPE_CODE_REQD';
2652: RETURN;
2653: END IF;
2654:
2655: p_err_stage := 'Select resource_type_id from pa_resource_types_active_v ';
2656:
2657: OPEN c_resource_types_csr;
2658: FETCH c_resource_types_csr INTO
2659: l_resource_type_id;

Line 2850: l_resource_type_id pa_resource_types.resource_type_id%TYPE;

2846: l_resource_name VARCHAR2(80);
2847: l_alias VARCHAR2(80); -- Bug 9683569
2848: l_new_track_as_labor_flag VARCHAR2(1);
2849: l_org_id NUMBER := NULL;
2850: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2851: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;

Line 2865: l_res_type_code pa_resource_types.resource_type_code%TYPE;

2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2865: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2866:
2867:
2868: CURSOR c_res_list_csr IS
2869: SELECT

Line 2879: pa_resource_types

2875: CURSOR c_resource_types_csr IS
2876: SELECT
2877: resource_type_code
2878: FROM
2879: pa_resource_types
2880: WHERE resource_type_id = l_grouped_resource_type_id;
2881:
2882: CURSOR c_exp_categ_csr IS
2883: SELECT

Line 3013: PA_RESOURCE_TYPES PRT

3009: prt.resource_type_id,
3010: prt.resource_type_code
3011: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
3012: PA_RESOURCES PR,
3013: PA_RESOURCE_TYPES PRT
3014: WHERE prta.resource_id = pr.resource_id
3015: AND pr.resource_id =P_RESOURCE_ID
3016: AND pr.resource_type_id= prt.resource_type_id;
3017:

Line 3027: FROM pa_resources pr, pa_resource_types prt

3023: -- Start of change
3024:
3025: CURSOR Cur_Unclassified_Resource_List IS
3026: SELECT prt.resource_type_id,prt.resource_type_code
3027: FROM pa_resources pr, pa_resource_types prt
3028: WHERE prt.resource_type_code='UNCLASSIFIED'
3029: AND pr.resource_type_id = prt.resource_type_id;
3030:
3031: BEGIN

Line 3069: p_err_stage := ' Select resource_type_code from pa_resource_types';

3065: RETURN;
3066: END IF;
3067:
3068: IF l_grouped_resource_type_id <> 0 THEN
3069: p_err_stage := ' Select resource_type_code from pa_resource_types';
3070: OPEN c_resource_types_csr;
3071: FETCH c_resource_types_csr INTO
3072: l_grouped_res_type_code;
3073: IF c_resource_types_csr%NOTFOUND THEN