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

Line 179: SELECT fnd_documents_s.nextval

175: into l_attached_document_id from dual;
176:
177: if ( l_document_id is null ) THEN
178:
179: SELECT fnd_documents_s.nextval
180: INTO l_document_id
181: FROM dual;
182:
183: l_category_id := p_category_id;

Line 186: INSERT INTO fnd_documents(

182:
183: l_category_id := p_category_id;
184: l_media_id := p_family_id;
185:
186: INSERT INTO fnd_documents(
187: document_id,
188: creation_date,
189: created_by,
190: last_update_date,

Line 223: fnd_documents_pkg.insert_tl_row(

219: 'FILE');
220:
221: SELECT userenv('LANG') INTO l_language FROM dual;
222:
223: fnd_documents_pkg.insert_tl_row(
224: X_document_id => l_document_id,
225: X_creation_date => sysdate,
226: X_created_by => p_created_by,
227: X_last_update_date => sysdate,

Line 235: INSERT INTO fnd_documents

231: );
232:
233: else
234:
235: INSERT INTO fnd_documents
236: (document_id,
237: creation_date,
238: created_by,
239: last_update_date,

Line 253: fnd_documents_s.NEXTVAL,

249: file_name,
250: dm_node,
251: dm_type)
252: SELECT
253: fnd_documents_s.NEXTVAL,
254: creation_date,
255: created_by,
256: last_update_date,
257: last_updated_by,

Line 269: FROM fnd_documents x

265: decode(dm_document_id,0,p_version_id,dm_document_id),
266: file_name,
267: dm_node,
268: dm_type
269: FROM fnd_documents x
270: WHERE x.document_id = l_document_id;
271:
272: select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;
273:

Line 272: select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;

268: dm_type
269: FROM fnd_documents x
270: WHERE x.document_id = l_document_id;
271:
272: select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;
273:
274: select fnd_documents_s.CURRVAL into l_document_id from dual;
275:
276: fnd_documents_pkg.insert_tl_row(

Line 274: select fnd_documents_s.CURRVAL into l_document_id from dual;

270: WHERE x.document_id = l_document_id;
271:
272: select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;
273:
274: select fnd_documents_s.CURRVAL into l_document_id from dual;
275:
276: fnd_documents_pkg.insert_tl_row(
277: X_document_id => l_document_id,
278: X_creation_date => sysdate,

Line 276: fnd_documents_pkg.insert_tl_row(

272: select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;
273:
274: select fnd_documents_s.CURRVAL into l_document_id from dual;
275:
276: fnd_documents_pkg.insert_tl_row(
277: X_document_id => l_document_id,
278: X_creation_date => sysdate,
279: X_created_by => p_created_by,
280: X_last_update_date => sysdate,

Line 350: fnd_documents docs

346: cursor get_document_id
347: is
348: select att.document_id,docs.datatype_id
349: from fnd_attached_documents att,
350: fnd_documents docs
351: where Attached_document_id=p_Attached_document_id
352: and docs.document_id=att.document_id;
353:
354:

Line 379: fnd_documents_pkg.Delete_Row(

375: open check_other_attachments (l_document_id);
376: fetch check_other_attachments INTO l_dummy;
377: CLOSE check_other_attachments;
378: if( l_dummy is null) THEN
379: fnd_documents_pkg.Delete_Row(
380: X_document_id =>l_document_id,
381: X_datatype_id =>l_datatype_id,
382: delete_ref_Flag => 'Y');
383: END if;

Line 418: update fnd_documents_tl

414: CLOSE get_document_id;
415:
416:
417:
418: update fnd_documents_tl
419: set Description = p_Description
420: ,last_updated_by = p_last_updated_by
421: ,last_update_login =p_last_update_login
422: where document_id= l_document_id

Line 425: update fnd_documents

421: ,last_update_login =p_last_update_login
422: where document_id= l_document_id
423: and language=userenv('LANG');
424:
425: update fnd_documents
426: set File_Name = p_FileName
427: ,Category_id= p_Category
428: ,last_updated_by = p_last_updated_by
429: ,last_update_login =p_last_update_login

Line 499: fnd_documents docs

495: CURSOR get_affected_attachments(cp_dm_document_id NUMBER)
496: IS
497: select att.attached_document_id
498: from fnd_attached_documents att,
499: fnd_documents docs
500: where docs.document_id=att.document_id
501: and docs.dm_document_id=cp_dm_document_id;
502:
503: CURSOR is_WebServices_document(cp_Repository_id NUMBER)

Line 587: from fnd_documents_vl

583: l_encrypt_key varchar2(30):='DM$Param'||'&'||'Key';
584: cursor get_doc_info (cp_document_id number)
585: IS
586: select media_id,datatype_id
587: from fnd_documents_vl
588: where document_id=cp_document_id;
589:
590: BEGIN
591:

Line 608: FROM fnd_documents_vl docs,

604: IF(l_datatype_id =7) THEN
605: SELECT repos.dav_url,
606: docs.dm_folder_path||'/'||docs.file_name
607: INTO l_host_url,l_document_path
608: FROM fnd_documents_vl docs,
609: dom_repositories repos
610: where repos.id=docs.dm_node
611: and docs.document_id=p_document_id;
612:

Line 691: fnd_documents fd,

687: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
688: fd.URL fd_URL,
689: fd.MEDIA_ID fd_MEDIA_ID
690: FROM fnd_attached_documents fad,
691: fnd_documents fd,
692: fnd_documents_tl fdtl
693: WHERE fad.document_id = fd.document_id
694: AND fd.document_id = fdtl.document_id
695: AND fdtl.language = userenv('LANG')

Line 692: fnd_documents_tl fdtl

688: fd.URL fd_URL,
689: fd.MEDIA_ID fd_MEDIA_ID
690: FROM fnd_attached_documents fad,
691: fnd_documents fd,
692: fnd_documents_tl fdtl
693: WHERE fad.document_id = fd.document_id
694: AND fd.document_id = fdtl.document_id
695: AND fdtl.language = userenv('LANG')
696: AND fd.document_id = X_from_document_id ;

Line 700: FROM fnd_documents_short_text

696: AND fd.document_id = X_from_document_id ;
697:
698: CURSOR shorttext (mid NUMBER) IS
699: SELECT short_text
700: FROM fnd_documents_short_text
701: WHERE media_id = mid;
702:
703: CURSOR longtext (mid NUMBER) IS
704: SELECT long_text

Line 705: FROM fnd_documents_long_text

701: WHERE media_id = mid;
702:
703: CURSOR longtext (mid NUMBER) IS
704: SELECT long_text
705: FROM fnd_documents_long_text
706: WHERE media_id = mid;
707:
708: CURSOR fnd_lobs_cur (mid NUMBER) IS
709: SELECT file_id,

Line 745: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,

741: --
742: IF (docrec.usage_type = 'O'
743: AND docrec.datatype_id IN (1,2,5,6,7,8,9) ) THEN
744: -- Create Documents records
745: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
746: document_id_tmp,
747: SYSDATE,
748: NVL(X_created_by,0),
749: SYSDATE,

Line 788: UPDATE fnd_documents

784: docrec.document_id := document_id_tmp;
785:
786: IF(docrec.datatype_id =7 OR docrec.datatype_id =8 OR docrec.datatype_id =9)
787: then
788: UPDATE fnd_documents
789: SET
790: DM_NODE = docrec.fd_dm_node,
791: DM_FOLDER_PATH =docrec.fd_dm_folder_path,
792: DM_TYPE = docrec.fd_dm_type,

Line 810: INSERT INTO fnd_documents_short_text (

806: OPEN shorttext(docrec.media_id);
807: FETCH shorttext INTO short_text_tmp;
808: CLOSE shorttext;
809:
810: INSERT INTO fnd_documents_short_text (
811: media_id,
812: short_text)
813: VALUES (
814: media_id_tmp,

Line 825: INSERT INTO fnd_documents_long_text (

821: OPEN longtext(docrec.media_id);
822: FETCH longtext INTO long_text_tmp;
823: CLOSE longtext;
824:
825: INSERT INTO fnd_documents_long_text (
826: media_id,
827: long_text)
828: VALUES (
829: media_id_tmp,

Line 887: UPDATE fnd_documents

883: -- was an ole or image that wasn't already a std doc
884: -- (images should be created as Std, but just in case)
885: IF (docrec.datatype_id IN (3,4)
886: AND docrec.usage_type <> 'S') THEN
887: UPDATE fnd_documents
888: SET usage_type = 'S'
889: WHERE document_id = docrec.document_id;
890: END IF;
891:

Line 964: fnd_documents fd,

960: fd.URL fd_URL,
961: fd.MEDIA_ID fd_MEDIA_ID
962:
963: FROM fnd_attached_documents fad,
964: fnd_documents fd,
965: fnd_documents_tl fdtl
966: WHERE fd.document_id = fad.document_id
967: AND fdtl.document_id = fd.document_id
968: AND fdtl.language = userenv('LANG')

Line 965: fnd_documents_tl fdtl

961: fd.MEDIA_ID fd_MEDIA_ID
962:
963: FROM fnd_attached_documents fad,
964: fnd_documents fd,
965: fnd_documents_tl fdtl
966: WHERE fd.document_id = fad.document_id
967: AND fdtl.document_id = fd.document_id
968: AND fdtl.language = userenv('LANG')
969: AND fad.entity_name = X_from_entity_name

Line 1009: fnd_documents fd,

1005: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
1006: fd.URL fd_URL,
1007: fd.MEDIA_ID fd_MEDIA_ID
1008: FROM fnd_attached_documents fad,
1009: fnd_documents fd,
1010: fnd_documents_tl fdtl
1011: WHERE fd.document_id = fad.document_id
1012: AND fdtl.document_id = fd.document_id
1013: AND fdtl.language = userenv('LANG')

Line 1010: fnd_documents_tl fdtl

1006: fd.URL fd_URL,
1007: fd.MEDIA_ID fd_MEDIA_ID
1008: FROM fnd_attached_documents fad,
1009: fnd_documents fd,
1010: fnd_documents_tl fdtl
1011: WHERE fd.document_id = fad.document_id
1012: AND fdtl.document_id = fd.document_id
1013: AND fdtl.language = userenv('LANG')
1014: AND fad.entity_name = X_from_entity_name

Line 1058: fnd_documents fd,

1054: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
1055: fd.URL fd_URL,
1056: fd.MEDIA_ID fd_MEDIA_ID
1057: FROM fnd_attached_documents fad,
1058: fnd_documents fd,
1059: fnd_documents_tl fdtl
1060: WHERE fd.document_id = fad.document_id
1061: AND fdtl.document_id = fd.document_id
1062: AND fdtl.language = userenv('LANG')

Line 1059: fnd_documents_tl fdtl

1055: fd.URL fd_URL,
1056: fd.MEDIA_ID fd_MEDIA_ID
1057: FROM fnd_attached_documents fad,
1058: fnd_documents fd,
1059: fnd_documents_tl fdtl
1060: WHERE fd.document_id = fad.document_id
1061: AND fdtl.document_id = fd.document_id
1062: AND fdtl.language = userenv('LANG')
1063: AND fad.entity_name = X_from_entity_name

Line 1108: fnd_documents fd,

1104: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
1105: fd.URL fd_URL,
1106: fd.MEDIA_ID fd_MEDIA_ID
1107: FROM fnd_attached_documents fad,
1108: fnd_documents fd,
1109: fnd_documents_tl fdtl
1110: WHERE fd.document_id = fad.document_id
1111: AND fdtl.document_id = fd.document_id
1112: AND fdtl.language = userenv('LANG')

Line 1109: fnd_documents_tl fdtl

1105: fd.URL fd_URL,
1106: fd.MEDIA_ID fd_MEDIA_ID
1107: FROM fnd_attached_documents fad,
1108: fnd_documents fd,
1109: fnd_documents_tl fdtl
1110: WHERE fd.document_id = fad.document_id
1111: AND fdtl.document_id = fd.document_id
1112: AND fdtl.language = userenv('LANG')
1113: AND fad.entity_name = X_from_entity_name

Line 1135: FROM fnd_documents_short_text

1131:
1132:
1133: CURSOR shorttext (mid NUMBER) IS
1134: SELECT short_text
1135: FROM fnd_documents_short_text
1136: WHERE media_id = mid;
1137:
1138: CURSOR longtext (mid NUMBER) IS
1139: SELECT long_text

Line 1140: FROM fnd_documents_long_text

1136: WHERE media_id = mid;
1137:
1138: CURSOR longtext (mid NUMBER) IS
1139: SELECT long_text
1140: FROM fnd_documents_long_text
1141: WHERE media_id = mid;
1142:
1143: CURSOR fnd_lobs_cur (mid NUMBER) IS
1144: SELECT file_id,

Line 1222: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,

1218: --
1219: IF (docrec.usage_type = 'O'
1220: AND docrec.datatype_id IN (1,2,5,6,7,8,9) ) THEN
1221: -- Create Documents records
1222: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
1223: document_id_tmp,
1224: SYSDATE,
1225: NVL(X_created_by,0),
1226: SYSDATE,

Line 1264: UPDATE fnd_documents

1260:
1261: --update the document row for ws/webdav attachments
1262: IF(docrec.datatype_id =7 OR docrec.datatype_id =8 OR docrec.datatype_id =9)
1263: then
1264: UPDATE fnd_documents
1265: SET
1266: DM_NODE = docrec.fd_dm_node,
1267: DM_FOLDER_PATH =docrec.fd_dm_folder_path,
1268: DM_TYPE = docrec.fd_dm_type,

Line 1286: INSERT INTO fnd_documents_short_text (

1282: OPEN shorttext(docrec.media_id);
1283: FETCH shorttext INTO short_text_tmp;
1284: CLOSE shorttext;
1285:
1286: INSERT INTO fnd_documents_short_text (
1287: media_id,
1288: short_text)
1289: VALUES (
1290: media_id_tmp,

Line 1300: INSERT INTO fnd_documents_long_text (

1296: -- get original data
1297: OPEN longtext(docrec.media_id);
1298: FETCH longtext INTO long_text_tmp;
1299: CLOSE longtext;
1300: INSERT INTO fnd_documents_long_text (
1301: media_id,
1302: long_text)
1303: VALUES (
1304: media_id_tmp,

Line 1412: UPDATE fnd_documents

1408: -- was an ole or image that wasn't already a std doc
1409: -- (images should be created as Std, but just in case)
1410: IF (docrec.datatype_id IN (3,4)
1411: AND docrec.usage_type <> 'S') THEN
1412: UPDATE fnd_documents
1413: SET usage_type = 'S'
1414: WHERE document_id = docrec.document_id;
1415: END IF;
1416: END LOOP; -- end of working through all attachments