APPS.CS_TP_QUESTIONS_PVT dependencies on CS_TP_FREETEXTS

Line 348: is select count (*) from CS_TP_FREETEXTS where LOOKUP_ID = v_lookup_id;

344: select lookup_id from CS_TP_QUESTIONS_B where question_id = p_Question_ID;
345:
346: Cursor
347: freetext_num_c (v_lookup_id NUMBER)
348: is select count (*) from CS_TP_FREETEXTS where LOOKUP_ID = v_lookup_id;
349: Cursor
350: free_text_c (v_lookup_id NUMBER) is
351: select freetext_id from CS_TP_FREETEXTS where LOOKUP_ID = v_lookup_id;
352: Cursor

Line 351: select freetext_id from CS_TP_FREETEXTS where LOOKUP_ID = v_lookup_id;

347: freetext_num_c (v_lookup_id NUMBER)
348: is select count (*) from CS_TP_FREETEXTS where LOOKUP_ID = v_lookup_id;
349: Cursor
350: free_text_c (v_lookup_id NUMBER) is
351: select freetext_id from CS_TP_FREETEXTS where LOOKUP_ID = v_lookup_id;
352: Cursor
353: choice_c (v_lookup_id NUMBER) is
354: select choice_id from CS_TP_CHOICES_VL where LOOKUP_ID = v_lookup_id;
355:

Line 393: CS_TP_FREETEXTS_PKG.DELETE_ROW (

389: if (l_freetext_num=1) then
390: open free_text_c(l_lookup_id);
391: fetch free_text_c into l_freetext_id;
392: close free_text_c;
393: CS_TP_FREETEXTS_PKG.DELETE_ROW (
394: X_FREETEXT_ID => l_freetext_id);
395:
396: elsif (l_freetext_num>1) then
397: X_Return_Status := FND_API.G_RET_STS_ERROR;