1 PACKAGE POS_PARTY_MANAGEMENT_PKG as
2 --$Header: POSPMNGS.pls 120.4 2005/10/07 02:45:25 bitang noship $
3
4 PROCEDURE classify_party
5 ( p_party_id IN NUMBER
6 , p_category IN VARCHAR2
7 , p_code IN VARCHAR2
8 , p_primary_flag IN VARCHAR2
9 , x_code_assignment_id OUT NOCOPY NUMBER
10 , x_status OUT NOCOPY VARCHAR2
11 , x_exception_msg OUT NOCOPY VARCHAR2
12 );
13
14 PROCEDURE classify_party
15 ( p_party_id IN NUMBER
16 , p_category IN VARCHAR2
17 , p_code IN VARCHAR2
18 , x_status OUT NOCOPY VARCHAR2
19 , x_exception_msg OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE pos_create_organization
23 (p_organization_name IN VARCHAR2,
24 p_duns_number IN NUMBER DEFAULT NULL,
25 p_corp_hq_flag IN VARCHAR2 DEFAULT NULL,
26 p_sic_code IN VARCHAR2 DEFAULT NULL,
27 x_org_party_id OUT NOCOPY NUMBER,
28 x_org_party_number OUT NOCOPY VARCHAR2,
29 x_profile_id OUT NOCOPY NUMBER,
30 x_exception_msg OUT NOCOPY VARCHAR2,
31 x_status OUT NOCOPY VARCHAR2
32 );
33
34 -- in release 12, this procedure should not be used to create supplier user
35 -- it should be used for boot strap enterprise user for Sourcing
36 PROCEDURE pos_create_user
37 (p_username IN VARCHAR2,
38 p_firstname IN VARCHAR2,
39 p_lastname IN VARCHAR2,
40 p_emailaddress IN VARCHAR2,
41 x_party_id OUT NOCOPY NUMBER, -- party id of the user
42 x_exception_msg OUT NOCOPY VARCHAR2,
43 x_status OUT NOCOPY VARCHAR2
44 );
45
46 FUNCTION check_for_vendor_user(p_username IN VARCHAR2) RETURN NUMBER;
47
48 FUNCTION check_for_enterprise_user(p_username IN VARCHAR2) RETURN NUMBER;
49
50 FUNCTION get_emp_or_ctgt_wrkr_pty_id (p_userid IN NUMBER) RETURN NUMBER;
51
52 -- bitang: the implementation here works for release 11.5.10 but might be changed for r12
53 -- due to TCA Supplier project.
54 -- this procedure is used in POSISPAB.pls. need to find out whether the
55 -- caller passes in a supplier username or internal user name
56 FUNCTION get_job_title_for_user (p_user_id IN NUMBER) RETURN VARCHAR2;
57
58 -- return Y if the employee_id column of the user is not null
59 -- and the employee_id is a current employee or contingent worker;
60 -- N otherwise.
61 FUNCTION is_user_employee_cont_worker(p_userid IN NUMBER)
62 RETURN VARCHAR2;
63
64 END POS_PARTY_MANAGEMENT_PKG;