384: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
385: --
386: --Get the values for in/out parameters
387: --
388: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
389: l_rec_team_member_id := hr_transaction_swi.getNumberValue(l_CommitNode,'RecTeamMemberId');
390: --
391: if p_effective_date is null then
392: l_effective_date := trunc(sysdate);
385: --
386: --Get the values for in/out parameters
387: --
388: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
389: l_rec_team_member_id := hr_transaction_swi.getNumberValue(l_CommitNode,'RecTeamMemberId');
390: --
391: if p_effective_date is null then
392: l_effective_date := trunc(sysdate);
393: else
400: --
401: create_rec_team_member
402: (p_validate => p_validate
403: ,p_rec_team_member_id => l_rec_team_member_id
404: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
405: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
406: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
401: create_rec_team_member
402: (p_validate => p_validate
403: ,p_rec_team_member_id => l_rec_team_member_id
404: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
405: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
406: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
409: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
402: (p_validate => p_validate
403: ,p_rec_team_member_id => l_rec_team_member_id
404: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
405: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
406: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
409: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
410: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
403: ,p_rec_team_member_id => l_rec_team_member_id
404: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
405: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
406: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
409: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
410: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
411: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
404: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
405: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
406: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
409: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
410: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
411: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
412: ,p_object_version_number => l_object_version_number
405: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
406: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
409: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
410: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
411: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
412: ,p_object_version_number => l_object_version_number
413: ,p_return_status => l_return_status
406: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
409: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
410: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
411: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
412: ,p_object_version_number => l_object_version_number
413: ,p_return_status => l_return_status
414: );
407: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
408: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
409: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
410: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
411: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
412: ,p_object_version_number => l_object_version_number
413: ,p_return_status => l_return_status
414: );
415: --
419: --
420: update_rec_team_member
421: (p_validate => p_validate
422: ,p_rec_team_member_id => l_rec_team_member_id
423: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
424: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',NULL)
425: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
420: update_rec_team_member
421: (p_validate => p_validate
422: ,p_rec_team_member_id => l_rec_team_member_id
423: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
424: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',NULL)
425: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
421: (p_validate => p_validate
422: ,p_rec_team_member_id => l_rec_team_member_id
423: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
424: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',NULL)
425: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
429: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
422: ,p_rec_team_member_id => l_rec_team_member_id
423: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
424: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',NULL)
425: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
429: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
430: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
423: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
424: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',NULL)
425: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
429: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
430: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
431: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
424: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',NULL)
425: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
429: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
430: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
431: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
432: ,p_object_version_number => l_object_version_number
425: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
429: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
430: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
431: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
432: ,p_object_version_number => l_object_version_number
433: ,p_return_status => l_return_status
426: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
429: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
430: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
431: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
432: ,p_object_version_number => l_object_version_number
433: ,p_return_status => l_return_status
434: );
427: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
428: ,p_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
429: ,p_update_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
430: ,p_delete_allowed => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
431: ,p_interview_security => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
432: ,p_object_version_number => l_object_version_number
433: ,p_return_status => l_return_status
434: );
435: --