DBA Data[Home] [Help]

APPS.HR_QUEST_ANSWER_SWI dependencies on HR_TRANSACTION_SWI

Line 445: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId',null)

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)

Line 446: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',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

Line 447: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)

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

Line 448: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId',null)

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

Line 449: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)

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

Line 458: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')

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

Line 459: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')

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

Line 460: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')

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

Line 461: ,p_type_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TypeObjectId')

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

Line 462: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')

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

Line 471: ( p_questionnaire_answer_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireAnswerId')

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: