[Home] [Help]
PACKAGE: APPS.POS_CANCEL_ASN
Source
1 PACKAGE POS_CANCEL_ASN AUTHID CURRENT_USER AS
2 /* $Header: POSASNCS.pls 115.5 2004/05/07 18:49:46 abtrived ship $*/
3
4 PROCEDURE cancel_asn (
5 p_shipment_num IN VARCHAR2,
6 p_invoice_num IN VARCHAR2,
7 p_processing_status IN VARCHAR2,
8 p_vendor_id IN NUMBER,
9 p_vendor_site_id IN NUMBER,
10 p_result IN OUT NOCOPY NUMBER,
11 p_error_code IN OUT NOCOPY VARCHAR2);
12
13
14 FUNCTION get_processing_status (
15 p_shipment_num VARCHAR2,
16 p_vendor_id NUMBER,
17 p_vendor_site_id NUMBER )
18 return VARCHAR2;
19
20
21 FUNCTION get_cancellation_status (
22 p_shipment_num VARCHAR2,
23 p_vendor_id NUMBER,
24 p_vendor_site_id NUMBER )
25 return VARCHAR2;
26
27 PROCEDURE find_processing_cancellation (
28 p_shipment_num IN VARCHAR2,
29 p_vendor_id IN NUMBER,
30 p_vendor_site_id IN NUMBER,
31 x_processing_status OUT NOCOPY VARCHAR2,
32 x_processing_dsp OUT NOCOPY VARCHAR2,
33 x_cancellation_status OUT NOCOPY VARCHAR2,
34 x_cancellation_dsp OUT NOCOPY VARCHAR2);
35
36
37 PROCEDURE find_processing_cancellation (
38 p_shipment_num IN VARCHAR2,
39 p_header_id IN NUMBER,
40 p_vendor_id IN NUMBER,
41 p_vendor_site_id IN NUMBER,
42 x_processing_status OUT NOCOPY VARCHAR2,
43 x_processing_dsp OUT NOCOPY VARCHAR2,
44 x_cancellation_status OUT NOCOPY VARCHAR2,
45 x_cancellation_dsp OUT NOCOPY VARCHAR2);
46
47 FUNCTION get_line_status (
48 p_shipment_line_id NUMBER)
49 RETURN VARCHAR2;
50
51 END POS_CANCEL_ASN;
52