[Home] [Help]
PACKAGE: APPS.PAY_NO_ABSENCE_USER
Source
1 PACKAGE PAY_NO_ABSENCE_USER AUTHID CURRENT_USER AS
2 /*$Header: pynoabsusr.pkh 120.0.12010000.1 2008/07/27 23:13:22 appldev ship $*/
3 -------------------------------------------------------------------------------------------------------------------------
4 /* Element populate function to return Input values of absence element */
5 -- NAME
6 -- Element_populate
7 -- PURPOSE
8 -- To populate element input values for absence recording.
9 -- ARGUMENTS
10 -- P_ASSIGNMENT_ID - Assignment id
11 -- P_PERSON_ID - Person id,
12 -- P_ABSENCE_ATTENDANCE_ID - Absence attendance id,
13 -- P_ELEMENT_TYPE_ID - Element type id,
14 -- P_ABSENCE_CATEGORY - Absence category ( Sickness ),
15 -- P_INPUT_VALUE_NAME 1-15 - Output variable holds element input value name.
16 -- P_INPUT_VALUE 1-15 - Output variable holds element input value.
17 -- USES
18 -- NOTES
19 -- The procedure fetches absence information from absence table with input absence_attendance_id and absence
20 -- category 'Sickness', 'Part Time Sickness' and 'Child Minder Sickness'. Then it assigns the values to output variables.
21 -------------------------------------------------------------------------------------------------------------------------
22 Function Element_populate (p_assignment_id in number,
23 p_person_id in number,
24 p_absence_attendance_id in number,
25 p_element_type_id in number,
26 p_absence_category in varchar2,
27 p_original_entry_id OUT nocopy NUMBER, --pgopal
28 p_input_value_name1 OUT NOCOPY VARCHAR2,
29 p_input_value1 OUT NOCOPY VARCHAR2,
30 p_input_value_name2 OUT NOCOPY VARCHAR2,
31 p_input_value2 OUT NOCOPY VARCHAR2,
32 p_input_value_name3 OUT NOCOPY VARCHAR2,
33 p_input_value3 OUT NOCOPY VARCHAR2,
34 p_input_value_name4 OUT NOCOPY VARCHAR2,
35 p_input_value4 OUT NOCOPY VARCHAR2,
36 p_input_value_name5 OUT NOCOPY VARCHAR2,
37 p_input_value5 OUT NOCOPY VARCHAR2,
38 p_input_value_name6 OUT NOCOPY VARCHAR2,
39 p_input_value6 OUT NOCOPY VARCHAR2,
40 p_input_value_name7 OUT NOCOPY VARCHAR2,
41 p_input_value7 OUT NOCOPY VARCHAR2,
42 p_input_value_name8 OUT NOCOPY VARCHAR2,
43 p_input_value8 OUT NOCOPY VARCHAR2,
44 p_input_value_name9 OUT NOCOPY VARCHAR2,
45 p_input_value9 OUT NOCOPY VARCHAR2,
46 p_input_value_name10 OUT NOCOPY VARCHAR2,
47 p_input_value10 OUT NOCOPY VARCHAR2,
48 p_input_value_name11 OUT NOCOPY VARCHAR2,
49 p_input_value11 OUT NOCOPY VARCHAR2,
50 p_input_value_name12 OUT NOCOPY VARCHAR2,
51 p_input_value12 OUT NOCOPY VARCHAR2,
52 p_input_value_name13 OUT NOCOPY VARCHAR2,
53 p_input_value13 OUT NOCOPY VARCHAR2,
54 p_input_value_name14 OUT NOCOPY VARCHAR2,
55 p_input_value14 OUT NOCOPY VARCHAR2,
56 p_input_value_name15 OUT NOCOPY VARCHAR2,
57 p_input_value15 OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
58 END PAY_NO_ABSENCE_USER;