DBA Data[Home] [Help]

APPS.PO_REQUISITION_HEADERS_PKG1 dependencies on PO_REQUISITION_HEADERS

Line 1: PACKAGE BODY PO_REQUISITION_HEADERS_PKG1 as

1: PACKAGE BODY PO_REQUISITION_HEADERS_PKG1 as
2: /* $Header: POXRIH2B.pls 120.2.12020000.2 2013/02/11 00:43:48 vegajula ship $ */
3:
4: /**************************************************************************/
5: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 6: c_log_head CONSTANT VARCHAR2(40) := 'po.plsql.PO_REQUISITION_HEADERS_PKG1.';

2: /* $Header: POXRIH2B.pls 120.2.12020000.2 2013/02/11 00:43:48 vegajula ship $ */
3:
4: /**************************************************************************/
5: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: c_log_head CONSTANT VARCHAR2(40) := 'po.plsql.PO_REQUISITION_HEADERS_PKG1.';
7:
8: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
9: X_Requisition_Header_Id NUMBER,
10: X_Preparer_Id NUMBER,

Line 59: FROM PO_REQUISITION_HEADERS

55: ) IS
56:
57: CURSOR C IS
58: SELECT *
59: FROM PO_REQUISITION_HEADERS
60: WHERE rowid = X_Rowid
61: FOR UPDATE of Requisition_Header_Id NOWAIT;
62: Recinfo C%ROWTYPE;
63: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 345: END PO_REQUISITION_HEADERS_PKG1;

341: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');
342: END Lock_Row;
343:
344:
345: END PO_REQUISITION_HEADERS_PKG1;