eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTS_CONFIG_VERSION_PVT dependencies on JTS_CONFIG_VERSIONS_B

Line 33: FROM jts_config_versions_b

29: l_exists NUMBER := 0;
30: BEGIN
31: SELECT count(*)
32: INTO l_exists
33: FROM jts_config_versions_b
34: WHERE configuration_id = p_config_id;
35:
36: IF (l_exists > 0) THEN
37:

Line 40: FROM jts_config_versions_b

36: IF (l_exists > 0) THEN
37:
38: SELECT max(version_number)
39: INTO l_max_version
40: FROM jts_config_versions_b
41: WHERE configuration_id = p_config_id;
42:
43: return (l_max_version + 1);
44: ELSE

Line 58: l_version_id JTS_CONFIG_VERSIONS_B.version_ID%TYPE;

54: --
55: -- Returns the next sequence in jts_config_versions for
56: -- version_id
57: FUNCTION GET_NEXT_VERSION_ID return NUMBER IS
58: l_version_id JTS_CONFIG_VERSIONS_B.version_ID%TYPE;
59: BEGIN
60: SELECT jts_config_versions_b_s.NEXTVAL
61: INTO l_version_id
62: FROM sys.dual;

Line 60: SELECT jts_config_versions_b_s.NEXTVAL

56: -- version_id
57: FUNCTION GET_NEXT_VERSION_ID return NUMBER IS
58: l_version_id JTS_CONFIG_VERSIONS_B.version_ID%TYPE;
59: BEGIN
60: SELECT jts_config_versions_b_s.NEXTVAL
61: INTO l_version_id
62: FROM sys.dual;
63:
64: return (l_version_id);

Line 76: l_version_id JTS_CONFIG_VERSIONS_B.version_id%TYPE;

72: -- Returns the versionin jts_config_versions for
73: -- version_name and configuration_id
74: FUNCTION GET_VERSION_ID(p_version_name IN VARCHAR2,
75: p_config_id IN NUMBER) return NUMBER IS
76: l_version_id JTS_CONFIG_VERSIONS_B.version_id%TYPE;
77: BEGIN
78:
79: SELECT version_id
80: INTO l_version_id

Line 81: FROM jts_config_versions_b

77: BEGIN
78:
79: SELECT version_id
80: INTO l_version_id
81: FROM jts_config_versions_b
82: WHERE version_name = p_version_name
83: AND configuration_id = p_config_id;
84:
85: return (l_version_id);

Line 101: l_version_id JTS_CONFIG_VERSIONS_B.version_id%TYPE;

97: p_version_id IN NUMBER,
98: p_config_id IN NUMBER
99: ) RETURN BOOLEAN IS
100: l_count NUMBER := 0;
101: l_version_id JTS_CONFIG_VERSIONS_B.version_id%TYPE;
102: BEGIN
103: SELECT count(*)
104: INTO l_count
105: FROM jts_config_versions_vl

Line 175: l_queue_name JTS_CONFIG_VERSIONS_B.queue_name%TYPE;

171: -- at this time
172: PROCEDURE INSERT_ROW(p_configuration_id IN NUMBER,
173: p_init_version IN VARCHAR2,
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;

Line 177: l_version_name JTS_CONFIG_VERSIONS_B.version_name%TYPE;

173: p_init_version IN VARCHAR2,
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;

Line 204: insert into JTS_CONFIG_VERSIONS_B (

200: --nodpfxml FND_MESSAGE.set_token('CONFIG_NAME', l_config_name);
201: l_description := substrb(FND_MESSAGE.get, 1, 240);
202:
203:
204: insert into JTS_CONFIG_VERSIONS_B (
205: VERSION_ID,
206: VERSION_NAME,
207: CONFIGURATION_ID,
208: VERSION_NUMBER,

Line 298: -- Deletes rows from jts_config_versions based on configuration_id

294: APP_EXCEPTION.RAISE_EXCEPTION;
295: END INSERT_ROW;
296:
297:
298: -- Deletes rows from jts_config_versions based on configuration_id
299: PROCEDURE DELETE_ROWS(p_config_id IN NUMBER
300: ) IS
301: BEGIN
302: DELETE FROM jts_config_versions_b

Line 302: DELETE FROM jts_config_versions_b

298: -- Deletes rows from jts_config_versions based on configuration_id
299: PROCEDURE DELETE_ROWS(p_config_id IN NUMBER
300: ) IS
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;

Line 421: UPDATE jts_config_versions_b

417: THEN
418: RAISE fnd_api.g_exc_unexpected_error;
419: END IF;
420:
421: UPDATE jts_config_versions_b
422: SET version_status_code = p_status,
423: last_update_date = sysdate,
424: last_updated_by = FND_GLOBAL.user_id
425: WHERE version_id = p_version_id;

Line 449: UPDATE jts_config_versions_b

445: THEN
446: RAISE fnd_api.g_exc_unexpected_error;
447: END IF;
448:
449: UPDATE jts_config_versions_b
450: SET replay_status_code = p_status,
451: replayed_on = sysdate,
452: replayed_by = FND_GLOBAL.user_id,
453: last_update_date = sysdate,

Line 478: UPDATE jts_config_versions_b

474: THEN
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477:
478: UPDATE jts_config_versions_b
479: SET last_update_date = sysdate,
480: last_updated_by = FND_GLOBAL.user_id
481: WHERE version_id = p_version_id;
482:

Line 530: UPDATE jts_config_versions_b

526: p_version_rec => l_version_rec,
527: x_return_status => x_return_status);
528:
529: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
530: UPDATE jts_config_versions_b
531: SET version_name = p_version_name,
532: last_update_date = sysdate,
533: last_updated_by = FND_GLOBAL.user_id,
534: last_update_login = FND_GLOBAL.user_id