DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_SWI dependencies on HR_XML_UTIL

Line 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)

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: )
130: or

Line 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)

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)
139: )

Line 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)

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: );
142: --

Line 1553: lv_action:= hr_xml_util.get_node_value(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,'AbsenceAction','Transaction/TransCtx/CNode',

1549: -- CancelMode
1550: if(l_postState = '2') then
1551: -- Check if the transaction is for delete
1552: begin
1553: lv_action:= hr_xml_util.get_node_value(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,'AbsenceAction','Transaction/TransCtx/CNode',
1554: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1555: end;
1556: if(lv_action='CancelMode') then
1557: -- reset the poststate