DBA Data[Home] [Help]

APPS.HR_PERSON_DEPLOYMENT_SWI dependencies on HR_TRANSACTION_SWI

Line 519: hr_transaction_swi.delete_transaction(p_transaction_id => a.transaction_id);

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

Line 1245: -- l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

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

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

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

Line 1278: ,p_from_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromBusinessGroupId',null)

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)

Line 1279: ,p_to_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToBusinessGroupId',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)

Line 1280: ,p_from_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FromPersonId',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)

Line 1281: ,p_to_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ToPersonId',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)

Line 1282: ,p_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId',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)

Line 1283: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',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)

Line 1284: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',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)

Line 1285: ,p_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber',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)

Line 1286: ,p_leaving_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason',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)

Line 1287: ,p_leaving_person_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId',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)

Line 1288: ,p_permanent => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Permanent',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)

Line 1289: ,p_Deplymt_Policy_Id => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId',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)

Line 1290: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',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)

Line 1291: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',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)

Line 1292: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',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)

Line 1293: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',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)

Line 1294: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',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)

Line 1295: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId',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)

Line 1296: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId',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)

Line 1297: ,p_retain_direct_reports => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports',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)

Line 1298: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId',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)

Line 1299: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId',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)

Line 1300: ,p_proposed_salary => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary',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)

Line 1301: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',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)

Line 1302: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId',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)

Line 1303: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId',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)

Line 1304: ,p_ass_status_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason',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)

Line 1305: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory',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)

Line 1306: ,p_per_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1',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)

Line 1307: ,p_per_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2',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)

Line 1308: ,p_per_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3',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)

Line 1309: ,p_per_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4',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)

Line 1310: ,p_per_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5',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)

Line 1311: ,p_per_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6',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)

Line 1312: ,p_per_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7',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)

Line 1313: ,p_per_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8',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)

Line 1314: ,p_per_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9',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)

Line 1315: ,p_per_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10',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)

Line 1316: ,p_per_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11',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)

Line 1317: ,p_per_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12',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)

Line 1318: ,p_per_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13',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)

Line 1319: ,p_per_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14',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)

Line 1320: ,p_per_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15',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)

Line 1321: ,p_per_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16',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)

Line 1322: ,p_per_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17',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)

Line 1323: ,p_per_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18',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)

Line 1324: ,p_per_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19',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)

Line 1325: ,p_per_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20',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)

Line 1326: ,p_per_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21',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)

Line 1327: ,p_per_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22',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)

Line 1328: ,p_per_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23',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)

Line 1329: ,p_per_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24',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)

Line 1330: ,p_per_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25',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)

Line 1331: ,p_per_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26',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)

Line 1332: ,p_per_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27',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)

Line 1333: ,p_per_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28',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)

Line 1334: ,p_per_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29',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

Line 1335: ,p_per_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30',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
1339: ,p_return_status => l_return_status);

Line 1336: ,p_deployment_reason => hr_transaction_swi.getvarchar2value(l_commitnode,'DeploymentReason',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);
1340:

Line 1337: ,p_person_deployment_id => hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',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:
1341:

Line 1343: l_person_deployment_id := hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null);

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

Line 1358: set_start_date(l_transaction_id,hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null));

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:

Line 1365: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

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

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

Line 1371: ,P_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonTypeId')

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

Line 1372: ,P_START_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')

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

Line 1373: ,P_END_DATE => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate')

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

Line 1374: ,P_EMPLOYEE_NUMBER => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeNumber')

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

Line 1375: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')

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

Line 1376: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')

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

Line 1377: ,P_STATUS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')

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

Line 1378: ,P_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'StatusChangeReason')

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

Line 1379: ,P_DEPLYMT_POLICY_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'DeplymtPolicyId')

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

Line 1380: ,P_ORGANIZATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')

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

Line 1381: ,P_LOCATION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')

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

Line 1382: ,P_JOB_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')

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

Line 1383: ,P_POSITION_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')

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

Line 1384: ,P_GRADE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')

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

Line 1385: ,P_SUPERVISOR_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')

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

Line 1386: ,P_SUPERVISOR_ASSIGNMENT_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')

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

Line 1387: ,P_RETAIN_DIRECT_REPORTS => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetainDirectReports')

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

Line 1388: ,P_PAYROLL_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')

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

Line 1389: ,P_PAY_BASIS_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')

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

Line 1390: ,P_PROPOSED_SALARY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposedSalary')

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

Line 1391: ,P_PEOPLE_GROUP_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')

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

Line 1392: ,P_SOFT_CODING_KEYFLEX_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')

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

Line 1393: ,P_ASSIGNMENT_STATUS_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')

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

Line 1394: ,P_ASS_STATUS_CHANGE_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssStatusChangeReason')

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

Line 1395: ,P_ASSIGNMENT_CATEGORY => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')

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

Line 1396: ,P_PER_INFORMATION1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation1')

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

Line 1397: ,P_PER_INFORMATION2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation2')

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

Line 1398: ,P_PER_INFORMATION3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation3')

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

Line 1399: ,P_PER_INFORMATION4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation4')

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

Line 1400: ,P_PER_INFORMATION5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation5')

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

Line 1401: ,P_PER_INFORMATION6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation6')

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

Line 1402: ,P_PER_INFORMATION7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation7')

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

Line 1403: ,P_PER_INFORMATION8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation8')

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

Line 1404: ,P_PER_INFORMATION9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation9')

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

Line 1405: ,P_PER_INFORMATION10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation10')

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

Line 1406: ,P_PER_INFORMATION11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation11')

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

Line 1407: ,P_PER_INFORMATION12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation12')

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

Line 1408: ,P_PER_INFORMATION13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation13')

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

Line 1409: ,P_PER_INFORMATION14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation14')

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

Line 1410: ,P_PER_INFORMATION15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation15')

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

Line 1411: ,P_PER_INFORMATION16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation16')

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

Line 1412: ,P_PER_INFORMATION17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation17')

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

Line 1413: ,P_PER_INFORMATION18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation18')

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

Line 1414: ,P_PER_INFORMATION19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation19')

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

Line 1415: ,P_PER_INFORMATION20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation20')

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

Line 1416: ,P_PER_INFORMATION21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation21')

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

Line 1417: ,P_PER_INFORMATION22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation22')

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

Line 1418: ,P_PER_INFORMATION23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation23')

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

Line 1419: ,P_PER_INFORMATION24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation24')

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

Line 1420: ,P_PER_INFORMATION25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation25')

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

Line 1421: ,P_PER_INFORMATION26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation26')

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

Line 1422: ,P_PER_INFORMATION27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation27')

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

Line 1423: ,P_PER_INFORMATION28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation28')

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

Line 1424: ,P_PER_INFORMATION29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation29')

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:

Line 1425: ,P_PER_INFORMATION30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerInformation30')

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:

Line 1426: ,P_DEPLOYMENT_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeploymentReason')

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

Line 1432: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

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

Line 1435: ,p_person_deployment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId')

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

Line 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

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:

Line 1438: ,P_LEAVING_REASON => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LeavingReason')

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:

Line 1439: ,P_LEAVING_PERSON_TYPE_ID => hr_transaction_swi.getNumberValue(l_CommitNode,'LeavingPersonTypeId')

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;

Line 1447: merge_attachments(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,

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:

Line 1448: hr_transaction_swi.getNumberValue(l_CommitNode,'PersonDeploymentId'),

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;

Line 1983: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) then

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

Line 2047: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) then

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

Line 2122: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) 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

Line 2175: if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)) then

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