eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_FM_REQUEST_GRP dependencies on FND_LOBS

Line 109: SELECT FILE_NAME into l_file_name from fnd_lobs where file_id = p_file_id and LANGUAGE = USERENV('LANG') ;

105:
106: BEGIN
107: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
108: JTF_FM_UTL_V.PRINT_MESSAGE('File Id' || p_file_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
109: SELECT FILE_NAME into l_file_name from fnd_lobs where file_id = p_file_id and LANGUAGE = USERENV('LANG') ;
110:
111: JTF_FM_UTL_V.PRINT_MESSAGE('END function ', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_QUEUE_NAME');
112:
113: RETURN l_file_name;

Line 482: -- Procedure To insert Query into FND_LOBS,

478:
479: END NEW_PAUSE_RESUME_REQUEST;
480:
481: /*****************************************************
482: -- Procedure To insert Query into FND_LOBS,
483: -- if file_id is invalid
484:
485: ******************************************************/
486: PROCEDURE INSERT_QUERY

Line 534: select fnd_lobs_s.nextval into x_query_file_id from dual;

530: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_QUERY_NOT_FOUND',p_query_id);
531: RAISE FND_API.G_EXC_ERROR;
532: ELSE
533:
534: select fnd_lobs_s.nextval into x_query_file_id from dual;
535: JTF_FM_UTL_V.PRINT_MESSAGE('GOT FILE ID SEQ from FND_LOBS '|| x_query_file_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
536: JTF_FM_UTL_V.PRINT_MESSAGE('Query Name is :'|| l_query_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
537: --JTF_FM_UTL_V.PRINT_MESSAGE('Query String is :'|| l_query_string,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
538: JTF_FM_UTL_V.PRINT_MESSAGE('Query ID is :'|| l_query_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 535: JTF_FM_UTL_V.PRINT_MESSAGE('GOT FILE ID SEQ from FND_LOBS '|| x_query_file_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

531: RAISE FND_API.G_EXC_ERROR;
532: ELSE
533:
534: select fnd_lobs_s.nextval into x_query_file_id from dual;
535: JTF_FM_UTL_V.PRINT_MESSAGE('GOT FILE ID SEQ from FND_LOBS '|| x_query_file_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
536: JTF_FM_UTL_V.PRINT_MESSAGE('Query Name is :'|| l_query_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
537: --JTF_FM_UTL_V.PRINT_MESSAGE('Query String is :'|| l_query_string,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
538: JTF_FM_UTL_V.PRINT_MESSAGE('Query ID is :'|| l_query_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
539:

Line 542: INSERT INTO fnd_lobs (

538: JTF_FM_UTL_V.PRINT_MESSAGE('Query ID is :'|| l_query_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
539:
540: --dbms_output.put_line('File Id is :' || to_char(l_file_id));
541: -- dbms_output.put_line('Inserting empty_blob() row');
542: INSERT INTO fnd_lobs (
543: FILE_ID,
544: FILE_NAME,
545: FILE_CONTENT_TYPE,
546: FILE_DATA,

Line 572: from fnd_lobs

568:
569: --dbms_output.put_line('Length of l_query...' || to_char(length(l_query)));
570:
571: select file_data into l_file_data
572: from fnd_lobs
573: where file_id = x_query_file_id
574: for update;
575:
576: l_amount := length(l_query ) ;

Line 581: JTF_FM_UTL_V.PRINT_MESSAGE('Uploaded Query into FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

577: DBMS_LOB.OPEN(l_file_data,DBMS_LOB.LOB_READWRITE);
578: DBMS_LOB.WRITE(l_file_data, l_amount, 1, l_query_raw);
579: DBMS_LOB.CLOSE(l_file_data);
580:
581: JTF_FM_UTL_V.PRINT_MESSAGE('Uploaded Query into FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
582:
583: update jtf_fm_queries_all set file_id = x_query_file_id
584: where query_id = p_query_id;
585:

Line 604: -- Procedure To insert Query into FND_LOBS,

600:
601: END INSERT_QUERY;
602:
603: /*****************************************************
604: -- Procedure To insert Query into FND_LOBS,
605: -- if file_id is invalid
606:
607: ******************************************************/
608: PROCEDURE CHECK_AND_INSERT_QUERY

Line 628: Select file_id into x_query_file_id from fnd_lobs where file_id = p_query_file_id;

624: BEGIN
625: -- Standard savepoint
626: SAVEPOINT query_status;
627: BEGIN
628: Select file_id into x_query_file_id from fnd_lobs where file_id = p_query_file_id;
629: JTF_FM_UTL_V.PRINT_MESSAGE('File PRESENT Id in FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
630:
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN

Line 629: JTF_FM_UTL_V.PRINT_MESSAGE('File PRESENT Id in FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

625: -- Standard savepoint
626: SAVEPOINT query_status;
627: BEGIN
628: Select file_id into x_query_file_id from fnd_lobs where file_id = p_query_file_id;
629: JTF_FM_UTL_V.PRINT_MESSAGE('File PRESENT Id in FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
630:
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: JTF_FM_UTL_V.PRINT_MESSAGE('No File Id in FND_LOBS',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 633: JTF_FM_UTL_V.PRINT_MESSAGE('No File Id in FND_LOBS',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

629: JTF_FM_UTL_V.PRINT_MESSAGE('File PRESENT Id in FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
630:
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: JTF_FM_UTL_V.PRINT_MESSAGE('No File Id in FND_LOBS',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
634:
635: INSERT_QUERY(p_query_id, x_query_file_id);
636: END;
637:

Line 3157: -- mpetrosi 4-oct-2001 added join to fnd_lobs

3153:
3154: l_api_name CONSTANT VARCHAR2(100) := 'GET_MES_ITEM_DETAILS';
3155: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || 'GET_MES_ITEM_DETAILS';
3156: -------------------------------------------------
3157: -- mpetrosi 4-oct-2001 added join to fnd_lobs
3158: -- Cursor to get the content_nm using the content_id for QUERY/COLLATERAL
3159: -- This cursor also checks if the content_id passed is valid
3160: CURSOR CCONT IS
3161: SELECT L.FILE_ID,L.FILE_NAME

Line 3163: FND_LOBS L

3159: -- This cursor also checks if the content_id passed is valid
3160: CURSOR CCONT IS
3161: SELECT L.FILE_ID,L.FILE_NAME
3162: FROM JTF_AMV_ATTACHMENTS A,
3163: FND_LOBS L
3164: WHERE A.ATTACHMENT_USED_BY_ID = p_content_id
3165: AND A.FILE_ID = L.FILE_ID AND
3166: A.ATTACHMENT_USED_BY = 'ITEM';
3167: -------------------------------------------------

Line 3172: FROM FND_LOBS

3168:
3169: -- Cursor to get the content_nm using the content_id for ATTACHMENTS
3170: CURSOR CATTACH IS
3171: SELECT FILE_ID, FILE_NAME
3172: FROM FND_LOBS
3173: WHERE
3174: FILE_ID = p_content_id;
3175:
3176: CURSOR CQUER IS