77: g_atp_flag varchar2(1) := 'N' ;
78: gUserId number := nvl(Fnd_Global.USER_ID, -1);
79: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);
80:
81: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;
82:
83: TYPE CONTROL_LEVEL_TAB_TYPE is table of mtl_item_attributes.control_level%type index by binary_integer ;
84:
85: g_attribute_name_tab ATTRIB_NAME_TAB_TYPE ;
79: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);
80:
81: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;
82:
83: TYPE CONTROL_LEVEL_TAB_TYPE is table of mtl_item_attributes.control_level%type index by binary_integer ;
84:
85: g_attribute_name_tab ATTRIB_NAME_TAB_TYPE ;
86: g_control_level_tab CONTROL_LEVEL_TAB_TYPE ;
87:
3674:
3675: select substr(attribute_name, instr(attribute_name, '.' )+ 1), control_level
3676: BULK COLLECT
3677: INTO g_attribute_name_tab, g_control_level_tab
3678: from mtl_item_attributes
3679: where control_level = 1 ;
3680:
3681:
3682: --perf bugfix 4905887 (sql id 16105473)