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.ITG_SYNCUOMINBOUND_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 26: p_uom_rec IN mtl_units_of_measure%ROWTYPE

22: RETURN p_value;
23: END check_size;
24:
25: PROCEDURE insert_uom(
26: p_uom_rec IN mtl_units_of_measure%ROWTYPE
27: ) IS
28: l_count NUMBER := 0;
29: BEGIN
30: g_action := 'UOM parameters validation';

Line 40: from mtl_units_of_measure

36:
37: -- this condition is not accounted in the NOT EXISTS clause of the insert
38: select count(*)
39: into l_count
40: from mtl_units_of_measure
41: where (uom_code = p_uom_rec.uom_code and unit_of_measure <> p_uom_rec.unit_of_measure)
42: or (uom_code <> p_uom_rec.uom_code and unit_of_measure = p_uom_rec.unit_of_measure);
43:
44: if l_count > 0 then

Line 52: FROM mtl_units_of_measure

48:
49: IF p_uom_rec.base_uom_flag = 'Y' THEN
50: SELECT COUNT(*)
51: INTO l_count
52: FROM mtl_units_of_measure
53: WHERE base_uom_flag = 'Y'
54: AND uom_class = p_uom_rec.uom_class;
55: IF l_count > 0 THEN
56: ITG_MSG.toomany_base_uom_flag;

Line 62: INSERT INTO mtl_units_of_measure_tl (

58: END IF;
59: END IF;
60:
61: g_action := 'UOM insert';
62: INSERT INTO mtl_units_of_measure_tl (
63: unit_of_measure,
64: unit_of_measure_tl,
65: uom_code,
66: uom_class,

Line 93: FROM mtl_units_of_measure_tl t

89: FROM FND_LANGUAGES l
90: WHERE l.installed_flag IN ('I', 'B')
91: AND NOT EXISTS (
92: SELECT NULL
93: FROM mtl_units_of_measure_tl t
94: WHERE (t.unit_of_measure = p_uom_rec.unit_of_measure
95: OR t.uom_code = p_uom_rec.uom_code)
96: AND t.language = l.language_code);
97: END insert_uom;

Line 100: p_uom_rec IN mtl_units_of_measure%ROWTYPE

96: AND t.language = l.language_code);
97: END insert_uom;
98:
99: PROCEDURE delete_uom(
100: p_uom_rec IN mtl_units_of_measure%ROWTYPE
101: ) IS
102: BEGIN
103: g_action := 'UOM disable';
104: IF p_uom_rec.disable_date IS NULL THEN

Line 109: UPDATE mtl_units_of_measure_tl

105: ITG_MSG.null_disable_date;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: UPDATE mtl_units_of_measure_tl
110: SET disable_date = p_uom_rec.disable_date,
111: last_update_date = p_uom_rec.last_update_date,
112: last_updated_by = p_uom_rec.last_updated_by,
113: --unit_of_measure_tl = p_uom_rec.unit_of_measure_tl, /*null update fails?*/

Line 127: p_uom_rec IN mtl_units_of_measure%ROWTYPE

123: END IF;
124: END delete_uom;
125:
126: PROCEDURE update_uom(
127: p_uom_rec IN mtl_units_of_measure%ROWTYPE
128: ) IS
129: BEGIN
130: g_action := 'UOM update';
131: UPDATE mtl_units_of_measure_tl

Line 131: UPDATE mtl_units_of_measure_tl

127: p_uom_rec IN mtl_units_of_measure%ROWTYPE
128: ) IS
129: BEGIN
130: g_action := 'UOM update';
131: UPDATE mtl_units_of_measure_tl
132: SET description = p_uom_rec.description,
133: disable_date = p_uom_rec.disable_date,
134: --unit_of_measure_tl = p_uom_rec.unit_of_measure_tl, /*null update?*/
135: source_lang = USERENV('LANG'),

Line 215: l_base mtl_units_of_measure.base_uom_flag%TYPE;

211: p_uom IN VARCHAR2,
212: p_uom_code IN VARCHAR2,
213: p_uom_class IN VARCHAR2
214: ) RETURN VARCHAR2 IS
215: l_base mtl_units_of_measure.base_uom_flag%TYPE;
216: BEGIN
217: SELECT base_uom_flag
218: INTO l_base
219: FROM mtl_units_of_measure

Line 219: FROM mtl_units_of_measure

215: l_base mtl_units_of_measure.base_uom_flag%TYPE;
216: BEGIN
217: SELECT base_uom_flag
218: INTO l_base
219: FROM mtl_units_of_measure
220: WHERE unit_of_measure = p_uom
221: AND uom_code = p_uom_code
222: AND uom_class = p_uom_class;
223:

Line 274: l_base_uom_code mtl_units_of_measure.uom_code%TYPE;

270:
271: FUNCTION get_base_uom(
272: p_uom_code IN VARCHAR2
273: ) RETURN VARCHAR2 IS
274: l_base_uom_code mtl_units_of_measure.uom_code%TYPE;
275: BEGIN
276: SELECT m2.uom_code
277: INTO l_base_uom_code
278: FROM mtl_units_of_measure m1,

Line 278: FROM mtl_units_of_measure m1,

274: l_base_uom_code mtl_units_of_measure.uom_code%TYPE;
275: BEGIN
276: SELECT m2.uom_code
277: INTO l_base_uom_code
278: FROM mtl_units_of_measure m1,
279: mtl_units_of_measure m2
280: WHERE m1.uom_code = p_uom_code
281: AND m1.uom_class = m2.uom_class
282: AND m2.base_uom_flag = 'Y';

Line 279: mtl_units_of_measure m2

275: BEGIN
276: SELECT m2.uom_code
277: INTO l_base_uom_code
278: FROM mtl_units_of_measure m1,
279: mtl_units_of_measure m2
280: WHERE m1.uom_code = p_uom_code
281: AND m1.uom_class = m2.uom_class
282: AND m2.base_uom_flag = 'Y';
283: RETURN l_base_uom_code;

Line 607: l_uom_rec mtl_units_of_measure%ROWTYPE;

603: p_dt_expiration IN DATE
604: ) IS
605: /* Working storage */
606: l_cls_rec mtl_uom_classes%ROWTYPE;
607: l_uom_rec mtl_units_of_measure%ROWTYPE;
608: l_con_rec mtl_uom_conversions%ROWTYPE;
609: l_ccv_rec mtl_uom_class_conversions%ROWTYPE;
610: l_param VARCHAR2(200);
611: l_value VARCHAR2(200);

Line 729: l_uom_rec mtl_units_of_measure%ROWTYPE;

725: p_description IN VARCHAR2,
726: p_dt_creation IN DATE,
727: p_dt_expiration IN DATE
728: ) IS
729: l_uom_rec mtl_units_of_measure%ROWTYPE;
730:
731: CURSOR l_def_cls_csr IS
732: SELECT uom_class
733: FROM mtl_units_of_measure

Line 733: FROM mtl_units_of_measure

729: l_uom_rec mtl_units_of_measure%ROWTYPE;
730:
731: CURSOR l_def_cls_csr IS
732: SELECT uom_class
733: FROM mtl_units_of_measure
734: WHERE unit_of_measure = l_uom_rec.unit_of_measure;
735: l_param VARCHAR2(200);
736: l_value VARCHAR2(200);
737: BEGIN

Line 829: l_dummy mtl_units_of_measure.base_uom_flag%TYPE;

825: p_dt_creation IN DATE,
826: p_dt_expiration IN DATE
827: ) IS
828: l_ccv_rec mtl_uom_class_conversions%ROWTYPE;
829: l_dummy mtl_units_of_measure.base_uom_flag%TYPE;
830:
831: /* Get uom and default the value of uom_class. */
832: CURSOR l_uom_csr(l_uom_code VARCHAR2) IS
833: SELECT uom_class, unit_of_measure

Line 834: FROM mtl_units_of_measure

830:
831: /* Get uom and default the value of uom_class. */
832: CURSOR l_uom_csr(l_uom_code VARCHAR2) IS
833: SELECT uom_class, unit_of_measure
834: FROM mtl_units_of_measure
835: WHERE uom_code = l_uom_code;
836:
837: BEGIN
838: g_action := 'UOM conversion parameter validation';

Line 919: l_base_flag mtl_units_of_measure.base_uom_flag%TYPE;

915: p_dt_expiration IN DATE
916: ) IS
917: /* Working storage */
918: l_con_rec mtl_uom_conversions%ROWTYPE;
919: l_base_flag mtl_units_of_measure.base_uom_flag%TYPE;
920:
921: /* Default the value of uom_class */
922: CURSOR l_def_cls_csr IS
923: SELECT uom_class

Line 924: FROM mtl_units_of_measure

920:
921: /* Default the value of uom_class */
922: CURSOR l_def_cls_csr IS
923: SELECT uom_class
924: FROM mtl_units_of_measure
925: WHERE unit_of_measure = l_con_rec.unit_of_measure;
926: BEGIN
927:
928: g_action := 'UOM-conversion parameter validation';

Line 1017: l_fr_base_uom mtl_units_of_measure.uom_code%TYPE;

1013: p_tofactor IN VARCHAR2,
1014: p_dt_creation IN DATE,
1015: p_dt_expiration IN DATE
1016: ) IS
1017: l_fr_base_uom mtl_units_of_measure.uom_code%TYPE;
1018: l_to_base_uom mtl_units_of_measure.uom_code%TYPE;
1019:
1020: /* Default the value of uom_class */
1021: CURSOR l_uom_csr(

Line 1018: l_to_base_uom mtl_units_of_measure.uom_code%TYPE;

1014: p_dt_creation IN DATE,
1015: p_dt_expiration IN DATE
1016: ) IS
1017: l_fr_base_uom mtl_units_of_measure.uom_code%TYPE;
1018: l_to_base_uom mtl_units_of_measure.uom_code%TYPE;
1019:
1020: /* Default the value of uom_class */
1021: CURSOR l_uom_csr(
1022: p_uom_code VARCHAR2

Line 1025: FROM mtl_units_of_measure

1021: CURSOR l_uom_csr(
1022: p_uom_code VARCHAR2
1023: ) IS
1024: SELECT uom_class, unit_of_measure, uom_code, base_uom_flag
1025: FROM mtl_units_of_measure
1026: WHERE uom_code = p_uom_code
1027: AND base_uom_flag LIKE '%';
1028:
1029: l_fr_uom_csr_rec l_uom_csr%ROWTYPE;