1 PACKAGE PO_VENDOR_SITES_SV AUTHID CURRENT_USER AS
2 /* $Header: POXVDVSS.pls 120.3 2010/04/21 10:55:41 vssrivat ship $*/
3
4
5 FUNCTION get_vendor_site_id -- <GA FPI>
6 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
7 ) RETURN PO_HEADERS_ALL.vendor_site_id%TYPE;
8
9
10
11 /*===========================================================================
12 FUNCTION NAME: val_vendor_site_id()
13
14 DESCRIPTION: This function checks whether a given Supplier Site
15 is still active. For Purchase Orders, it also
16 confirms that the Site is not specified as
17 "RFQ Only."
18
19
20 PARAMETERS: X_document_type IN VARCHAR2,
21 X_vendor_site_id IN NUMBER
22
23 RETURN TYPE: BOOLEAN
24
25 DESIGN REFERENCES:
26
27 ALGORITHM:
28
29 NOTES:
30
31 OPEN ISSUES:
32
33 CLOSED ISSUES:
34
35 CHANGE HISTORY: Created 09-JUL-1995 LBROADBE
36 Changed to 14-AUG-1995 LBROADBE
37 Function
38 ===========================================================================*/
39 FUNCTION val_vendor_site_id
40 (
41 p_document_type IN VARCHAR2,
42 p_vendor_site_id IN NUMBER,
43 p_org_id IN NUMBER DEFAULT NULL --< Shared Proc FPJ >
44 )
45 return BOOLEAN;
46
47 /*===========================================================================
48 PROCEDURE NAME: get_def_vendor_site()
49
50 DESCRIPTION: If for a given vendor there is only one site,
51 bring that vendor site as the default vendor site.
52
53 PARAMETERS:
54
55 DESIGN REFERENCES: ../POXPOMPO.doc
56
57 ALGORITHM:
58
59 NOTES:
60
61 OPEN ISSUES:
62
63 CLOSED ISSUES:
64
65 CHANGE HISTORY: Sudha Iyer 04/95 Created
66 Melissa Snyder 11/14/95 Added X_document_type
67 parameter.
68 ===========================================================================*/
69
70
71 PROCEDURE get_def_vendor_site(X_vendor_id IN number,
72 X_vendor_site_id OUT NOCOPY number,
73 X_vendor_site_code OUT NOCOPY varchar2,
74 X_document_type IN varchar2);
75
76 /*===========================================================================
77 PROCEDURE NAME: get_vendor_site_info()
78
79 DESCRIPTION: For a given vendor site,this procedure gets the other
80 attributes of that vendor site.
81
82 PARAMETERS:
83
84 DESIGN REFERENCES: ../POXPOMPO.doc
85 ../POXSCERQ.dd
86
87 ALGORITHM:
88
89 NOTES:
90
91 OPEN ISSUES:
92
93 CLOSED ISSUES:
94
95 CHANGE HISTORY:
96 ===========================================================================*/
97
98 PROCEDURE get_vendor_site_info(X_vendor_site_id IN number,
99 X_vs_ship_to_location_id IN OUT NOCOPY number,
100 X_vs_bill_to_location_id IN OUT NOCOPY number,
101 X_vs_ship_via_lookup_code IN OUT NOCOPY varchar2,
102 X_vs_fob_lookup_code IN OUT NOCOPY varchar2,
103 X_vs_pay_on_code IN OUT NOCOPY varchar2,
104 X_vs_freight_terms_lookup_code IN OUT NOCOPY varchar2,
105 X_vs_terms_id IN OUT NOCOPY number,
106 X_vs_invoice_currency_code IN OUT NOCOPY varchar2,
107 x_vs_shipping_control IN OUT NOCOPY VARCHAR2 -- <INBOUND LOGISTICS FPJ>
108 );
109
110 /*===========================================================================
111 PROCEDURE NAME: val_vendor_site()
112
113 DESCRIPTION:
114 o DEF - If there is only one purchasing site for this vendor, default the vendor site.
115 only those vendor sites are valid for input that are purchasing
116 sites and are not rfq only sites.
117 PARAMETERS:
118
119 DESIGN REFERENCES: ../POXPOMPO.doc
120
121 ALGORITHM:
122
123 NOTES:
124
125 OPEN ISSUES:
126
127 CLOSED ISSUES:
128
129 CHANGE HISTORY:
130 ===========================================================================*/
131 PROCEDURE val_vendor_site (X_vendor_id IN number,
132 X_vendor_site_id IN number,
133 X_org_id IN number,
134 X_set_of_books_id IN number,
135 X_res_ship_to_loc_id IN OUT NOCOPY number,
136 X_ship_to_loc_dsp IN OUT NOCOPY varchar2,
137 X_ship_org_code IN OUT NOCOPY varchar2,
138 X_ship_org_name IN OUT NOCOPY varchar2,
139 X_ship_org_id IN OUT NOCOPY number,
140 X_res_bill_to_loc_id IN OUT NOCOPY number ,
141 X_bill_to_loc_dsp IN OUT NOCOPY varchar2,
142 X_res_fob IN OUT NOCOPY varchar2,
143 X_res_pay_on_code IN OUT NOCOPY varchar2,
144 X_res_ship_via IN OUT NOCOPY varchar2 ,
145 X_res_freight_terms IN OUT NOCOPY varchar2 ,
146 X_res_terms_id IN OUT NOCOPY number,
147 X_res_invoice_currency_code IN OUT NOCOPY varchar2,
148 X_fob_dsp IN OUT NOCOPY varchar2,
149 X_pay_on_dsp IN OUT NOCOPY varchar2,
150 X_ship_via_dsp IN OUT NOCOPY varchar2,
151 X_freight_terms_dsp IN OUT NOCOPY varchar2,
152 X_terms_dsp IN OUT NOCOPY varchar2 ,
153 X_vendor_contact_id IN OUT NOCOPY number,
154 X_vendor_contact_name IN OUT NOCOPY varchar2,
155 x_res_shipping_control IN OUT NOCOPY VARCHAR2 -- <INBOUND LOGISTICS FPJ>
156 ) ;
157
158
159
160 /*===========================================================================
161 PROCEDURE NAME : get_vendor_site_name()
162
163 DESCRIPTION :
164
165 PARAMETERS:
166
167 RETURN VALUE:
168
169 DESIGN REFERENCES: ../POXPOREL.doc
170
171 ALGORITHM:
172
173 NOTES:
174
175 OPEN ISSUES:
176
177 CLOSED ISSUES:
178
179 CHANGE HISTORY:
180
181 ========================================================================*/
182
183 PROCEDURE get_vendor_site_name
184 (X_vendor_site_id IN NUMBER,
185 X_vendor_site_name IN OUT NOCOPY VARCHAR2);
186
187
188 /*===========================================================================
189 PROCEDURE NAME: derive_vendor_site_info()
190
191 DESCRIPTION: Accepts as input a vendor site record and using the components
192 that have values, derives the values for components that do not have
193 any values (are null)
194
195 PARAMETERS: p_vendor_site_record IN OUT NOCOPY RCV_SHIPMENT_HEADER_SV.VendorSiteRecType
196
197 DESIGN REFERENCES:
198
199 ALGORITHM:
200
201 NOTES: dbms_sql is used to generate the WHERE clause based on components that
202 have values
203
204 OPEN ISSUES:
205
206 CLOSED ISSUES:
207
208 CHANGE HISTORY: 10/24 Raj Bhakta
209 ===========================================================================*/
210
211 PROCEDURE derive_vendor_site_info(
212 p_vendor_site_record IN OUT NOCOPY RCV_SHIPMENT_HEADER_SV.VendorSiteRecType);
213
214
215 /*===========================================================================
216 PROCEDURE NAME: validate_vendor_site_info()
217
218 DESCRIPTION: Accepts as input a vendor site record, validates the
219 components that have values and also some other business rules.
220
221 PARAMETERS: p_vendor_site_record IN OUT NOCOPY RCV_SHIPMENT_HEADER_SV.VendorSiteRecType
222
223 DESIGN REFERENCES:
224
225 ALGORITHM:
226
227 NOTES: dbms_sql is used to generate the WHERE clause based on components that
228 have values
229
230 OPEN ISSUES:
231
232 CLOSED ISSUES:
233
234 CHANGE HISTORY: 10/24 Raj Bhakta
235 ===========================================================================*/
236
237 PROCEDURE validate_vendor_site_info(
238 p_vendor_site_record IN OUT NOCOPY RCV_SHIPMENT_HEADER_SV.VendorSiteRecType,
239 p_remit_to_site_id NUMBER DEFAULT NULL); -- Bug# 3532503
240
241 /* RETROACTIVE FPI START */
242 /*******************************************************************
243 PROCEDURE NAME: Get_Transmission_Defaults
244
245 DESCRIPTION : This procedure get the default transmission method that
246 User has set up in the Supplier Site window.
247
248 Referenced by :
249 parameters : p_document_id - Document header_id
250 p_document_type - Document Type (PO/RELEASE etc)
251 p_preparer_id - Preparer_id of the document.
252 x_default_method - Default supplier communication method
253 set up in the vendor sites.
254 x_email_address - Email address where the email should be
255 sent.
256 x_fax_number - Fax number where the fax should be sent.
257 x_document_num - Document Number.
258 p_retrieve_only_flag - By default, this procedure updates the
259 xml_flag in the database based on whether the vendor site
260 is set up for XML. If this parameter is 'Y', we will not
261 update the database. This is necessary to avoid locking
262 issues from HTML. (Bug 5407459)
263
264 CHANGE History: Created 30-Sep-2002 pparthas
265 *******************************************************************/
266
267 Procedure Get_Transmission_Defaults(p_document_id IN NUMBER,
268 p_document_type IN VARCHAR2,
269 p_document_subtype IN VARCHAR2,
270 p_preparer_id IN OUT NOCOPY NUMBER,
271 x_default_method OUT NOCOPY VARCHAR2,
272 x_email_address OUT NOCOPY VARCHAR2,
273 x_fax_number OUT NOCOPY VARCHAR2,
274 x_document_num OUT NOCOPY VARCHAR2,
275 p_retrieve_only_flag IN VARCHAR2 DEFAULT NULL);
276
280 p_document_type IN VARCHAR2,
277 -- Bug 5407459 Added this procedure.
278 procedure get_transmission_defaults_edi (
279 p_document_id IN NUMBER,
281 p_document_subtype IN VARCHAR2,
282 p_preparer_id IN OUT NOCOPY NUMBER,
283 x_default_method OUT NOCOPY VARCHAR2,
284 x_email_address OUT NOCOPY VARCHAR2,
285 x_fax_number OUT NOCOPY VARCHAR2,
286 x_document_num OUT NOCOPY VARCHAR2,
287 p_retrieve_only_flag IN VARCHAR2 DEFAULT NULL);
288
289 --<Shared Proc FPJ>
290 FUNCTION get_org_id_from_vendor_site(p_vendor_site_id IN NUMBER)
291 RETURN PO_HEADERS_ALL.org_id%TYPE;
292
293 --FOR CLM PROJECT
294
295 PROCEDURE get_vendor_id
296 ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,
297 x_vendor_id OUT NOCOPY PO_HEADERS_ALL.vendor_id%TYPE
298 );
299
300 PROCEDURE get_vendor_site_id
301 ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,
302 x_vendor_site_id OUT NOCOPY PO_HEADERS_ALL.vendor_site_id%TYPE
303 );
304
305 --FOR CLM PROJECT
306
307
308 END PO_VENDOR_SITES_SV;
309 /* RETROACTIVE FPI END */