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

Line 46: l_resource_type_id pa_resource_types.resource_type_id%TYPE;

42: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
43: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
44: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
45: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
46: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
47: l_res_type_code pa_resource_types.resource_type_code%TYPE;
48:
49: BEGIN
50:

Line 47: l_res_type_code pa_resource_types.resource_type_code%TYPE;

43: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
44: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
45: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
46: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
47: l_res_type_code pa_resource_types.resource_type_code%TYPE;
48:
49: BEGIN
50:
51: /* Added for bug 1889671. This will fetch 13 txn attributed from pa_resource_txn_attributes table

Line 88: PA_RESOURCE_TYPES PRT

84: l_resource_type_id,
85: l_res_type_code
86: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
87: PA_RESOURCES PR,
88: PA_RESOURCE_TYPES PRT
89: WHERE prta.resource_id = pr.resource_id
90: AND pr.resource_id =X_RESOURCE_ID
91: AND pr.resource_type_id= prt.resource_type_id;
92:

Line 308: l_resource_type_id pa_resource_types.resource_type_id%TYPE;

304: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
305: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
306: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
307: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
308: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
309: l_res_type_code pa_resource_types.resource_type_code%TYPE;
310:
311:
312: BEGIN

Line 309: l_res_type_code pa_resource_types.resource_type_code%TYPE;

305: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
306: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
307: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
308: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
309: l_res_type_code pa_resource_types.resource_type_code%TYPE;
310:
311:
312: BEGIN
313:

Line 352: PA_RESOURCE_TYPES PRT

348: l_resource_type_id,
349: l_res_type_code
350: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
351: PA_RESOURCES PR,
352: PA_RESOURCE_TYPES PRT
353: WHERE prta.resource_id(+) = pr.resource_id
354: AND pr.resource_id =X_RESOURCE_ID
355: AND pr.resource_type_id= prt.resource_type_id;
356: