1 PACKAGE POS_VENDOR_UTIL_PKG as
2 -- $Header: POSVENDS.pls 120.4 2005/10/13 12:25:10 bitang noship $
3
4 -- This procedure will merge the related parties for
5 -- given vendor_id 's
6 PROCEDURE merge_vendor_parties
7 ( p_vendor_id IN NUMBER, -- new VENDOR_ID
8 p_dup_vendor_id IN NUMBER -- old / disabled VENDOR_ID
9 --,p_vendor_site_id IN NUMBER, -- new VENDOR_SITE_ID
10 --p_dup_vendor_site_id IN NUMBER -- old / disabled VENDOR_SITE_ID
11 );
12
13 PROCEDURE merge_registration_details
14 (p_vendor_id IN NUMBER, -- new VENDOR_ID
15 p_dup_vendor_id IN NUMBER -- old / disabled VENDOR_ID
16 );
17
18 FUNCTION get_party_id_for_vendor(p_vendor_id IN NUMBER) RETURN NUMBER;
19
20 FUNCTION get_po_vendor_id_for_user(p_username IN VARCHAR2) RETURN NUMBER;
21
22 FUNCTION get_vendor_party_id_for_user(p_username IN VARCHAR2) RETURN NUMBER;
23
24 -- validate_user_setup
25 -- Purpose: to make sure the user has the correct vendor, site and contact setup
26 -- for a single supplier hierarchy
27 -- Return Value: returns value 'Y' or 'N' indicating respectively whether user
28 -- set-up is valid or not
29 FUNCTION validate_user_setup (p_user_id in number) RETURN VARCHAR2;
30
31 -- Return Y if p_vendor_name already exists in po_vendors
32 -- Note: this api does case insensitive check
33 FUNCTION vendor_name_exist (p_vendor_name IN VARCHAR2) RETURN VARCHAR2;
34
35 -- Return legal entity id and name based on the liability account
36 -- (accts_pay_code_combination_id), and the operating unit id
37 -- of a vendor site; return null if error
38 PROCEDURE get_le_by_liability_acct
39 (p_accts_pay_ccid IN NUMBER,
40 p_operating_unit_id IN NUMBER,
41 x_le_id OUT nocopy NUMBER,
42 x_le_name OUT nocopy VARCHAR2
43 );
44
45 -- Return legal entity id based on the liability account
46 -- (accts_pay_code_combination_id), and the operating unit id
47 -- of a vendor site; return null if error
48 FUNCTION get_le_id_by_liability_acct
49 (p_accts_pay_ccid IN NUMBER,
50 p_operating_unit_id IN NUMBER
51 )
52 RETURN NUMBER;
53
54 -- Return legal entity id based on the liability account
55 -- (accts_pay_code_combination_id), and the operating unit id
56 -- of a vendor site; return null if error
57 FUNCTION get_le_name_by_liability_acct
58 (p_accts_pay_ccid IN NUMBER,
59 p_operating_unit_id IN NUMBER
60 )
61 RETURN VARCHAR2;
62
63 END POS_VENDOR_UTIL_PKG;