APPS.GMS_ENC_ADJUSTMENTS dependencies on GMS_ENCUMBRANCE_ITEMS

Line 36: UPDATE gms_encumbrance_items_all ei

32: , X_login IN NUMBER
33: , X_status OUT NOCOPY NUMBER )
34: IS
35: BEGIN
36: UPDATE gms_encumbrance_items_all ei
37: SET
38: ei.net_zero_adjustment_flag = 'Y'
39: , ei.last_update_date = sysdate
40: , ei.last_updated_by = X_user

Line 88: select gms_encumbrance_items_s.nextval

84: X_backout_id NUMBER(15);
85: temp_status NUMBER DEFAULT NULL;
86:
87: BEGIN
88: select gms_encumbrance_items_s.nextval
89: into X_backout_id
90: from SYS.dual ;
91: -- X_backout_id := pa_utils.GetNextEiId;
92:

Line 93: INSERT INTO gms_encumbrance_items_all(

89: into X_backout_id
90: from SYS.dual ;
91: -- X_backout_id := pa_utils.GetNextEiId;
92:
93: INSERT INTO gms_encumbrance_items_all(
94: encumbrance_item_id
95: , task_id
96: , project_id --Bug 5726575
97: , encumbrance_type

Line 198: gms_encumbrance_items_all ei

194: , ei.denom_tp_currency_code -- denom_tp_currency_code
195: , (0 - ei.denom_transfer_price) -- denom_transfer_price
196: , ei.encumbrance_comment -- encumbrance_comment
197: FROM
198: gms_encumbrance_items_all ei
199:
200: WHERE
201: ei.encumbrance_item_id = X_enc_item_id ;
202: /*

Line 281: SELECT gms_encumbrance_items_s.nextval encumbrance_item_id,

277: P_OUTCOME VARCHAR2(1000);
278:
279: CURSOR getEI IS
280: -- verified the columns with latest table order
281: SELECT gms_encumbrance_items_s.nextval encumbrance_item_id,
282: i.last_update_date,
283: i.last_updated_by,
284: i.creation_date,
285: i.created_by,

Line 347: ,gms_encumbrance_items i

343: t.billable_flag
344:
345: FROM
346: pa_tasks t
347: ,gms_encumbrance_items i
348: WHERE
349: (X_enc_class_code = 'ER'
350: OR i.system_linkage_function = 'ST' )
351: AND i.task_id = t.task_id

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 484: gms_encumbrance_items_pkg.insert_row(

480: , P_OUTCOME ) ;
481:
482: -- verified the columns with getEI order.(latest table order )
483:
484: gms_encumbrance_items_pkg.insert_row(
485: x_dummy,
486: EI.encumbrance_item_id,
487: EI.last_update_date,
488: EI.last_updated_by,

Line 805: gms_encumbrance_items_all ei

801: , ei.net_zero_adjustment_flag
802: , ei.source_encumbrance_item_id
803: , ei.transferred_from_enc_item_id
804: from
805: gms_encumbrance_items_all ei
806: where
807: encumbrance_id = encend_id ;
808:
809: cursor ReverseGroup is