APPS.CUG_SR_ATTRIBUTE_INTF dependencies on CS_TP_FREETEXTS

Line 86: /* Cursor to query record from CS_TP_FREETEXTS for deleting records from freetext */

82: select choice_id, value, default_choice_flag
83: from cs_tp_choices_vl
84: where lookup_id = p_lookup_id;
85:
86: /* Cursor to query record from CS_TP_FREETEXTS for deleting records from freetext */
87: cursor c_tp_freetext (p_lookup_id number) IS
88: select freetext_id, lookup_id
89: from cs_tp_freetexts
90: where lookup_id = p_lookup_id;

Line 89: from cs_tp_freetexts

85:
86: /* Cursor to query record from CS_TP_FREETEXTS for deleting records from freetext */
87: cursor c_tp_freetext (p_lookup_id number) IS
88: select freetext_id, lookup_id
89: from cs_tp_freetexts
90: where lookup_id = p_lookup_id;
91:
92: /* Defining local variables*/
93: l_sr_attr c_sr_attr%ROWTYPE;

Line 433: CS_TP_FREETEXTS_PKG.DELETE_ROW(l_tp_freetext.freetext_id);

429: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
430: open c_tp_freetext (l_tmpl_quest_lookup_id);
431: fetch c_tp_freetext into l_tp_freetext;
432: while (c_tp_freetext%FOUND) loop
433: CS_TP_FREETEXTS_PKG.DELETE_ROW(l_tp_freetext.freetext_id);
434: fetch c_tp_freetext into l_tp_freetext;
435: end loop;
436: close c_tp_freetext;
437: