1 PACKAGE pqp_professional_body_function AUTHID CURRENT_USER AS
2 -- $Header: pqgbpbfn.pkh 115.4 2003/02/14 19:19:43 tmehra noship $
3 -----------------------------------------------------------------------------
4 -- GET_ORGANIZATION_INFO
5 -----------------------------------------------------------------------------
6 FUNCTION get_organization_info (p_element_type_id IN NUMBER -- Context
7 ,p_business_group_id IN NUMBER -- Context
8 ,p_organization_id OUT NOCOPY NUMBER
9 ,p_error_message OUT NOCOPY VARCHAR2
10 )
11 RETURN NUMBER;
12
13 -----------------------------------------------------------------------------
14 -- GET_PB_MEM_INFO
15 -----------------------------------------------------------------------------
16 FUNCTION get_pb_mem_info (p_assignment_id IN NUMBER -- Context
17 ,p_business_group_id IN NUMBER -- Context
18 ,p_organization_id IN NUMBER
19 ,p_pay_start_dt IN DATE
20 ,p_pay_end_dt IN DATE
21 ,p_professional_body_nm OUT NOCOPY VARCHAR2
22 ,p_membership_category OUT NOCOPY VARCHAR2
23 ,p_error_message OUT NOCOPY VARCHAR2
24 )
25 RETURN NUMBER;
26
27 -----------------------------------------------------------------------------
28 -- GET_PB_UDT_INFO
29 -----------------------------------------------------------------------------
30 FUNCTION get_pb_udt_info (p_business_group_id IN NUMBER -- Context
31 ,p_organization_id IN NUMBER
32 ,p_membership_category IN VARCHAR2
33 ,p_user_table_name OUT NOCOPY VARCHAR2
34 ,p_user_row_value OUT NOCOPY VARCHAR2
35 ,p_error_message OUT NOCOPY VARCHAR2
36 )
37 RETURN NUMBER;
38
39 -----------------------------------------------------------------------------
40
41 END pqp_professional_body_function;