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