1: PACKAGE wms_rcv_pup_pvt AUTHID CURRENT_USER AS
2: /* $Header: WMSRCVPS.pls 120.0.12010000.1 2008/07/28 18:36:22 appldev ship $*/
3:
4: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
5: G_RET_STS_UNEXP_ERR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
7:
8: g_default_txn_mode CONSTANT VARCHAR2(25) := 'ONLINE';
1: PACKAGE wms_rcv_pup_pvt AUTHID CURRENT_USER AS
2: /* $Header: WMSRCVPS.pls 120.0.12010000.1 2008/07/28 18:36:22 appldev ship $*/
3:
4: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
5: G_RET_STS_UNEXP_ERR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
7:
8: g_default_txn_mode CONSTANT VARCHAR2(25) := 'ONLINE';
9:
2: /* $Header: WMSRCVPS.pls 120.0.12010000.1 2008/07/28 18:36:22 appldev ship $*/
3:
4: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
5: G_RET_STS_UNEXP_ERR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
7:
8: g_default_txn_mode CONSTANT VARCHAR2(25) := 'ONLINE';
9:
10: TYPE number_tb_type IS TABLE OF NUMBER
20:
21: PROCEDURE pack_unpack_split
22: (p_transaction_temp_id IN NUMBER DEFAULT NULL
23: ,p_header_id IN NUMBER DEFAULT NULL
24: ,p_call_rcv_tm IN VARCHAR2 DEFAULT fnd_api.g_true
25: ,p_txn_mode_code IN VARCHAR2 DEFAULT g_default_txn_mode
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,x_msg_count OUT NOCOPY NUMBER
28: ,x_msg_data OUT NOCOPY VARCHAR2