DBA Data[Home] [Help]

APPS.RRS_BULKLOAD_ENTITIES dependencies on EGO_ATTRS_V

Line 218: FROM ego_attrs_v

214: AND application_id = G_APPLICATION_ID
215: );
216: CURSOR c_attr_grp_n_attr_int_names(p_attr_id IN NUMBER,c_attr_group_type IN VARCHAR2) IS
217: SELECT attr_group_name, attr_name
218: FROM ego_attrs_v
219: WHERE attr_id = p_attr_id
220: AND attr_group_type = c_attr_group_type
221: AND application_id = G_APPLICATION_ID;
222: TYPE L_USER_ATTR_REC_TYPE IS RECORD

Line 253: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;

249: l_trade_area_num_char VARCHAR(10);
250: l_count NUMBER(5);
251: l_data_type_code VARCHAR2(2);
252: l_transaction_id NUMBER(15);
253: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
254: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
255:
256: l_attr_group_id NUMBER(15); --bug 6493113
257: l_site_id NUMBER(15); --bug 6493113

Line 254: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;

250: l_count NUMBER(5);
251: l_data_type_code VARCHAR2(2);
252: l_transaction_id NUMBER(15);
253: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
254: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
255:
256: l_attr_group_id NUMBER(15); --bug 6493113
257: l_site_id NUMBER(15); --bug 6493113
258: l_attr_group_id_table DBMS_SQL.NUMBER_TABLE;