1 package icx_supp_custom AUTHID CURRENT_USER as
2 /* $Header: ICXSUPCS.pls 115.1 2001/10/15 13:51:22 pkm ship $ */
3
4
5 function validateSupplier(p_supplier in varchar2,
6 p_addr1 in varchar2,
7 p_addr2 in varchar2,
8 p_addr3 in varchar2,
9 p_city in varchar2,
10 p_province in varchar2,
11 p_county in varchar2,
12 p_state in varchar2,
13 p_zip in varchar2,
14 p_country in varchar2)
15 return number;
16
17 procedure setDomain(p_username in varchar2,
18 p_supplier_id in number,
19 p_email_address in varchar2,
20 p_new_username out varchar2);
21
22 function validateContact(p_supplier_id in number,
23 p_first_name in varchar2,
24 p_last_name in varchar2,
25 p_phone_number in varchar2,
26 p_mail_stop in varchar2,
27 p_addr1 in varchar2,
28 p_addr2 in varchar2,
29 p_addr3 in varchar2,
30 p_city in varchar2,
31 p_province in varchar2,
32 p_county in varchar2,
33 p_state in varchar2,
34 p_zip in varchar2,
35 p_country in varchar2)
36 return number;
37
38 procedure GetApprover (p_supplier_id IN NUMBER,
39 p_contact_id IN NUMBER,
40 p_user_id IN NUMBER,
41 p_approver_id IN OUT NUMBER,
42 p_approver_name IN OUT VARCHAR2);
43
44 procedure GetContactSelector (p_supplier_id IN NUMBER,
45 p_approver_id IN OUT NUMBER,
46 p_approver_name IN OUT VARCHAR2);
47
48 procedure GetAcctAdmin(p_supplier_id in number,
49 p_admin_id out number,
50 p_admin_name out varchar2,
51 p_display_admin_name out varchar2);
52
53 function VerifySelfApproval(p_supplier_id IN NUMBER)
54 return BOOLEAN;
55
56 function VerifyAuthority(p_supplier_id IN NUMBER,
57 p_approver_id IN NUMBER)
58 return BOOLEAN;
59
60 end icx_supp_custom;
[Home] [Help]