APPS.CUG_SR_ATTRIBUTE_INTF dependencies on CS_TP_CHOICES_PVT

Line 116: l_template_question_choice cs_tp_choices_pvt.choice;

112:
113: l_template_rec cs_tp_templates_pvt.template;
114: l_template_link_list cs_tp_templates_pvt.template_link_list;
115: l_template_question_list cs_tp_questions_pvt.question;
116: l_template_question_choice cs_tp_choices_pvt.choice;
117: --l_template_quest_choice_list cs_tp_choices_pvt.choice_list;
118: l_template_question_freetext cs_tp_choices_pvt.freetext;
119:
120:

Line 117: --l_template_quest_choice_list cs_tp_choices_pvt.choice_list;

113: l_template_rec cs_tp_templates_pvt.template;
114: l_template_link_list cs_tp_templates_pvt.template_link_list;
115: l_template_question_list cs_tp_questions_pvt.question;
116: l_template_question_choice cs_tp_choices_pvt.choice;
117: --l_template_quest_choice_list cs_tp_choices_pvt.choice_list;
118: l_template_question_freetext cs_tp_choices_pvt.freetext;
119:
120:
121: BEGIN

Line 118: l_template_question_freetext cs_tp_choices_pvt.freetext;

114: l_template_link_list cs_tp_templates_pvt.template_link_list;
115: l_template_question_list cs_tp_questions_pvt.question;
116: l_template_question_choice cs_tp_choices_pvt.choice;
117: --l_template_quest_choice_list cs_tp_choices_pvt.choice_list;
118: l_template_question_freetext cs_tp_choices_pvt.freetext;
119:
120:
121: BEGIN
122:

Line 367: CS_TP_CHOICES_PVT.DELETE_CHOICE

363: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
364: open c_tp_choice (l_tmpl_quest_lookup_id);
365: fetch c_tp_choice into l_tp_choice;
366: while (c_tp_choice%FOUND) loop
367: CS_TP_CHOICES_PVT.DELETE_CHOICE
368: (
369: p_api_version_number => l_api_version,
370: p_init_msg_list => l_init_msg_list_true,
371: p_commit => l_init_commit_true,

Line 390: CS_TP_CHOICES_PVT.ADD_FREETEXT

386: l_template_question_freetext.mlast_updated_date:= l_sr_attr.last_update_date;
387:
388: fnd_file.put_line(fnd_file.log,'Calling the Add_Freetext API, SR Type: '
389: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
390: CS_TP_CHOICES_PVT.ADD_FREETEXT
391: (
392: p_api_version_number => l_api_version,
393: p_init_msg_list => l_init_msg_list_true,
394: p_commit => l_init_commit_true,

Line 413: CS_TP_CHOICES_PVT.DELETE_CHOICE

409:
410: open c_tp_choice (l_tmpl_quest_lookup_id);
411: fetch c_tp_choice into l_tp_choice;
412: while (c_tp_choice%FOUND) loop
413: CS_TP_CHOICES_PVT.DELETE_CHOICE
414: (
415: p_api_version_number => l_api_version,
416: p_init_msg_list => l_init_msg_list_true,
417: p_commit => l_init_commit_true,

Line 453: CS_TP_CHOICES_PVT.ADD_CHOICE

449: l_template_question_choice.mlast_updated_date := l_tmpl_choice_lookup.last_update_date;
450:
451: fnd_file.put_line(fnd_file.log,'Calling the Add_Choice API, SR Type: ' || l_sr_attr.sr_type ||
452: ' Attribute : '|| l_sr_attr.sr_name || ' Choice : ' ||l_tmpl_choice_lookup.meaning ||'- DESC:'||l_tmpl_choice_lookup.description);
453: CS_TP_CHOICES_PVT.ADD_CHOICE
454: (
455: p_api_version_number => l_api_version,
456: p_init_msg_list => l_init_msg_list_true,
457: p_commit => l_init_commit_true,

Line 612: l_templ_question_list cs_tp_choices_pvt.choice;

608: l_lookup_id number := 0;
609: l_choice_id number := 0;
610:
611: /* Define recordtype for Questions to be created */
612: l_templ_question_list cs_tp_choices_pvt.choice;
613:
614: BEGIN
615:
616: fnd_file.put_line(fnd_file.log,'Start of program');

Line 647: CS_TP_CHOICES_PVT.DELETE_CHOICE

643: -- ||' Attribute Name : ' || l_cug_sr_attr_ListName.sr_name || ' LOV Name : '
644: -- || l_cug_sr_attr_ListName.list_name
645: -- || ' ChoiceID : ' || l_tp_choice.value);
646:
647: CS_TP_CHOICES_PVT.DELETE_CHOICE
648: (
649: p_api_version_number => l_api_version,
650: p_init_msg_list => l_init_msg_list_true,
651: p_commit => l_init_commit_true,

Line 682: CS_TP_CHOICES_PVT.ADD_CHOICE

678: -- fnd_file.put_line(fnd_file.log,'Re-creating choices, Attribute Name : ' ||
679: -- l_cug_sr_attr_ListName.sr_name || ' LOV Name : ' || l_cug_sr_attr_ListName.list_name
680: -- || ' ChoiceName : ' || l_fnd_lookup.description);
681:
682: CS_TP_CHOICES_PVT.ADD_CHOICE
683: (
684: p_api_version_number => l_api_version,
685: p_init_msg_list => l_init_msg_list_true,
686: p_commit => l_init_commit_true,