APPS.JTF_FM_MD_MIGRATION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

    SELECT 1
	 FROM JTF_FM_MIGRATION_HISTORY
     WHERE migration_code = c_code
	  AND status = c_status;

Line: 39

  DELETE FROM JTF_FM_MIGRATION_HISTORY
	   WHERE MIGRATION_CODE = p_code;

Line: 41

  INSERT INTO JTF_FM_MIGRATION_HISTORY(MIGRATION_CODE,
    OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
    LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
  VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,
    FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);

Line: 52

PROCEDURE update_log(p_code IN VARCHAR2,
				 p_old_status IN VARCHAR2,
				 p_new_status IN VARCHAR2,
				 p_number  IN NUMBER,
				 x_status OUT NOCOPY VARCHAR2)
IS
  l_i NUMBER;

Line: 60

  UPDATE JTF_FM_MIGRATION_HISTORY
     SET STATUS = p_new_status,
   	    LAST_UPDATE_DATE = SYSDATE
   WHERE MIGRATION_CODE = p_code
	AND STATUS = p_old_status;

Line: 67

	    INSERT INTO JTF_FM_MIG_HISTORY_DETAILS
       (MIGRATION_CODE,
        ITEM_ID,
        CONTENT_TYPE_CODE,
        CONTENT_ITEM_ID,
        CITEM_VERSION_ID,
        FILE_ID,
        FILE_NAME,
        DESCRIPTION,
        QUERY_CITEM_ID,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
       VALUES(MIGRATED_CONTENT(l_i).MIGRATION_CODE,
       MIGRATED_CONTENT(l_i).ITEM_ID,
       MIGRATED_CONTENT(l_i).CONTENT_TYPE_CODE,
       MIGRATED_CONTENT(l_i).CONTENT_ITEM_ID,
       MIGRATED_CONTENT(l_i).CITEM_VERSION_ID,
       MIGRATED_CONTENT(l_i).FILE_ID,
       MIGRATED_CONTENT(l_i).FILE_NAME,
       MIGRATED_CONTENT(l_i).DESCRIPTION,
       MIGRATED_CONTENT(l_i).QUERY_CITEM_ID,
       FND_GLOBAL.user_id,
       SYSDATE,
       FND_GLOBAL.user_id,
       SYSDATE,
       FND_GLOBAL.user_id);

Line: 104

END update_log;

Line: 269

    SELECT content_item_id, citem_version_id
	 FROM jtf_fm_mig_history_details
     WHERE item_id  = c_item_id
	 and content_type_code = c_content_type_code;

Line: 464

	 SELECT QUERY_ID,QUERY_NAME, QUERY_DESC, FILE_ID from JTF_FM_QUERIES_ALL ;

Line: 531

   select fnd_lobs_s.nextval into l_file_id from dual;

Line: 532

   INSERT INTO fnd_lobs(file_id,file_name,file_content_type,file_data,upload_date, file_format)
   VALUES (l_file_id,'Dummy FM TEXT file','text/plain',empty_blob(),sysdate, 'text');

Line: 547

    select b.item_id
	 from jtf_amv_items_b b
     where b.content_type_id = 20
	  and b.application_id IN(690,530)
     ORDER BY b.item_id;

Line: 556

    SELECT distinct file_id, file_name,description
	FROM jtf_amv_attachments a
    WHERE attachment_used_by_id = c_item_id
    AND file_id IS NOT NULL;

Line: 563

     SELECT QUERY_ID from JTF_FM_QUERY_MES where MES_DOC_ID = c_item_id;

Line: 567

	 SELECT CONTENT_ITEM_ID from JTF_FM_MIG_HISTORY_DETAILS where item_id = c_query_id;

Line: 719

           update_log(p_code => 'JTF_FM_QUERY_MIG',
			  p_old_status => 'START',
			  p_new_status => 'SUCCESS',
			  p_number => 1,
			  x_status => l_status);

Line: 747

      update_log(p_code => 'JTF_FM_OCM_MIG',
			  p_old_status => 'START',
			  p_new_status => 'SUCCESS',
			  p_number  =>l_num,
			  x_status => l_status);