[Home] [Help]
102: --Create Lookup
103: select CS_TP_LOOKUP_S.NEXTVAL into l_lookup_id from dual;
104:
105: --Insert a new lookup, note DEFAULT_VALUE, X_START_DATE_ACTIVE, X_END_DATE_ACTIVE are null
106: CS_TP_LOOKUPS_PKG.INSERT_ROW (
107: X_ROWID => l_ROWID,
108: X_LOOKUP_ID => l_lookup_id,
109: X_LOOKUP_TYPE => P_One_Question.mAnswerType,
110: X_DEFAULT_VALUE => NULL,
375: CS_TP_TEMPLATE_QUESTIONS_PKG.DELETE_ROW (
376: X_TEMPLATE_ID => p_Template_ID,
377: X_QUESTION_ID => p_Question_ID);
378: --delete lookup
379: CS_TP_LOOKUPS_PKG.DELETE_ROW (l_lookup_id);
380: --delete question
381: CS_TP_QUESTIONS_PKG.DELETE_ROW (X_QUESTION_ID => p_Question_ID);
382:
383:
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: end if;
598: -- Construct query statement, open cursor, execute query statement, retrieve results
599: l_statement := 'SELECT Q.QUESTION_ID, Q.NAME, L.LOOKUP_TYPE, Q.MANDTORY_FLAG, Q.SCORING_FLAG, Q.LOOKUP_ID, Q.LAST_UPDATE_DATE, Q.NOTE_TYPE, Q.SHOW_ON_CREATION_FLAG '
600: || ' FROM CS_TP_QUESTIONS_VL Q, CS_TP_LOOKUPS L, CS_TP_TEMPLATE_QUESTIONS TQ' ||
601: ' where Q.LOOKUP_ID = L.LOOKUP_ID and TQ.QUESTION_ID = Q.QUESTION_ID and TQ.TEMPLATE_ID=:v_Template_ID';
602:
603: if (P_Display_Order is NULL OR P_Display_Order=FND_API.G_MISS_CHAR OR length(P_Display_Order)<=0 OR P_Display_Order =NORMAL) then
604: l_statement := l_statement || ' ORDER BY TQ.SEQUENCE_NUMBER ';
724: l_api_name CONSTANT VARCHAR2(30) := 'Show_Question';
725: l_api_version CONSTANT NUMBER := 1.0;
726: cursor C (v_Question_ID NUMBER) is
727: SELECT Q.QUESTION_ID, Q.NAME, L.LOOKUP_TYPE, Q.MANDTORY_FLAG, Q.SCORING_FLAG, Q.LOOKUP_ID, Q.LAST_UPDATE_DATE, Q.NOTE_TYPE, Q.SHOW_ON_CREATION_FLAG
728: FROM CS_TP_QUESTIONS_VL Q, CS_TP_LOOKUPS L where Q.LOOKUP_ID = L.LOOKUP_ID and Q.QUESTION_ID = v_Question_ID;
729: One_Question C%ROWTYPE;
730:
731: begin
732: -- Initialize message list if p_init_msg_list is set to TRUE.