1 PACKAGE WSH_RCV_CORR_RTV_TXN_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHRCRVS.pls 115.4 2004/01/19 00:34:03 rvishnuv noship $ */
3
4 --===================
5 -- PUBLIC VARS
6 --===================
7
8 -- This record is used to process the matched records (for corrections
9 -- , rtvs, and rtv corrections) and update the
10 -- received and returned quantities on delivery details
11 -- accordingly.
12 -- record_changed_flag_tab tells us whether the respective delivery detail needs to be updated or
13 -- or not.
14 TYPE update_detail_rec_type is RECORD (
15 del_det_id_tab wsh_util_core.id_tab_type,
16 requested_qty_tab wsh_util_core.id_tab_type,
17 requested_qty2_tab wsh_util_core.id_tab_type,
18 shipped_qty_tab wsh_util_core.id_tab_type,
19 shipped_qty2_tab wsh_util_core.id_tab_type,
20 received_qty_tab wsh_util_core.id_tab_type,
21 received_qty2_tab wsh_util_core.id_tab_type,
22 returned_qty_tab wsh_util_core.id_tab_type,
23 returned_qty2_tab wsh_util_core.id_tab_type,
24 shipment_line_id_tab wsh_util_core.id_tab_type,
25 released_sts_tab wsh_util_core.column_tab_type,
26 record_changed_flag_tab wsh_util_core.column_tab_type,
27 wv_changed_flag_tab wsh_util_core.column_tab_type,
28 net_weight_tab wsh_util_core.id_tab_type,
29 gross_weight_tab wsh_util_core.id_tab_type,
30 volume_tab wsh_util_core.id_tab_type);
31
32 -- This record is used to handle the remaining requested quantity
33 -- on open delivery details.
34 -- please refer to the process_remaining_req_quantity procedure
35 -- description in the package body for more details
36 TYPE rem_req_qty_rec_type is RECORD(
37 requested_quantity NUMBER,
38 requested_quantity_uom VARCHAR2(3),
39 requested_quantity2 NUMBER,
40 requested_quantity2_uom VARCHAR2(3),
41 po_line_location_id NUMBER,
42 po_line_id NUMBER);
43
44 -- This record is used as a input record in
45 -- process_remaining_req_quantity
46 TYPE action_in_rec_type is RECORD(
47 action_code VARCHAR2(30));
48
49
50 -- This record is used as a out record in
51 -- process_corrections_and_rtv just for
52 -- accomadating any additional out parameters in future
53 TYPE corr_rtv_out_rec_type is RECORD(
54 dummy VARCHAR2(1));
55
56 --===================
57 -- PROCEDURES
58 --===================
59
60 --========================================================================
61 -- PROCEDURE : Process_Corrections_And_Rtv --
62 -- This procedure is called from
63 -- both Inbound Reconciliation UI and
64 -- Matching Algorithm to match the
65 -- Corrections and RTV transactions.
66 --
67 -- PARAMETERS: p_api_version Known api version error number
68 -- p_init_msg_list FND_API.G_TRUE to reset list
69 -- p_rtv_corr_in_rec global line rec type (not used)
70 -- p_matched_detail_rec record of matched delivery details
71 -- p_action_prms action parameters record type
72 -- p_rtv_corr_out_rec output record of the API (not used)
73 -- x_po_cancel_rec output record of cancelled po lines
74 -- x_po_close_rec output record of closed po lines
75 -- x_msg_data text of messages
76 -- x_msg_count number of messages in the list
77 -- x_return_status return status of the API
78
79 -- VERSION : current version 1.0
80 -- initial version 1.0
81 -- COMMENT : This procedure is used to match the child transactions (Receipt Corrections, RTV, and RTV corrections) of a Receipt.
82 --========================================================================
83 PROCEDURE process_corrections_and_rtv (
84 p_rtv_corr_in_rec IN OE_WSH_BULK_GRP.Line_rec_type,
85 p_matched_detail_rec IN OUT NOCOPY WSH_IB_UI_RECON_GRP.asn_rcv_del_det_rec_type,
86 p_action_prms IN WSH_BULK_TYPES_GRP.action_parameters_rectype,
87 p_rtv_corr_out_rec OUT NOCOPY corr_rtv_out_rec_type,
88 x_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
89 x_po_close_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2);
93
94 --========================================================================
95 -- PROCEDURE : Process_Remaining_Req_Quantity --
96 -- This procedure is called from
97 -- process_corrections_and_rtv
98 -- and from revert_details to handle
99 -- the remaining requested quantity
100 -- that needs to be adjusted on open
101 -- delivery details.
102 --
103 -- PARAMETERS: p_rem_req_qty_rec Record that stores the remaining
104 -- requested quantity after performing the
105 -- matching or after performing the revert.
106 -- p_in_rec Input record to pass the action code
107 -- (possible values are "MATCH" and
108 -- "REVERT_MATCH").
109 -- x_return_status Return status of the API
110
111 -- VERSION : current version 1.0
112 -- initial version 1.0
113 --========================================================================
114 PROCEDURE process_remaining_req_quantity (
115 p_rem_req_qty_rec IN rem_req_qty_rec_type,
116 p_in_rec IN action_in_rec_type,
117 x_return_status OUT NOCOPY VARCHAR2);
118
119 END WSH_RCV_CORR_RTV_TXN_PKG;