DBA Data[Home] [Help]

APPS.AMS_LIST_WORD_REPLACES_PVT dependencies on AMS_LIST_WORD_REPLACES_S

Line 41: SELECT AMS_LIST_WORD_REPLACES_S.NEXTVAL

37: l_wrd_rpl_rec wrd_rpl_rec_type := p_wrd_rpl_rec;
38: l_wrd_rpl_count NUMBER;
39:
40: CURSOR c_list_word_replace_seq IS
41: SELECT AMS_LIST_WORD_REPLACES_S.NEXTVAL
42: FROM DUAL;
43:
44: CURSOR c_list_word_replace_count(wrd_rpl_id IN NUMBER) IS
45: SELECT COUNT(*)

Line 306: UPDATE AMS_LIST_WORD_REPLACES SET

302:
303: AMS_Utility_PVT.debug_message(l_full_name||': update');
304: END IF;
305:
306: UPDATE AMS_LIST_WORD_REPLACES SET
307: last_update_date = SYSDATE,
308: last_updated_by = FND_GLOBAL.user_id,
309: last_update_login = FND_GLOBAL.conc_login_id,
310: object_version_number = l_wrd_rpl_rec.object_version_number + 1,