APPS.PO_RELEASES_SV dependencies on PO_RELEASES

Line 1: PACKAGE BODY PO_RELEASES_SV as

1: PACKAGE BODY PO_RELEASES_SV as
2: /* $Header: POXPOR1B.pls 120.1 2005/06/10 01:58:21 kpsingh noship $ */
3:
4: /*======================== PO_RELEASES_SV ===============================*/
5:

Line 4: /*======================== PO_RELEASES_SV ===============================*/

1: PACKAGE BODY PO_RELEASES_SV as
2: /* $Header: POXPOR1B.pls 120.1 2005/06/10 01:58:21 kpsingh noship $ */
3:
4: /*======================== PO_RELEASES_SV ===============================*/
5:
6: /*===========================================================================
7:
8: PROCEDURE NAME: lock_row_for_status_update

Line 16: FROM po_releases

12: PROCEDURE lock_row_for_status_update (x_po_release_id IN NUMBER)
13: IS
14: CURSOR C IS
15: SELECT *
16: FROM po_releases
17: WHERE po_release_id = x_po_release_id
18: FOR UPDATE of po_release_id NOWAIT;
19: Recinfo C%ROWTYPE;
20:

Line 56: x_item_type PO_RELEASES_ALL.WF_ITEM_TYPE%TYPE;

52: (X_po_release_id IN NUMBER,
53: X_row_id IN VARCHAR2) IS
54:
55: X_progress VARCHAR2(3) := '';
56: x_item_type PO_RELEASES_ALL.WF_ITEM_TYPE%TYPE;
57: x_item_key PO_RELEASES_ALL.WF_ITEM_KEY%TYPE;
58: X_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;
59:
60: BEGIN

Line 57: x_item_key PO_RELEASES_ALL.WF_ITEM_KEY%TYPE;

53: X_row_id IN VARCHAR2) IS
54:
55: X_progress VARCHAR2(3) := '';
56: x_item_type PO_RELEASES_ALL.WF_ITEM_TYPE%TYPE;
57: x_item_key PO_RELEASES_ALL.WF_ITEM_KEY%TYPE;
58: X_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;
59:
60: BEGIN
61:

Line 58: X_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;

54:
55: X_progress VARCHAR2(3) := '';
56: x_item_type PO_RELEASES_ALL.WF_ITEM_TYPE%TYPE;
57: x_item_key PO_RELEASES_ALL.WF_ITEM_KEY%TYPE;
58: X_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;
59:
60: BEGIN
61:
62: /*

Line 70: FROM po_releases

66: X_progress := '010';
67:
68: SELECT wf_item_key, wf_item_type, release_type
69: INTO x_item_key, x_item_type, X_release_type
70: FROM po_releases
71: WHERE po_release_id = X_po_release_id;
72:
73: X_progress := '020';
74:

Line 91: fnd_attached_documents2_pkg.delete_attachments('PO_RELEASES', X_po_release_id,'', '', '', '', 'Y');

87: OBJECT_ID = X_po_release_id;
88:
89: X_progress := '040';
90:
91: fnd_attached_documents2_pkg.delete_attachments('PO_RELEASES', X_po_release_id,'', '', '', '', 'Y');
92:
93: /* Bug 2904413 */
94: X_progress := '050';
95:

Line 96: po_releases_pkg_s2.delete_row(X_row_id);

92:
93: /* Bug 2904413 */
94: X_progress := '050';
95:
96: po_releases_pkg_s2.delete_row(X_row_id);
97: -- dbms_output.put_line('after call to delete row');
98:
99: /*
100: ** Call the cover routine to delete all of the children

Line 102: po_releases_sv.delete_children(X_po_release_id);

98:
99: /*
100: ** Call the cover routine to delete all of the children
101: */
102: po_releases_sv.delete_children(X_po_release_id);
103: -- dbms_output.put_line('after delete children');
104:
105: EXCEPTION
106: WHEN OTHERS THEN

Line 180: FROM PO_RELEASES

176: /*po_notifications_sv1.delete_po_notif ('RELEASE',
177: X_po_release_id); */
178: SELECT wf_item_type,wf_item_key
179: INTO x_item_type,x_item_key
180: FROM PO_RELEASES
181: WHERE po_release_id = x_po_release_id;
182:
183: if ((x_item_type is null) and (x_item_key is null)) then
184: po_approval_reminder_sv.cancel_notif ('BLANKET',

Line 202: END PO_RELEASES_SV;

198: po_message_s.sql_error('delete_children', X_progress, sqlcode);
199: END delete_children;
200:
201:
202: END PO_RELEASES_SV;