DBA Data[Home] [Help]

APPS.MSC_ASK_ORACLE dependencies on MSC_QUESTIONS_S

Line 37: SELECT msc_questions_s.nextval

33: IF (x_mode = 1) THEN
34: -- First insert into msc_questions_b and then into msc_questions_tl
35: -- Note that the sequence will ensure that all question_ids are
36: -- greater than 5001
37: SELECT msc_questions_s.nextval
38: INTO x_question_id
39: FROM dual;
40: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
41:

Line 105: SELECT msc_questions_s.nextval

101: and language = x_lang_code);
102:
103: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));
104: ELSIF (x_mode = 2) THEN -- copy mode
105: SELECT msc_questions_s.nextval
106: INTO x_question_id
107: FROM dual;
108: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
109: