APPS.RRS_ATTR_PANE dependencies on RRS_SITES_EXT_VL

Line 243: l_ext_table_name := 'RRS_SITES_EXT_VL';

239: IF UPPER(p_object_type) = 'NODE' THEN
240: RAISE e_no_uda;
241: ELSIF UPPER(p_object_type) = 'SITE' THEN
242: l_obj_name := 'RRS_SITE';
243: l_ext_table_name := 'RRS_SITES_EXT_VL';
244: l_pk_name := 'SITE_ID';
245: l_classification_name := 'SITE_USE_TYPE_CODE';
246: ELSIF UPPER(p_object_type) = 'LOCATION' THEN
247: l_obj_name := 'RRS_LOCATION';

Line 613: l_uom_code RRS_SITES_EXT_VL.UOM_EXT_ATTR1%TYPE;

609: l_attr_info attr_info_rec;
610: l_code_value VARCHAR2(1000);
611: l_date_value DATE;
612:
613: l_uom_code RRS_SITES_EXT_VL.UOM_EXT_ATTR1%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;

Line 650: l_ext_table_name := 'RRS_SITES_EXT_VL';

646:
647: --DBMS_OUTPUT.PUT_LINE('p_object_type: ' || p_object_type);
648: /* decide which object type we are processing*/
649: IF UPPER(p_object_type) = 'SITE' THEN
650: l_ext_table_name := 'RRS_SITES_EXT_VL';
651: l_pk_name := 'SITE_ID';
652: ELSIF UPPER(p_object_type) = 'LOCATION' THEN
653: l_ext_table_name := 'RRS_LOCATIONS_EXT_VL';
654: l_pk_name := 'LOCATION_ID';