DBA Data[Home] [Help]

APPS.HR_QUEST_ANS_VAL_SWI dependencies on HR_TRANSACTION_SWI

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

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

Line 447: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId',null)

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)

Line 448: ,p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',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

Line 449: ,p_field_id => hr_transaction_swi.getNumberValue(l_CommitNode,'FieldId',null)

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

Line 451: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value',null)

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:

Line 459: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId')

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

Line 461: ,p_value => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Value')

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:

Line 469: ( p_quest_answer_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestAnswerValId')

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