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