APPS.AMS_CELL_PVT dependencies on AMS_CELLS_ALL_TL

Line 166: INSERT INTO ams_cells_all_tl(

162: SYSDATE,
163: FND_PROFILE.value ('AMS_SRCGEN_USER_CITY')
164: );
165:
166: INSERT INTO ams_cells_all_tl(
167: cell_id,
168: language,
169: last_update_date,
170: last_updated_by,

Line 193: FROM ams_cells_all_tl t

189: FROM fnd_languages l
190: WHERE l.installed_flag in ('I', 'B')
191: AND NOT EXISTS(
192: SELECT NULL
193: FROM ams_cells_all_tl t
194: WHERE t.cell_id = l_cell_rec.cell_id
195: AND t.language = l.language_code );
196:
197: --dbms_output.put_line('returen status is: ' || x_return_status);

Line 400: FROM ams_cells_all_tl

396: FOR UPDATE NOWAIT;
397:
398: CURSOR c_cell_tl IS
399: SELECT cell_id
400: FROM ams_cells_all_tl
401: WHERE cell_id = p_cell_id
402: AND USERENV('LANG') IN (language, source_lang)
403: FOR UPDATE NOWAIT;
404:

Line 603: update ams_cells_all_tl set

599: AMS_Utility_PVT.debug_message(l_full_name ||': update b');
600: RAISE FND_API.g_exc_error;
601: END IF;
602:
603: update ams_cells_all_tl set
604: cell_name = l_cell_rec.cell_name,
605: description = l_cell_rec.description,
606: last_update_date = SYSDATE,
607: last_updated_by = FND_GLOBAL.user_id,