115: and hat.TRANSACTION_IDENTIFIER = 'ABSENCES'
116: and hat.STATUS in ('Y','C')
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 (
1542: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1543:
1544: l_commitElement := xmldom.makeElement(l_CommitNode);
1545: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1546: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1547:
1548: -- overiding for poststate
1549: -- CancelMode
1550: if(l_postState = '2') then
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
1561:
1562:
1563: if l_postState = '0' then
1564:
1565: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1566: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1567: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1568: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1569:
1562:
1563: if l_postState = '0' then
1564:
1565: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1566: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1567: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1568: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1569:
1570: create_person_absence
1563: if l_postState = '0' then
1564:
1565: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1566: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1567: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1568: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1569:
1570: create_person_absence
1571: (p_validate => p_validate
1564:
1565: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1566: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1567: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1568: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1569:
1570: create_person_absence
1571: (p_validate => p_validate
1572: ,p_effective_date => p_effective_date
1569:
1570: create_person_absence
1571: (p_validate => p_validate
1572: ,p_effective_date => p_effective_date
1573: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1574: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1575: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1570: create_person_absence
1571: (p_validate => p_validate
1572: ,p_effective_date => p_effective_date
1573: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1574: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1575: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1571: (p_validate => p_validate
1572: ,p_effective_date => p_effective_date
1573: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1574: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1575: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1572: ,p_effective_date => p_effective_date
1573: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1574: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1575: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1573: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1574: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1575: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1574: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1575: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1575: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1576: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1584: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1577: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1584: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1585: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1578: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1584: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1585: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1586: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1579: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1584: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1585: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1586: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1587: ,p_absence_days => l_absence_days
1580: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1584: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1585: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1586: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1587: ,p_absence_days => l_absence_days
1588: ,p_absence_hours => l_absence_hours
1581: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1584: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1585: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1586: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1587: ,p_absence_days => l_absence_days
1588: ,p_absence_hours => l_absence_hours
1589: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1582: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1583: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1584: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1585: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1586: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1587: ,p_absence_days => l_absence_days
1588: ,p_absence_hours => l_absence_hours
1589: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1590: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1585: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1586: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1587: ,p_absence_days => l_absence_days
1588: ,p_absence_hours => l_absence_hours
1589: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1590: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1591: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1586: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1587: ,p_absence_days => l_absence_days
1588: ,p_absence_hours => l_absence_hours
1589: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1590: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1591: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1587: ,p_absence_days => l_absence_days
1588: ,p_absence_hours => l_absence_hours
1589: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1590: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1591: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1588: ,p_absence_hours => l_absence_hours
1589: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1590: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1591: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1589: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1590: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1591: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1590: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1591: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1591: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1592: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1593: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1594: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1595: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1596: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1597: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1598: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1599: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1600: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1601: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1602: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1603: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1604: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1605: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1606: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1607: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1608: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1609: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1610: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1611: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1612: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1613: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1614: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1615: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1616: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1617: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1618: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1619: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1620: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1621: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1622: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1623: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1624: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1625: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1626: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1627: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1628: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1629: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1630: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1631: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1632: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1633: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1634: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1635: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1636: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1637: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1638: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1639: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1640: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1641: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1642: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1643: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1651: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1644: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1651: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1652: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1645: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1651: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1652: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1653: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1646: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1651: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1652: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1653: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1654: ,p_absence_attendance_id => l_absence_attendance_id
1647: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1651: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1652: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1653: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1654: ,p_absence_attendance_id => l_absence_attendance_id
1655: ,p_object_version_number => l_object_version_number
1648: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1651: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1652: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1653: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1654: ,p_absence_attendance_id => l_absence_attendance_id
1655: ,p_object_version_number => l_object_version_number
1656: ,p_occurrence => l_occurrence
1649: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1650: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1651: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1652: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1653: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1654: ,p_absence_attendance_id => l_absence_attendance_id
1655: ,p_object_version_number => l_object_version_number
1656: ,p_occurrence => l_occurrence
1657: ,p_return_status => l_return_status);
1658:
1659: elsif l_postState = '2' then
1660:
1661:
1662: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1663: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1664: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1665:
1666: if( l_absence_days is null and l_absence_hours is null) then
1659: elsif l_postState = '2' then
1660:
1661:
1662: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1663: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1664: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1665:
1666: if( l_absence_days is null and l_absence_hours is null) then
1667:
1660:
1661:
1662: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1663: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1664: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1665:
1666: if( l_absence_days is null and l_absence_hours is null) then
1667:
1668: open c_get_dur(l_absence_attendance_id);
1678:
1679: update_person_absence
1680: (p_validate => p_validate
1681: ,p_effective_date => p_effective_date
1682: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1683: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1684: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1679: update_person_absence
1680: (p_validate => p_validate
1681: ,p_effective_date => p_effective_date
1682: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1683: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1684: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1680: (p_validate => p_validate
1681: ,p_effective_date => p_effective_date
1682: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1683: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1684: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1681: ,p_effective_date => p_effective_date
1682: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1683: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1684: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1682: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1683: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1684: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1683: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1684: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1691: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1684: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1691: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1692: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1685: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1691: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1692: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1693: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1686: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1691: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1692: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1693: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1694: ,p_absence_days => l_absence_days
1687: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1691: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1692: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1693: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1694: ,p_absence_days => l_absence_days
1695: ,p_absence_hours => l_absence_hours
1688: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1691: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1692: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1693: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1694: ,p_absence_days => l_absence_days
1695: ,p_absence_hours => l_absence_hours
1696: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1689: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1690: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1691: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1692: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1693: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1694: ,p_absence_days => l_absence_days
1695: ,p_absence_hours => l_absence_hours
1696: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1697: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1692: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1693: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1694: ,p_absence_days => l_absence_days
1695: ,p_absence_hours => l_absence_hours
1696: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1697: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1698: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1693: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1694: ,p_absence_days => l_absence_days
1695: ,p_absence_hours => l_absence_hours
1696: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1697: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1698: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1694: ,p_absence_days => l_absence_days
1695: ,p_absence_hours => l_absence_hours
1696: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1697: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1698: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1695: ,p_absence_hours => l_absence_hours
1696: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1697: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1698: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1696: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1697: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1698: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1697: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1698: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1698: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1699: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1700: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1701: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1702: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1703: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1704: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1705: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1706: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1707: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1708: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1709: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1710: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1711: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1712: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1713: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1714: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1715: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1716: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1717: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1718: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1719: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1720: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1721: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1722: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1723: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1724: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1725: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1726: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1727: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1728: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1729: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1730: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1731: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1732: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1733: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1734: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1735: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1736: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1737: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1738: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1739: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1740: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1741: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1742: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1743: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1744: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1745: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1746: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1747: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1748: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1749: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1757: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1750: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1757: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1758: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1751: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1757: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1758: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1759: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1752: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1757: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1758: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1759: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1760: ,p_object_version_number => l_object_version_number
1753: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1757: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1758: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1759: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1760: ,p_object_version_number => l_object_version_number
1761: ,p_return_status => l_return_status);
1754: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1757: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1758: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1759: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1760: ,p_object_version_number => l_object_version_number
1761: ,p_return_status => l_return_status);
1762:
1755: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1756: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1757: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1758: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1759: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1760: ,p_object_version_number => l_object_version_number
1761: ,p_return_status => l_return_status);
1762:
1763:
1764: elsif l_postState = '3' then
1765:
1766: delete_person_absence
1767: ( p_validate => p_validate
1768: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1769: ,p_object_version_number => l_object_version_number
1770: ,p_return_status => l_return_status
1771: );
1772:
1799:
1800:
1801: -- finally call the attachements update
1802: if( l_return_status <> 'E') then
1803: merge_attachments(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,
1804: hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId'),
1805: l_return_status);
1806: end if;
1807:
1800:
1801: -- finally call the attachements update
1802: if( l_return_status <> 'E') then
1803: merge_attachments(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,
1804: hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId'),
1805: l_return_status);
1806: end if;
1807:
1808: p_return_status := l_return_status;