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_RBS_UTILS dependencies on PA_RES_TYPES_B

Line 285: FROM pa_res_types_b

281: FROM Pa_rbs_element_map
282: --WHERE RESOURCE_NAME = 'REVENUE_CATEGORY' -- NEED TO REVISIT
283: WHERE resource_type_id =
284: (SELECT res_type_id
285: FROM pa_res_types_b
286: WHERE res_type_code = 'REVENUE_CATEGORY')
287: AND RESOURCE_ID = p_resource_source_id;
288: EXCEPTION
289: WHEN OTHERS THEN

Line 408: FROM pa_res_types_b

404: FROM pa_rbs_element_map
405: --WHERE RESOURCE_NAME = p_resource_type_code -- NEED TO REVISIT
406: WHERE resource_type_id =
407: (SELECT res_type_id
408: FROM pa_res_types_b
409: WHERE res_type_code = 'REVENUE_CATEGORY')
410: AND RESOURCE_ID = p_resource_source_id;
411: EXCEPTION
412: WHEN OTHERS THEN

Line 1257: FROM pa_rbs_elem_in_temp a,pa_res_types_b b

1253: Cursor c_get_res_types
1254: IS
1255: SELECT distinct a.resource_type_id,
1256: decode(a.resource_type_id,-1,'VERSION',-2,'RULE',b.res_type_code)
1257: FROM pa_rbs_elem_in_temp a,pa_res_types_b b
1258: WHERE a.resource_type_id = b.res_type_id(+)
1259: ORDER by resource_type_id;
1260:
1261: --Declaration of the local variables

Line 1561: --This cursor selects all the resource types from pa_res_types_b table

1557: PROCEDURE Refresh_Resource_Names(errbuf OUT NOCOPY VARCHAR2,
1558: retcode OUT NOCOPY VARCHAR2)
1559: IS
1560:
1561: --This cursor selects all the resource types from pa_res_types_b table
1562: CURSOR Res_Types_c IS
1563: SELECT Res_type_id
1564: FROM pa_res_types_b;
1565:

Line 1564: FROM pa_res_types_b;

1560:
1561: --This cursor selects all the resource types from pa_res_types_b table
1562: CURSOR Res_Types_c IS
1563: SELECT Res_type_id
1564: FROM pa_res_types_b;
1565:
1566: l_res_type_id NUMBER;
1567: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1568: BEGIN

Line 2545: FROM pa_res_types_b

2541: ORDER BY child.parent_member_id; -- Added for bug 3745326 so that outline numbers for child elements can be properly derived.
2542:
2543: CURSOR get_res_type_id(p_resource_type_id NUMBER) IS
2544: SELECT res_type_id, res_type_code
2545: FROM pa_res_types_b
2546: WHERE res_type_code = decode(p_resource_type_id, 101, 'NAMED_PERSON',
2547: decode(p_resource_type_id, 102, 'JOB',
2548: decode(p_resource_type_id, 103, 'ORGANIZATION',
2549: decode(p_resource_type_id, 104, 'SUPPLIER',

Line 2561: (select res_type_id from pa_res_types_b

2557: CURSOR get_rev_cat(p_resource_list_id NUMBER) IS
2558: SELECT rlm.revenue_category,
2559: typ.res_type_id -- resource_type_id
2560: FROM pa_resource_list_members rlm,
2561: (select res_type_id from pa_res_types_b
2562: where res_type_code = 'REVENUE_CATEGORY') typ
2563: WHERE rlm.resource_list_id = p_resource_list_id
2564: AND rlm.resource_type_id = 109;
2565:

Line 2855: (select res_type_id, res_type_code from pa_res_types_b) typ

2851: decode(typ.res_type_code, 'ROLE', rlm.project_role_id,
2852: NULL))))), -- resource_source_id,
2853: typ.res_type_id -- resource_type_id
2854: FROM pa_resource_list_members rlm,
2855: (select res_type_id, res_type_code from pa_res_types_b) typ
2856: WHERE rlm.resource_list_id = l_list.resource_list_id
2857: AND ((rlm.resource_type_id = 103
2858: AND typ.res_type_code = 'ORGANIZATION') OR -- Org
2859: (rlm.resource_type_id = 101

Line 2875: (select res_type_id, res_type_code from pa_res_types_b) typ,

2871: resource_type_id)
2872: SELECT source.resource_source_id,
2873: typ.res_type_id -- resource_type_id
2874: FROM pa_resource_list_members rlm,
2875: (select res_type_id, res_type_code from pa_res_types_b) typ,
2876: ((select expenditure_type_id resource_source_id,
2877: expenditure_type resource_name, 1 type_number
2878: from pa_expenditure_types)
2879: UNION

Line 2913: (select res_type_id, res_type_code from pa_res_types_b) typ,

2909: (SELECT source.resource_source_id,
2910: typ.res_type_id -- resource_type_id
2911: FROM
2912: pa_resource_list_members rlm,
2913: (select res_type_id, res_type_code from pa_res_types_b) typ,
2914: ((select expenditure_category_id resource_source_id,
2915: expenditure_category resource_name, 2 type_number
2916: from pa_expenditure_categories)
2917: UNION

Line 2937: (select res_type_id, res_type_code from pa_res_types_b) typ,

2933: (SELECT source.resource_source_id,
2934: typ.res_type_id -- resource_type_id
2935: FROM
2936: pa_resource_list_members rlm,
2937: (select res_type_id, res_type_code from pa_res_types_b) typ,
2938: (select expenditure_type_id resource_source_id,
2939: expenditure_type resource_name, 1 type_number
2940: from pa_expenditure_types) source
2941: WHERE rlm.resource_list_id = l_list.resource_list_id

Line 3079: from pa_res_types_b

3075: INTO l_revenue_category_id
3076: FROM pa_rbs_element_map
3077: WHERE resource_name = l_parents.revenue_category
3078: AND resource_type_id = (select res_type_id
3079: from pa_res_types_b
3080: where res_type_code = 'REVENUE_CATEGORY');
3081: EXCEPTION WHEN NO_DATA_FOUND THEN
3082: l_revenue_category_id := -999;
3083: END;

Line 3087: FROM pa_res_types_b

3083: END;
3084: END IF;
3085:
3086: SELECT res_type_id INTO l_res_type_id
3087: FROM pa_res_types_b
3088: WHERE res_type_code = l_list.group_res_type;
3089:
3090: --dbms_output.put_line('l_parents.organization_id is: ' || l_parents.organization_id);
3091: SELECT decode(l_list.group_res_type,

Line 3252: from pa_res_types_b

3248: INTO l_revenue_category_id
3249: FROM pa_rbs_element_map
3250: WHERE resource_name = l_members.revenue_category
3251: AND resource_type_id = (select res_type_id
3252: from pa_res_types_b
3253: where res_type_code = 'REVENUE_CATEGORY');
3254: EXCEPTION WHEN NO_DATA_FOUND THEN
3255: l_revenue_category_id := -888;
3256: END;