1 PACKAGE PO_REQ_DOCUMENT_CHECKS_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGRCKS.pls 115.1 2003/09/10 02:11:18 bmunagal noship $*/
3
4 -- The new overloaded procedures req_status_check added in DropShip FPJ project
5
6 -- Detailed comments are in PVT Package Body PO_REQ_DOCUMENT_CHECKS_PVT.req_status_check
7 PROCEDURE req_status_check (
8 p_api_version IN NUMBER,
9 p_req_header_id IN PO_TBL_NUMBER,
10 p_req_line_id IN PO_TBL_NUMBER,
11 p_req_distribution_id IN PO_TBL_NUMBER,
12 p_mode IN VARCHAR2,
13 p_lock_flag IN VARCHAR2 := 'N',
14 x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2
18 );
19
20 -- Detailed comments are in PVT Package Body PO_REQ_DOCUMENT_CHECKS_PVT.req_status_check
21 PROCEDURE req_status_check (
22 p_api_version IN NUMBER,
23 p_req_header_id IN NUMBER,
24 p_req_line_id IN NUMBER := NULL,
25 p_req_distribution_id IN NUMBER := NULL,
26 p_mode IN VARCHAR2,
27 p_lock_flag IN VARCHAR2 := 'N',
28 x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34
35 END PO_REQ_DOCUMENT_CHECKS_GRP;