APPS.CS_TP_QUESTIONS_PVT dependencies on CS_TP_TEMPLATE_QUESTIONS

Line 69: select max(SEQUENCE_NUMBER) from CS_TP_TEMPLATE_QUESTIONS;

65: l_created_by NUMBER :=FND_API.G_MISS_NUM;
66: l_login NUMBER :=FND_API.G_MISS_NUM;
67: l_ROWID VARCHAR2(30);
68: Cursor C is
69: select max(SEQUENCE_NUMBER) from CS_TP_TEMPLATE_QUESTIONS;
70: l_max_sequence NUMBER;
71:
72: begin
73: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 158: CS_TP_TEMPLATE_QUESTIONS_PKG.INSERT_ROW (

154:
155:
156: --insert into the question template linking table
157:
158: CS_TP_TEMPLATE_QUESTIONS_PKG.INSERT_ROW (
159: X_ROWID => l_ROWID,
160: X_TEMPLATE_ID => P_Template_ID,
161: X_QUESTION_ID => l_question_id,
162: X_SEQUENCE_NUMBER => l_max_sequence + 1,

Line 375: CS_TP_TEMPLATE_QUESTIONS_PKG.DELETE_ROW (

371: end if;
372: close lookup_c;
373:
374: --delete template question link
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);

Line 495: CS_TP_TEMPLATE_QUESTIONS_PKG.UPDATE_ROW (

491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: end if;
494:
495: CS_TP_TEMPLATE_QUESTIONS_PKG.UPDATE_ROW (
496: X_TEMPLATE_ID => P_Template_ID,
497: X_QUESTION_ID => P_Questions (i).mQuestionID,
498: X_NOTE_TYPE => P_Questions (i).mNoteType,
499: X_SHOW_ON_CREATION_FLAG =>

Line 600: || ' FROM CS_TP_QUESTIONS_VL Q, CS_TP_LOOKUPS L, CS_TP_TEMPLATE_QUESTIONS TQ' ||

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 ';