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

Line 823: Purpose: This procedure inserts record in the Credential and Fnd_Lobs table.

819: P_FILE_ID OUT NOCOPY NUMBER,
820: P_MSG_DATA OUT NOCOPY VARCHAR2
821: ) IS
822: /*
823: Purpose: This procedure inserts record in the Credential and Fnd_Lobs table.
824: After the successful insertion of these records it calls the FND_WEBATTCH API to create the link in the
825: attachment tables for the Entity IGS_PE_CREDENTIALS
826:
827: Change History:

Line 842: SELECT FND_LOBS_S.NEXTVAL FROM dual;

838: FROM fnd_document_categories_tl
839: WHERE name = cp_name;
840:
841: CURSOR fileid_cur IS
842: SELECT FND_LOBS_S.NEXTVAL FROM dual;
843:
844: BEGIN
845: -- Insert data in the fnd_lobs table
846: OPEN fileid_cur;

Line 845: -- Insert data in the fnd_lobs table

841: CURSOR fileid_cur IS
842: SELECT FND_LOBS_S.NEXTVAL FROM dual;
843:
844: BEGIN
845: -- Insert data in the fnd_lobs table
846: OPEN fileid_cur;
847: FETCH fileid_cur INTO l_fileid;
848: CLOSE fileid_cur;
849:

Line 850: INSERT INTO FND_LOBS(

846: OPEN fileid_cur;
847: FETCH fileid_cur INTO l_fileid;
848: CLOSE fileid_cur;
849:
850: INSERT INTO FND_LOBS(
851: FILE_ID,
852: FILE_NAME,
853: FILE_CONTENT_TYPE,
854: UPLOAD_DATE,