1 PACKAGE RCV_OPSM_DLV_BE_PKG AUTHID CURRENT_USER AS
2 /* $Header: RCVOPSMDLVS.pls 120.2 2010/09/27 20:34:35 skaradib noship $ */
3 ------------------------------------------------------------------------------------------------
4 --
5 -- Procedure: RCV_OPSM_DLV_EVENT
6 -- Parameters: p_shipmentheaderid - SHIPMENT_HEADER_ID
7 -- p_groupid - GROUP_ID
8 -- p_out_rmaheader_info - out variable for RCV_OPSM_DLVHDR_TBL type
9 -- p_out_rmaline_info - out variable for RCV_OPSM_DLVLINE_TBL type
10 -- p_out_rmalot_info - out variable for RCV_OPSM_DLVLOT_TBL type
11 -- p_out_rmaserial_info - out variable for RCV_OPSM_DLVSRL_TBL type
12 -- x_return_status - return status of the API
13 -- x_msg_data - return Error Message of the API
14 --
15 --
16 -- Description: This Procedure fetches all the OPSM Integrated items for the input parameter
17 -- shipment header id and group id and load the details to the respective table type objects
18 -- and sends them as out variable.
19 --
20 -- Author: susubram
21 ------------------------------------------------------------------------------------------------
22 PROCEDURE RCV_OPSM_DLV_EVENT
23 (
24 p_shipmentheaderid IN NUMBER,
25 p_groupid IN NUMBER,
26 p_out_rmaheader_info OUT NOCOPY RCV_OPSM_DLVHDR_TBL,
27 p_out_rmaline_info OUT NOCOPY RCV_OPSM_DLVLINE_TBL,
28 p_out_rmalot_info OUT NOCOPY RCV_OPSM_DLVLOT_TBL,
29 p_out_rmaserial_info OUT NOCOPY RCV_OPSM_DLVSRL_TBL,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_data OUT NOCOPY VARCHAR2);
32 ---------------------------------------------------------------------------------------
33 -- Procedure: RCV_OPSM_CHECK
34 -- Parameters: p_shipmentheaderid - SHIPMENT_HEADER_ID
35 -- p_opsmexist- It returns 'Y' or 'N'
36 -- x_return_status-return status of the procedure
37 -- x_msg_data -return Error Message of the procedure
38 --
39 -- Description: This Function Returns 'Y' or 'N'after checking
40 -- the condition that the Input shipment header id and group id has
41 -- at least one OPSM enabled item or not.
42 ---------------------------------------------------------------------------------------
43 PROCEDURE RCV_OPSM_CHECK
44 (
45 p_shipmentheaderid IN NUMBER,
46 p_groupid IN NUMBER,
47 p_opsmexist OUT NOCOPY VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_data OUT NOCOPY VARCHAR2);
50 G_PKG_NAME CONSTANT VARCHAR2(50) := 'RCV_OPSM_DLV_BE_PKG';
51 END RCV_OPSM_DLV_BE_PKG;