APPS.RRS_ATTR_PANE dependencies on EGO_ATTRS_V

Line 480: FROM EGO_ATTRS_V

476: BEGIN
477: SELECT ATTR_NAME, ATTR_DISPLAY_NAME, DISPLAY_CODE, DESCRIPTION, SEQUENCE
478: BULK COLLECT
479: INTO l_attribute_tab
480: FROM EGO_ATTRS_V
481: WHERE APPLICATION_ID = 718
482: AND ATTR_GROUP_TYPE = x_attr_group_tab(j).ATTR_GROUP_TYPE
483: AND ATTR_GROUP_NAME = x_attr_group_tab(j).ATTR_GROUP_NAME
484: AND ENABLED_FLAG = 'Y' --Bug Fix 9709262: The disabled attribute will not show up.

Line 618: l_dynamic_url EGO_ATTRS_V.INFO_1%TYPE;

614: l_uom MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE_TL%TYPE;
615: l_uom_conversion_rate MTL_UOM_CONVERSIONS.CONVERSION_RATE%TYPE;
616:
617: l_index NUMBER := 1;
618: l_dynamic_url EGO_ATTRS_V.INFO_1%TYPE;
619: l_url_value EGO_ATTRS_V.INFO_1%TYPE;
620: l_url_tokens array_of_string := new array_of_string();
621:
622: l_x_display_value VARCHAR2(1000);

Line 619: l_url_value EGO_ATTRS_V.INFO_1%TYPE;

615: l_uom_conversion_rate MTL_UOM_CONVERSIONS.CONVERSION_RATE%TYPE;
616:
617: l_index NUMBER := 1;
618: l_dynamic_url EGO_ATTRS_V.INFO_1%TYPE;
619: l_url_value EGO_ATTRS_V.INFO_1%TYPE;
620: l_url_tokens array_of_string := new array_of_string();
621:
622: l_x_display_value VARCHAR2(1000);
623: l_x_display_type VARCHAR2(200);

Line 637: l_dep_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE;

633:
634: l_date_format_mask VARCHAR2(100);
635:
636: --Bug Fix for Bug 9012596 - jijiao 10/15/2009
637: l_dep_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE;
638: l_start_index NUMBER;
639: l_next_space_index NUMBER;
640: l_dep_column EGO_ATTRS_V.DATABASE_COLUMN%TYPE;
641: l_dep_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

Line 640: l_dep_column EGO_ATTRS_V.DATABASE_COLUMN%TYPE;

636: --Bug Fix for Bug 9012596 - jijiao 10/15/2009
637: l_dep_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE;
638: l_start_index NUMBER;
639: l_next_space_index NUMBER;
640: l_dep_column EGO_ATTRS_V.DATABASE_COLUMN%TYPE;
641: l_dep_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
642: l_dep_code_value VARCHAR2(1000);
643: l_dep_date_value DATE;
644:

Line 641: l_dep_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

637: l_dep_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE;
638: l_start_index NUMBER;
639: l_next_space_index NUMBER;
640: l_dep_column EGO_ATTRS_V.DATABASE_COLUMN%TYPE;
641: l_dep_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
642: l_dep_code_value VARCHAR2(1000);
643: l_dep_date_value DATE;
644:
645: BEGIN

Line 677: FROM EGO_ATTRS_V

673: --Need add Attribute Group Type to the where clause to handle the Same Attribute Group Names for the different Attribute Group Types
674: BEGIN
675: SELECT DATABASE_COLUMN, DATA_TYPE_CODE, INFO_1, UOM_CLASS, VALUE_SET_ID, VALIDATION_CODE, DISPLAY_CODE, DISPLAY_MEANING
676: INTO l_attr_info
677: FROM EGO_ATTRS_V
678: WHERE APPLICATION_ID = 718
679: AND ATTR_GROUP_TYPE = p_attr_group_type
680: AND ATTR_GROUP_NAME = p_attr_group_name
681: AND ATTR_NAME = p_attr_name;

Line 942: FROM EGO_ATTRS_V

938:
939: BEGIN
940: SELECT DATABASE_COLUMN, DATA_TYPE_CODE
941: INTO l_dep_column, l_dep_data_type
942: FROM EGO_ATTRS_V
943: WHERE APPLICATION_ID = 718
944: AND ATTR_GROUP_TYPE = p_attr_group_type
945: AND ATTR_GROUP_NAME = p_attr_group_name
946: AND ATTR_NAME = l_dep_attr_name;

Line 1189: FROM EGO_ATTRS_V

1185:
1186: -- query the corresponding attribute name of the data column name
1187: SELECT ATTR_NAME
1188: INTO l_attr_name
1189: FROM EGO_ATTRS_V
1190: WHERE APPLICATION_ID = 718
1191: AND ATTR_GROUP_TYPE = l_attr_group_type
1192: AND ATTR_GROUP_NAME = l_attr_group_name
1193: AND DATABASE_COLUMN = p_column_name;

Line 1265: FROM EGO_ATTRS_V

1261:
1262: -- query the corresponding attribute name of the data column name
1263: SELECT ATTR_NAME
1264: INTO l_attr_name
1265: FROM EGO_ATTRS_V
1266: WHERE APPLICATION_ID = 718
1267: AND ATTR_GROUP_TYPE = l_attr_group_type
1268: AND ATTR_GROUP_NAME = l_attr_group_name
1269: AND DATABASE_COLUMN = p_column_name;