1 PACKAGE WSH_PO_INTEGRATION_GRP AS
2 /* $Header: WSHPOGPS.pls 120.1 2005/07/12 04:58:47 amony noship $ */
3
4 -- { IB-Phase-2
5 TYPE validateSF_in_rec_type
6 IS
7 RECORD
8 ( po_line_id_tbl wsh_util_core.id_tab_type,
9 po_shipment_line_id_tbl wsh_util_core.id_tab_type,
10 ship_from_location_id NUMBER
11 );
12
13 TYPE validateSF_out_rec_type
14 IS
15 RECORD
16 (
17 is_valid BOOLEAN
18 );
19 -- } IB-Phase-2
20
21 --=============================================================================
22 -- API name : check_purge
23 -- Type : Private.
24 -- Function :
25 -- Pre-reqs : None.
26 -- Parameters :
27 -- p_api_version_number IN NUMBER
28 -- p_init_msg_list IN VARCHAR2
29 -- p_commit IN VARCHAR2
30 -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype
31 -- x_out_rec OUT WSH_PO_INTG_TYPES_GRP.purge_out_rectype
32 -- x_return_status OUT VARCHAR2
33 -- x_msg_count OUT NUMBER
34 -- x_msg_data OUT VARCHAR2
35 --==============================================================================
36 PROCEDURE check_purge(
37 p_api_version_number IN NUMBER,
38 p_init_msg_list IN VARCHAR2,
39 p_commit IN VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype,
44 x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.purge_out_rectype);
45
46
47 --=============================================================================
48 -- API name : purge
49 -- Type : Private.
50 -- Function :
51 -- Pre-reqs : None.
52 -- Parameters :
53 -- p_api_version_number IN NUMBER
54 -- p_init_msg_list IN VARCHAR2
55 -- p_commit IN VARCHAR2
56 -- x_return_status OUT VARCHAR2
57 -- x_msg_count OUT NUMBER
58 -- x_msg_data OUT VARCHAR2
59 -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype
60 --=============================================================================
61 PROCEDURE purge(
62 p_api_version_number IN NUMBER,
63 p_init_msg_list IN VARCHAR2,
64 p_commit IN VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype
69 );
70
71
72 --=============================================================================
73 -- API name : vendor_merge
74 -- Type : Private.
75 -- Function :
76 -- Pre-reqs : None.
77 -- Parameters :
78 -- p_api_version_number IN NUMBER
79 -- p_init_msg_list IN VARCHAR2
80 -- p_commit IN VARCHAR2
81 -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.merge_in_rectype
82 -- x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.merge_out_rectype
83 -- x_return_status OUT NOCOPY VARCHAR2
84 -- x_msg_count OUT NOCOPY NUMBER
85 -- x_msg_data OUT NOCOPY VARCHAR2
86 --
87 --=============================================================================
88
89 PROCEDURE vendor_merge(
90 P_api_version_number IN NUMBER,
91 P_init_msg_list IN VARCHAR2,
92 P_commit IN VARCHAR2,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 P_in_rec IN WSH_PO_INTG_TYPES_GRP.merge_in_rectype,
97 x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.merge_out_rectype);
98
99
100
101 --=============================================================================
102 -- API name : HasDeliveryInfoChanged
103 -- Type : Private.
104 -- Function :
105 -- Pre-reqs : None.
106 -- Parameters :
107 -- p_api_version_number IN NUMBER
108 -- p_init_msg_list IN NUMBER
109 -- p_commit IN VARCHAR2
110 -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.delInfo_in_rectype
111 -- x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.delInfo_out_rectype
112 -- x_return_status OUT NOCOPY VARCHAR2
113 -- x_msg_count OUT NOCOPY NUMBER
114 -- x_msg_data OUT NOCOPY VARCHAR2
115 --=============================================================================
116
117 PROCEDURE HasDeliveryInfoChanged(
118 P_api_version_number IN NUMBER,
119 P_init_msg_list IN VARCHAR2,
120 P_commit IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 P_in_rec IN WSH_PO_INTG_TYPES_GRP.delInfo_in_rectype,
125 x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.delInfo_out_rectype);
126
127
128
129 -- { IB-Phase-2
130 --=============================================================================
131 -- API name : validateASNReceiptShipFrom
132 -- Type : public.
133 -- Function :
134 -- Pre-reqs : None.
135 -- Parameters :
136 -- p_api_version_number IN NUMBER
137 -- p_init_msg_list IN VARCHAR2
138 -- p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type
139 -- p_commit IN VARCHAR2
140 -- x_return_status OUT NOCOPY VARCHAR2
141 -- x_out_rec OUT WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type
142 -- x_msg_count OUT NOCOPY NUMBER
143 -- x_msg_data OUT NOCOPY VARCHAR2
144 -- Comment :This API will be called whenever a ASN is created with a
145 -- ShipFromLocation on the IssupplierPortal Page. This API
146 -- determines whether the ASN can be created for the given
147 -- ShipFromLocation based on the following points. It returns
148 -- TRUE or FALSE to indicate this
149 -- TRUE - ASN can be created.
150 -- FALSE - ASN cannot be created.
151 -- a) IS the ShipFromLocationId passed through input parameter
152 -- p_in_rec a valid WSH Location.
153 -- AND
154 -- b) There is a open Delivery Line (for the input PO line and PO
155 -- Shipment Line) with the ShipFromLocation
156 -- as the one specified as the input parameter or has a
157 -- value of -1 as its ShipFromLocation. Return TRUE.
158 -- c) IF (b) above is false (no Delivery lines satisfy (b) ), then
159 -- check if there are open Delivery Lines for the input PO line
160 -- and PO Shipment Line). If so return FALSE, other wise return
161 -- TRUE.
162 --=============================================================================
163 procedure validateASNReceiptShipFrom
164 (
165 p_api_version_number IN NUMBER,
166 p_init_msg_list IN VARCHAR2,
167 p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type,
168 p_commit IN VARCHAR2,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_out_rec OUT NOCOPY WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175
176 -- } IB-Phase-2
177
178 END WSH_PO_INTEGRATION_GRP;
179