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

Line 904: -- -- fnd_lobs table, but is not used with that name to avoid confusion.

900: -- *p_file_id = fnd_lob file_id that will be assigned to this object
901: -- *p_file_data = the attachment
902: -- *p_file_name = name of the file being added
903: -- *p_mime_type = this is equivalent to p_file_content_type of the
904: -- -- fnd_lobs table, but is not used with that name to avoid confusion.
905: -- *p_file_format = only two(2) valid formats: 'text','binary'
906: -- p_program_tag IN VARCHAR2 DEFAULT NULL
907: /*******************************************************************/
908: PROCEDURE insert_attachment(

Line 938: -- Getting next fnd_lobs sequence number

934: Fnd_Message.Set_Token('INPUT', 'p_mime_type', FALSE);
935: Fnd_Msg_Pub.ADD;
936: END IF;
937:
938: -- Getting next fnd_lobs sequence number
939: SELECT
940: fnd_lobs_s.NEXTVAL
941: INTO
942: x_file_id

Line 940: fnd_lobs_s.NEXTVAL

936: END IF;
937:
938: -- Getting next fnd_lobs sequence number
939: SELECT
940: fnd_lobs_s.NEXTVAL
941: INTO
942: x_file_id
943: FROM
944: dual;

Line 946: INSERT INTO fnd_lobs(

942: x_file_id
943: FROM
944: dual;
945:
946: INSERT INTO fnd_lobs(
947: file_id
948: ,file_name
949: ,file_content_type
950: ,file_data

Line 1026: -- file_id = file id in fnd_lobs given to the lob created.

1022: --
1023: -- This procedure does not commit the action.
1024: --
1025: -- VARIABLES
1026: -- file_id = file id in fnd_lobs given to the lob created.
1027: /*******************************************************************/
1028: PROCEDURE insert_attribute_bundle(
1029: x_lob_file_id OUT NOCOPY NUMBER
1030: ,p_new_bundle IN CLOB

Line 1039: -- Getting next fnd_lobs sequence number

1035:
1036: BEGIN
1037: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1038:
1039: -- Getting next fnd_lobs sequence number
1040: SELECT ibc_attribute_bundles_s1.NEXTVAL
1041: INTO x_lob_file_id
1042: FROM dual;
1043:

Line 1082: -- new_blob = prepared data to be added to fnd_lobs, it also returns a reference

1078: --
1079: -- This procedure does not commit the action.
1080: --
1081: -- VARIABLES
1082: -- new_blob = prepared data to be added to fnd_lobs, it also returns a reference
1083: -- to the blob for further additions.
1084: -- exp_date = expiration date to set with data (DEFAULT is NULL).
1085: -- program_tag = VARCHAR2(32) to store added info about blob.
1086: -- file_id = file id in fnd_lobs given to the lob created.

Line 1086: -- file_id = file id in fnd_lobs given to the lob created.

1082: -- new_blob = prepared data to be added to fnd_lobs, it also returns a reference
1083: -- to the blob for further additions.
1084: -- exp_date = expiration date to set with data (DEFAULT is NULL).
1085: -- program_tag = VARCHAR2(32) to store added info about blob.
1086: -- file_id = file id in fnd_lobs given to the lob created.
1087: /*******************************************************************/
1088: PROCEDURE touch_attribute_bundle(
1089: x_lob_file_id OUT NOCOPY NUMBER
1090: ,p_exp_date IN DATE

Line 1099: -- Getting next fnd_lobs sequence number

1095: l_api_name CONSTANT VARCHAR2(30) := 'touch_attribute_bundle';
1096: BEGIN
1097: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1098:
1099: -- Getting next fnd_lobs sequence number
1100: SELECT
1101: fnd_lobs_s.NEXTVAL
1102: INTO
1103: x_lob_file_id

Line 1101: fnd_lobs_s.NEXTVAL

1097: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1098:
1099: -- Getting next fnd_lobs sequence number
1100: SELECT
1101: fnd_lobs_s.NEXTVAL
1102: INTO
1103: x_lob_file_id
1104: FROM
1105: dual;

Line 1108: INSERT INTO fnd_lobs(

1104: FROM
1105: dual;
1106:
1107: -- Reserving empty blob with meta-data
1108: INSERT INTO fnd_lobs(
1109: file_id,
1110: file_name,
1111: file_content_type,
1112: file_data,

Line 1235: CURSOR CUR_FND_LOBS

1231: /*******************************************************************/
1232: PROCEDURE post_insert(p_file_id IN NUMBER,
1233: p_file_type IN VARCHAR2)
1234: IS
1235: CURSOR CUR_FND_LOBS
1236: IS
1237: SELECT
1238: file_id,
1239: file_name,

Line 1249: FND_LOBS

1245: program_tag,
1246: file_format,
1247: LANGUAGE
1248: FROM
1249: FND_LOBS
1250: WHERE
1251: file_id = p_file_id;
1252:
1253: CURSOR CUR_CITEM_REN(p_citem_version_id IN NUMBER)

Line 1267: fnd_lobs_rec CUR_FND_LOBS%ROWTYPE;

1263: citem.LANGUAGE = ren.LANGUAGE(+) AND
1264: NVL(default_rendition_mime_type,' ') = NVL(mime_type,' ')
1265: AND citem.citem_version_id = p_citem_version_id;
1266:
1267: fnd_lobs_rec CUR_FND_LOBS%ROWTYPE;
1268:
1269: l_citem_version_id NUMBER;
1270: l_language VARCHAR2(4);
1271: l_file_name VARCHAR2(100);

Line 1279: OPEN CUR_FND_LOBS;

1275: l_old_file_id NUMBER := NULL;
1276:
1277: BEGIN
1278:
1279: OPEN CUR_FND_LOBS;
1280: FETCH CUR_FND_LOBS INTO fnd_lobs_rec;
1281:
1282: l_citem_version_id := SUBSTR(FND_LOBS_REC.program_tag,INSTR(FND_LOBS_REC.program_tag,':',1)+1);
1283: l_app_name := UPPER(SUBSTR(FND_LOBS_REC.program_tag,1,INSTR(FND_LOBS_REC.program_tag,':',1)-1));

Line 1280: FETCH CUR_FND_LOBS INTO fnd_lobs_rec;

1276:
1277: BEGIN
1278:
1279: OPEN CUR_FND_LOBS;
1280: FETCH CUR_FND_LOBS INTO fnd_lobs_rec;
1281:
1282: l_citem_version_id := SUBSTR(FND_LOBS_REC.program_tag,INSTR(FND_LOBS_REC.program_tag,':',1)+1);
1283: l_app_name := UPPER(SUBSTR(FND_LOBS_REC.program_tag,1,INSTR(FND_LOBS_REC.program_tag,':',1)-1));
1284: l_language := FND_LOBS_REC.LANGUAGE;

Line 1282: l_citem_version_id := SUBSTR(FND_LOBS_REC.program_tag,INSTR(FND_LOBS_REC.program_tag,':',1)+1);

1278:
1279: OPEN CUR_FND_LOBS;
1280: FETCH CUR_FND_LOBS INTO fnd_lobs_rec;
1281:
1282: l_citem_version_id := SUBSTR(FND_LOBS_REC.program_tag,INSTR(FND_LOBS_REC.program_tag,':',1)+1);
1283: l_app_name := UPPER(SUBSTR(FND_LOBS_REC.program_tag,1,INSTR(FND_LOBS_REC.program_tag,':',1)-1));
1284: l_language := FND_LOBS_REC.LANGUAGE;
1285: l_file_name := SUBSTR(FND_LOBS_REC.file_name,INSTR(FND_LOBS_REC.file_name,'/',-1)+1);
1286:

Line 1283: l_app_name := UPPER(SUBSTR(FND_LOBS_REC.program_tag,1,INSTR(FND_LOBS_REC.program_tag,':',1)-1));

1279: OPEN CUR_FND_LOBS;
1280: FETCH CUR_FND_LOBS INTO fnd_lobs_rec;
1281:
1282: l_citem_version_id := SUBSTR(FND_LOBS_REC.program_tag,INSTR(FND_LOBS_REC.program_tag,':',1)+1);
1283: l_app_name := UPPER(SUBSTR(FND_LOBS_REC.program_tag,1,INSTR(FND_LOBS_REC.program_tag,':',1)-1));
1284: l_language := FND_LOBS_REC.LANGUAGE;
1285: l_file_name := SUBSTR(FND_LOBS_REC.file_name,INSTR(FND_LOBS_REC.file_name,'/',-1)+1);
1286:
1287:

Line 1284: l_language := FND_LOBS_REC.LANGUAGE;

1280: FETCH CUR_FND_LOBS INTO fnd_lobs_rec;
1281:
1282: l_citem_version_id := SUBSTR(FND_LOBS_REC.program_tag,INSTR(FND_LOBS_REC.program_tag,':',1)+1);
1283: l_app_name := UPPER(SUBSTR(FND_LOBS_REC.program_tag,1,INSTR(FND_LOBS_REC.program_tag,':',1)-1));
1284: l_language := FND_LOBS_REC.LANGUAGE;
1285: l_file_name := SUBSTR(FND_LOBS_REC.file_name,INSTR(FND_LOBS_REC.file_name,'/',-1)+1);
1286:
1287:
1288: CLOSE CUR_FND_LOBS;

Line 1285: l_file_name := SUBSTR(FND_LOBS_REC.file_name,INSTR(FND_LOBS_REC.file_name,'/',-1)+1);

1281:
1282: l_citem_version_id := SUBSTR(FND_LOBS_REC.program_tag,INSTR(FND_LOBS_REC.program_tag,':',1)+1);
1283: l_app_name := UPPER(SUBSTR(FND_LOBS_REC.program_tag,1,INSTR(FND_LOBS_REC.program_tag,':',1)-1));
1284: l_language := FND_LOBS_REC.LANGUAGE;
1285: l_file_name := SUBSTR(FND_LOBS_REC.file_name,INSTR(FND_LOBS_REC.file_name,'/',-1)+1);
1286:
1287:
1288: CLOSE CUR_FND_LOBS;
1289:

Line 1288: CLOSE CUR_FND_LOBS;

1284: l_language := FND_LOBS_REC.LANGUAGE;
1285: l_file_name := SUBSTR(FND_LOBS_REC.file_name,INSTR(FND_LOBS_REC.file_name,'/',-1)+1);
1286:
1287:
1288: CLOSE CUR_FND_LOBS;
1289:
1290: --
1291: -- The below was added to remove any existing attribute files ids or
1292: -- attachment file_ids

Line 1293: -- from FND_LOBS after the content item is loaded from seed. FNDGFU will

1289:
1290: --
1291: -- The below was added to remove any existing attribute files ids or
1292: -- attachment file_ids
1293: -- from FND_LOBS after the content item is loaded from seed. FNDGFU will
1294: -- always insert new files and this file_id will be replaced with the new ones.
1295: -- select the file_id to removed from the fnd lobs
1296: -- Later after the update is done make sure that the file is not referenced any where.
1297: --

Line 1295: -- select the file_id to removed from the fnd lobs

1291: -- The below was added to remove any existing attribute files ids or
1292: -- attachment file_ids
1293: -- from FND_LOBS after the content item is loaded from seed. FNDGFU will
1294: -- always insert new files and this file_id will be replaced with the new ones.
1295: -- select the file_id to removed from the fnd lobs
1296: -- Later after the update is done make sure that the file is not referenced any where.
1297: --
1298:
1299: BEGIN

Line 1331: UPDATE FND_LOBS

1327:
1328:
1329: IF p_file_type='ATTACH' THEN
1330:
1331: UPDATE FND_LOBS
1332: SET file_name = (SELECT attachment_file_name FROM ibc_citem_versions_tl
1333: WHERE attachment_file_id=p_file_id AND ROWNUM=1)
1334: WHERE file_id = p_file_id;
1335:

Line 1359: UPDATE FND_LOBS

1355: END;
1356:
1357: ELSIF p_file_type='ATTRIB' THEN
1358:
1359: UPDATE FND_LOBS
1360: SET file_name = l_file_name
1361: WHERE file_id = p_file_id;
1362:
1363: END IF;

Line 1365: DELETE FROM fnd_lobs

1361: WHERE file_id = p_file_id;
1362:
1363: END IF;
1364:
1365: DELETE FROM fnd_lobs
1366: WHERE file_id = l_old_file_id
1367: AND NOT EXISTS (SELECT NULL FROM ibc_citem_versions_tl
1368: WHERE DECODE(p_file_type,'ATTRIB',ATTRIBUTE_FILE_ID,'ATTACH',ATTACHMENT_FILE_ID) = l_old_file_id);
1369:

Line 1511: -- Transaction for FND LOBS

1507: -- API name : Create_Autonomous_renditions
1508: -- Type : Private
1509: -- Pre-reqs : None
1510: -- Function : Called from Content Item Screens/AM to create an autonomous
1511: -- Transaction for FND LOBS
1512: -------------------------------------------------------------------------------
1513: PROCEDURE Create_Autonomous_Upload( p_file_name IN VARCHAR2,
1514: p_mime_type IN VARCHAR2,
1515: p_file_format IN VARCHAR2,

Line 1527: -- Getting next fnd_lobs sequence number

1523:
1524: BEGIN
1525:
1526: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1527: -- Getting next fnd_lobs sequence number
1528: SELECT
1529: fnd_lobs_s.NEXTVAL INTO x_file_id
1530: FROM
1531: dual;

Line 1529: fnd_lobs_s.NEXTVAL INTO x_file_id

1525:
1526: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1527: -- Getting next fnd_lobs sequence number
1528: SELECT
1529: fnd_lobs_s.NEXTVAL INTO x_file_id
1530: FROM
1531: dual;
1532:
1533: INSERT INTO fnd_lobs(

Line 1533: INSERT INTO fnd_lobs(

1529: fnd_lobs_s.NEXTVAL INTO x_file_id
1530: FROM
1531: dual;
1532:
1533: INSERT INTO fnd_lobs(
1534: file_id
1535: ,file_name
1536: ,file_content_type
1537: ,file_data

Line 1633: -- Function : returns the CLOB from FND_LOBS for the attachment files

1629: -- Start of comments
1630: -- API name : getAttachclob
1631: -- Type : Private
1632: -- Pre-reqs : None
1633: -- Function : returns the CLOB from FND_LOBS for the attachment files
1634: --
1635: -------------------------------------------------------------------------------
1636: FUNCTION getAttachclob (p_file_id NUMBER) RETURN CLOB IS
1637: l_xmlblob BLOB;

Line 1655: FROM FND_LOBS

1651: DBMS_LOB.createtemporary(l_xmlclob, TRUE, 2);
1652:
1653: SELECT file_data
1654: INTO l_xmlblob
1655: FROM FND_LOBS
1656: WHERE file_id = p_file_id;
1657:
1658: l_totalLen := DBMS_LOB.GETLENGTH(l_xmlblob);
1659: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_xmlblob);