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;