APPS.IBC_CITEM_ADMIN_GRP dependencies on FND_LOBS

Line 286: fnd_lobs

282: CURSOR c_fname IS
283: SELECT
284: file_name
285: FROM
286: fnd_lobs
287: WHERE
288: file_id = f_file_id;
289:
290: temp FND_LOBS.file_name%TYPE;

Line 290: temp FND_LOBS.file_name%TYPE;

286: fnd_lobs
287: WHERE
288: file_id = f_file_id;
289:
290: temp FND_LOBS.file_name%TYPE;
291: BEGIN
292: --DBMS_OUTPUT.put_line('----- getAttachFileName -----');
293: OPEN c_fname;
294: FETCH c_fname INTO temp;

Line 1420: -- adding data to fnd_lobs

1416: FND_MESSAGE.Set_Token('CIVL',px_citem_ver_id, FALSE);
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSE
1420: -- adding data to fnd_lobs
1421: Ibc_Utilities_Pvt.insert_attribute_bundle(
1422: x_lob_file_id => new_attrib_fid
1423: ,p_new_bundle => o_attrib_bundle
1424: ,x_return_status => x_return_status

Line 6207: FROM fnd_lobs

6203: WHERE content_item_id = p_content_item_id;
6204:
6205: CURSOR c_lob(p_file_id NUMBER) IS
6206: SELECT file_name, file_content_type
6207: FROM fnd_lobs
6208: WHERE file_id = p_file_id;
6209:
6210: BEGIN
6211: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');

Line 9543: -- Inserting temp lob into fnd_lobs

9539: ,x_return_status => return_status
9540: );
9541:
9542: --**************** STORING INFO TO DB ***********
9543: -- Inserting temp lob into fnd_lobs
9544: IF (return_status = FND_API.G_RET_STS_SUCCESS) THEN
9545: -- removing old bundle if requested (this is fine because no sharing
9546: -- has occured yet due to fact that the item is not published.
9547: IF (p_remove_old = FND_API.g_true) THEN

Line 9551: -- adding data to fnd_lobs

9547: IF (p_remove_old = FND_API.g_true) THEN
9548: return_status := deleteAttributeBundle(p_citem_ver_id);
9549: END IF;
9550:
9551: -- adding data to fnd_lobs
9552: Ibc_Utilities_Pvt.insert_attribute_bundle(
9553: x_lob_file_id => file_id
9554: ,p_new_bundle => bundle_text
9555: ,x_return_status => return_status

Line 9802: l_attach_rendition_mtype FND_LOBS.file_content_type%TYPE;

9798: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
9799: --******************* END REQUIRED VARIABLES ***************************
9800: att_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
9801: att_type_code IBC_ATTRIBUTE_TYPES_B.data_type_code%TYPE;
9802: l_attach_rendition_mtype FND_LOBS.file_content_type%TYPE;
9803: l_current_attachment_file_id NUMBER;
9804: content_item_id NUMBER;
9805: dir_id NUMBER;
9806: l_row_id ROWID;

Line 9811: FROM fnd_lobs

9807: l_rendition_id NUMBER;
9808:
9809: CURSOR c_lob(p_file_id NUMBER) IS
9810: SELECT file_name, file_content_type
9811: FROM fnd_lobs
9812: WHERE file_id = p_file_id;
9813:
9814: BEGIN
9815: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');

Line 11596: FROM fnd_lobs

11592:
11593:
11594: CURSOR c_lob(p_file_id NUMBER) IS
11595: SELECT file_name, file_content_type
11596: FROM fnd_lobs
11597: WHERE file_id = p_file_id;
11598:
11599: BEGIN
11600: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');

Line 12082: -- Inserting temp lob into fnd_lobs

12078: ,p_ctype_code => p_ctype_code
12079: ,x_return_status => x_return_status
12080: );
12081: --**************** STORING INFO TO DB ***********
12082: -- Inserting temp lob into fnd_lobs
12083: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
12084:
12085: -- adding data to fnd_lobs
12086: Ibc_Utilities_Pvt.insert_attribute_bundle(

Line 12085: -- adding data to fnd_lobs

12081: --**************** STORING INFO TO DB ***********
12082: -- Inserting temp lob into fnd_lobs
12083: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
12084:
12085: -- adding data to fnd_lobs
12086: Ibc_Utilities_Pvt.insert_attribute_bundle(
12087: x_lob_file_id => bundle_file_id
12088: ,p_new_bundle => bundle_text
12089: ,x_return_status => x_return_status