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_EXP_COPY dependencies on PA_EXPENDITURES

Line 543: /* Bug 1118913 Removed pa_expenditures_s.nextval new_exp_id from

539:
540: l_org_id NUMBER := pa_moac_utils.get_current_org_id;
541:
542: /* Bug 954856 Added ORDER BY expenditure_id to cursor getEXP */
543: /* Bug 1118913 Removed pa_expenditures_s.nextval new_exp_id from
544: cursor. Whereever EXP.new_exp_id change to
545: new_exp_id */
546:
547: CURSOR getEXP IS

Line 574: pa_expenditures

570: , acct_rate_date
571: , acct_exchange_rate
572: , person_type -- fix for bug : 3645842
573: FROM
574: pa_expenditures
575: WHERE
576: expenditure_group = orig_exp_group
577: AND expenditure_id = nvl( orig_exp_id, expenditure_id )
578: ORDER BY expenditure_id;

Line 583: temp_acct_rate_type pa_expenditures.acct_rate_type%TYPE;

579:
580: EXP getEXP%ROWTYPE;
581:
582: -- Starts Added for bug#4618898
583: temp_acct_rate_type pa_expenditures.acct_rate_type%TYPE;
584: temp_acct_rate_date pa_expenditures.acct_rate_date%TYPE;
585: temp_acct_exchange_rate pa_expenditures.acct_exchange_rate%TYPE;
586: l_status VARCHAR2(30);
587: l_dummy1 NUMBER;

Line 584: temp_acct_rate_date pa_expenditures.acct_rate_date%TYPE;

580: EXP getEXP%ROWTYPE;
581:
582: -- Starts Added for bug#4618898
583: temp_acct_rate_type pa_expenditures.acct_rate_type%TYPE;
584: temp_acct_rate_date pa_expenditures.acct_rate_date%TYPE;
585: temp_acct_exchange_rate pa_expenditures.acct_exchange_rate%TYPE;
586: l_status VARCHAR2(30);
587: l_dummy1 NUMBER;
588: l_dummy2 NUMBER;

Line 585: temp_acct_exchange_rate pa_expenditures.acct_exchange_rate%TYPE;

581:
582: -- Starts Added for bug#4618898
583: temp_acct_rate_type pa_expenditures.acct_rate_type%TYPE;
584: temp_acct_rate_date pa_expenditures.acct_rate_date%TYPE;
585: temp_acct_exchange_rate pa_expenditures.acct_exchange_rate%TYPE;
586: l_status VARCHAR2(30);
587: l_dummy1 NUMBER;
588: l_dummy2 NUMBER;
589: l_dummy3 NUMBER;

Line 637: SELECT pa_expenditures_s.nextval

633: -- Earlier the new expenditure id was generated
634: -- in the select statement. But there was problem
635: -- using the sequence generator in the SELECT statement
636:
637: SELECT pa_expenditures_s.nextval
638: INTO new_exp_id
639: FROM DUAL ;
640:
641: --

Line 765: 'PA_EXPENDITURES',

761: -- Copies the attachments for the original expenditure
762: -- to the newly created expenditure
763:
764: fnd_attached_documents2_pkg.copy_attachments(
765: 'PA_EXPENDITURES',
766: EXP.orig_exp_id,
767: null,
768: null,
769: null,

Line 771: 'PA_EXPENDITURES',

767: null,
768: null,
769: null,
770: null,
771: 'PA_EXPENDITURES',
772: new_exp_id,
773: null,
774: null,
775: null,

Line 829: pa_expenditures e

825: INTO
826: X_exp_class_code,
827: l_inc_by_org_id
828: FROM
829: pa_expenditures e
830: WHERE
831: e.expenditure_id = orig_exp_id;
832:
833: IF ( X_exp_class_code = 'OT' ) THEN

Line 879: , pa_expenditures_s.nextval new_exp_id

875:
876: CURSOR RevExp is
877: SELECT
878: e.expenditure_id orig_exp_id
879: , pa_expenditures_s.nextval new_exp_id
880: , e.expenditure_ending_date
881: , e.description
882: , e.incurred_by_person_id person_id
883: , e.incurred_by_organization_id inc_by_org_id

Line 904: pa_expenditures e

900: , e.acct_rate_date
901: , e.acct_exchange_rate
902: , e.person_type -- CWK change
903: FROM
904: pa_expenditures e
905: WHERE
906: e.expenditure_group = X_orig_exp_group ;
907:
908: cursor RevExpItems(expend_id NUMBER ) is

Line 1128: X_from_entity_name => 'PA_EXPENDITURES',

1124: -- Copies the attachments for the original expenditure
1125: -- to the newly created expenditure
1126:
1127: fnd_attached_documents2_pkg.copy_attachments(
1128: X_from_entity_name => 'PA_EXPENDITURES',
1129: X_from_pk1_value => Exp.orig_exp_id,
1130: X_from_pk2_value => null,
1131: X_from_pk3_value => null,
1132: X_from_pk4_value => null,

Line 1134: X_to_entity_name => 'PA_EXPENDITURES',

1130: X_from_pk2_value => null,
1131: X_from_pk3_value => null,
1132: X_from_pk4_value => null,
1133: X_from_pk5_value => null,
1134: X_to_entity_name => 'PA_EXPENDITURES',
1135: X_to_pk1_value => Exp.new_exp_id,
1136: X_to_pk2_value => null,
1137: X_to_pk3_value => null,
1138: X_to_pk4_value => null,