DBA Data[Home] [Help]

APPS.PO_REQUISITION_LINES_PKG dependencies on PO_REQUISITION_LINES

Line 1: PACKAGE BODY PO_REQUISITION_LINES_PKG as

1: PACKAGE BODY PO_REQUISITION_LINES_PKG as
2: /* $Header: POXRIL1B.pls 120.6 2006/06/13 21:43:49 ksareddy noship $ */
3:
4:
5: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 128: UPDATE PO_REQUISITION_LINES

124:
125: x_progress := '010';
126:
127:
128: UPDATE PO_REQUISITION_LINES
129: SET
130: requisition_line_id = X_Requisition_Line_Id,
131: requisition_header_id = X_Requisition_Header_Id,
132: line_num = X_Line_Num,

Line 294: FROM po_requisition_lines

290: SELECT 1
291: INTO dummy
292: FROM DUAL
293: WHERE not exists (SELECT 1
294: FROM po_requisition_lines
295: WHERE line_num = X_line_num
296: AND requisition_header_id = X_req_header_id
297: AND ((x_rowid is null) or (rowid <> x_rowid))
298: );

Line 308: END PO_REQUISITION_LINES_PKG;

304: END check_unique;
305:
306:
307:
308: END PO_REQUISITION_LINES_PKG;