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.12020000.2 2013/02/10 15:54:30 vegajula ship $ */
3:
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 6: c_log_head CONSTANT VARCHAR2(35) := 'po.plsql.PO_REQUISITION_LINES_PKG1.';

2: /* $Header: POXRIL2B.pls 120.1.12020000.2 2013/02/10 15:54:30 vegajula ship $ */
3:
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: c_log_head CONSTANT VARCHAR2(35) := 'po.plsql.PO_REQUISITION_LINES_PKG1.';
7: PROCEDURE Lock1_Row(X_Rowid VARCHAR2,
8: X_Requisition_Line_Id NUMBER,
9: X_Requisition_Header_Id NUMBER,
10: X_Line_Num NUMBER,

Line 34: FROM PO_REQUISITION_LINES

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

Line 171: FROM po_requisition_lines

167: x_progress := '010';
168:
169: SELECT requisition_header_id
170: INTO x_requisition_header_id
171: FROM po_requisition_lines
172: WHERE rowid = X_rowid;
173:
174: if (SQL%NOTFOUND) then
175: Raise NO_DATA_FOUND;

Line 180: DELETE FROM PO_REQUISITION_LINES

176: end if;
177:
178: x_progress := '020';
179:
180: DELETE FROM PO_REQUISITION_LINES
181: WHERE rowid = X_Rowid;
182:
183: if (SQL%NOTFOUND) then
184: Raise NO_DATA_FOUND;

Line 202: END PO_REQUISITION_LINES_PKG1;

198:
199: END Delete_Row;
200:
201:
202: END PO_REQUISITION_LINES_PKG1;