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.3 2011/06/24 07:59:15 vegajula ship $ */
3:
4: /*======================== PO_RELEASES_SV ===============================*/
5:

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

1: PACKAGE BODY PO_RELEASES_SV as
2: /* $Header: POXPOR1B.pls 120.3 2011/06/24 07:59:15 vegajula ship $ */
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 103: po_releases_sv.delete_children(X_po_release_id);

99: /** Call the cover routine to delete all of the children
100: */
101:
102: po_headers_sv1.delete_events_entities('RELEASE', X_po_release_id);
103: po_releases_sv.delete_children(X_po_release_id);
104: -- dbms_output.put_line('after delete children');
105:
106: po_releases_pkg_s2.delete_row(X_row_id);
107: -- dbms_output.put_line('after call to delete row');

Line 106: po_releases_pkg_s2.delete_row(X_row_id);

102: po_headers_sv1.delete_events_entities('RELEASE', X_po_release_id);
103: po_releases_sv.delete_children(X_po_release_id);
104: -- dbms_output.put_line('after delete children');
105:
106: po_releases_pkg_s2.delete_row(X_row_id);
107: -- dbms_output.put_line('after call to delete row');
108:
109: EXCEPTION
110: WHEN OTHERS THEN

Line 184: FROM PO_RELEASES

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

Line 206: END PO_RELEASES_SV;

202: po_message_s.sql_error('delete_children', X_progress, sqlcode);
203: END delete_children;
204:
205:
206: END PO_RELEASES_SV;