515: --
516: --Deleting any existing transactions for this p_person_deployment_id
517: for a in c_del_trans
518: loop
519: hr_transaction_swi.delete_transaction(p_transaction_id => a.transaction_id);
520:
521: end loop;
522: -- Convert API warning boolean parameter values to specific
523: -- messages and add them to Multiple Message List
1241: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1242:
1243: l_commitElement := xmldom.makeElement(l_CommitNode);
1244: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1245: -- l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1246:
1247: -- overiding for poststate
1248: -- CancelMode
1249: if(l_postState = '2') then
1248: -- CancelMode
1249: if(l_postState = '2') then
1250: -- Check if the transaction is for delete
1251: begin
1252: lv_action:= hr_xml_util.get_node_value(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,'GoldAction','Transaction/TransCtx/CNode',
1253: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1254: end;
1255: if(lv_action='ReturnMode') then
1256: -- reset the poststate
1274: if l_postState = '0' then
1275:
1276: create_person_deployment
1277: (p_validate => p_validate
1278: ,p_from_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromBusinessGroupId',null)
1279: ,p_to_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToBusinessGroupId',null)
1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1275:
1276: create_person_deployment
1277: (p_validate => p_validate
1278: ,p_from_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromBusinessGroupId',null)
1279: ,p_to_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToBusinessGroupId',null)
1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1276: create_person_deployment
1277: (p_validate => p_validate
1278: ,p_from_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromBusinessGroupId',null)
1279: ,p_to_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToBusinessGroupId',null)
1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1277: (p_validate => p_validate
1278: ,p_from_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromBusinessGroupId',null)
1279: ,p_to_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToBusinessGroupId',null)
1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1278: ,p_from_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromBusinessGroupId',null)
1279: ,p_to_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToBusinessGroupId',null)
1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1279: ,p_to_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToBusinessGroupId',null)
1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',null)
1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',null)
1336: ,p_deployment_reason => hr_transaction_swi.getvarchar2value(l_commitnode,'DeploymentReason',null)
1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',null)
1336: ,p_deployment_reason => hr_transaction_swi.getvarchar2value(l_commitnode,'DeploymentReason',null)
1337: ,p_person_deployment_id => hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null)
1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',null)
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',null)
1336: ,p_deployment_reason => hr_transaction_swi.getvarchar2value(l_commitnode,'DeploymentReason',null)
1337: ,p_person_deployment_id => hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null)
1338: ,p_object_version_number => l_object_version_number
1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',null)
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',null)
1336: ,p_deployment_reason => hr_transaction_swi.getvarchar2value(l_commitnode,'DeploymentReason',null)
1337: ,p_person_deployment_id => hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null)
1338: ,p_object_version_number => l_object_version_number
1339: ,p_return_status => l_return_status);
1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',null)
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',null)
1336: ,p_deployment_reason => hr_transaction_swi.getvarchar2value(l_commitnode,'DeploymentReason',null)
1337: ,p_person_deployment_id => hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null)
1338: ,p_object_version_number => l_object_version_number
1339: ,p_return_status => l_return_status);
1340:
1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',null)
1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',null)
1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',null)
1336: ,p_deployment_reason => hr_transaction_swi.getvarchar2value(l_commitnode,'DeploymentReason',null)
1337: ,p_person_deployment_id => hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null)
1338: ,p_object_version_number => l_object_version_number
1339: ,p_return_status => l_return_status);
1340:
1341:
1339: ,p_return_status => l_return_status);
1340:
1341:
1342: /*Start of code for bug#14547912*/
1343: l_person_deployment_id := hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null);
1344: begin
1345: select max(hat.transaction_id)
1346: into l_transaction_id
1347: from hr_api_transactions hat,hr_api_transaction_steps hats
1354: end;
1355:
1356: if (l_transaction_id is not null)
1357: then
1358: set_start_date(l_transaction_id,hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null));
1359: end if;
1360:
1361: /*End of code for bug#14547912*/
1362:
1361: /*End of code for bug#14547912*/
1362:
1363: elsif l_postState = '2' then
1364:
1365: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1366:
1367: update_person_deployment
1368: (p_validate => p_validate
1369: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1365: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1366:
1367: update_person_deployment
1368: (p_validate => p_validate
1369: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1370: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1371: ,P_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId')
1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1367: update_person_deployment
1368: (p_validate => p_validate
1369: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1370: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1371: ,P_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId')
1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1368: (p_validate => p_validate
1369: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1370: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1371: ,P_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId')
1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1369: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1370: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1371: ,P_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId')
1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1370: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1371: ,P_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId')
1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1371: ,P_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId')
1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')
1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')
1425: ,P_PER_INFORMATION30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30')
1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')
1425: ,P_PER_INFORMATION30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30')
1426: ,P_DEPLOYMENT_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeploymentReason')
1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')
1425: ,P_PER_INFORMATION30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30')
1426: ,P_DEPLOYMENT_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeploymentReason')
1427: ,p_return_status => l_return_status);
1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')
1425: ,P_PER_INFORMATION30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30')
1426: ,P_DEPLOYMENT_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeploymentReason')
1427: ,p_return_status => l_return_status);
1428:
1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')
1425: ,P_PER_INFORMATION30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30')
1426: ,P_DEPLOYMENT_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeploymentReason')
1427: ,p_return_status => l_return_status);
1428:
1429:
1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')
1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')
1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')
1425: ,P_PER_INFORMATION30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30')
1426: ,P_DEPLOYMENT_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeploymentReason')
1427: ,p_return_status => l_return_status);
1428:
1429:
1430: elsif l_postState = '3' then
1428:
1429:
1430: elsif l_postState = '3' then
1431:
1432: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1433: return_from_deployment
1434: (p_validate => p_validate
1435: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1436: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1431:
1432: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1433: return_from_deployment
1434: (p_validate => p_validate
1435: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1436: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1437: ,P_END_DATE => to_date(to_char(hr_transaction_swi.getDateValue(l_CommitNode,'EndDate'),'RRRR-MM-DD'),'RRRR-MM-DD') -- Modified for bug#14549229
1438: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1439: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1433: return_from_deployment
1434: (p_validate => p_validate
1435: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1436: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1437: ,P_END_DATE => to_date(to_char(hr_transaction_swi.getDateValue(l_CommitNode,'EndDate'),'RRRR-MM-DD'),'RRRR-MM-DD') -- Modified for bug#14549229
1438: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1439: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1440: ,p_return_status => l_return_status);
1441:
1434: (p_validate => p_validate
1435: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1436: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1437: ,P_END_DATE => to_date(to_char(hr_transaction_swi.getDateValue(l_CommitNode,'EndDate'),'RRRR-MM-DD'),'RRRR-MM-DD') -- Modified for bug#14549229
1438: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1439: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1440: ,p_return_status => l_return_status);
1441:
1442:
1435: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')
1436: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1437: ,P_END_DATE => to_date(to_char(hr_transaction_swi.getDateValue(l_CommitNode,'EndDate'),'RRRR-MM-DD'),'RRRR-MM-DD') -- Modified for bug#14549229
1438: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')
1439: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')
1440: ,p_return_status => l_return_status);
1441:
1442:
1443: end if;
1443: end if;
1444:
1445: -- finally call the attachements update
1446: if( l_return_status <> 'E') then
1447: merge_attachments(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,
1448: hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId'),
1449: l_return_status);
1450: end if;
1451:
1444:
1445: -- finally call the attachements update
1446: if( l_return_status <> 'E') then
1447: merge_attachments(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,
1448: hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId'),
1449: l_return_status);
1450: end if;
1451:
1452: p_return_status := l_return_status;
1979:
1980: -- for now this will only allow for transaction owner to update
1981:
1982: if(p_transaction_id is not null) then
1983: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) then
1984: if p_deployment_type ='P' then
1985: if p_transaction_status = 'APPROVED' then
1986: lv_UpdateAllowed := 'UpdateEnabled1';
1987: else
2043:
2044: -- for now this will only allow for transaction owner to update
2045:
2046: if(p_transaction_id is not null) then
2047: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) then
2048: if p_deployment_type ='P' then
2049: if p_transaction_status in ('COMPLETE','APPROVED','REJECTED') then
2050: lv_DeleteAllowed := 'DeleteEnabled';
2051: elsif (p_transaction_status in ('PENDING_APPROVAL','RETURN_INIT_PENDING_APPROVAL')) then
2118:
2119: -- for now this will only allow for transaction owner to update
2120:
2121: if(p_transaction_id is not null) then
2122: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) then
2123:
2124: if p_transaction_status ='APPROVED' then
2125: lv_Init_Allowed := 'InitEnabled';
2126: else
2171:
2172: -- for now this will only allow for transaction owner to update
2173:
2174: if(p_transaction_id is not null) then
2175: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) then
2176: if p_deployment_type = 'P' then
2177: lv_ret_Init_Allowed := 'ReturnDisabled';
2178: else
2179: if p_transaction_status in ('ACTIVE') then