1 package PN_CC_SYNC_PKG AUTHID CURRENT_USER as
2 -- $Header: PNCCSYNS.pls 115.0 2003/11/15 02:17:48 vmmehta noship $
3
4
5 -------------------------------------------------------------------
6 -- Main procedure for cost center synchronization with HR
7 -- ( Run as a Conc Process )
8 -------------------------------------------------------------------
9
10 PROCEDURE cc_sync_with_hr (
11 errbuf OUT NOCOPY VARCHAR2,
12 retcode OUT NOCOPY VARCHAR2,
13 p_as_of_date IN VARCHAR2,
14 p_locn_type IN pn_locations.location_type_lookup_code%TYPE,
15 p_locn_code_from IN pn_locations.location_code%TYPE,
16 p_locn_code_to IN pn_locations.location_code%TYPE,
17 p_emp_cost_center IN pn_space_assign_emp.cost_center_code%TYPE );
18
19
20 -------------------------------------------------------------------
21 -- For getting cost center on 'As of date' and full name from HR
22 -------------------------------------------------------------------
23
24 PROCEDURE get_cc_as_of_date ( p_employee_id IN NUMBER,
25 p_column_name IN VARCHAR2 DEFAULT NULL,
26 p_as_of_date IN DATE,
27 p_emp_name OUT NOCOPY VARCHAR2,
28 p_cost_center OUT NOCOPY VARCHAR2
29 ) ;
30
31
32 END PN_CC_SYNC_PKG;