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 540: /* Bug 1118913 Removed pa_expenditures_s.nextval new_exp_id from

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

Line 571: pa_expenditures

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

Line 580: temp_acct_rate_type pa_expenditures.acct_rate_type%TYPE;

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

Line 581: temp_acct_rate_date pa_expenditures.acct_rate_date%TYPE;

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

Line 582: temp_acct_exchange_rate pa_expenditures.acct_exchange_rate%TYPE;

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

Line 634: SELECT pa_expenditures_s.nextval

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

Line 762: 'PA_EXPENDITURES',

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

Line 768: 'PA_EXPENDITURES',

764: null,
765: null,
766: null,
767: null,
768: 'PA_EXPENDITURES',
769: new_exp_id,
770: null,
771: null,
772: null,

Line 826: pa_expenditures e

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

Line 876: , pa_expenditures_s.nextval new_exp_id

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

Line 901: pa_expenditures e

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

Line 1125: X_from_entity_name => 'PA_EXPENDITURES',

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

Line 1131: X_to_entity_name => 'PA_EXPENDITURES',

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