APPS.JTS_CONFIG_VERSION_FLOW_PVT dependencies on JTS_CONFIG_VERSION_FLOWS

Line 22: FROM jts_config_version_flows vf,

18: BEGIN
19:
20: SELECT COUNT(*)
21: INTO l_completed
22: FROM jts_config_version_flows vf,
23: jts_setup_flows_b sf
24: WHERE version_id = p_version_id
25: AND complete_flag = 'Y'
26: AND sf.flow_id = vf.flow_id

Line 31: FROM jts_config_version_flows vf,

27: AND sf.has_child_flag = 'N';
28:
29: SELECT COUNT(*)
30: INTO l_total
31: FROM jts_config_version_flows vf,
32: jts_setup_flows_b sf
33: WHERE version_id = p_version_id
34: AND sf.flow_id = vf.flow_id
35: AND sf.has_child_flag = 'N';

Line 68: UPDATE jts_config_version_flows

64: RAISE fnd_api.g_exc_unexpected_error;
65: END IF;
66:
67: --propagate the changes up the root for last update fields
68: UPDATE jts_config_version_flows
69: SET complete_flag = p_complete_flag,
70: last_updated_by = FND_GLOBAL.user_id,
71: last_update_login = FND_GLOBAL.user_id,
72: last_update_date = sysdate

Line 82: UPDATE jts_config_version_flows

78: -- Propagate last_update information up to the parent right below the root level
79: WHILE (l_flow_id IS NOT NULL) LOOP
80: l_parent_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(l_flow_id);
81: IF (l_parent_id IS NOT NULL) THEN --not at root level yet
82: UPDATE jts_config_version_flows
83: SET last_updated_by = FND_GLOBAL.user_id,
84: last_update_login = FND_GLOBAL.user_id,
85: last_update_date = sysdate
86: WHERE version_id = p_version_id

Line 119: INSERT INTO jts_config_version_flows(

115: RAISE fnd_api.g_exc_unexpected_error;
116: END IF;
117:
118: FOR I IN 1..p_flow_hiearchy.count LOOP
119: INSERT INTO jts_config_version_flows(
120: version_id,
121: flow_id,
122: complete_flag,
123: object_version_number,

Line 147: --Deletes from jts_config_version_flows

143: WHEN OTHERS THEN
144: APP_EXCEPTION.RAISE_EXCEPTION;
145: END CREATE_VERSION_FLOWS;
146:
147: --Deletes from jts_config_version_flows
148: PROCEDURE DELETE_VERSION_FLOWS(p_api_version IN Number,
149: p_version_id IN NUMBER) IS
150: l_api_version CONSTANT NUMBER := 1.0;
151: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_VERSION_FLOWS';

Line 163: DELETE FROM jts_config_version_flows

159: THEN
160: RAISE fnd_api.g_exc_unexpected_error;
161: END IF;
162:
163: DELETE FROM jts_config_version_flows
164: WHERE version_id = p_version_id;
165:
166: EXCEPTION
167: WHEN NO_DATA_FOUND THEN

Line 173: -- Deletes all records from jts_config_version_flows where

169: WHEN OTHERS THEN
170: APP_EXCEPTION.RAISE_EXCEPTION;
171: END DELETE_VERSION_FLOWS;
172:
173: -- Deletes all records from jts_config_version_flows where
174: -- version_id exists for p_config_id in versions table
175: PROCEDURE DELETE_CONFIG_VERSION_FLOWS(p_api_version IN Number,
176: p_config_id IN NUMBER) IS
177: l_api_version CONSTANT NUMBER := 1.0;

Line 180: l_version_id JTS_CONFIG_VERSION_FLOWS.version_id%TYPE;

176: p_config_id IN NUMBER) IS
177: l_api_version CONSTANT NUMBER := 1.0;
178: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_CONFIG_VERSION_FLOWS';
179: versions_csr JTS_CONFIG_UTIL_PVT.Versions_Csr_Type;
180: l_version_id JTS_CONFIG_VERSION_FLOWS.version_id%TYPE;
181: BEGIN
182:
183: IF NOT fnd_api.compatible_api_call ( l_api_version,
184: p_api_version,

Line 199: DELETE FROM jts_config_version_flows

195: LOOP
196: FETCH versions_csr INTO l_version_id;
197: EXIT WHEN versions_csr%NOTFOUND;
198:
199: DELETE FROM jts_config_version_flows
200: WHERE version_id = l_version_id;
201: END LOOP;
202:
203: CLOSE versions_csr;

Line 223: FROM jts_config_version_flows v,

219: CURSOR vflows_csr IS
220: SELECT version_id, flow_id, v.complete_flag,
221: v.creation_date, v.created_by, v.last_update_date, v.last_updated_by, v.last_update_login,
222: u1.user_name, u2.user_name
223: FROM jts_config_version_flows v,
224: fnd_user u1,
225: fnd_user u2
226: WHERE version_id = p_version_id
227: AND u1.user_id (+) = v.created_by