[Home] [Help]
460: l_current_date DATE :=FND_API.G_MISS_DATE;
461: l_last_updated_by VARCHAR2(200) :=FND_API.G_MISS_CHAR;
462: l_login VARCHAR2(200) :=FND_API.G_MISS_CHAR;
463: Cursor last_updateC (V_Question_ID Number) is
464: select last_update_date from CS_TP_QUESTIONS_VL where QUESTION_ID = V_Question_ID ;
465: l_last_update_date DATE;
466: begin
467: -- Initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean( p_init_msg_list ) THEN
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.