APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_LOOKUPS

Line 90: FROM AMW_LOOKUPS

86: INTO N
87: FROM AMW_CONTROL_OBJECTIVES
88: WHERE CONTROL_REV_ID=P_CONTROL_REV_ID
89: AND OBJECTIVE_CODE IN (SELECT LOOKUP_CODE
90: FROM AMW_LOOKUPS
91: WHERE LOOKUP_TYPE='AMW_CONTROL_OBJECTIVES'
92: AND TAG=P_TAG_NUM);
93: RETURN N;
94: EXCEPTION

Line 235: from amw_lookups

231: l_meaning varchar2(80);
232: begin
233: select meaning
234: into l_meaning
235: from amw_lookups
236: where lookup_type = p_lookup_type
237: and lookup_code = p_lookup_code
238: AND enabled_flag ='Y'
239: AND (end_date_active > SYSDATE or end_date_active is null);

Line 988: ---- modified by qliu to get the uom from amw_lookups

984: ---------------------------------------------------------------------
985: ----npanandi 12.02.2004: Added below function to get UnitOfMeasureTL
986: ----given UoM_Code, and UoM_Class (from Profile Option)
987: ---------------------------------------------------------------------
988: ---- modified by qliu to get the uom from amw_lookups
989: FUNCTION GET_UOM_TL(P_UOM_CODE IN VARCHAR2) RETURN VARCHAR2
990: IS
991: -- L_UOM_CLASS MTL_UNITS_OF_MEASURE_VL.UOM_CLASS%TYPE;
992: -- LX_UNIT_OF_MEASURE_TL MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE_TL%TYPE;

Line 993: L_UOM_CLASS AMW_LOOKUPS.LOOKUP_CODE%TYPE;

989: FUNCTION GET_UOM_TL(P_UOM_CODE IN VARCHAR2) RETURN VARCHAR2
990: IS
991: -- L_UOM_CLASS MTL_UNITS_OF_MEASURE_VL.UOM_CLASS%TYPE;
992: -- LX_UNIT_OF_MEASURE_TL MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE_TL%TYPE;
993: L_UOM_CLASS AMW_LOOKUPS.LOOKUP_CODE%TYPE;
994: LX_UNIT_OF_MEASURE_TL AMW_LOOKUPS.MEANING%TYPE;
995: BEGIN
996: /*
997: L_UOM_CLASS := FND_PROFILE.VALUE('AMW_CTRL_UOM_CLASS');

Line 994: LX_UNIT_OF_MEASURE_TL AMW_LOOKUPS.MEANING%TYPE;

990: IS
991: -- L_UOM_CLASS MTL_UNITS_OF_MEASURE_VL.UOM_CLASS%TYPE;
992: -- LX_UNIT_OF_MEASURE_TL MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE_TL%TYPE;
993: L_UOM_CLASS AMW_LOOKUPS.LOOKUP_CODE%TYPE;
994: LX_UNIT_OF_MEASURE_TL AMW_LOOKUPS.MEANING%TYPE;
995: BEGIN
996: /*
997: L_UOM_CLASS := FND_PROFILE.VALUE('AMW_CTRL_UOM_CLASS');
998:

Line 1016: FROM AMW_LOOKUPS

1012: */
1013: BEGIN
1014: SELECT meaning
1015: INTO LX_UNIT_OF_MEASURE_TL
1016: FROM AMW_LOOKUPS
1017: WHERE lookup_type='AMW_CONTROL_FREQUENCY'
1018: AND lookup_code=P_UOM_CODE;
1019: EXCEPTION
1020: WHEN NO_DATA_FOUND THEN