APPS.JTF_FM_MD_MIGRATION_PVT dependencies on JTF_FM_MIG_HISTORY_DETAILS

Line 67: INSERT INTO JTF_FM_MIG_HISTORY_DETAILS

63: WHERE MIGRATION_CODE = p_code
64: AND STATUS = p_old_status;
65:
66: FOR l_i IN p_number..MIGRATED_CONTENT.count LOOP
67: INSERT INTO JTF_FM_MIG_HISTORY_DETAILS
68: (MIGRATION_CODE,
69: ITEM_ID,
70: CONTENT_TYPE_CODE,
71: CONTENT_ITEM_ID,

Line 270: FROM jtf_fm_mig_history_details

266: l_query NUMBER := NULL;
267:
268: CURSOR c_get_content_item_csr(c_item_id VARCHAR2,c_content_type_code VARCHAR2) IS
269: SELECT content_item_id, citem_version_id
270: FROM jtf_fm_mig_history_details
271: WHERE item_id = c_item_id
272: and content_type_code = c_content_type_code;
273:
274:

Line 567: SELECT CONTENT_ITEM_ID from JTF_FM_MIG_HISTORY_DETAILS where item_id = c_query_id;

563: SELECT QUERY_ID from JTF_FM_QUERY_MES where MES_DOC_ID = c_item_id;
564:
565: -- Get the CITEM_ID for the associated QUERY, assuming it has already been migrated to OCM
566: CURSOR c_get_query_details_csr(c_query_id NUMBER) IS
567: SELECT CONTENT_ITEM_ID from JTF_FM_MIG_HISTORY_DETAILS where item_id = c_query_id;
568:
569:
570: l_lang VARCHAR2(4);
571: l_langdesc VARCHAR2(255);