APPS.GMS_ENC_ADJUSTMENTS dependencies on GMS_ENCUMBRANCES

Line 391: from gms_award_distributions adl ,gms_encumbrance_items ei,gms_encumbrances es

387: FOR EI IN getEI LOOP
388:
389: Begin
390: select award_id into P_Award_Id
391: from gms_award_distributions adl ,gms_encumbrance_items ei,gms_encumbrances es
392: where adl.expenditure_item_id = ei.encumbrance_item_id
393: and ei.encumbrance_id = es.encumbrance_id
394: and es.encumbrance_id = X_orig_enc_id
395: and adl.document_type = 'ENC'

Line 624: gms_encumbrances

620: orig_user_enc_txn_reference,
621: vendor_id,
622: org_id
623: FROM
624: gms_encumbrances
625: WHERE
626: encumbrance_group = orig_enc_group
627: AND encumbrance_id = nvl( orig_enc_id, encumbrance_id );
628:

Line 658: select gms_encumbrances_s.nextval

654: EXIT WHEN getENC%NOTFOUND;
655:
656: x_orig_enc_id := enc.encumbrance_id ;
657:
658: select gms_encumbrances_s.nextval
659: into new_enc_id
660: from dual;
661:
662: BEGIN

Line 682: gms_encumbrances_pkg.Insert_row (x_rowid => x_dummy ,

678: , enc_ending_date
679: , ENC.person_id );
680: END IF;
681:
682: gms_encumbrances_pkg.Insert_row (x_rowid => x_dummy ,
683: x_encumbrance_id => new_enc_id,
684: x_last_update_date => sysdate ,
685: x_last_updated_by => X_user ,
686: x_creation_date => sysdate ,

Line 769: , gms_encumbrances_s.nextval new_enc_id

765:
766: CURSOR RevEnc is
767: SELECT
768: e.encumbrance_id orig_enc_id
769: , gms_encumbrances_s.nextval new_enc_id
770: , e.encumbrance_ending_date
771: , e.description
772: , e.incurred_by_person_id person_id
773: , e.incurred_by_organization_id inc_by_org_id

Line 794: gms_encumbrances e

790: , e.acct_rate_date
791: , e.acct_exchange_rate
792: , e.org_id
793: FROM
794: gms_encumbrances e
795: WHERE
796: e.encumbrance_group = X_orig_enc_group ;
797:
798: cursor RevEncItems(encend_id NUMBER ) is

Line 914: gms_encumbrances_pkg.Insert_row(x_rowid => x_dummy ,

910: ELSE
911: enc_status := 'APPROVED';
912: END IF;
913:
914: gms_encumbrances_pkg.Insert_row(x_rowid => x_dummy ,
915: X_encumbrance_id => Enc.new_enc_id,
916: X_last_update_date => sysdate ,
917: X_last_updated_by => fnd_global.user_id ,
918: X_creation_date => sysdate ,