APPS.JTF_FM_MD_MIGRATION_PVT dependencies on JTF_FM_MIGRATION_HISTORY

Line 20: FROM JTF_FM_MIGRATION_HISTORY

16: IS
17: CURSOR c_check_log_csr(c_code VARCHAR2,
18: c_status VARCHAR2) IS
19: SELECT 1
20: FROM JTF_FM_MIGRATION_HISTORY
21: WHERE migration_code = c_code
22: AND status = c_status;
23: l_temp NUMBER;
24: BEGIN

Line 39: DELETE FROM JTF_FM_MIGRATION_HISTORY

35: p_status IN VARCHAR2,
36: x_status OUT NOCOPY VARCHAR2)
37: IS
38: BEGIN
39: DELETE FROM JTF_FM_MIGRATION_HISTORY
40: WHERE MIGRATION_CODE = p_code;
41: INSERT INTO JTF_FM_MIGRATION_HISTORY(MIGRATION_CODE,
42: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
43: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)

Line 41: INSERT INTO JTF_FM_MIGRATION_HISTORY(MIGRATION_CODE,

37: IS
38: BEGIN
39: DELETE FROM JTF_FM_MIGRATION_HISTORY
40: WHERE MIGRATION_CODE = p_code;
41: INSERT INTO JTF_FM_MIGRATION_HISTORY(MIGRATION_CODE,
42: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
43: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
44: VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,
45: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);

Line 60: UPDATE JTF_FM_MIGRATION_HISTORY

56: x_status OUT NOCOPY VARCHAR2)
57: IS
58: l_i NUMBER;
59: BEGIN
60: UPDATE JTF_FM_MIGRATION_HISTORY
61: SET STATUS = p_new_status,
62: LAST_UPDATE_DATE = SYSDATE
63: WHERE MIGRATION_CODE = p_code
64: AND STATUS = p_old_status;