APPS.PO_RELEASES_PKG_S2 dependencies on PO_RELEASES

Line 1: PACKAGE BODY PO_RELEASES_PKG_S2 as

1: PACKAGE BODY PO_RELEASES_PKG_S2 as
2: /* $Header: POXP3PLB.pls 120.5 2005/09/30 08:50:33 nipagarw noship $ */
3:
4: /*===========================================================================
5:

Line 90: ** POXPOERL.fmb(Release) PO_RELEASES.ON-UPDATE trigger updates

86: BEGIN
87: /* Bug 1181957
88: ** Change the Authorization status to REQUIRES REAPPROVAL, only
89: ** if it is APPROVEd.
90: ** POXPOERL.fmb(Release) PO_RELEASES.ON-UPDATE trigger updates
91: ** the authorization_status if X_Need_To_Approve > 0.
92: ** X_Need_To_Approve is initialized and IF statement is added.
93: */
94:

Line 99: IF po_releases_sv4.val_approval_status(

95: X_Need_To_Approve := 0;
96:
97: IF X_Approved_Flag = 'Y' THEN
98:
99: IF po_releases_sv4.val_approval_status(
100: X_po_release_id,
101: X_release_num,
102: X_agent_id,
103: X_release_date,

Line 114: UPDATE PO_RELEASES

110: X_Need_To_Approve := 2;
111: END IF;
112: END IF;
113:
114: UPDATE PO_RELEASES
115: SET
116: po_release_id = X_Po_Release_Id,
117: last_update_date = X_Last_Update_Date,
118: last_updated_by = X_Last_Updated_By,

Line 202: DELETE FROM PO_RELEASES

198:
199:
200: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
201: BEGIN
202: DELETE FROM PO_RELEASES
203: WHERE rowid = X_Rowid;
204:
205: if (SQL%NOTFOUND) then
206: Raise NO_DATA_FOUND;

Line 210: END PO_RELEASES_PKG_S2;

206: Raise NO_DATA_FOUND;
207: end if;
208: END Delete_Row;
209:
210: END PO_RELEASES_PKG_S2;