PACKAGE: APPS.POS_VENDOR_REG_PKG

Source

1 PACKAGE POS_VENDOR_REG_PKG AS
2 /* $Header: POSVREGS.pls 120.4 2006/07/13 20:51:02 gdwivedi noship $ */
3 
4 PROCEDURE approve_supplier_reg
5   (p_supplier_reg_id IN  NUMBER,
6    x_return_status   OUT NOCOPY VARCHAR2,
7    x_msg_count       OUT NOCOPY NUMBER,
8    x_msg_data        OUT NOCOPY VARCHAR2
9    );
10 
11 PROCEDURE reject_supplier_reg
12   (p_supplier_reg_id IN  NUMBER,
13    x_return_status   OUT NOCOPY VARCHAR2,
14    x_msg_count       OUT NOCOPY NUMBER,
15    x_msg_data        OUT NOCOPY VARCHAR2
16    );
17 
18 PROCEDURE submit_supplier_reg
19   (p_supplier_reg_id IN  NUMBER,
20    x_return_status   OUT NOCOPY VARCHAR2,
21    x_msg_count       OUT NOCOPY NUMBER,
22    x_msg_data        OUT NOCOPY VARCHAR2
23    );
24 
25 PROCEDURE send_save_for_later_ntf
26   (p_supplier_reg_id IN  NUMBER,
27    p_email_address   IN  VARCHAR2,
28    x_return_status   OUT NOCOPY VARCHAR2,
29    x_msg_count       OUT NOCOPY NUMBER,
30    x_msg_data        OUT NOCOPY VARCHAR2
31    );
32 
33 FUNCTION is_ou_id_valid
34   (p_ou_id IN NUMBER
35    ) RETURN VARCHAR2;
36 
37 FUNCTION is_supplier_number_unique(
38   p_supp_regid IN NUMBER,
39   p_supp_number IN VARCHAR2
40 ) RETURN VARCHAR2;
41 
42 PROCEDURE is_taxpayer_id_unique(
43   p_supp_regid IN NUMBER,
44   p_taxpayer_id IN VARCHAR2,
45   p_country IN VARCHAR2,
46   x_is_unique OUT NOCOPY VARCHAR2,
47   x_vendor_id OUT NOCOPY NUMBER
48 );
49 
50 PROCEDURE is_duns_num_unique(
51   p_supp_regid IN NUMBER,
52   p_duns_num IN VARCHAR2,
53   x_is_unique OUT NOCOPY VARCHAR2,
54   x_vendor_id OUT NOCOPY NUMBER
55 );
56 
57 PROCEDURE is_taxregnum_unique(
58   p_supp_regid IN NUMBER
59 , p_taxreg_num IN VARCHAR2
60 , p_country IN VARCHAR2
61 , x_is_unique OUT NOCOPY VARCHAR2
62 , x_vendor_id OUT NOCOPY NUMBER
63 );
64 
65 PROCEDURE notify_banking_approver
66   (p_vendor_id IN  NUMBER,
67    x_return_status   OUT nocopy VARCHAR2,
68    x_msg_count       OUT nocopy NUMBER,
69    x_msg_data        OUT nocopy VARCHAR2);
70 
71 END POS_VENDOR_REG_PKG;