DBA Data[Home] [Help]

APPS.GMS_ENC_ADJUSTMENTS dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

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 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 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