DBA Data[Home] [Help]

APPS.CS_TP_QUESTIONS_PVT dependencies on DUAL

Line 103: select CS_TP_LOOKUP_S.NEXTVAL into l_lookup_id from dual;

99: l_created_by := FND_GLOBAL.user_id;
100: l_login := fnd_global.login_id;
101:
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,

Line 121: select CS_TP_QUESTIONS_S.NEXTVAL into l_question_id from dual;

117: X_END_DATE_ACTIVE => NULL);
118:
119:
120: --Get the question id from the next available sequence number
121: select CS_TP_QUESTIONS_S.NEXTVAL into l_question_id from dual;
122:
123: --insert into question table
124:
125: CS_TP_QUESTIONS_PKG.INSERT_ROW (