DBA Data[Home] [Help]

APPS.PO_RELEASES_PKG_S0 dependencies on PO_RELEASES

Line 1: PACKAGE BODY PO_RELEASES_PKG_S0 as

1: PACKAGE BODY PO_RELEASES_PKG_S0 as
2: /* $Header: POXP1PLB.pls 120.4 2005/08/29 00:29:01 vsanjay noship $ */
3:
4: /*===========================================================================
5:

Line 89: CURSOR C IS SELECT rowid FROM PO_RELEASES

85: X_Global_Attribute20 VARCHAR2,
86: p_shipping_control IN VARCHAR2, --
87: p_org_id IN NUMBER DEFAULT NULL --
88: ) IS
89: CURSOR C IS SELECT rowid FROM PO_RELEASES
90: WHERE po_release_id = X_Po_Release_Id;
91:
92:
93:

Line 96: CURSOR C2 IS SELECT po_releases_s.nextval FROM sys.dual;

92:
93:
94:
95:
96: CURSOR C2 IS SELECT po_releases_s.nextval FROM sys.dual;
97:
98: x_progress VARCHAR2(3) := NULL;
99: BEGIN
100: x_progress := '005';

Line 110: INSERT INTO PO_RELEASES (

106: end if;
107:
108: x_progress := '010';
109:
110: INSERT INTO PO_RELEASES (
111: po_release_id,
112: last_update_date,
113: last_updated_by,
114: po_header_id,

Line 292: END PO_RELEASES_PKG_S0;

288: raise;
289:
290: END Insert_Row;
291:
292: END PO_RELEASES_PKG_S0;