APPS.JTS_CONFIGURATIONS_PKG dependencies on JTS_CONFIGURATIONS_B

Line 7: -- Purpose : Table Handler for jts_configurations_b and _tl tables

3:
4:
5: -- --------------------------------------------------------------------
6: -- Package name : JTS_CONFIGURATIONS_PKG
7: -- Purpose : Table Handler for jts_configurations_b and _tl tables
8: -- History : 06-Jun-02 SHuh Created.
9: --
10: -- PROCEDURES
11: -- DELETE_ROW

Line 23: DELETE FROM jts_configurations_b

19: -- Deletes a row from jts_configurations table
20: PROCEDURE DELETE_ROW(p_config_id IN NUMBER
21: ) IS
22: BEGIN
23: DELETE FROM jts_configurations_b
24: WHERE configuration_id = p_config_id;
25:
26: DELETE FROM jts_configurations_tl
27: WHERE configuration_id = p_config_id;

Line 65: cursor C is select ROWID from JTS_CONFIGURATIONS_B

61: X_LAST_UPDATE_DATE in DATE,
62: X_LAST_UPDATED_BY in NUMBER,
63: X_LAST_UPDATE_LOGIN in NUMBER
64: ) is
65: cursor C is select ROWID from JTS_CONFIGURATIONS_B
66: where CONFIGURATION_ID = X_CONFIGURATION_ID
67: ;
68: begin
69: insert into JTS_CONFIGURATIONS_B (

Line 69: insert into JTS_CONFIGURATIONS_B (

65: cursor C is select ROWID from JTS_CONFIGURATIONS_B
66: where CONFIGURATION_ID = X_CONFIGURATION_ID
67: ;
68: begin
69: insert into JTS_CONFIGURATIONS_B (
70: CONFIGURATION_ID,
71: CONFIG_NAME,
72: FLOW_ID,
73: RECORD_MODE,

Line 214: from JTS_CONFIGURATIONS_B

210: ATTRIBUTE13,
211: ATTRIBUTE14,
212: ATTRIBUTE15,
213: SECURITY_GROUP_ID
214: from JTS_CONFIGURATIONS_B
215: where CONFIGURATION_ID = X_CONFIGURATION_ID
216: for update of CONFIGURATION_ID nowait;
217: recinfo c%rowtype;
218:

Line 324: update JTS_CONFIGURATIONS_B set

320: X_LAST_UPDATED_BY in NUMBER,
321: X_LAST_UPDATE_LOGIN in NUMBER
322: ) is
323: begin
324: update JTS_CONFIGURATIONS_B set
325: CONFIG_NAME = X_CONFIG_NAME,
326: FLOW_ID = X_FLOW_ID,
327: RECORD_MODE = X_RECORD_MODE,
328: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 375: from JTS_CONFIGURATIONS_B B

371: begin
372: delete from JTS_CONFIGURATIONS_TL T
373: where not exists
374: (select NULL
375: from JTS_CONFIGURATIONS_B B
376: where B.CONFIGURATION_ID = T.CONFIGURATION_ID
377: );
378:
379: update JTS_CONFIGURATIONS_TL T set (