DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_API dependencies on HR_XML_UTIL

Line 3182: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

3178:
3179: select
3180: hr_person_absence_swi.getStartDate(hat.transaction_id) ActualDateStart,
3181: hr_person_absence_swi.getEndDate(hat.transaction_id) ActualDateEnd,
3182: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3183: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3184: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3185: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),
3186: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

Line 3184: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

3180: hr_person_absence_swi.getStartDate(hat.transaction_id) ActualDateStart,
3181: hr_person_absence_swi.getEndDate(hat.transaction_id) ActualDateEnd,
3182: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3183: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3184: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3185: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),
3186: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3187: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3188: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

Line 3186: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

3182: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3183: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3184: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3185: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),
3186: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3187: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3188: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3189: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),
3190: hat.TRANSACTION_ID,

Line 3188: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

3184: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3185: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),
3186: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3187: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3188: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3189: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),
3190: hat.TRANSACTION_ID,
3191: hat.TRANSACTION_DOCUMENT,
3192: -- hrtsteps.object_state, -- stores ovn

Line 3193: hr_xml_util.get_node_value(hat.transaction_id,'ObjectVersionNumber','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

3189: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),
3190: hat.TRANSACTION_ID,
3191: hat.TRANSACTION_DOCUMENT,
3192: -- hrtsteps.object_state, -- stores ovn
3193: hr_xml_util.get_node_value(hat.transaction_id,'ObjectVersionNumber','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3194: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3195: abt.absence_attendance_type_id,
3196: hat.transaction_ref_id,
3197: pet.ELEMENT_TYPE_ID,

Line 3216: and hr_xml_util.get_node_value(hat.transaction_id,'AbsenceAction','Transaction/TransCtx/CNode',

3212: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3213: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3214: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) )
3215:
3216: and hr_xml_util.get_node_value(hat.transaction_id,'AbsenceAction','Transaction/TransCtx/CNode',
3217: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)=p_mode
3218: and p_start_date between piv.EFFECTIVE_START_DATE and piv.EFFECTIVE_END_DATE
3219: and p_start_date between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
3220: AND abt.absence_attendance_type_id= hrtsteps.Information5

Line 3355: --l_time_start := hr_xml_util.get_node_value(l_transactionid,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

3351:
3352:
3353: exit when csr_sshr_abs_records%notfound;
3354:
3355: --l_time_start := hr_xml_util.get_node_value(l_transactionid,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3356: -- NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
3357: --l_time_end := hr_xml_util.get_node_value(l_transactionid,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3358: -- NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
3359:

Line 3357: --l_time_end := hr_xml_util.get_node_value(l_transactionid,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

3353: exit when csr_sshr_abs_records%notfound;
3354:
3355: --l_time_start := hr_xml_util.get_node_value(l_transactionid,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3356: -- NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
3357: --l_time_end := hr_xml_util.get_node_value(l_transactionid,'TimeEnd','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3358: -- NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
3359:
3360: -- as this is just in create mode so hours should be present if abs element is hours based
3361: /*