1 PACKAGE PAY_DK_EHOL_CARD_REQUEST AUTHID CURRENT_USER AS
2 /* $Header: pydkeholreq.pkh 120.0.12020000.2 2012/07/18 06:58:08 rsahai noship $ */
3
4 PROCEDURE printElements(doc xmldom.DOMDocument);
5
6 PROCEDURE read_hol_card( errbuf OUT NOCOPY VARCHAR2
7 , retcode OUT NOCOPY VARCHAR2
8 , p_filename IN VARCHAR2
9 , p_effective_date IN VARCHAR2
10 , p_business_group_id IN number
11 , p_absence_type_id IN NUMBER
12 , test_submission IN VARCHAR2
13 );
14
15 PROCEDURE log_dk_ehol_card_header;
16 PROCEDURE log_dk_ehol_card_body ;
17 PROCEDURE validate_ecard_details(p_business_group_id number , p_effective_date date, retcode OUT NOCOPY varchar2);
18 PROCEDURE create_absence(p_effective_date date,
19 p_start_date date,
20 p_end_date date,
21 p_business_group_id number,
22 p_person_id number
23 -- , p_assg_id number,
24 -- p_holidays number ,
25 -- p_year varchar2
26 );
27
28
29 PROCEDURE create_override_hol ( p_effective_date IN DATE
30 , p_assignment_id IN NUMBER
31 , p_business_group_id IN NUMBER
32 , p_start_date IN DATE
33 , p_end_date IN DATE
34 , p_over_days IN NUMBER
35 , p_over_hours IN NUMBER
36 , p_year varchar2 ) ;
37
38 PROCEDURE create_timestamp_entry ( p_effective_date IN DATE
39 , p_assignment_id IN NUMBER
40 , p_business_group_id IN NUMBER
41 , p_run_id IN varchar2
42 , p_date_created IN varchar2
43 , p_time_created IN varchar2
44 );
45
46
47 FUNCTION get_eholiday_details ( p_assignment_id IN NUMBER
48 ,p_effective_date IN DATE
49 ,p_abs_start_date IN DATE
50 ,p_abs_end_date IN DATE
51 ,p_start_date OUT NOCOPY DATE
52 ,p_end_date OUT NOCOPY DATE
53 ,p_over_days OUT NOCOPY NUMBER
54 ,p_over_hours OUT NOCOPY NUMBER
55 ,p_creator_id OUT NOCOPY varchar2
56 ,p_year OUT NOCOPY varchar2 ) RETURN NUMBER ;
57
58
59 END PAY_DK_EHOL_CARD_REQUEST;