eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_ABSENCE_SWI dependencies on HR_PERSON_ABSENCE_SWI

Line 1: Package body hr_person_absence_swi As

1: Package body hr_person_absence_swi As
2: /* $Header: hrabsswi.pkb 120.20.12020000.2 2012/11/06 08:33:22 aammoham ship $ */
3: --
4: -- Package variables
5: --

Line 6: g_package varchar2(33) := 'hr_person_absence_swi.';

2: /* $Header: hrabsswi.pkb 120.20.12020000.2 2012/11/06 08:33:22 aammoham ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'hr_person_absence_swi.';
7:
8: g_date_format constant varchar2(10):='RRRR-MM-DD';
9: g_usr_day_time_fmt varchar(40) := g_date_format|| ' HH24:MI:SS';
10:

Line 121: and hr_person_absence_swi.getStartDate(hat.transaction_id) is not null

117: --Code for Bug 10218346
118: and hat.transaction_id <>
119: nvl(hr_transaction_swi.g_txn_ctx.transaction_id,-1)
120: --End of Code for Bug 10218346
121: and hr_person_absence_swi.getStartDate(hat.transaction_id) is not null
122: and hr_person_absence_swi.getEndDate(hat.transaction_id) is not null
123: and (
124: (
125: to_date (to_char(hr_person_absence_swi.getStartDate(hat.transaction_id), g_date_format) ||' ' ||

Line 122: and hr_person_absence_swi.getEndDate(hat.transaction_id) is not null

118: and hat.transaction_id <>
119: nvl(hr_transaction_swi.g_txn_ctx.transaction_id,-1)
120: --End of Code for Bug 10218346
121: and hr_person_absence_swi.getStartDate(hat.transaction_id) is not null
122: and hr_person_absence_swi.getEndDate(hat.transaction_id) is not null
123: and (
124: (
125: to_date (to_char(hr_person_absence_swi.getStartDate(hat.transaction_id), g_date_format) ||' ' ||
126: nvl((hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),'00:00'),g_usr_day_time_fmt)

Line 125: to_date (to_char(hr_person_absence_swi.getStartDate(hat.transaction_id), g_date_format) ||' ' ||

121: and hr_person_absence_swi.getStartDate(hat.transaction_id) is not null
122: and hr_person_absence_swi.getEndDate(hat.transaction_id) is not null
123: and (
124: (
125: to_date (to_char(hr_person_absence_swi.getStartDate(hat.transaction_id), g_date_format) ||' ' ||
126: nvl((hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),'00:00'),g_usr_day_time_fmt)
127: BETWEEN to_date (to_char(p_date_start, g_date_format)||' ' || nvl(null,'00:00'),g_usr_day_time_fmt)
128: AND to_date(to_char(nvl(p_date_end,p_date_start), g_date_format) || ' '|| nvl(null,'00:00') , g_usr_day_time_fmt)
129: )

Line 134: to_date (to_char(hr_person_absence_swi.getStartDate(hat.transaction_id), g_date_format) ||' ' ||

130: or
131: (
132: to_date (to_char(p_date_start, g_date_format) ||' ' || nvl(null,'00:00'),g_usr_day_time_fmt)
133: BETWEEN
134: to_date (to_char(hr_person_absence_swi.getStartDate(hat.transaction_id), g_date_format) ||' ' ||
135: nvl((hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),'00:00'),g_usr_day_time_fmt)
136: AND
137: to_date (to_char(hr_person_absence_swi.getEndDate(hat.transaction_id), g_date_format) ||' ' ||
138: nvl((hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),'00:00'),g_usr_day_time_fmt)

Line 137: to_date (to_char(hr_person_absence_swi.getEndDate(hat.transaction_id), g_date_format) ||' ' ||

133: BETWEEN
134: to_date (to_char(hr_person_absence_swi.getStartDate(hat.transaction_id), g_date_format) ||' ' ||
135: nvl((hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),'00:00'),g_usr_day_time_fmt)
136: AND
137: to_date (to_char(hr_person_absence_swi.getEndDate(hat.transaction_id), g_date_format) ||' ' ||
138: nvl((hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),'00:00'),g_usr_day_time_fmt)
139: )
140:
141: );

Line 1862: end hr_person_absence_swi;

1858:
1859: end otl_hr_check;
1860:
1861:
1862: end hr_person_absence_swi;