17: l_api_version CONSTANT NUMBER := 1.0;
18: l_api_name CONSTANT VARCHAR2 (30) := 'IN_REPLAY_STATUS';
19: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
20: BEGIN
21: IF NOT fnd_api.compatible_api_call ( l_api_version,
22: p_api_version,
23: l_api_name,
24: G_PKG_NAME
25: )
23: l_api_name,
24: G_PKG_NAME
25: )
26: THEN
27: RAISE fnd_api.g_exc_unexpected_error;
28: END IF;
29:
30: -- Replay Status column, could change depending on the business logic
31: IF ( p_status IN (C_SUBMIT_REPLAY_STATUS, C_FAIL_REPLAY_STATUS, C_CANCEL_REPLAY_STATUS,
46: l_api_version CONSTANT NUMBER := 1.0;
47: l_api_name CONSTANT VARCHAR2 (30) := 'IN_VERSION_STATUS';
48: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
49: BEGIN
50: IF NOT fnd_api.compatible_api_call ( l_api_version,
51: p_api_version,
52: l_api_name,
53: G_PKG_NAME
54: )
52: l_api_name,
53: G_PKG_NAME
54: )
55: THEN
56: RAISE fnd_api.g_exc_unexpected_error;
57: END IF;
58:
59: -- Version Status column, could change depending on the business logic
60: IF (p_status IN (C_INIT_VERSION_STATUS, C_PROCESS_VERSION_STATUS, C_COMPLETE_VERSION_STATUS)) THEN
76: l_api_version CONSTANT NUMBER := 1.0;
77: l_api_name CONSTANT VARCHAR2 (30) := 'NOT_REPLAYED';
78: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
79: BEGIN
80: IF NOT fnd_api.compatible_api_call ( l_api_version,
81: p_api_version,
82: l_api_name,
83: G_PKG_NAME
84: )
82: l_api_name,
83: G_PKG_NAME
84: )
85: THEN
86: RAISE fnd_api.g_exc_unexpected_error;
87: END IF;
88:
89: -- Replay has been cancelled or Replay was never submitted, could change depending on the business logic
90: IF (p_status = C_NOSUBMIT_REPLAY_STATUS OR p_status = C_CANCEL_REPLAY_STATUS) THEN
114: l_replayed_by_name FND_USER.user_name%TYPE;
115: l_not_replayed BOOLEAN := TRUE;
116: l_in_replay BOOLEAN := FALSE;
117: BEGIN
118: IF NOT fnd_api.compatible_api_call ( l_api_version,
119: p_api_version,
120: l_api_name,
121: G_PKG_NAME
122: )
120: l_api_name,
121: G_PKG_NAME
122: )
123: THEN
124: RAISE fnd_api.g_exc_unexpected_error;
125: END IF;
126:
127: JTS_CONFIG_UTIL_PVT.GET_VERSIONS_CURSOR(p_api_version,
128: p_config_id,
187: AND u.user_id (+) = vs.created_by
188: ORDER BY vs.creation_date DESC;
189:
190: BEGIN
191: IF NOT fnd_api.compatible_api_call ( l_api_version,
192: p_api_version,
193: l_api_name,
194: G_PKG_NAME
195: )
193: l_api_name,
194: G_PKG_NAME
195: )
196: THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
199:
200: x_replay_status_code := NULL;
201: x_replay_status := NULL;
244: l_api_version CONSTANT NUMBER := 1.0;
245: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_VERSION_STATUS';
246: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
247: BEGIN
248: IF NOT fnd_api.compatible_api_call ( l_api_version,
249: p_api_version,
250: l_api_name,
251: G_PKG_NAME
252: )
250: l_api_name,
251: G_PKG_NAME
252: )
253: THEN
254: RAISE fnd_api.g_exc_unexpected_error;
255: END IF;
256:
257: INSERT INTO jts_config_version_statuses
258: (
284: p_version_id,
285: p_status);
286: END IF;
287:
288: IF (FND_API.to_boolean(p_commit)) THEN
289: COMMIT;
290: END IF;
291:
292: EXCEPTION
300: l_api_version CONSTANT NUMBER := 1.0;
301: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_VERSION_STATUSES';
302: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
303: BEGIN
304: IF NOT fnd_api.compatible_api_call ( l_api_version,
305: p_api_version,
306: l_api_name,
307: G_PKG_NAME
308: )
306: l_api_name,
307: G_PKG_NAME
308: )
309: THEN
310: RAISE fnd_api.g_exc_unexpected_error;
311: END IF;
312:
313: DELETE FROM jts_config_version_statuses
314: WHERE version_id = p_version_id;
327: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
328: versions_csr JTS_CONFIG_UTIL_PVT.Versions_Csr_Type;
329: l_version_id JTS_CONFIG_VERSION_STATUSES.version_id%TYPE;
330: BEGIN
331: IF NOT fnd_api.compatible_api_call ( l_api_version,
332: p_api_version,
333: l_api_name,
334: G_PKG_NAME
335: )
333: l_api_name,
334: G_PKG_NAME
335: )
336: THEN
337: RAISE fnd_api.g_exc_unexpected_error;
338: END IF;
339:
340: JTS_CONFIG_UTIL_PVT.GET_VERSIONS_CURSOR(p_api_version,
341: p_config_id,