1 PACKAGE csd_receive_pvt AUTHID CURRENT_USER AS
2 /* $Header: csdvrcvs.pls 120.1 2005/07/29 16:53:30 mshirkol noship $ */
3
4 /*-----------------------------------------------------------------------------------------------------------*/
5 /* procedure name: RECEIVE_ITEM */
6 /* description : Populates the Receive open interface tables and calls the Receive processor. This handles */
7 /* all types of receives a) Direct b) Standard */
8 /* Called from : CSDREPLN.pld. logistics tab.*/
9 /* Input Parm : p_api_version NUMBER Required Api Version number */
10 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
11 /* default value is fnd_api.g_false */
12 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
13 /* fnd_api.g_false */
14 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
15 /* validation steps must be done and which steps */
16 /* should be skipped. */
17 /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
18 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
19 /* fnd_api.g_ret_sts_success (success) */
20 /* fnd_api.g_ret_sts_error (error) */
21 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
22 /* x_msg_count NUMBER Number of messages in the message stack */
23 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
24 /*-----------------------------------------------------------------------------------------------------------*/
25 PROCEDURE receive_item (
26 p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2,
28 p_commit IN VARCHAR2,
29 p_validation_level IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,
34 p_receive_tbl IN OUT NOCOPY csd_receive_util.rcv_tbl_type
35 );
36
37 /*-----------------------------------------------------------------------------------------------------------*/
38 /* procedure name: POPULATE_INTF_TBLS */
39 /* description : Inserts records into open interface tables for receiving. */
40 /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api */
41 /* Input Parm : p_api_version NUMBER Required Api Version number */
42 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
43 /* default value is fnd_api.g_false */
44 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
45 /* fnd_api.g_false */
46 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
47 /* validation steps must be done and which steps */
48 /* should be skipped. */
49 /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
50 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
51 /* fnd_api.g_ret_sts_success (success) */
52 /* fnd_api.g_ret_sts_error (error) */
53 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
54 /* x_msg_count NUMBER Number of messages in the message stack */
55 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
56 /* x_request_group_id NUMBER Required */
57 /*-----------------------------------------------------------------------------------------------------------*/
58 PROCEDURE populate_rcv_intf_tbls (
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2,
61 p_validation_level IN NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_receive_tbl IN csd_receive_util.rcv_tbl_type,
66 x_request_group_id OUT NOCOPY NUMBER
67 );
68
69
70 /*-----------------------------------------------------------------------------------------------------------*/
71 /* procedure name: RCV_REQ_ONLINE */
72 /* description : This API will submit the request for receiving in the online mode. */
73 /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api*/
74 /* Input Parm : p_api_version NUMBER Required Api Version number */
75 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
76 /* default value is fnd_api.g_false */
77 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
78 /* fnd_api.g_false */
79 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
80 /* validation steps must be done and which steps */
81 /* should be skipped. */
82 /* p_request_group_id NUMBER Required request group which is processed by the */
83 /* request */
84 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
85 /* fnd_api.g_ret_sts_success (success) */
86 /* fnd_api.g_ret_sts_error (error) */
87 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
88 /* x_msg_count NUMBER Number of messages in the message stack */
89 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
90 /*-----------------------------------------------------------------------------------------------------------*/
91 PROCEDURE rcv_req_online (
92 p_api_version IN NUMBER,
93 p_commit IN VARCHAR2,
94 p_init_msg_list IN VARCHAR2,
95 p_validation_level IN NUMBER,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_request_group_id IN NUMBER
100 );
101
102 /*-----------------------------------------------------------------------------------------------------------*/
103 /* procedure name: DELETE_INTF_TBLS */
104 /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/
105 /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */
106 /* Called from : receive_item api */
107 /* Input Parm : */
108 /* p_request_group_id NUMBER Required */
109 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
110 /* fnd_api.g_ret_sts_success (success) */
111 /* fnd_api.g_ret_sts_error (error) */
112 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
113 /*-----------------------------------------------------------------------------------------------------------*/
114 PROCEDURE delete_intf_tbls (
115 x_return_status OUT NOCOPY VARCHAR2,
116 p_request_group_id IN NUMBER
117 );
118
119
120 END csd_receive_pvt;