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_TRANSACTIONS_PUB dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 419: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,

415: -- Once passed validation, this API also makes sure only the enabled segments
416: -- are passed back through the IN/OUT p_attributex parameters
417: PROCEDURE validate_dff (
418: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
419: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
420: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,

Line 420: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,

416: -- are passed back through the IN/OUT p_attributex parameters
417: PROCEDURE validate_dff (
418: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
419: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
420: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,

Line 421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,

417: PROCEDURE validate_dff (
418: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
419: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
420: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,

Line 422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,

418: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
419: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
420: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,

Line 423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,

419: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
420: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,

Line 424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,

420: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
428: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,

Line 425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,

421: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
428: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
429: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,

Line 426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,

422: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
428: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
429: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
430: x_status_code OUT NOCOPY VARCHAR2,

Line 427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,

423: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
428: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
429: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
430: x_status_code OUT NOCOPY VARCHAR2,
431: x_error_message OUT NOCOPY VARCHAR2)

Line 428: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,

424: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
428: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
429: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
430: x_status_code OUT NOCOPY VARCHAR2,
431: x_error_message OUT NOCOPY VARCHAR2)
432:

Line 429: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,

425: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
426: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
427: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
428: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
429: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
430: x_status_code OUT NOCOPY VARCHAR2,
431: x_error_message OUT NOCOPY VARCHAR2)
432:
433: IS

Line 434: v_attribute1 pa_expenditure_items_all.attribute1%TYPE;

430: x_status_code OUT NOCOPY VARCHAR2,
431: x_error_message OUT NOCOPY VARCHAR2)
432:
433: IS
434: v_attribute1 pa_expenditure_items_all.attribute1%TYPE;
435: v_attribute2 pa_expenditure_items_all.attribute2%TYPE;
436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;
437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;

Line 435: v_attribute2 pa_expenditure_items_all.attribute2%TYPE;

431: x_error_message OUT NOCOPY VARCHAR2)
432:
433: IS
434: v_attribute1 pa_expenditure_items_all.attribute1%TYPE;
435: v_attribute2 pa_expenditure_items_all.attribute2%TYPE;
436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;
437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;

Line 436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;

432:
433: IS
434: v_attribute1 pa_expenditure_items_all.attribute1%TYPE;
435: v_attribute2 pa_expenditure_items_all.attribute2%TYPE;
436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;
437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;

Line 437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;

433: IS
434: v_attribute1 pa_expenditure_items_all.attribute1%TYPE;
435: v_attribute2 pa_expenditure_items_all.attribute2%TYPE;
436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;
437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;
441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;

Line 438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;

434: v_attribute1 pa_expenditure_items_all.attribute1%TYPE;
435: v_attribute2 pa_expenditure_items_all.attribute2%TYPE;
436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;
437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;
441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;
442: v_attribute9 pa_expenditure_items_all.attribute9%TYPE;

Line 439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;

435: v_attribute2 pa_expenditure_items_all.attribute2%TYPE;
436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;
437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;
441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;
442: v_attribute9 pa_expenditure_items_all.attribute9%TYPE;
443: v_attribute10 pa_expenditure_items_all.attribute10%TYPE;

Line 440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;

436: v_attribute3 pa_expenditure_items_all.attribute3%TYPE;
437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;
441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;
442: v_attribute9 pa_expenditure_items_all.attribute9%TYPE;
443: v_attribute10 pa_expenditure_items_all.attribute10%TYPE;
444: v_desc_flex_context_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;

Line 441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;

437: v_attribute4 pa_expenditure_items_all.attribute4%TYPE;
438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;
441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;
442: v_attribute9 pa_expenditure_items_all.attribute9%TYPE;
443: v_attribute10 pa_expenditure_items_all.attribute10%TYPE;
444: v_desc_flex_context_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
445: i NUMBER;

Line 442: v_attribute9 pa_expenditure_items_all.attribute9%TYPE;

438: v_attribute5 pa_expenditure_items_all.attribute5%TYPE;
439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;
441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;
442: v_attribute9 pa_expenditure_items_all.attribute9%TYPE;
443: v_attribute10 pa_expenditure_items_all.attribute10%TYPE;
444: v_desc_flex_context_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
445: i NUMBER;
446: /* Start of Bug 3064318 */

Line 443: v_attribute10 pa_expenditure_items_all.attribute10%TYPE;

439: v_attribute6 pa_expenditure_items_all.attribute6%TYPE;
440: v_attribute7 pa_expenditure_items_all.attribute7%TYPE;
441: v_attribute8 pa_expenditure_items_all.attribute8%TYPE;
442: v_attribute9 pa_expenditure_items_all.attribute9%TYPE;
443: v_attribute10 pa_expenditure_items_all.attribute10%TYPE;
444: v_desc_flex_context_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
445: i NUMBER;
446: /* Start of Bug 3064318 */
447: TYPE seg_col_name is TABLE of varchar2(150)

Line 655: -- 1) pa_expenditure_items_all.non_labor_resource and pa_expenditure_items_all.organization_id

651: IS
652:
653: --The following Cursor will select the item in Projects based upon the parameters passed
654: --to the API. It is a UNION because
655: -- 1) pa_expenditure_items_all.non_labor_resource and pa_expenditure_items_all.organization_id
656: -- (non labor resource owning organization) only exist for Usages (expenditure_type_class = 'USG')
657: -- 2) pa_expenditures_all.incurred_by_person_id may or may not exist for Usages, and
658: -- does not exist for Supplier Invoices.
659:

Line 664: FROM pa_expenditure_items_all ei,

660: CURSOR item_in_projects IS
661: --The first part of the UNION handles all expenditure_type_classes EXCEPT
662: --Usages (USG) and Supplier Invoices (VI).
663: SELECT net_zero_adjustment_flag
664: FROM pa_expenditure_items_all ei,
665: pa_expenditures_all exp,
666: per_all_people_f per,
667: pa_projects_all proj,
668: pa_tasks task,

Line 707: FROM pa_expenditure_items_all ei,

703: --The second part of the UNION handles Usages (expenditure_type_class='USG')
704: --when IN parameter x_employee_number is NOT NULL. The additional join to
705: --hr_all_organization_units hr2 is required.
706: SELECT net_zero_adjustment_flag
707: FROM pa_expenditure_items_all ei,
708: pa_expenditures_all exp,
709: per_all_people_f per,
710: pa_projects_all proj,
711: pa_tasks task,

Line 754: FROM pa_expenditure_items_all ei,

750: --The third part of the UNION handles Usages (expenditure_type_class='USG')
751: --when IN PARAMETER x_exployee_number IS NULL. The additional join to
752: --hr_all_organization_units hr2 is required and the join to per_all_people_f is not required.
753: SELECT net_zero_adjustment_flag
754: FROM pa_expenditure_items_all ei,
755: pa_expenditures_all exp,
756: pa_projects_all proj,
757: pa_tasks task,
758: hr_all_organization_units hr1,

Line 797: FROM pa_expenditure_items_all ei,

793: --The fourth part of the UNION handles Supplier Invoices (expenditure_type_class='VI').
794: --The join to per_all_people_f is not required as pa_expenditures_all.incurred_by_person_id
795: --is NULL for Supplier Invoices.
796: SELECT net_zero_adjustment_flag
797: FROM pa_expenditure_items_all ei,
798: pa_expenditures_all exp,
799: pa_projects_all proj,
800: pa_tasks task,
801: hr_all_organization_units hr1

Line 840: l_net_zero_adjustment_flag pa_expenditure_items_all.net_zero_adjustment_flag%TYPE;

836: FROM pa_lookups
837: WHERE lookup_type = 'PA_ADJUSTMENT_STATUS'
838: AND lookup_code = x_adjustment_status_code;
839:
840: l_net_zero_adjustment_flag pa_expenditure_items_all.net_zero_adjustment_flag%TYPE;
841: e_no_unique_transaction exception;
842:
843:
844: BEGIN