DBA Data[Home] [Help]

APPS.IBC_CITEM_ADMIN_GRP dependencies on IBC_ATTRIBUTE_TYPES_TL

Line 364: FROM ibc_attribute_types_tl

360: IS
361: l_result VARCHAR2(80);
362: CURSOR c_attribute_type IS
363: SELECT attribute_type_name
364: FROM ibc_attribute_types_tl
365: WHERE content_type_code = p_content_type_code
366: AND attribute_type_code = p_attribute_type_code
367: AND LANGUAGE = p_language;
368:

Line 1649: atn IBC_ATTRIBUTE_TYPES_TL.attribute_type_name%TYPE;

1645: attribute_type_names JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1646: attributes JTF_VARCHAR2_TABLE_32767 := JTF_VARCHAR2_TABLE_32767();
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

Line 1650: atc IBC_ATTRIBUTE_TYPES_TL.attribute_type_code%TYPE; -- loop variable for attribute type

1646: attributes JTF_VARCHAR2_TABLE_32767 := JTF_VARCHAR2_TABLE_32767();
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);

Line 1744: IBC_ATTRIBUTE_TYPES_TL attl,

1740: INTO
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