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.GMA_EDITEXT_ATTACH_MIG dependencies on FND_DOCUMENTS

Line 57: l_attached_document_id fnd_documents.document_id%TYPE;

53: AND t.language = l.language_code
54: ORDER BY installed_flag;
55:
56: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;
57: l_attached_document_id fnd_documents.document_id%TYPE;
58: l_document_id fnd_documents.document_id%TYPE;
59: l_media_id NUMBER;
60: l_Cur_Paragraph Cur_Paragraph%rowtype;
61: l_Document_exist varchar2(10);

Line 58: l_document_id fnd_documents.document_id%TYPE;

54: ORDER BY installed_flag;
55:
56: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;
57: l_attached_document_id fnd_documents.document_id%TYPE;
58: l_document_id fnd_documents.document_id%TYPE;
59: l_media_id NUMBER;
60: l_Cur_Paragraph Cur_Paragraph%rowtype;
61: l_Document_exist varchar2(10);
62: l_file_name VARCHAR2(240);

Line 306: CURSOR cur_fnd_documents(x_filename in varchar2)

302: AND B.SUB_PARACODE=x_sub_paracode
303: AND B.TABLE_NAME=x_table_name --'IC_ITEM_MST'
304: AND B.LANGUAGE=L.LANGUAGE_CODE;
305:
306: CURSOR cur_fnd_documents(x_filename in varchar2)
307: is
308: SELECT
309: DOCUMENT_ID,
310: FILE_NAME,

Line 312: FROM FND_DOCUMENTS

308: SELECT
309: DOCUMENT_ID,
310: FILE_NAME,
311: MEDIA_ID
312: FROM FND_DOCUMENTS
313: WHERE FILE_NAME=x_filename;
314:
315: l_flag varchar2(10):='FALSE';
316: l_filename varchar2(2000);

Line 326: -- Lets define the attachment filename as unique for each language into FND_DOCUMENTS_TL table

322: p_paragraph_code,
323: p_sub_paracode)
324: LOOP
325:
326: -- Lets define the attachment filename as unique for each language into FND_DOCUMENTS_TL table
327: l_filename:=p_text_code||'.'||crec.language;
328:
329:
330: if nvl(p_pk1_value,'N')<>'N' then

Line 349: for rec IN Cur_fnd_documents(l_filename)

345:
346: l_filename:=l_filename||'.'||p_paragraph_count;
347: p_file_name := l_filename;
348: -- Lets validate the filename through Cursor
349: for rec IN Cur_fnd_documents(l_filename)
350: loop
351:
352: -- Lets validate the filename is already present or not
353: l_flag:='TRUE';

Line 361: ' ... Document Already Exist in FND_DOCUMENTS_TL (Cannot Create).';

357: ' Document_Id='||rec.DOCUMENT_ID||
358: ' File_Name='||rec.FILE_NAME||
359: ' Media_ID='||rec.MEDIA_ID||
360: ' Language='||crec.LANGUAGE||
361: ' ... Document Already Exist in FND_DOCUMENTS_TL (Cannot Create).';
362:
363:
364: fnd_file.put_line(fnd_file.log,l_long_message);
365: fnd_file.put_line(fnd_file.output,l_long_message);

Line 792: l_attached_document_id fnd_documents.document_id%TYPE;

788: l_new_attachment_id NUMBER;
789: l_row_id VARCHAR2(30);
790: l_current_date DATE := sysdate;
791: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;
792: l_attached_document_id fnd_documents.document_id%TYPE;
793: l_create_Attached_Doc boolean := true;
794: l_dummy fnd_documents.document_id%TYPE;
795:
796: CURSOR c_attached_doc_id IS

Line 794: l_dummy fnd_documents.document_id%TYPE;

790: l_current_date DATE := sysdate;
791: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;
792: l_attached_document_id fnd_documents.document_id%TYPE;
793: l_create_Attached_Doc boolean := true;
794: l_dummy fnd_documents.document_id%TYPE;
795:
796: CURSOR c_attached_doc_id IS
797: SELECT FND_ATTACHED_DOCUMENTS_S.nextval
798: FROM dual;

Line 933: l_attached_document_id fnd_documents.document_id%TYPE;

929: l_long_message VARCHAR2(4000);
930:
931: l_row_id VARCHAR2(30);
932: l_current_date DATE := sysdate;
933: l_attached_document_id fnd_documents.document_id%TYPE;
934: l_document_ID fnd_documents.document_id%TYPE;
935:
936: l_file_id number;
937: l_long_text long;

Line 934: l_document_ID fnd_documents.document_id%TYPE;

930:
931: l_row_id VARCHAR2(30);
932: l_current_date DATE := sysdate;
933: l_attached_document_id fnd_documents.document_id%TYPE;
934: l_document_ID fnd_documents.document_id%TYPE;
935:
936: l_file_id number;
937: l_long_text long;
938: l_text ic_text_tbl_tl.text%type;

Line 993: -- if true then insert the attachment into fnd_documents_long_text table

989:
990: DBMS_SQL.CLOSE_CURSOR(l_cursor);
991:
992: if l_flag='TRUE' then
993: -- if true then insert the attachment into fnd_documents_long_text table
994: INSERT INTO
995: fnd_documents_short_text
996: (
997: MEDIA_ID,

Line 995: fnd_documents_short_text

991:
992: if l_flag='TRUE' then
993: -- if true then insert the attachment into fnd_documents_long_text table
994: INSERT INTO
995: fnd_documents_short_text
996: (
997: MEDIA_ID,
998: APP_SOURCE_VERSION,
999: SHORT_TEXT