APPS.PO_REQUISITION_LINES_PKG1 dependencies on PO_REQUISITION_LINES

Line 1: PACKAGE BODY PO_REQUISITION_LINES_PKG1 as

1: PACKAGE BODY PO_REQUISITION_LINES_PKG1 as
2: /* $Header: POXRIL2B.pls 120.1 2005/06/27 04:48:16 sjadhav noship $ */
3:
4:
5: PROCEDURE Lock1_Row(X_Rowid VARCHAR2,

Line 32: FROM PO_REQUISITION_LINES

28: ) IS
29:
30: CURSOR C IS
31: SELECT *
32: FROM PO_REQUISITION_LINES
33: WHERE rowid = X_Rowid
34: FOR UPDATE of Requisition_Line_Id NOWAIT;
35:
36: Recinfo C%ROWTYPE;

Line 113: FROM po_requisition_lines

109: x_progress := '010';
110:
111: SELECT requisition_header_id
112: INTO x_requisition_header_id
113: FROM po_requisition_lines
114: WHERE rowid = X_rowid;
115:
116: if (SQL%NOTFOUND) then
117: Raise NO_DATA_FOUND;

Line 122: DELETE FROM PO_REQUISITION_LINES

118: end if;
119:
120: x_progress := '020';
121:
122: DELETE FROM PO_REQUISITION_LINES
123: WHERE rowid = X_Rowid;
124:
125: if (SQL%NOTFOUND) then
126: Raise NO_DATA_FOUND;

Line 144: END PO_REQUISITION_LINES_PKG1;

140:
141: END Delete_Row;
142:
143:
144: END PO_REQUISITION_LINES_PKG1;