[Home] [Help]
PACKAGE: APPS.POS_ASN_XML
Source
1 Package POS_ASN_XML AUTHID CURRENT_USER AS
2 /* $Header: POSASNXS.pls 115.9 2002/11/26 02:13:52 mji 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_ship_to_location_id OUT NOCOPY NUMBER,
63 p_auto_transact_code OUT NOCOPY VARCHAR,
64 p_transaction_type OUT NOCOPY VARCHAR,
65 p_error_code OUT NOCOPY NUMBER,
66 p_error_message OUT NOCOPY VARCHAR);
67
68
69 Procedure derive_org_id
70 (p_document_line_num IN NUMBER,
71 p_document_shipment_line_num IN NUMBER,
72 p_release_num IN NUMBER,
73 p_po_number IN VARCHAR,
74 p_supplier_code IN VARCHAR,
75 p_item_num IN VARCHAR,
76 p_supplier_item_num IN VARCHAR,
77 p_org_id OUT NOCOPY NUMBER,
78 p_ship_to_org_id OUT NOCOPY NUMBER,
79 p_po_header_id OUT NOCOPY NUMBER,
80 p_error_code OUT NOCOPY NUMBER,
81 p_error_message OUT NOCOPY VARCHAR);
82
83
84 Procedure derive_vendor_id
85 (p_org_id IN NUMBER,
86 p_supplier_code IN VARCHAR,
87 p_vendor_id OUT NOCOPY NUMBER,
88 p_vendor_site_id OUT NOCOPY NUMBER,
89 p_error_code OUT NOCOPY NUMBER,
90 p_error_message OUT NOCOPY VARCHAR);
91
92
93 Procedure store_line_vendor_error
94 (p_error_code IN NUMBER,
95 p_error_message IN VARCHAR,
96 line_vendor_error_code OUT NOCOPY NUMBER,
97 line_vendor_error_message OUT NOCOPY VARCHAR);
98
99
100 Procedure store_line_org_error
101 (p_error_code IN NUMBER,
102 p_error_message IN VARCHAR,
103 line_org_error_code OUT NOCOPY NUMBER,
104 line_org_error_message OUT NOCOPY VARCHAR);
105
106
107 Procedure store_line_location_error
108 (p_error_code IN NUMBER,
109 p_error_message IN VARCHAR,
110 line_location_error_code OUT NOCOPY NUMBER,
111 line_location_error_message OUT NOCOPY VARCHAR);
112
113
114 Procedure get_user_id
115 (p_user_name IN VARCHAR,
116 p_user_id OUT NOCOPY NUMBER,
117 p_error_code OUT NOCOPY NUMBER,
118 p_error_message OUT NOCOPY VARCHAR);
119
120 Procedure pre_validate
121 (p_header_interface_id IN NUMBER,
122 p_ship_to_org_id OUT NOCOPY NUMBER,
123 p_vendor_id OUT NOCOPY NUMBER,
124 p_vendor_site_id OUT NOCOPY NUMBER,
125 p_error_code OUT NOCOPY NUMBER,
126 p_error_message OUT NOCOPY VARCHAR);
127
128
129 Procedure derive_line_cols
130 (p_po_header_id IN NUMBER,
131 p_line_num IN NUMBER,
132 p_document_shipment_line_num IN NUMBER,
133 p_release_num IN NUMBER,
134 p_item_id OUT NOCOPY NUMBER,
135 p_item_num OUT NOCOPY VARCHAR,
136 p_item_revision OUT NOCOPY VARCHAR,
137 p_supplier_item_num OUT NOCOPY VARCHAR,
138 p_ship_to_location_id IN OUT NOCOPY NUMBER,
139 p_po_line_id OUT NOCOPY NUMBER,
140 p_line_location_id OUT NOCOPY NUMBER,
141 p_ship_to_org_id OUT NOCOPY NUMBER,
142 p_po_release_id OUT NOCOPY NUMBER,
143 p_error_code OUT NOCOPY NUMBER,
144 p_error_message OUT NOCOPY VARCHAR);
145
146
147 Procedure populate_doc_id
148 (p_header_interface_id IN NUMBER,
149 p_location_id IN NUMBER,
150 p_bill_of_lading IN VARCHAR,
151 p_packing_slip IN VARCHAR,
152 p_waybill_airbill_num IN VARCHAR);
153
154 Procedure derive_unit_of_measure
155 (p_uom_code IN VARCHAR,
156 p_unit_of_measure OUT NOCOPY VARCHAR,
157 p_error_code OUT NOCOPY NUMBER,
158 p_error_message OUT NOCOPY VARCHAR);
159
160
161 END POS_ASN_XML;
162