DBA Data[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