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 360: DELETE FROM fnd_lobs

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

Line 682: CURSOR fnd_lobs_cur (mid NUMBER) IS

678: SELECT long_text
679: FROM fnd_documents_long_text
680: WHERE media_id = mid;
681:
682: CURSOR fnd_lobs_cur (mid NUMBER) IS
683: SELECT file_id,
684: file_name,
685: file_content_type,
686: upload_date,

Line 694: FROM fnd_lobs

690: file_data,
691: language,
692: oracle_charset,
693: file_format
694: FROM fnd_lobs
695: WHERE file_id = mid;
696:
697: media_id_tmp NUMBER;
698: document_id_tmp NUMBER;

Line 704: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;

700: short_text_tmp VARCHAR2(4000);
701: --long_text_tmp VARCHAR2(32767);
702: long_text_tmp fnd_documents_long_text.long_text%TYPE;
703: docrec doclist%ROWTYPE;
704: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
705: BEGIN
706: -- Use cursor loop to get all attachments associated with
707: -- the from_entity
708: IF (X_from_entity_name IS NULL OR X_from_pk1_value IS NULL) THEN

Line 834: OPEN fnd_lobs_cur(docrec.media_id);

830: media_id_tmp := '';
831:
832: ELSIF (docrec.datatype_id=6) THEN
833:
834: OPEN fnd_lobs_cur(docrec.media_id);
835: FETCH fnd_lobs_cur
836: INTO fnd_lobs_rec.file_id,
837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,

Line 835: FETCH fnd_lobs_cur

831:
832: ELSIF (docrec.datatype_id=6) THEN
833:
834: OPEN fnd_lobs_cur(docrec.media_id);
835: FETCH fnd_lobs_cur
836: INTO fnd_lobs_rec.file_id,
837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,

Line 836: INTO fnd_lobs_rec.file_id,

832: ELSIF (docrec.datatype_id=6) THEN
833:
834: OPEN fnd_lobs_cur(docrec.media_id);
835: FETCH fnd_lobs_cur
836: INTO fnd_lobs_rec.file_id,
837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,

Line 837: fnd_lobs_rec.file_name,

833:
834: OPEN fnd_lobs_cur(docrec.media_id);
835: FETCH fnd_lobs_cur
836: INTO fnd_lobs_rec.file_id,
837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,

Line 838: fnd_lobs_rec.file_content_type,

834: OPEN fnd_lobs_cur(docrec.media_id);
835: FETCH fnd_lobs_cur
836: INTO fnd_lobs_rec.file_id,
837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,

Line 839: fnd_lobs_rec.upload_date,

835: FETCH fnd_lobs_cur
836: INTO fnd_lobs_rec.file_id,
837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,

Line 840: fnd_lobs_rec.expiration_date,

836: INTO fnd_lobs_rec.file_id,
837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,

Line 841: fnd_lobs_rec.program_name,

837: fnd_lobs_rec.file_name,
838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,
845: fnd_lobs_rec.oracle_charset,

Line 842: fnd_lobs_rec.program_tag,

838: fnd_lobs_rec.file_content_type,
839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,
845: fnd_lobs_rec.oracle_charset,
846: fnd_lobs_rec.file_format;

Line 843: fnd_lobs_rec.file_data,

839: fnd_lobs_rec.upload_date,
840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,
845: fnd_lobs_rec.oracle_charset,
846: fnd_lobs_rec.file_format;
847: CLOSE fnd_lobs_cur;

Line 844: fnd_lobs_rec.language,

840: fnd_lobs_rec.expiration_date,
841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,
845: fnd_lobs_rec.oracle_charset,
846: fnd_lobs_rec.file_format;
847: CLOSE fnd_lobs_cur;
848:

Line 845: fnd_lobs_rec.oracle_charset,

841: fnd_lobs_rec.program_name,
842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,
845: fnd_lobs_rec.oracle_charset,
846: fnd_lobs_rec.file_format;
847: CLOSE fnd_lobs_cur;
848:
849: INSERT INTO fnd_lobs (

Line 846: fnd_lobs_rec.file_format;

842: fnd_lobs_rec.program_tag,
843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,
845: fnd_lobs_rec.oracle_charset,
846: fnd_lobs_rec.file_format;
847: CLOSE fnd_lobs_cur;
848:
849: INSERT INTO fnd_lobs (
850: file_id,

Line 847: CLOSE fnd_lobs_cur;

843: fnd_lobs_rec.file_data,
844: fnd_lobs_rec.language,
845: fnd_lobs_rec.oracle_charset,
846: fnd_lobs_rec.file_format;
847: CLOSE fnd_lobs_cur;
848:
849: INSERT INTO fnd_lobs (
850: file_id,
851: file_name,

Line 849: INSERT INTO fnd_lobs (

845: fnd_lobs_rec.oracle_charset,
846: fnd_lobs_rec.file_format;
847: CLOSE fnd_lobs_cur;
848:
849: INSERT INTO fnd_lobs (
850: file_id,
851: file_name,
852: file_content_type,
853: upload_date,

Line 863: fnd_lobs_rec.file_name,

859: oracle_charset,
860: file_format)
861: VALUES (
862: media_id_tmp,
863: fnd_lobs_rec.file_name,
864: fnd_lobs_rec.file_content_type,
865: fnd_lobs_rec.upload_date,
866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,

Line 864: fnd_lobs_rec.file_content_type,

860: file_format)
861: VALUES (
862: media_id_tmp,
863: fnd_lobs_rec.file_name,
864: fnd_lobs_rec.file_content_type,
865: fnd_lobs_rec.upload_date,
866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,

Line 865: fnd_lobs_rec.upload_date,

861: VALUES (
862: media_id_tmp,
863: fnd_lobs_rec.file_name,
864: fnd_lobs_rec.file_content_type,
865: fnd_lobs_rec.upload_date,
866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,

Line 866: fnd_lobs_rec.expiration_date,

862: media_id_tmp,
863: fnd_lobs_rec.file_name,
864: fnd_lobs_rec.file_content_type,
865: fnd_lobs_rec.upload_date,
866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,
870: fnd_lobs_rec.language,

Line 867: fnd_lobs_rec.program_name,

863: fnd_lobs_rec.file_name,
864: fnd_lobs_rec.file_content_type,
865: fnd_lobs_rec.upload_date,
866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,
870: fnd_lobs_rec.language,
871: fnd_lobs_rec.oracle_charset,

Line 868: fnd_lobs_rec.program_tag,

864: fnd_lobs_rec.file_content_type,
865: fnd_lobs_rec.upload_date,
866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,
870: fnd_lobs_rec.language,
871: fnd_lobs_rec.oracle_charset,
872: fnd_lobs_rec.file_format);

Line 869: fnd_lobs_rec.file_data,

865: fnd_lobs_rec.upload_date,
866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,
870: fnd_lobs_rec.language,
871: fnd_lobs_rec.oracle_charset,
872: fnd_lobs_rec.file_format);
873:

Line 870: fnd_lobs_rec.language,

866: fnd_lobs_rec.expiration_date,
867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,
870: fnd_lobs_rec.language,
871: fnd_lobs_rec.oracle_charset,
872: fnd_lobs_rec.file_format);
873:
874: media_id_tmp := '';

Line 871: fnd_lobs_rec.oracle_charset,

867: fnd_lobs_rec.program_name,
868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,
870: fnd_lobs_rec.language,
871: fnd_lobs_rec.oracle_charset,
872: fnd_lobs_rec.file_format);
873:
874: media_id_tmp := '';
875:

Line 872: fnd_lobs_rec.file_format);

868: fnd_lobs_rec.program_tag,
869: fnd_lobs_rec.file_data,
870: fnd_lobs_rec.language,
871: fnd_lobs_rec.oracle_charset,
872: fnd_lobs_rec.file_format);
873:
874: media_id_tmp := '';
875:
876: END IF; -- end of duplicating text

Line 962: CLOSE fnd_lobs_cur;

958: CLOSE docpk3;
959: CLOSE doclist;
960: CLOSE shorttext;
961: CLOSE longtext;
962: CLOSE fnd_lobs_cur;
963:
964: END copy_attachments;
965:
966: