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_CITEM_ADMIN_GRP dependencies on IBC_ATTRIBUTE_TYPES_B

Line 242: temp IBC_ATTRIBUTE_TYPES_B.attribute_type_code%TYPE;

238: f_citem_id IN NUMBER
239: )
240: RETURN VARCHAR2
241: IS
242: temp IBC_ATTRIBUTE_TYPES_B.attribute_type_code%TYPE;
243:
244: CURSOR c_acode IS
245: SELECT
246: ibc_attribute_types_b.attribute_type_code

Line 246: ibc_attribute_types_b.attribute_type_code

242: temp IBC_ATTRIBUTE_TYPES_B.attribute_type_code%TYPE;
243:
244: CURSOR c_acode IS
245: SELECT
246: ibc_attribute_types_b.attribute_type_code
247: FROM
248: ibc_attribute_types_b
249: ,ibc_content_items
250: WHERE

Line 248: ibc_attribute_types_b

244: CURSOR c_acode IS
245: SELECT
246: ibc_attribute_types_b.attribute_type_code
247: FROM
248: ibc_attribute_types_b
249: ,ibc_content_items
250: WHERE
251: ibc_content_items.content_item_id = f_citem_id
252: AND

Line 253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code

249: ,ibc_content_items
250: WHERE
251: ibc_content_items.content_item_id = f_citem_id
252: AND
253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code
254: AND
255: ibc_attribute_types_b.data_type_code = Ibc_Utilities_Pub.G_DTC_ATTACHMENT;
256:
257: BEGIN

Line 255: ibc_attribute_types_b.data_type_code = Ibc_Utilities_Pub.G_DTC_ATTACHMENT;

251: ibc_content_items.content_item_id = f_citem_id
252: AND
253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code
254: AND
255: ibc_attribute_types_b.data_type_code = Ibc_Utilities_Pub.G_DTC_ATTACHMENT;
256:
257: BEGIN
258: --DBMS_OUTPUT.put_line('----- getAttachAttribCode-----');
259: OPEN c_acode;

Line 768: FROM ibc_attribute_types_b a,

764: RETURN VARCHAR2
765: IS
766: CURSOR c_cct IS
767: SELECT a.reference_code
768: FROM ibc_attribute_types_b a,
769: ibc_content_items b
770: WHERE b.content_item_id = f_content_item_id
771: AND b.content_type_code = a.content_type_code
772: AND a.attribute_type_code = f_attribute_type_code

Line 775: temp IBC_ATTRIBUTE_TYPES_B.reference_code%TYPE;

771: AND b.content_type_code = a.content_type_code
772: AND a.attribute_type_code = f_attribute_type_code
773: AND a.reference_code = f_content_type_code;
774:
775: temp IBC_ATTRIBUTE_TYPES_B.reference_code%TYPE;
776: BEGIN
777: --DBMS_OUTPUT.put_line('----- isCorrectContentType -----');
778: OPEN c_cct;
779: FETCH c_cct INTO temp;

Line 1025: att_type IBC_ATTRIBUTE_TYPES_B.attribute_type_code%TYPE; -- loop variable -- type of attribute

1021: qty_codes NUMBER; -- total quantity of attribute codes to process
1022: temp_text VARCHAR2(32767); -- max input size plus padding
1023: temp_attribute VARCHAR2(32767);
1024: att_size NUMBER; -- loop variable -- max size of attribute
1025: att_type IBC_ATTRIBUTE_TYPES_B.attribute_type_code%TYPE; -- loop variable -- type of attribute
1026: required NUMBER;
1027: cont_flag VARCHAR2(1); -- continue flag
1028:
1029: CURSOR c_attribute_type(p_attribute_type_code IN VARCHAR2) IS

Line 1033: FROM ibc_attribute_types_b

1029: CURSOR c_attribute_type(p_attribute_type_code IN VARCHAR2) IS
1030: SELECT data_type_code
1031: ,data_length
1032: ,min_instances
1033: FROM ibc_attribute_types_b
1034: WHERE attribute_type_code = p_attribute_type_code
1035: AND content_type_code = p_ctype_code;
1036:
1037: BEGIN

Line 1651: dtc IBC_ATTRIBUTE_TYPES_B.data_type_code%TYPE;

1647:
1648: -- attribute loop variables
1649: atn IBC_ATTRIBUTE_TYPES_TL.attribute_type_name%TYPE;
1650: atc IBC_ATTRIBUTE_TYPES_TL.attribute_type_code%TYPE; -- loop variable for attribute type
1651: dtc IBC_ATTRIBUTE_TYPES_B.data_type_code%TYPE;
1652:
1653: -- XML encoding
1654: l_xml_encoding VARCHAR2(80);
1655: BEGIN

Line 1745: IBC_ATTRIBUTE_TYPES_B atb

1741: atn,
1742: dtc
1743: FROM
1744: IBC_ATTRIBUTE_TYPES_TL attl,
1745: IBC_ATTRIBUTE_TYPES_B atb
1746: WHERE
1747: atb.attribute_type_code = attl.attribute_type_code
1748: AND
1749: atb.content_type_code = attl.content_type_code

Line 2080: FROM ibc_attribute_types_b

2076: CURSOR c_comp_info(p_content_type VARCHAR2,
2077: p_attribute_type VARCHAR2)
2078: IS
2079: SELECT default_value, updateable_flag
2080: FROM ibc_attribute_types_b
2081: WHERE content_type_code = p_content_type
2082: AND attribute_type_code = p_attribute_type;
2083:
2084: BEGIN

Line 2511: FROM ibc_attribute_types_b

2507: ,default_value dv
2508: ,updateable_flag upd
2509: ,data_length dl
2510: ,flex_value_set_id vset
2511: FROM ibc_attribute_types_b
2512: WHERE content_type_code = p_content_type_code;
2513:
2514: CURSOR c_count_renditions IS
2515: SELECT COUNT(*)

Line 9801: att_type_code IBC_ATTRIBUTE_TYPES_B.data_type_code%TYPE;

9797: l_api_name CONSTANT VARCHAR2(30) := 'set_citem_attachment'; --|**|
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;