PACKAGE: APPS.PO_REQ_DOCUMENT_CHECKS_PVT

Source

1 PACKAGE PO_REQ_DOCUMENT_CHECKS_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVRCKS.pls 115.2 2003/09/25 03:00:58 bmunagal noship $*/
3 
4 -----------------------------------------------------------------------------
5 -- Public variables
6 -----------------------------------------------------------------------------
7 
8 --<DropShip FPJ Start>
9 --The following constants are possible values
10 --  for p_mode input parameter of po_status_check Procedure
11 G_CHECK_UPDATEABLE   CONSTANT VARCHAR2(30) := 'CHECK_UPDATEABLE';
12 G_GET_STATUS         CONSTANT VARCHAR2(30) := 'GET_STATUS';
13 G_CHECK_RESERVABLE   CONSTANT VARCHAR2(30) := 'CHECK_RESERVABLE';
14 G_CHECK_UNRESERVABLE CONSTANT VARCHAR2(30) := 'CHECK_UNRESERVABLE';
15 --<DropShip FPJ End>
16 
17 
18 -----------------------------------------------------------------------------
19 -- Public subprograms
20 -----------------------------------------------------------------------------
21 
22 
23 -- Detailed comments maintained in the Package Body PO_REQ_DOCUMENT_CHECKS_PVT.req_status_check
24 PROCEDURE req_status_check (
25     p_api_version         IN NUMBER,
26     p_req_header_id       IN PO_TBL_NUMBER,
27     p_req_line_id         IN PO_TBL_NUMBER,
28     p_req_distribution_id IN PO_TBL_NUMBER,
29     p_mode                IN VARCHAR2,
30     p_lock_flag           IN VARCHAR2 := 'N',
31     x_req_status_rec      OUT NOCOPY PO_STATUS_REC_TYPE,
32     x_return_status       OUT NOCOPY VARCHAR2,
33     x_msg_count           OUT NOCOPY NUMBER,
34     x_msg_data            OUT NOCOPY VARCHAR2
35 );
36 
37 END PO_REQ_DOCUMENT_CHECKS_PVT;