DBA Data[Home] [Help]

APPS.CS_TP_TEMPLATES_PVT dependencies on CS_TP_CHOICES_PVT

Line 2110: l_template_question_choice CS_TP_CHOICES_PVT.Choice;

2106: l_template_question CS_TP_QUESTIONS_PVT.Question;
2107: i NUMBER;
2108: initial_value NUMBER := 1;
2109: l_template_question_ID NUMBER;
2110: l_template_question_choice CS_TP_CHOICES_PVT.Choice;
2111: l_templ_quest_choice_list CS_TP_CHOICES_PVT.Choice_List;
2112: l_template_question_freetext CS_TP_CHOICES_PVT.FREETEXT;
2113: l_templ_quest_lookup_ID NUMBER;
2114: l_template_question_choice_ID NUMBER;

Line 2111: l_templ_quest_choice_list CS_TP_CHOICES_PVT.Choice_List;

2107: i NUMBER;
2108: initial_value NUMBER := 1;
2109: l_template_question_ID NUMBER;
2110: l_template_question_choice CS_TP_CHOICES_PVT.Choice;
2111: l_templ_quest_choice_list CS_TP_CHOICES_PVT.Choice_List;
2112: l_template_question_freetext CS_TP_CHOICES_PVT.FREETEXT;
2113: l_templ_quest_lookup_ID NUMBER;
2114: l_template_question_choice_ID NUMBER;
2115: l_template_question_text_ID NUMBER;

Line 2112: l_template_question_freetext CS_TP_CHOICES_PVT.FREETEXT;

2108: initial_value NUMBER := 1;
2109: l_template_question_ID NUMBER;
2110: l_template_question_choice CS_TP_CHOICES_PVT.Choice;
2111: l_templ_quest_choice_list CS_TP_CHOICES_PVT.Choice_List;
2112: l_template_question_freetext CS_TP_CHOICES_PVT.FREETEXT;
2113: l_templ_quest_lookup_ID NUMBER;
2114: l_template_question_choice_ID NUMBER;
2115: l_template_question_text_ID NUMBER;
2116:

Line 2315: CS_TP_CHOICES_PVT.Show_Choices (

2311:
2312: --//Next is to update the is new question conente according to the old
2313: --//Question content
2314: If(l_template_question_list(i).mAnswerType = 'CHOICE') Then
2315: CS_TP_CHOICES_PVT.Show_Choices (
2316: p_api_version_number => p_api_version_number,
2317: p_init_msg_list => l_init_msg_list_true,
2318: p_commit => l_init_commit_true,
2319: P_Lookup_Id => l_template_question_list(i).mLookUpID,

Line 2335: CS_TP_CHOICES_PVT.Add_Choice (

2331: l_template_question_choice.mLookupID := l_templ_quest_lookup_ID;
2332: l_template_question_choice.mScore :=
2333: l_templ_quest_choice_list(l_temp_counter).mScore;
2334:
2335: CS_TP_CHOICES_PVT.Add_Choice (
2336: p_api_version_number => p_api_version_number,
2337: p_init_msg_list => l_init_msg_list_true,
2338: p_commit => l_init_commit_true,
2339: p_One_Choice => l_template_question_choice,

Line 2351: CS_TP_CHOICES_PVT.Show_Freetext (

2347: l_temp_counter := 0;
2348: End If;
2349: If(l_template_question_list(i).mAnswerType = 'FREETEXT') Then
2350:
2351: CS_TP_CHOICES_PVT.Show_Freetext (
2352: p_api_version_number => p_api_version_number,
2353: p_init_msg_list => l_init_msg_list_true,
2354: p_commit => l_init_commit_true,
2355: P_Lookup_ID => l_template_question_list(i).mLookUpID,

Line 2363: CS_TP_CHOICES_PVT.Add_Freetext (

2359: X_Freetext => l_template_question_freetext);
2360:
2361: l_template_question_freetext.mLookUpID := l_templ_quest_lookup_ID;
2362:
2363: CS_TP_CHOICES_PVT.Add_Freetext (
2364: p_api_version_number => p_api_version_number,
2365: p_init_msg_list => l_init_msg_list_true,
2366: p_commit => l_init_commit_true,
2367: P_One_Freetext => l_template_question_freetext,