APPS.IBE_M_MIGRATION_PVT dependencies on IBE_MIGRATION_HISTORY

Line 38: FROM IBE_MIGRATION_HISTORY

34: IS
35: CURSOR c_check_log_csr(c_code VARCHAR2,
36: c_status VARCHAR2) IS
37: SELECT 1
38: FROM IBE_MIGRATION_HISTORY
39: WHERE migration_code = c_code
40: AND status = c_status;
41:
42: CURSOR c_check_item_migrated IS

Line 72: DELETE FROM IBE_MIGRATION_HISTORY

68: p_status IN VARCHAR2,
69: x_status OUT NOCOPY VARCHAR2)
70: IS
71: BEGIN
72: DELETE FROM IBE_MIGRATION_HISTORY
73: WHERE MIGRATION_CODE = p_code;
74: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
75: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
76: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)

Line 74: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,

70: IS
71: BEGIN
72: DELETE FROM IBE_MIGRATION_HISTORY
73: WHERE MIGRATION_CODE = p_code;
74: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
75: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
76: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
77: VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,
78: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);

Line 91: UPDATE IBE_MIGRATION_HISTORY

87: p_new_status IN VARCHAR2,
88: x_status OUT NOCOPY VARCHAR2)
89: IS
90: BEGIN
91: UPDATE IBE_MIGRATION_HISTORY
92: SET STATUS = p_new_status,
93: LAST_UPDATE_DATE = SYSDATE
94: WHERE MIGRATION_CODE = p_code
95: AND STATUS = p_old_status;

Line 104: -- update ibe_migration_history

100: END update_log;
101:
102: -- Migration for context
103: -- p_mode: 'EVALUATION', 'EXECUTION', 'ROLLBACK'
104: -- update ibe_migration_history
105: PROCEDURE context_mig(p_mode IN VARCHAR2,
106: x_status OUT NOCOPY VARCHAR2,
107: x_content_component_tbl OUT NOCOPY CONTENT_COMPONENT_TBL_TYPE)
108: IS

Line 125: FROM IBE_MIGRATION_HISTORY

121: WHERE CONTEXT_ID = c_context_id;
122:
123: CURSOR c_get_rollback_csr IS
124: SELECT creation_date, last_update_date
125: FROM IBE_MIGRATION_HISTORY
126: WHERE MIGRATION_CODE = 'IBE_CONTENT_COMPONENT'
127: AND STATUS = 'SUCCESS';
128:
129: l_content_component_tbl CONTENT_COMPONENT_TBL_TYPE;

Line 145: FROM IBE_MIGRATION_HISTORY

141: l_module VARCHAR2(30);
142:
143: CURSOR c_get_code(c_migcode VARCHAR2) IS
144: SELECT 1
145: FROM IBE_MIGRATION_HISTORY
146: WHERE MIGRATION_CODE = c_migcode;
147: BEGIN
148: SAVEPOINT context_mig;
149: l_migcode := 'IBE_CONTENT_COMPONENT';

Line 158: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,

154: OPEN c_get_code(l_migcode);
155: FETCH c_get_code INTO l_i;
156: IF (c_get_code%NOTFOUND) THEN
157: CLOSE c_get_code;
158: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
159: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
160: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
161: VALUES(l_migcode, 0, FND_GLOBAL.user_id, SYSDATE,
162: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, 'START');

Line 231: UPDATE IBE_MIGRATION_HISTORY

227: ||l_content_component_tbl(l_j).component_type_code);
228: END IF;
229: END LOOP;
230: END IF;
231: UPDATE IBE_MIGRATION_HISTORY
232: SET STATUS = 'SUCCESS',
233: LAST_UPDATE_DATE = SYSDATE
234: WHERE MIGRATION_CODE = l_migcode
235: AND STATUS = 'START';

Line 1611: FROM IBE_MIGRATION_HISTORY

1607: IS
1608: CURSOR c_get_date_csr(c_code VARCHAR2,
1609: c_status VARCHAR2) IS
1610: SELECT last_update_date
1611: FROM IBE_MIGRATION_HISTORY
1612: WHERE migration_code = c_code
1613: AND status = c_status;
1614: CURSOR c1(l_date IN DATE) IS
1615: SELECT attachment_id,object_version_number FROM jtf_amv_attachments a

Line 2153: -- Insert the log into IBE_MIGRATION_HISTORY

2149: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2150: END IF;
2151: END IF;
2152: END IF;
2153: -- Insert the log into IBE_MIGRATION_HISTORY
2154: IF (p_clean_flag = 'Y') THEN
2155: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2156: printDebuglog('Clean old data');
2157: END IF;