eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UOM_API_PUB dependencies on MTL_UOM_CLASSES_TL

Line 32: FROM mtl_uom_classes_tl

28: RETURN BOOLEAN
29: IS
30: CURSOR l_cur IS
31: SELECT 1
32: FROM mtl_uom_classes_tl
33: WHERE uom_class = p_uom_class;
34: l_found BOOLEAN;
35: l_count NUMBER;
36: BEGIN

Line 475: p_uom_class_tl MTL_UOM_CLASSES_TL.UOM_CLASS_TL%type;

471:
472: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;
473:
474: -- p_uom_class_tl VARCHAR2(10);
475: p_uom_class_tl MTL_UOM_CLASSES_TL.UOM_CLASS_TL%type;
476: L_ROW_ID VARCHAR2(40);
477: P_API_VERSION_NUMBER NUMBER := 1.0;
478: P_INIT_MSG_LST VARCHAR2(50);
479:

Line 890: -- Code logic to insert MTL_UOM_CLASSES_TL table. (user installed languages)

886: END IF;
887:
888: END LOOP;
889:
890: -- Code logic to insert MTL_UOM_CLASSES_TL table. (user installed languages)
891:
892: -- second if p_action_type = 'I'
893: IF p_action_type = 'I' THEN
894:

Line 897: mtl_uom_classes_tl_pkg.insert_row(x_rowid => l_row_id,

893: IF p_action_type = 'I' THEN
894:
895: begin
896:
897: mtl_uom_classes_tl_pkg.insert_row(x_rowid => l_row_id,
898: x_uom_class => p_uom_class,
899: x_uom_class_tl => p_uom_class_tl,
900: x_description => p_description,
901: x_disable_date => p_disable_date,

Line 942: -- End of Code logic to insert MTL_UOM_CLASSES_TL table.

938: IF NOT (X_RETURN_STATUS = L_SUCCESS) THEN
939: APP_EXCEPTION.RAISE_EXCEPTION;
940: END IF;
941:
942: -- End of Code logic to insert MTL_UOM_CLASSES_TL table.
943: -- Code logic to insert MTL_UNITS_OF_MEASURE table. (user installed languages)
944: -- From this procedure always base_unit_of_measure gets inserted into unit of measure table.
945: -- DBMS_OUTPUT.PUT_LINE('Before calling UOM insert');
946:

Line 1173: MTL_UOM_CLASSES_TL_PKG.UPDATE_ROW ( X_UOM_CLASS => P_UOM_CLASS,

1169: IF p_action_type = 'U' THEN
1170:
1171: BEGIN
1172:
1173: MTL_UOM_CLASSES_TL_PKG.UPDATE_ROW ( X_UOM_CLASS => P_UOM_CLASS,
1174: X_UOM_CLASS_TL => P_UOM_CLASS_TL,
1175: X_DESCRIPTION => P_DESCRIPTION,
1176: x_disable_date => p_disable_date,
1177: x_attribute_category => p_attribute_category,

Line 1919: L_FROM_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

1915: L_CONV_REC MTL_LOT_UOM_CLASS_CONVERSIONS%ROWTYPE;
1916: -- L_FROM_UNIT_OF_MEASURE VARCHAR(25);
1917: L_FROM_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1918: -- L_FROM_UOM_CLASS VARCHAR2(30);
1919: L_FROM_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1920: L_TO_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1921: -- L_TO_UNIT_OF_MEASURE VARCHAR2(40);
1922: -- l_to_uom_class VARCHAR2(40);
1923: L_TO_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

Line 1923: L_TO_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

1919: L_FROM_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1920: L_TO_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1921: -- L_TO_UNIT_OF_MEASURE VARCHAR2(40);
1922: -- l_to_uom_class VARCHAR2(40);
1923: L_TO_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1924: --L_UOM_CODE VARCHAR2(3);
1925: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;
1926: -- l_class VARCHAR2(10);
1927: l_conversion_id NUMBER;

Line 1990: L_FROM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

1986: L_QTY_TBL MTL_LOT_UOM_CONV_PUB.QUANTITY_UPDATE_REC_TYPE;
1987: X_BATCH_ROW GME_BATCH_HEADER%ROWTYPE;
1988:
1989: -- L_FROM_CLASS VARCHAR2(100);
1990: L_FROM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1991:
1992: X_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1993: X_SEC_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1994:

Line 1992: X_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

1988:
1989: -- L_FROM_CLASS VARCHAR2(100);
1990: L_FROM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1991:
1992: X_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1993: X_SEC_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1994:
1995: P_FROM_BASE_UOM_FLAG VARCHAR2(10);
1996: --L_TO_CLASS VARCHAR2(30);

Line 1993: X_SEC_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

1989: -- L_FROM_CLASS VARCHAR2(100);
1990: L_FROM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1991:
1992: X_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1993: X_SEC_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1994:
1995: P_FROM_BASE_UOM_FLAG VARCHAR2(10);
1996: --L_TO_CLASS VARCHAR2(30);
1997: L_TO_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

Line 1997: L_TO_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

1993: X_SEC_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1994:
1995: P_FROM_BASE_UOM_FLAG VARCHAR2(10);
1996: --L_TO_CLASS VARCHAR2(30);
1997: L_TO_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1998:
1999: x_opm_costed_flag MTL_MATERIAL_TRANSACTIONS.OPM_COSTED_FLAG%TYPE ;
2000:
2001: P_TO_BASE_UOM_FLAG VARCHAR2(10);