[Home] [Help]
PACKAGE BODY: APPS.PAY_FI_ABSENCE
Source
1 PACKAGE BODY PAY_FI_ABSENCE AS
2 /* $Header: pyfiabsc.pkb 120.0.12000000.2 2007/03/01 09:16:43 dbehera noship $ */
3 FUNCTION MAINTAIN_PAID_HOLIDAY
4 ( p_assignment_id in number,
5 p_person_id in number,
6 p_absence_attendance_id in number,
7 p_element_type_id in number,
8 p_absence_category in varchar2,
9 p_original_entry_id OUT nocopy NUMBER,
10 p_input_value_name1 OUT NOCOPY VARCHAR2,
11 p_input_value1 OUT NOCOPY VARCHAR2,
12 p_input_value_name2 OUT NOCOPY VARCHAR2,
13 p_input_value2 OUT NOCOPY VARCHAR2,
14 p_input_value_name3 OUT NOCOPY VARCHAR2,
15 p_input_value3 OUT NOCOPY VARCHAR2,
16 p_input_value_name4 OUT NOCOPY VARCHAR2,
17 p_input_value4 OUT NOCOPY VARCHAR2,
18 p_input_value_name5 OUT NOCOPY VARCHAR2,
19 p_input_value5 OUT NOCOPY VARCHAR2,
20 p_input_value_name6 OUT NOCOPY VARCHAR2,
21 p_input_value6 OUT NOCOPY VARCHAR2,
22 p_input_value_name7 OUT NOCOPY VARCHAR2,
23 p_input_value7 OUT NOCOPY VARCHAR2,
24 p_input_value_name8 OUT NOCOPY VARCHAR2,
25 p_input_value8 OUT NOCOPY VARCHAR2,
26 p_input_value_name9 OUT NOCOPY VARCHAR2,
27 p_input_value9 OUT NOCOPY VARCHAR2,
28 p_input_value_name10 OUT NOCOPY VARCHAR2,
29 p_input_value10 OUT NOCOPY VARCHAR2,
30 p_input_value_name11 OUT NOCOPY VARCHAR2,
31 p_input_value11 OUT NOCOPY VARCHAR2,
32 p_input_value_name12 OUT NOCOPY VARCHAR2,
33 p_input_value12 OUT NOCOPY VARCHAR2,
34 p_input_value_name13 OUT NOCOPY VARCHAR2,
35 p_input_value13 OUT NOCOPY VARCHAR2,
36 p_input_value_name14 OUT NOCOPY VARCHAR2,
37 p_input_value14 OUT NOCOPY VARCHAR2,
38 p_input_value_name15 OUT NOCOPY VARCHAR2,
39 p_input_value15 OUT NOCOPY VARCHAR2)
40 RETURN VARCHAR2 IS
41
42
43 BEGIN
44
45 IF p_absence_category = 'V' THEN
46
47 p_input_value_name1 := 'CREATOR_ID';
48 p_input_value1 := p_absence_attendance_id;
49
50 RETURN 'Y';
51
52 ELSE
53
54 RETURN 'N';
55
56 END IF;
57
58 END MAINTAIN_PAID_HOLIDAY;
59
60 END PAY_FI_ABSENCE;