APPS.JTS_CONFIG_VERSION_PVT dependencies on JTS_CONFIG_VERSIONS_TL

Line 178: l_description JTS_CONFIG_VERSIONS_TL.description%TYPE;

174: x_version_id OUT NUMBER) IS
175: l_queue_name JTS_CONFIG_VERSIONS_B.queue_name%TYPE;
176: l_version_number NUMBER := 1;
177: l_version_name JTS_CONFIG_VERSIONS_B.version_name%TYPE;
178: l_description JTS_CONFIG_VERSIONS_TL.description%TYPE;
179: l_config_name JTS_CONFIGURATIONS_B.config_name%TYPE;
180: BEGIN
181: x_version_id := GET_NEXT_VERSION_ID;
182: l_queue_name := C_QUEUE_PREFIX || x_version_id;

Line 262: insert into JTS_CONFIG_VERSIONS_TL (

258: FND_GLOBAL.user_id,
259: FND_GLOBAL.user_id
260: );
261:
262: insert into JTS_CONFIG_VERSIONS_TL (
263: VERSION_ID,
264: CONFIGURATION_ID,
265: DESCRIPTION,
266: CREATION_DATE,

Line 288: from JTS_CONFIG_VERSIONS_TL T

284: from FND_LANGUAGES L
285: where L.INSTALLED_FLAG in ('I', 'B')
286: and not exists
287: (select NULL
288: from JTS_CONFIG_VERSIONS_TL T
289: where T.VERSION_ID = X_VERSION_ID
290: and T.LANGUAGE = L.LANGUAGE_CODE);
291:
292: EXCEPTION

Line 305: DELETE FROM jts_config_versions_tl

301: BEGIN
302: DELETE FROM jts_config_versions_b
303: WHERE configuration_id = p_config_id;
304:
305: DELETE FROM jts_config_versions_tl
306: WHERE configuration_id = p_config_id;
307:
308: EXCEPTION
309: WHEN OTHERS THEN

Line 538: UPDATE jts_config_versions_tl

534: last_update_login = FND_GLOBAL.user_id
535: WHERE version_id = p_version_id;
536:
537: --take care of translation
538: UPDATE jts_config_versions_tl
539: SET description = p_version_desc,
540: last_update_date = sysdate,
541: last_updated_by = FND_GLOBAL.user_id,
542: last_update_login = FND_GLOBAL.user_id,