[Home] [Help]
PACKAGE: APPS.POS_ASN_XML
Source
1 Package POS_ASN_XML AUTHID CURRENT_USER AS
2 /* $Header: POSASNXS.pls 120.2 2012/01/02 11:12:50 kcthirum ship $*/
3
4 Procedure validate_shipment_num
5 (p_shipment_num IN VARCHAR,
6 p_vendor_id IN NUMBER,
7 p_vendor_site_id IN NUMBER,
8 p_ship_to_org_id IN NUMBER,
9 p_error_code OUT NOCOPY NUMBER,
10 p_error_message OUT NOCOPY VARCHAR);
11
12
13 Procedure validate_shipment_date
14 (p_shipment_date IN DATE,
15 p_error_code OUT NOCOPY NUMBER,
16 p_error_message OUT NOCOPY VARCHAR);
17
18
19 Procedure validate_receipt_date
20 (p_shipment_date IN DATE,
21 p_expected_receipt_date IN DATE,
22 p_error_code OUT NOCOPY NUMBER,
23 p_error_message OUT NOCOPY VARCHAR);
24
25
26 Procedure validate_quantity
27 (p_line_location_id IN NUMBER,
28 p_quantity IN NUMBER,
29 p_unit_of_measure IN VARCHAR,
30 p_error_code OUT NOCOPY NUMBER,
31 p_error_message OUT NOCOPY VARCHAR);
32
33
34 Procedure validate_freight_carrier_code
35 (p_freight_code IN VARCHAR,
36 p_error_code OUT NOCOPY NUMBER);
37
38
39 Procedure validate_freight_terms
40 (p_freight_terms IN VARCHAR,
41 p_error_code OUT NOCOPY NUMBER);
42
43
44 Procedure use_preProcessor
45 (p_group_id IN NUMBER,
46 p_org_id IN NUMBER,
47 p_error_message OUT NOCOPY VARCHAR,
48 p_error_code OUT NOCOPY NUMBER,
49 p_po_num OUT NOCOPY VARCHAR,
50 p_line_num OUT NOCOPY NUMBER,
51 p_po_shipment_line_num OUT NOCOPY NUMBER);
52
53
54 Procedure derive_location_id
55 (p_ship_to_partner_id IN VARCHAR,
56 p_org_id IN NUMBER,
57 p_address1 IN VARCHAR,
58 p_address2 IN VARCHAR,
59 p_city IN VARCHAR,
60 p_postal_code IN VARCHAR,
61 p_country IN VARCHAR,
62 p_po_line_location_id IN NUMBER,
63 p_ship_to_location_id OUT NOCOPY NUMBER,
64 p_auto_transact_code OUT NOCOPY VARCHAR,
65 p_transaction_type OUT NOCOPY VARCHAR,
66 p_error_code OUT NOCOPY NUMBER,
67 p_error_message OUT NOCOPY VARCHAR);
68
69
70 Procedure derive_org_id
71 (p_document_line_num IN NUMBER,
72 p_document_shipment_line_num IN NUMBER,
73 p_release_num IN NUMBER,
74 p_po_number IN VARCHAR,
75 p_supplier_code IN VARCHAR,
76 p_item_num IN VARCHAR,
77 p_supplier_item_num IN VARCHAR,
78 p_org_id OUT NOCOPY NUMBER,
79 p_ship_to_org_id OUT NOCOPY NUMBER,
80 p_po_header_id OUT NOCOPY NUMBER,
81 p_error_code OUT NOCOPY NUMBER,
82 p_error_message OUT NOCOPY VARCHAR);
83
84
85 Procedure derive_vendor_id
86 (p_org_id IN NUMBER,
87 p_supplier_code IN VARCHAR,
88 p_vendor_id OUT NOCOPY NUMBER,
89 p_vendor_site_id OUT NOCOPY NUMBER,
90 p_error_code OUT NOCOPY NUMBER,
91 p_error_message OUT NOCOPY VARCHAR);
92
93
94 Procedure store_line_vendor_error
95 (p_error_code IN NUMBER,
96 p_error_message IN VARCHAR,
97 line_vendor_error_code OUT NOCOPY NUMBER,
98 line_vendor_error_message OUT NOCOPY VARCHAR);
99
100
101 Procedure store_line_org_error
102 (p_error_code IN NUMBER,
103 p_error_message IN VARCHAR,
104 line_org_error_code OUT NOCOPY NUMBER,
105 line_org_error_message OUT NOCOPY VARCHAR);
106
107
108 Procedure store_line_location_error
109 (p_error_code IN NUMBER,
110 p_error_message IN VARCHAR,
111 line_location_error_code OUT NOCOPY NUMBER,
112 line_location_error_message OUT NOCOPY VARCHAR);
113
114
115 Procedure get_user_id
116 (p_user_name IN VARCHAR,
117 p_user_id OUT NOCOPY NUMBER,
118 p_error_code OUT NOCOPY NUMBER,
119 p_error_message OUT NOCOPY VARCHAR);
120
121 Procedure pre_validate
122 (p_header_interface_id IN NUMBER,
123 p_ship_to_org_id OUT NOCOPY NUMBER,
124 p_vendor_id OUT NOCOPY NUMBER,
125 p_vendor_site_id OUT NOCOPY NUMBER,
126 p_error_code OUT NOCOPY NUMBER,
127 p_error_message OUT NOCOPY VARCHAR);
128
129
130 Procedure derive_line_cols
131 (p_po_header_id IN NUMBER,
132 p_line_num IN NUMBER,
133 p_document_shipment_line_num IN NUMBER,
134 p_release_num IN NUMBER,
135 p_item_id OUT NOCOPY NUMBER,
136 p_item_num OUT NOCOPY VARCHAR,
137 p_item_revision OUT NOCOPY VARCHAR,
138 p_supplier_item_num OUT NOCOPY VARCHAR,
139 --p_ship_to_location_id IN OUT NOCOPY NUMBER,
140 p_ship_to_location_id OUT NOCOPY NUMBER,
141 p_po_line_id OUT NOCOPY NUMBER,
142 p_line_location_id OUT NOCOPY NUMBER,
143 p_ship_to_org_id OUT NOCOPY NUMBER,
144 p_po_release_id OUT NOCOPY NUMBER,
145 p_error_code OUT NOCOPY NUMBER,
146 p_error_message OUT NOCOPY VARCHAR);
147
148
149 Procedure populate_doc_id
150 (p_header_interface_id IN NUMBER,
151 p_location_id IN NUMBER,
152 p_bill_of_lading IN VARCHAR,
153 p_packing_slip IN VARCHAR,
154 p_waybill_airbill_num IN VARCHAR);
155
156 Procedure derive_unit_of_measure
157 (p_uom_code IN VARCHAR,
158 p_unit_of_measure OUT NOCOPY VARCHAR,
159 p_error_code OUT NOCOPY NUMBER,
160 p_error_message OUT NOCOPY VARCHAR);
161
162 Procedure derive_interface_id_for_wms
163 (header_intf_id IN number,
164 item IN VARCHAR,
165 item_rev IN VARCHAR2,
166 doc_num in varchar2,
167 doc_rev_num in number,
168 doc_line_num in number,
169 doc_shipment_line_num in number,
170 doc_release_num in number,
171 wms_interface_transaction_id OUT NOCOPY number,
172 p_error_code OUT NOCOPY NUMBER,
173 p_error_message OUT NOCOPY VARCHAR);
174
175 END POS_ASN_XML;
176