DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT dependencies on DUAL

Line 85: select CS_TP_CHOICES_S.NEXTVAL into l_choice_id from dual;

81: l_current_date := sysdate;
82: l_created_by := FND_GLOBAL.user_id;
83: l_login := fnd_global.login_id;
84:
85: select CS_TP_CHOICES_S.NEXTVAL into l_choice_id from dual;
86: CS_TP_CHOICES_PKG.INSERT_ROW (
87: X_ROWID => l_ROWID,
88: X_CHOICE_ID => l_choice_id,
89: X_LOOKUP_ID => P_One_Choice.mLookupID,

Line 575: select CS_TP_FREETEXTS_S.NEXTVAL into l_freetext_id from dual;

571: fetch FreetextC into l_freetext_update_id;
572: close FreeTextC;
573:
574: if (l_freetext_update_id is NULL ) then
575: select CS_TP_FREETEXTS_S.NEXTVAL into l_freetext_id from dual;
576: CS_TP_FREETEXTS_PKG.INSERT_ROW (
577: X_ROWID => l_ROWID,
578: X_FREETEXT_ID => l_freetext_id,
579: X_LOOKUP_ID => P_One_Freetext.mLookupID,