PACKAGE: APPS.XNB_SALES_ORDER_PVT

Source

1 PACKAGE XNB_SALES_ORDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: XNBVPSOS.pls 120.2 2005/09/20 01:52:36 ksrikant noship $ */
3 
4 
5    PROCEDURE check_noninvoiceable_item(	itemtype  IN VARCHAR2,
6 		 			itemkey   IN VARCHAR2,
7 		 			actid 	  IN NUMBER,
8 		 			funcmode  IN VARCHAR2,
9 					resultout OUT NOCOPY VARCHAR2);
10 
11     PROCEDURE publish_bill_to_address(	itemtype  IN VARCHAR2,
12 		 			itemkey   IN VARCHAR2,
13 		 			actid 	  IN NUMBER,
14 		 			funcmode  IN VARCHAR2,
15 					resultout OUT NOCOPY VARCHAR2);
16 
17     PROCEDURE get_bill_to_address
18     (
19     l_inv_to_org_id 	IN 	NUMBER ,
20     l_party_id		OUT	NOCOPY NUMBER,
21     l_account_id	OUT	NOCOPY NUMBER,
22     l_party_number	OUT	NOCOPY VARCHAR2,
23     l_party_name	OUT	NOCOPY VARCHAR2,
24     l_account_number	OUT	NOCOPY VARCHAR2,
25     l_account_name	OUT	NOCOPY VARCHAR2,
26     l_bill_to_address	OUT	NOCOPY VARCHAR2,
27     l_country		OUT	NOCOPY VARCHAR2,
28     l_state		OUT	NOCOPY VARCHAR2,
29     l_county		OUT	NOCOPY VARCHAR2,
30     l_city		OUT	NOCOPY VARCHAR2,
31     l_postal_code	OUT	NOCOPY VARCHAR2,
32     x_result 		OUT	NOCOPY NUMBER
33     );
34 
35         PROCEDURE create_sales_order
36     (
37 	l_doc_id			IN 	NUMBER,
38         l_party_id			IN	NUMBER,
39         l_account_id			IN	NUMBER,
40 	l_party_number			IN	VARCHAR2,
41     	l_party_name			IN 	VARCHAR2,
42 	l_account_number		IN	VARCHAR2,
43 	l_account_name			IN 	VARCHAR2,
44     	l_bill_to_address		IN 	VARCHAR2,
45     	l_country			IN 	VARCHAR2,
46     	l_state				IN 	VARCHAR2,
47     	l_county	 		IN 	VARCHAR2,
48     	l_city		 		IN 	VARCHAR2,
49     	l_postal_code			IN 	VARCHAR2,
50     	l_primary_bill_to_flag		IN 	CHAR,
51     	l_bill_to_owner_flag		IN 	CHAR,
52     	x_result			OUT	NOCOPY NUMBER
53     );
54 
55     PROCEDURE truncate_sales_order
56     (
57 	    itemtype			IN VARCHAR2,
58 	    itemkey				IN VARCHAR2,
59 	    actid				IN NUMBER,
60 	    funcmode			IN VARCHAR2,
61 	    resultout			OUT NOCOPY VARCHAR2
62     );
63 
64     PROCEDURE check_account
65     (
66 	    itemtype			IN VARCHAR2,
67 	    itemkey				IN VARCHAR2,
68 	    actid				IN NUMBER,
69 	    funcmode			IN VARCHAR2,
70 	    resultout			OUT NOCOPY VARCHAR2
71     );
72 
73     PROCEDURE return_install_at_addr
74     (
75         p_instance_id     in number,
76         p_address_line    out nocopy varchar2,
77         p_city            out nocopy varchar2,
78         p_country         out nocopy varchar2,
79         p_county          out nocopy varchar2,
80         p_postal_code     out nocopy varchar2,
81         p_state           out nocopy varchar2
82     );
83 
84     PROCEDURE return_ship_to_address
85     (
86         p_ship_to_org_id     in number,
87         p_address_line    out nocopy varchar2,
88         p_city            out nocopy varchar2,
89         p_country         out nocopy varchar2,
90         p_county          out nocopy varchar2,
91         p_postal_code     out nocopy varchar2,
92         p_state           out nocopy varchar2
93     );
94 
95     PROCEDURE publish_line_bill_to_address(	itemtype  IN VARCHAR2,
96 		 				itemkey   IN VARCHAR2,
97 		 				actid 	  IN NUMBER,
98 		 				funcmode  IN VARCHAR2,
99 						resultout OUT NOCOPY VARCHAR2);
100 
101 PROCEDURE truncate_all_lines
102     (
103 	    itemtype			IN VARCHAR2,
104 	    itemkey			IN VARCHAR2,
105 	    actid			IN NUMBER,
106 	    funcmode			IN VARCHAR2,
107 	    resultout			OUT NOCOPY VARCHAR2
108     );
109 
110 END xnb_sales_order_pvt;