APPS.JTS_CONFIG_VERSIONS_PKG dependencies on JTS_CONFIG_VERSIONS_B

Line 7: -- Purpose : Table Handler for JTS_CONFIG_VERSIONS_B AND _TL tables

3:
4:
5: -- --------------------------------------------------------------------
6: -- Package name : JTS_CONFIG_VERSIONS_PKG
7: -- Purpose : Table Handler for JTS_CONFIG_VERSIONS_B AND _TL tables
8: -- History : 06-Jun-02 SHuh Created.
9: --
10: -- PROCEDURES
11: -- DELETE_ROW

Line 54: cursor C is select ROWID from JTS_CONFIG_VERSIONS_B

50: X_LAST_UPDATE_DATE in DATE,
51: X_LAST_UPDATED_BY in NUMBER,
52: X_LAST_UPDATE_LOGIN in NUMBER
53: ) is
54: cursor C is select ROWID from JTS_CONFIG_VERSIONS_B
55: where VERSION_ID = X_VERSION_ID
56: ;
57: begin
58: insert into JTS_CONFIG_VERSIONS_B (

Line 58: insert into JTS_CONFIG_VERSIONS_B (

54: cursor C is select ROWID from JTS_CONFIG_VERSIONS_B
55: where VERSION_ID = X_VERSION_ID
56: ;
57: begin
58: insert into JTS_CONFIG_VERSIONS_B (
59: VERSION_STATUS_CODE,
60: REPLAY_STATUS_CODE,
61: REPLAYED_ON,
62: REPLAYED_BY,

Line 225: from JTS_CONFIG_VERSIONS_B

221: ATTRIBUTE13,
222: ATTRIBUTE14,
223: ATTRIBUTE15,
224: SECURITY_GROUP_ID
225: from JTS_CONFIG_VERSIONS_B
226: where VERSION_ID = X_VERSION_ID
227: for update of VERSION_ID nowait;
228: recinfo c%rowtype;
229:

Line 350: update JTS_CONFIG_VERSIONS_B set

346: X_LAST_UPDATED_BY in NUMBER,
347: X_LAST_UPDATE_LOGIN in NUMBER
348: ) is
349: begin
350: update JTS_CONFIG_VERSIONS_B set
351: VERSION_STATUS_CODE = X_VERSION_STATUS_CODE,
352: REPLAY_STATUS_CODE = X_REPLAY_STATUS_CODE,
353: REPLAYED_ON = X_REPLAYED_ON,
354: REPLAYED_BY = X_REPLAYED_BY,

Line 405: DELETE FROM jts_config_versions_b

401: -- Deletes a row from jts_config_versions
402: PROCEDURE DELETE_ROW(p_version_id IN NUMBER
403: ) IS
404: BEGIN
405: DELETE FROM jts_config_versions_b
406: WHERE version_id = p_version_id;
407:
408: DELETE FROM jts_config_versions_tl
409: WHERE version_id = p_version_id;

Line 422: from JTS_CONFIG_VERSIONS_B B

418: begin
419: delete from JTS_CONFIG_VERSIONS_TL T
420: where not exists
421: (select NULL
422: from JTS_CONFIG_VERSIONS_B B
423: where B.VERSION_ID = T.VERSION_ID
424: );
425:
426: update JTS_CONFIG_VERSIONS_TL T set (