441:
442: if l_postState = '0' then
443:
444: create_quest_answer
445: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
446: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
447: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
448: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId',null)
449: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
442: if l_postState = '0' then
443:
444: create_quest_answer
445: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
446: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
447: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
448: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId',null)
449: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
450: ,p_effective_date => p_effective_date
443:
444: create_quest_answer
445: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
446: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
447: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
448: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId',null)
449: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
450: ,p_effective_date => p_effective_date
451: ,p_validate => p_validate
444: create_quest_answer
445: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
446: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
447: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
448: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId',null)
449: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
450: ,p_effective_date => p_effective_date
451: ,p_validate => p_validate
452: ,p_return_status => l_return_status
445: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)
446: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
447: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
448: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId',null)
449: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
450: ,p_effective_date => p_effective_date
451: ,p_validate => p_validate
452: ,p_return_status => l_return_status
453: );
454:
455: elsif l_postState = '2' then
456:
457: update_quest_answer
458: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')
459: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
460: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
461: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId')
462: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
455: elsif l_postState = '2' then
456:
457: update_quest_answer
458: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')
459: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
460: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
461: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId')
462: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
463: ,p_effective_date => p_effective_date
456:
457: update_quest_answer
458: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')
459: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
460: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
461: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId')
462: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
463: ,p_effective_date => p_effective_date
464: ,p_validate => p_validate
457: update_quest_answer
458: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')
459: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
460: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
461: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId')
462: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
463: ,p_effective_date => p_effective_date
464: ,p_validate => p_validate
465: ,p_return_status => l_return_status
458: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')
459: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
460: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
461: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId')
462: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
463: ,p_effective_date => p_effective_date
464: ,p_validate => p_validate
465: ,p_return_status => l_return_status
466: );
467:
468: elsif l_postState = '3' then
469:
470: delete_quest_answer
471: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')
472: ,p_validate => p_validate
473: ,p_return_status => l_return_status
474: );
475: