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_AD_SS_GEN_001 dependencies on FND_LOBS

Line 5375: -- from the tables FND_ATTCHED_DOCUMENTS, FND_DOCUMENTS and FND_LOBS.

5371: p_ss_perstat_id IN NUMBER,
5372: x_return_status OUT NOCOPY VARCHAR2
5373: ) AS
5374: -- This method will be used to delete the Personal Statement Attachment record
5375: -- from the tables FND_ATTCHED_DOCUMENTS, FND_DOCUMENTS and FND_LOBS.
5376: BEGIN
5377: x_return_status := 'S';
5378: FND_DOCUMENTS_PKG.DELETE_ROW (
5379: x_document_id => p_document_id,

Line 5405: l_fileid FND_LOBS.FILE_ID%TYPE;

5401: SELECT category_id
5402: FROM fnd_document_categories_tl
5403: WHERE name = cp_name;
5404:
5405: l_fileid FND_LOBS.FILE_ID%TYPE;
5406: l_category_id FND_DOCUMENT_CATEGORIES_TL.category_id%TYPE;
5407: BEGIN
5408: x_return_status := 'S';
5409:

Line 5411: -- Insert data in the FND_LOBS table without the FILE_DATA.

5407: BEGIN
5408: x_return_status := 'S';
5409:
5410:
5411: -- Insert data in the FND_LOBS table without the FILE_DATA.
5412: -- FILE_DATA would be updated from the Controller of the calling page since
5413: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5414: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5415:

Line 5414: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;

5410:
5411: -- Insert data in the FND_LOBS table without the FILE_DATA.
5412: -- FILE_DATA would be updated from the Controller of the calling page since
5413: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5414: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5415:
5416: INSERT INTO FND_LOBS(
5417: FILE_ID,
5418: FILE_NAME,

Line 5416: INSERT INTO FND_LOBS(

5412: -- FILE_DATA would be updated from the Controller of the calling page since
5413: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5414: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5415:
5416: INSERT INTO FND_LOBS(
5417: FILE_ID,
5418: FILE_NAME,
5419: FILE_CONTENT_TYPE,
5420: UPLOAD_DATE,

Line 5477: -- from the tables FND_ATTCHED_DOCUMENTS, FND_DOCUMENTS and FND_LOBS.

5473: PROCEDURE DELETE_PERSTMT_ATTACHMENT_UP(p_document_id IN NUMBER,
5474: x_return_status OUT NOCOPY VARCHAR2
5475: ) AS
5476: -- This method will be used to delete the Personal Statement Attachment record
5477: -- from the tables FND_ATTCHED_DOCUMENTS, FND_DOCUMENTS and FND_LOBS.
5478: BEGIN
5479: x_return_status := 'S';
5480: FND_DOCUMENTS_PKG.DELETE_ROW (
5481: x_document_id => p_document_id,

Line 5507: l_fileid FND_LOBS.FILE_ID%TYPE;

5503: SELECT category_id
5504: FROM fnd_document_categories_tl
5505: WHERE name = cp_name;
5506:
5507: l_fileid FND_LOBS.FILE_ID%TYPE;
5508: l_category_id FND_DOCUMENT_CATEGORIES_TL.category_id%TYPE;
5509: BEGIN
5510: x_return_status := 'S';
5511:

Line 5513: -- Insert data in the FND_LOBS table without the FILE_DATA.

5509: BEGIN
5510: x_return_status := 'S';
5511:
5512:
5513: -- Insert data in the FND_LOBS table without the FILE_DATA.
5514: -- FILE_DATA would be updated from the Controller of the calling page since
5515: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5516: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5517:

Line 5516: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;

5512:
5513: -- Insert data in the FND_LOBS table without the FILE_DATA.
5514: -- FILE_DATA would be updated from the Controller of the calling page since
5515: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5516: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5517:
5518: INSERT INTO FND_LOBS(
5519: FILE_ID,
5520: FILE_NAME,

Line 5518: INSERT INTO FND_LOBS(

5514: -- FILE_DATA would be updated from the Controller of the calling page since
5515: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5516: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5517:
5518: INSERT INTO FND_LOBS(
5519: FILE_ID,
5520: FILE_NAME,
5521: FILE_CONTENT_TYPE,
5522: UPLOAD_DATE,