1 PACKAGE POS_DROP_SHIP_PVT AUTHID CURRENT_USER AS
2 /* $Header: POSVDROS.pls 115.3 2004/05/13 22:32:33 swijesek noship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POSVDROS.pls
7 |
8 | DESCRIPTION
9 | PL/SQL spec for package: POS_DROP_SHIP_PVT
10 |
11 *=====================================================================*/
12
13 -- Start of comments
14 -- API name : get_drop_ship_info
15 -- Type : private
16 -- Pre-reqs : none
17 -- Function :
18 -- Parameters :
19 -- IN : po_header_id in number required
20 -- po_line_id in mumber required
21 -- line_location_id in number required
22 -- po_release_id in number required
23 -- OUT :
24 -- Version : initial version
25 -- End of comments
26
27 procedure get_drop_ship_info ( p_po_header_id in number,
28 p_po_line_id in number,
29 p_line_location_id in number,
30 p_po_release_id in number,
31 x_customer_name out nocopy varchar2,
32 x_contact_name out nocopy varchar2,
33 x_customer_loc out nocopy varchar2,
34 x_contact_phone out nocopy varchar2,
35 x_contact_fax out nocopy varchar2,
36 x_contact_email out nocopy varchar2,
37 x_ship_method out nocopy varchar2,
38 x_ship_instruct out nocopy varchar2,
39 x_pack_instruct out nocopy varchar2,
40 x_cust_po_num out nocopy varchar2,
41 x_cust_line_num out nocopy varchar2,
42 x_cust_ship_num out nocopy varchar2,
43 x_product_desc out nocopy varchar2,
44 x_delto_customer_name out nocopy varchar2,
45 x_delto_contact_name out nocopy varchar2,
46 x_delto_contact_phone out nocopy varchar2,
47 x_delto_contact_fax out nocopy varchar2,
48 x_delto_contact_email out nocopy varchar2,
49 x_delto_address1 out nocopy varchar2,
50 x_delto_address2 out nocopy varchar2,
51 x_delto_city out nocopy varchar2,
52 x_delto_state out nocopy varchar2,
53 x_delto_zip out nocopy varchar2,
54 x_delto_country out nocopy varchar2,
55 x_return_status out nocopy varchar2,
56 x_msg_data out nocopy varchar2);
57
58
59 -- Start of comments
60 -- API name : get_drop_ship_xml_info
61 -- Type : private
62 -- Pre-reqs : none
63 -- Function :
64 -- Parameters :
65 -- IN : po_header_id in number required
66 -- po_line_id in mumber required
67 -- line_location_id in number required
68 -- po_release_id in number required
69 -- OUT :
70 -- Version : initial version
71 -- End of comments
72
73 procedure get_drop_ship_xml_info (p_po_header_id in number,
74 p_po_line_id in number,
75 p_line_location_id in number,
76 p_po_release_id in number,
77 x_customer_name out nocopy varchar2,
78 x_contact_name out nocopy varchar2,
79 x_contact_phone out nocopy varchar2,
80 x_contact_fax out nocopy varchar2,
81 x_contact_email out nocopy varchar2,
82 x_ship_method out nocopy varchar2,
83 x_ship_instruct out nocopy varchar2,
84 x_pack_instruct out nocopy varchar2,
85 x_cust_po_num out nocopy varchar2,
86 x_cust_line_num out nocopy varchar2,
87 x_cust_ship_num out nocopy varchar2,
88 x_product_desc out nocopy varchar2,
89 x_delto_customer_name out nocopy varchar2,
90 x_delto_customer_addr out nocopy varchar2,
91 x_delto_customer_loc out nocopy varchar2,
92 x_delto_contact_name out nocopy varchar2,
93 x_delto_contact_phone out nocopy varchar2,
94 x_delto_contact_fax out nocopy varchar2,
95 x_delto_contact_email out nocopy varchar2);
96
97 end POS_DROP_SHIP_PVT;