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.FND_ATTACHED_DOCUMENTS2_PKG dependencies on FND_LOBS

Line 75: DELETE FROM fnd_lobs

71: AND fd.datatype_id IN (3,4)
72: AND fad.entity_name = X_entity_name
73: AND fad.pk1_value = X_pk1_value);
74:
75: DELETE FROM fnd_lobs
76: WHERE file_id IN
77: (SELECT fd.media_id
78: FROM fnd_documents_tl fdtl,
79: fnd_documents fd,

Line 161: DELETE FROM fnd_lobs

157: AND fad.entity_name = X_entity_name
158: AND fad.pk1_value = X_pk1_value
159: AND fad.pk2_value = X_pk2_value);
160:
161: DELETE FROM fnd_lobs
162: WHERE file_id IN
163: (SELECT fd.media_id
164: FROM fnd_documents_tl fdtl,
165: fnd_documents fd,

Line 254: DELETE FROM fnd_lobs

250: AND fad.pk1_value = X_pk1_value
251: AND fad.pk2_value = X_pk2_value
252: AND fad.pk3_value = X_pk3_value);
253:
254: DELETE FROM fnd_lobs
255: WHERE file_id IN
256: (SELECT fd.media_id
257: FROM fnd_documents_tl fdtl,
258: fnd_documents fd,

Line 363: DELETE FROM fnd_lobs

359: AND fad.pk4_value = X_pk4_value
360: OR X_pk5_value IS NULL
361: AND fad.pk5_value = X_pk5_value);
362:
363: DELETE FROM fnd_lobs
364: WHERE file_id IN
365: (SELECT fd.media_id
366: FROM fnd_documents_tl fdtl,
367: fnd_documents fd,

Line 631: CURSOR fnd_lobs_cur (mid NUMBER) IS

627: SELECT long_text
628: FROM fnd_documents_long_text
629: WHERE media_id = mid;
630:
631: CURSOR fnd_lobs_cur (mid NUMBER) IS
632: SELECT file_id,
633: file_name,
634: file_content_type,
635: upload_date,

Line 643: FROM fnd_lobs

639: file_data,
640: language,
641: oracle_charset,
642: file_format
643: FROM fnd_lobs
644: WHERE file_id = mid;
645:
646: media_id_tmp NUMBER;
647: document_id_tmp NUMBER;

Line 652: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;

648: row_id_tmp VARCHAR2(30);
649: short_text_tmp VARCHAR2(4000);
650: long_text_tmp VARCHAR2(32767);
651: docrec doclist%ROWTYPE;
652: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
653: BEGIN
654: -- Use cursor loop to get all attachments associated with
655: -- the from_entity
656: IF (X_from_entity_name IS NULL OR X_from_pk1_value IS NULL) THEN

Line 778: OPEN fnd_lobs_cur(docrec.media_id);

774: media_id_tmp := '';
775:
776: ELSIF (docrec.datatype_id=6) THEN
777:
778: OPEN fnd_lobs_cur(docrec.media_id);
779: FETCH fnd_lobs_cur
780: INTO fnd_lobs_rec.file_id,
781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,

Line 779: FETCH fnd_lobs_cur

775:
776: ELSIF (docrec.datatype_id=6) THEN
777:
778: OPEN fnd_lobs_cur(docrec.media_id);
779: FETCH fnd_lobs_cur
780: INTO fnd_lobs_rec.file_id,
781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,

Line 780: INTO fnd_lobs_rec.file_id,

776: ELSIF (docrec.datatype_id=6) THEN
777:
778: OPEN fnd_lobs_cur(docrec.media_id);
779: FETCH fnd_lobs_cur
780: INTO fnd_lobs_rec.file_id,
781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,

Line 781: fnd_lobs_rec.file_name,

777:
778: OPEN fnd_lobs_cur(docrec.media_id);
779: FETCH fnd_lobs_cur
780: INTO fnd_lobs_rec.file_id,
781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,

Line 782: fnd_lobs_rec.file_content_type,

778: OPEN fnd_lobs_cur(docrec.media_id);
779: FETCH fnd_lobs_cur
780: INTO fnd_lobs_rec.file_id,
781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,

Line 783: fnd_lobs_rec.upload_date,

779: FETCH fnd_lobs_cur
780: INTO fnd_lobs_rec.file_id,
781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,

Line 784: fnd_lobs_rec.expiration_date,

780: INTO fnd_lobs_rec.file_id,
781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,

Line 785: fnd_lobs_rec.program_name,

781: fnd_lobs_rec.file_name,
782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,
789: fnd_lobs_rec.oracle_charset,

Line 786: fnd_lobs_rec.program_tag,

782: fnd_lobs_rec.file_content_type,
783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,
789: fnd_lobs_rec.oracle_charset,
790: fnd_lobs_rec.file_format;

Line 787: fnd_lobs_rec.file_data,

783: fnd_lobs_rec.upload_date,
784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,
789: fnd_lobs_rec.oracle_charset,
790: fnd_lobs_rec.file_format;
791: CLOSE fnd_lobs_cur;

Line 788: fnd_lobs_rec.language,

784: fnd_lobs_rec.expiration_date,
785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,
789: fnd_lobs_rec.oracle_charset,
790: fnd_lobs_rec.file_format;
791: CLOSE fnd_lobs_cur;
792:

Line 789: fnd_lobs_rec.oracle_charset,

785: fnd_lobs_rec.program_name,
786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,
789: fnd_lobs_rec.oracle_charset,
790: fnd_lobs_rec.file_format;
791: CLOSE fnd_lobs_cur;
792:
793: INSERT INTO fnd_lobs (

Line 790: fnd_lobs_rec.file_format;

786: fnd_lobs_rec.program_tag,
787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,
789: fnd_lobs_rec.oracle_charset,
790: fnd_lobs_rec.file_format;
791: CLOSE fnd_lobs_cur;
792:
793: INSERT INTO fnd_lobs (
794: file_id,

Line 791: CLOSE fnd_lobs_cur;

787: fnd_lobs_rec.file_data,
788: fnd_lobs_rec.language,
789: fnd_lobs_rec.oracle_charset,
790: fnd_lobs_rec.file_format;
791: CLOSE fnd_lobs_cur;
792:
793: INSERT INTO fnd_lobs (
794: file_id,
795: file_name,

Line 793: INSERT INTO fnd_lobs (

789: fnd_lobs_rec.oracle_charset,
790: fnd_lobs_rec.file_format;
791: CLOSE fnd_lobs_cur;
792:
793: INSERT INTO fnd_lobs (
794: file_id,
795: file_name,
796: file_content_type,
797: upload_date,

Line 807: fnd_lobs_rec.file_name,

803: oracle_charset,
804: file_format)
805: VALUES (
806: media_id_tmp,
807: fnd_lobs_rec.file_name,
808: fnd_lobs_rec.file_content_type,
809: fnd_lobs_rec.upload_date,
810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,

Line 808: fnd_lobs_rec.file_content_type,

804: file_format)
805: VALUES (
806: media_id_tmp,
807: fnd_lobs_rec.file_name,
808: fnd_lobs_rec.file_content_type,
809: fnd_lobs_rec.upload_date,
810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,

Line 809: fnd_lobs_rec.upload_date,

805: VALUES (
806: media_id_tmp,
807: fnd_lobs_rec.file_name,
808: fnd_lobs_rec.file_content_type,
809: fnd_lobs_rec.upload_date,
810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,

Line 810: fnd_lobs_rec.expiration_date,

806: media_id_tmp,
807: fnd_lobs_rec.file_name,
808: fnd_lobs_rec.file_content_type,
809: fnd_lobs_rec.upload_date,
810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,
814: fnd_lobs_rec.language,

Line 811: fnd_lobs_rec.program_name,

807: fnd_lobs_rec.file_name,
808: fnd_lobs_rec.file_content_type,
809: fnd_lobs_rec.upload_date,
810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,
814: fnd_lobs_rec.language,
815: fnd_lobs_rec.oracle_charset,

Line 812: fnd_lobs_rec.program_tag,

808: fnd_lobs_rec.file_content_type,
809: fnd_lobs_rec.upload_date,
810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,
814: fnd_lobs_rec.language,
815: fnd_lobs_rec.oracle_charset,
816: fnd_lobs_rec.file_format);

Line 813: fnd_lobs_rec.file_data,

809: fnd_lobs_rec.upload_date,
810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,
814: fnd_lobs_rec.language,
815: fnd_lobs_rec.oracle_charset,
816: fnd_lobs_rec.file_format);
817:

Line 814: fnd_lobs_rec.language,

810: fnd_lobs_rec.expiration_date,
811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,
814: fnd_lobs_rec.language,
815: fnd_lobs_rec.oracle_charset,
816: fnd_lobs_rec.file_format);
817:
818: media_id_tmp := '';

Line 815: fnd_lobs_rec.oracle_charset,

811: fnd_lobs_rec.program_name,
812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,
814: fnd_lobs_rec.language,
815: fnd_lobs_rec.oracle_charset,
816: fnd_lobs_rec.file_format);
817:
818: media_id_tmp := '';
819:

Line 816: fnd_lobs_rec.file_format);

812: fnd_lobs_rec.program_tag,
813: fnd_lobs_rec.file_data,
814: fnd_lobs_rec.language,
815: fnd_lobs_rec.oracle_charset,
816: fnd_lobs_rec.file_format);
817:
818: media_id_tmp := '';
819:
820: END IF; -- end of duplicating text

Line 905: CLOSE fnd_lobs_cur;

901: CLOSE docpk3;
902: CLOSE doclist;
903: CLOSE shorttext;
904: CLOSE longtext;
905: CLOSE fnd_lobs_cur;
906:
907: END copy_attachments;
908:
909: