PACKAGE: APPS.POS_VENDOR_REG_PKG

Source

1 PACKAGE POS_VENDOR_REG_PKG AUTHID CURRENT_USER AS
2 /* $Header: POSVREGS.pls 120.5 2011/09/30 23:16:37 atjen ship $ */
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 -- Begin Supplier Management: Bug 12849540
72 PROCEDURE validate_required_user_attrs
73 (   p_supp_reg_id   IN NUMBER,
74     p_buyer_user    IN VARCHAR2,
75     x_attr_req_tbl  OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
76     x_return_status OUT NOCOPY VARCHAR2,
77     x_msg_count     OUT NOCOPY NUMBER,
78     x_msg_data      OUT NOCOPY VARCHAR2
79 
80 );
81 -- End Supplier Management: Bug 12849540
82 
83 END POS_VENDOR_REG_PKG;