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_TXN_ATTRIBUTES

Line 32: l_person_id pa_resource_txn_attributes.person_id%TYPE;

28: Where Resource_List_Member_Id = X_Resource_List_Member_Id;
29:
30: -- Added for bug 1889671
31:
32: l_person_id pa_resource_txn_attributes.person_id%TYPE;
33: l_job_id pa_resource_txn_attributes.job_id%TYPE;
34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

Line 33: l_job_id pa_resource_txn_attributes.job_id%TYPE;

29:
30: -- Added for bug 1889671
31:
32: l_person_id pa_resource_txn_attributes.person_id%TYPE;
33: l_job_id pa_resource_txn_attributes.job_id%TYPE;
34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

Line 34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;

30: -- Added for bug 1889671
31:
32: l_person_id pa_resource_txn_attributes.person_id%TYPE;
33: l_job_id pa_resource_txn_attributes.job_id%TYPE;
34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;

Line 35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;

31:
32: l_person_id pa_resource_txn_attributes.person_id%TYPE;
33: l_job_id pa_resource_txn_attributes.job_id%TYPE;
34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

Line 36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

32: l_person_id pa_resource_txn_attributes.person_id%TYPE;
33: l_job_id pa_resource_txn_attributes.job_id%TYPE;
34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

Line 37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

33: l_job_id pa_resource_txn_attributes.job_id%TYPE;
34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

Line 38: l_event_type pa_resource_txn_attributes.event_type%TYPE;

34: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
42: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

Line 39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

35: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

36: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

37: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 42: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

38: l_event_type pa_resource_txn_attributes.event_type%TYPE;
39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 43: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

39: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 44: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

40: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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:

Line 45: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

41: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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

Line 51: /* Added for bug 1889671. This will fetch 13 txn attributed from pa_resource_txn_attributes table

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
52: along with resource_format_id. Also,resoure_type_id and resource_type_code is also fetched.*/
53:
54: SELECT prta.person_id,
55: prta.job_id,

Line 86: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,

82: l_system_link_function,
83: l_resource_format_id,
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

Line 294: l_person_id pa_resource_txn_attributes.person_id%TYPE;

290: Where Resource_List_Member_Id = X_Resource_List_Member_Id;
291:
292: -- Added for bug 1889671
293:
294: l_person_id pa_resource_txn_attributes.person_id%TYPE;
295: l_job_id pa_resource_txn_attributes.job_id%TYPE;
296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

Line 295: l_job_id pa_resource_txn_attributes.job_id%TYPE;

291:
292: -- Added for bug 1889671
293:
294: l_person_id pa_resource_txn_attributes.person_id%TYPE;
295: l_job_id pa_resource_txn_attributes.job_id%TYPE;
296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

Line 296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;

292: -- Added for bug 1889671
293:
294: l_person_id pa_resource_txn_attributes.person_id%TYPE;
295: l_job_id pa_resource_txn_attributes.job_id%TYPE;
296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;

Line 297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;

293:
294: l_person_id pa_resource_txn_attributes.person_id%TYPE;
295: l_job_id pa_resource_txn_attributes.job_id%TYPE;
296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

Line 298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

294: l_person_id pa_resource_txn_attributes.person_id%TYPE;
295: l_job_id pa_resource_txn_attributes.job_id%TYPE;
296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

Line 299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

295: l_job_id pa_resource_txn_attributes.job_id%TYPE;
296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

Line 300: l_event_type pa_resource_txn_attributes.event_type%TYPE;

296: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
304: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

Line 301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

297: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

298: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

299: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 304: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

300: l_event_type pa_resource_txn_attributes.event_type%TYPE;
301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 305: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

301: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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;

Line 306: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

302: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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:

Line 307: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

303: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%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:

Line 314: /* Added for bug 1889671. This will fetch 13 txn attributed from pa_resource_txn_attributes table

310:
311:
312: BEGIN
313:
314: /* Added for bug 1889671. This will fetch 13 txn attributed from pa_resource_txn_attributes table
315: along with resource_format_id. Also,resoure_type_id and resource_type_code is also fetched.*/
316:
317: SELECT prta.person_id,
318: prta.job_id,

Line 350: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,

346: l_system_link_function,
347: l_resource_format_id,
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