1247: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1248:
1249: l_commitElement := xmldom.makeElement(l_CommitNode);
1250: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1251: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1252:
1253: -- overiding for poststate
1254: -- CancelMode
1255: if(l_postState = '2') then
1254: -- CancelMode
1255: if(l_postState = '2') then
1256: -- Check if the transaction is for delete
1257: begin
1258: lv_action:= hr_xml_util.get_node_value(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,'AbsenceAction','Transaction/TransCtx/CNode',
1259: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1260: end;
1261: if(lv_action='CancelMode') then
1262: -- reset the poststate
1266:
1267:
1268: if l_postState = '0' then
1269:
1270: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1271: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1272: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1273: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1274:
1267:
1268: if l_postState = '0' then
1269:
1270: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1271: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1272: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1273: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1274:
1275: create_person_absence
1268: if l_postState = '0' then
1269:
1270: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1271: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1272: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1273: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1274:
1275: create_person_absence
1276: (p_validate => p_validate
1269:
1270: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1271: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1272: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1273: l_occurrence := hr_transaction_swi.getNumberValue(l_CommitNode,'Occurrence',null);
1274:
1275: create_person_absence
1276: (p_validate => p_validate
1277: ,p_effective_date => p_effective_date
1274:
1275: create_person_absence
1276: (p_validate => p_validate
1277: ,p_effective_date => p_effective_date
1278: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1279: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1280: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1275: create_person_absence
1276: (p_validate => p_validate
1277: ,p_effective_date => p_effective_date
1278: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1279: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1280: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1276: (p_validate => p_validate
1277: ,p_effective_date => p_effective_date
1278: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1279: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1280: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1277: ,p_effective_date => p_effective_date
1278: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1279: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1280: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1278: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1279: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1280: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1279: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1280: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1280: ,p_absence_attendance_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceTypeId',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1281: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1289: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1282: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1289: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1290: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1283: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1289: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1290: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1291: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1284: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart',null)
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1289: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1290: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1291: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1292: ,p_absence_days => l_absence_days
1285: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart',null)
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1289: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1290: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1291: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1292: ,p_absence_days => l_absence_days
1293: ,p_absence_hours => l_absence_hours
1286: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1289: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1290: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1291: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1292: ,p_absence_days => l_absence_days
1293: ,p_absence_hours => l_absence_hours
1294: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1287: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd',null)
1288: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',null)
1289: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart',null)
1290: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1291: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1292: ,p_absence_days => l_absence_days
1293: ,p_absence_hours => l_absence_hours
1294: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1295: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1290: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',null)
1291: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1292: ,p_absence_days => l_absence_days
1293: ,p_absence_hours => l_absence_hours
1294: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1295: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1296: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1291: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd',null)
1292: ,p_absence_days => l_absence_days
1293: ,p_absence_hours => l_absence_hours
1294: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1295: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1296: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1292: ,p_absence_days => l_absence_days
1293: ,p_absence_hours => l_absence_hours
1294: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1295: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1296: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1293: ,p_absence_hours => l_absence_hours
1294: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1295: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1296: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1294: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',null)
1295: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1296: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1295: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId',null)
1296: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1296: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1297: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1298: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1299: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1300: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1301: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1302: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1303: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1304: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1305: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1306: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1307: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1308: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1309: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1310: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1311: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1312: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1313: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1314: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1315: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1316: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1317: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1318: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1319: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1320: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1321: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1322: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1323: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1324: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1325: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1326: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1327: ,p_create_element_entry => hr_transaction_swi.getNumberValue(l_CommitNode,'CreateElementEntry',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1328: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1329: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1330: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1331: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1332: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1333: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1334: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1335: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1336: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1337: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1338: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1339: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1340: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1341: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1342: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1343: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1344: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1345: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1346: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1347: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1348: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1356: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1349: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1356: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1357: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1350: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1356: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1357: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1358: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1351: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23',null)
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1356: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1357: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1358: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1359: ,p_absence_attendance_id => l_absence_attendance_id
1352: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24',null)
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1356: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1357: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1358: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1359: ,p_absence_attendance_id => l_absence_attendance_id
1360: ,p_object_version_number => l_object_version_number
1353: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25',null)
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1356: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1357: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1358: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1359: ,p_absence_attendance_id => l_absence_attendance_id
1360: ,p_object_version_number => l_object_version_number
1361: ,p_occurrence => l_occurrence
1354: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26',null)
1355: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27',null)
1356: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28',null)
1357: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29',null)
1358: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30',null)
1359: ,p_absence_attendance_id => l_absence_attendance_id
1360: ,p_object_version_number => l_object_version_number
1361: ,p_occurrence => l_occurrence
1362: ,p_return_status => l_return_status);
1363:
1364: elsif l_postState = '2' then
1365:
1366:
1367: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1368: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1369: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1370: update_person_absence
1371: (p_validate => p_validate
1364: elsif l_postState = '2' then
1365:
1366:
1367: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1368: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1369: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1370: update_person_absence
1371: (p_validate => p_validate
1372: ,p_effective_date => p_effective_date
1365:
1366:
1367: l_absence_days := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceDays',null);
1368: l_absence_hours := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceHours',null);
1369: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1370: update_person_absence
1371: (p_validate => p_validate
1372: ,p_effective_date => p_effective_date
1373: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1369: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
1370: update_person_absence
1371: (p_validate => p_validate
1372: ,p_effective_date => p_effective_date
1373: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1374: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1375: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1370: update_person_absence
1371: (p_validate => p_validate
1372: ,p_effective_date => p_effective_date
1373: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1374: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1375: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1371: (p_validate => p_validate
1372: ,p_effective_date => p_effective_date
1373: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1374: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1375: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1372: ,p_effective_date => p_effective_date
1373: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1374: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1375: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1373: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1374: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1375: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1374: ,p_abs_attendance_reason_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsAttendanceReasonId')
1375: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1382: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1375: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1382: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1383: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1376: ,p_date_notification => hr_transaction_swi.getDateValue(l_CommitNode,'DateNotification')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1382: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1383: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1384: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1377: ,p_date_projected_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedStart')
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1382: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1383: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1384: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1385: ,p_absence_days => l_absence_days
1378: ,p_time_projected_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedStart')
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1382: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1383: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1384: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1385: ,p_absence_days => l_absence_days
1386: ,p_absence_hours => l_absence_hours
1379: ,p_date_projected_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProjectedEnd')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1382: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1383: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1384: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1385: ,p_absence_days => l_absence_days
1386: ,p_absence_hours => l_absence_hours
1387: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1380: ,p_time_projected_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeProjectedEnd')
1381: ,p_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart')
1382: ,p_time_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeStart')
1383: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1384: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1385: ,p_absence_days => l_absence_days
1386: ,p_absence_hours => l_absence_hours
1387: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1388: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1383: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd')
1384: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1385: ,p_absence_days => l_absence_days
1386: ,p_absence_hours => l_absence_hours
1387: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1388: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1389: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1384: ,p_time_end => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeEnd')
1385: ,p_absence_days => l_absence_days
1386: ,p_absence_hours => l_absence_hours
1387: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1388: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1389: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1385: ,p_absence_days => l_absence_days
1386: ,p_absence_hours => l_absence_hours
1387: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1388: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1389: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1386: ,p_absence_hours => l_absence_hours
1387: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1388: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1389: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1387: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPerson_id')
1388: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1389: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1388: ,p_replacement_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ReplacementPersonId')
1389: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1389: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1390: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1391: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1392: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1393: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1394: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1395: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1396: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1397: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1398: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1399: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1400: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1401: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1402: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1403: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1404: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1405: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1406: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1407: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1408: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1409: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1410: ,p_period_of_incapacity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfIncapacityId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1411: ,p_ssp1_issued => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Ssp1Issued')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1412: ,p_maternity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MaternityId')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1413: ,p_sickness_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessStartDate')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1414: ,p_sickness_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'SicknessEndDate')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1415: ,p_pregnancy_related_illness => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PregnancyRelatedIllness')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1416: ,p_reason_for_notification_dela => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ReasonForNotificationDela')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1417: ,p_accept_late_notification_fla => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AcceptLateNotificationFla')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1418: ,p_linked_absence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LinkedAbsenceId')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1419: ,p_batch_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BatchId')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1420: ,p_abs_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformationCategory')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1421: ,p_abs_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation1')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1422: ,p_abs_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation2')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1423: ,p_abs_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation3')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1424: ,p_abs_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation4')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1425: ,p_abs_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation5')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1426: ,p_abs_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation6')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1427: ,p_abs_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation7')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1428: ,p_abs_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation8')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1429: ,p_abs_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation9')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1430: ,p_abs_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation10')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1431: ,p_abs_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation11')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1432: ,p_abs_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation12')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1433: ,p_abs_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation13')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1434: ,p_abs_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation14')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1435: ,p_abs_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation15')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1436: ,p_abs_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation16')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1437: ,p_abs_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation17')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1438: ,p_abs_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation18')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1439: ,p_abs_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation19')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1440: ,p_abs_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation20')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1448: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1441: ,p_abs_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation21')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1448: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1449: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1442: ,p_abs_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation22')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1448: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1449: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1450: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1443: ,p_abs_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation23')
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1448: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1449: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1450: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1451: ,p_object_version_number => l_object_version_number
1444: ,p_abs_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation24')
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1448: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1449: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1450: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1451: ,p_object_version_number => l_object_version_number
1452: ,p_return_status => l_return_status);
1445: ,p_abs_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation25')
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1448: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1449: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1450: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1451: ,p_object_version_number => l_object_version_number
1452: ,p_return_status => l_return_status);
1453:
1446: ,p_abs_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation26')
1447: ,p_abs_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation27')
1448: ,p_abs_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation28')
1449: ,p_abs_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation29')
1450: ,p_abs_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AbsInformation30')
1451: ,p_object_version_number => l_object_version_number
1452: ,p_return_status => l_return_status);
1453:
1454:
1455: elsif l_postState = '3' then
1456:
1457: delete_person_absence
1458: ( p_validate => p_validate
1459: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
1460: ,p_object_version_number => l_object_version_number
1461: ,p_return_status => l_return_status
1462: );
1463:
1464: end if;
1465:
1466: -- finally call the attachements update
1467: if( l_return_status <> 'E') then
1468: merge_attachments(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,
1469: hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId'),
1470: l_return_status);
1471: end if;
1472:
1465:
1466: -- finally call the attachements update
1467: if( l_return_status <> 'E') then
1468: merge_attachments(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,
1469: hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId'),
1470: l_return_status);
1471: end if;
1472:
1473: p_return_status := l_return_status;