438: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
439:
440: l_commitElement := xmldom.makeElement(l_CommitNode);
441: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
442: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
443:
444: if l_postState = '0' then
445:
446: insert_quest_answer_val
443:
444: if l_postState = '0' then
445:
446: insert_quest_answer_val
447: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId',null)
448: ,p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
449: ,p_field_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FieldId',null)
450: ,p_object_version_number => l_object_version_number
451: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value',null)
444: if l_postState = '0' then
445:
446: insert_quest_answer_val
447: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId',null)
448: ,p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
449: ,p_field_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FieldId',null)
450: ,p_object_version_number => l_object_version_number
451: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value',null)
452: ,p_validate => p_validate
445:
446: insert_quest_answer_val
447: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId',null)
448: ,p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
449: ,p_field_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FieldId',null)
450: ,p_object_version_number => l_object_version_number
451: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value',null)
452: ,p_validate => p_validate
453: ,p_return_status => l_return_status
447: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId',null)
448: ,p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
449: ,p_field_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FieldId',null)
450: ,p_object_version_number => l_object_version_number
451: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value',null)
452: ,p_validate => p_validate
453: ,p_return_status => l_return_status
454: );
455:
455:
456: elsif l_postState = '2' then
457:
458: update_quest_answer_val
459: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId')
460: ,p_object_version_number => l_object_version_number
461: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value')
462: ,p_validate => p_validate
463: ,p_return_status => l_return_status
457:
458: update_quest_answer_val
459: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId')
460: ,p_object_version_number => l_object_version_number
461: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value')
462: ,p_validate => p_validate
463: ,p_return_status => l_return_status
464: );
465:
465:
466: elsif l_postState = '3' then
467:
468: delete_quest_answer_val
469: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId')
470: ,p_object_version_number => l_object_version_number
471: ,p_validate => p_validate
472: ,p_return_status => l_return_status
473: );