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.MTL_MVT_STATS_RULE_SETS_PKG dependencies on MTL_MVT_STATS_RULE_SETS_TL

Line 14: --| MTL_MVT_STATS_RULE_SETS and MTL_MVT_STATS_RULE_SETS_TL |

10: --| |
11: --| DESCRIPTION |
12: --| Use this package to create procedure for inserting rows, updating |
13: --| rows, locking rows and deleting rows on tables |
14: --| MTL_MVT_STATS_RULE_SETS and MTL_MVT_STATS_RULE_SETS_TL |
15: --| |
16: --| PROCEDURE LIST |
17: --| PROCEDURE Insert_Row |
18: --| PROCEDURE Update_Row |

Line 45: -- _b and table mtl_mvt_stats_rule_sets_tl

41: --=========================================================================
42: --PRECEDURE : Insert_Row Public
43: --PARAMETERS: see below
44: --COMMENT : table handler for inserting data into table mtl_mvt_stats_rule_sets
45: -- _b and table mtl_mvt_stats_rule_sets_tl
46: --==========================================================================
47: PROCEDURE Insert_Row
48: ( x_rowid IN OUT NOCOPY VARCHAR2
49: , p_rule_set_code IN VARCHAR2

Line 92: INSERT INTO MTL_MVT_STATS_RULE_SETS_TL

88: , p_last_updated_by
89: , p_last_update_login
90: );
91:
92: INSERT INTO MTL_MVT_STATS_RULE_SETS_TL
93: ( Rule_Set_code
94: , Rule_Set_display_name
95: , Rule_Set_description
96: , created_by

Line 122: MTL_MVT_STATS_RULE_SETS_TL T

118: AND NOT EXISTS
119: (SELECT
120: NULL
121: FROM
122: MTL_MVT_STATS_RULE_SETS_TL T
123: WHERE T.Rule_Set_code = p_rule_set_code
124: AND T.language = L.language_code);
125:
126: OPEN c;

Line 149: -- table mtl_mvt_stats_rule_sets_tl

145: --=========================================================================
146: --PRECEDURE : Lock_Row Public
147: --PARAMETERS: see below
148: --COMMENT : table handler for locking table mtl_mvt_stats_rule_sets_b and
149: -- table mtl_mvt_stats_rule_sets_tl
150: --EXCEPTION : record_changed;
151: --==========================================================================
152: PROCEDURE Lock_Row
153: ( p_rule_set_code IN VARCHAR2

Line 172: MTL_MVT_STATS_RULE_SETS_TL

168: Rule_Set_display_name
169: , Rule_Set_description
170: , decode(language, USERENV('LANG'), 'Y', 'N') baselang
171: FROM
172: MTL_MVT_STATS_RULE_SETS_TL
173: WHERE Rule_Set_code = p_rule_set_code
174: FOR UPDATE OF Rule_Set_code NOWAIT;
175:
176: record_changed EXCEPTION;

Line 219: -- _b and table mtl_mvt_stats_rule_sets_tl

215: --=========================================================================
216: --PRECEDURE : Update_Row Public
217: --PARAMETERS: see below
218: --COMMENT : table handler for updating data of table mtl_mvt_stats_rule_sets
219: -- _b and table mtl_mvt_stats_rule_sets_tl
220: --==========================================================================
221: PROCEDURE Update_Row
222: ( p_rule_set_code IN VARCHAR2
223: , p_rule_set_display_name IN VARCHAR2

Line 247: UPDATE MTL_MVT_STATS_RULE_SETS_TL

243: THEN
244: RAISE NO_DATA_FOUND;
245: END IF;
246:
247: UPDATE MTL_MVT_STATS_RULE_SETS_TL
248: SET
249: Rule_Set_display_name = p_rule_set_display_name
250: , Rule_Set_description = p_rule_set_description
251: , last_update_date = p_last_update_date

Line 277: -- _b and table mtl_mvt_stats_rule_sets_tl

273: --=========================================================================
274: --PRECEDURE : Delete_Row Public
275: --PARAMETERS: see below
276: --COMMENT : table handler for deleting data from table mtl_mvt_stats_rule_sets
277: -- _b and table mtl_mvt_stats_rule_sets_tl
278: --==========================================================================
279: PROCEDURE Delete_Row
280: ( p_rule_set_code IN VARCHAR2
281: )

Line 284: DELETE FROM MTL_MVT_STATS_RULE_SETS_TL

280: ( p_rule_set_code IN VARCHAR2
281: )
282: IS
283: BEGIN
284: DELETE FROM MTL_MVT_STATS_RULE_SETS_TL
285: WHERE Rule_Set_code = p_rule_set_code;
286:
287: IF (SQL%NOTFOUND)
288: THEN

Line 319: DELETE FROM MTL_MVT_STATS_RULE_SETS_TL T

315: --==========================================================================
316: PROCEDURE Add_Language
317: IS
318: BEGIN
319: DELETE FROM MTL_MVT_STATS_RULE_SETS_TL T
320: WHERE NOT EXISTS
321: (SELECT
322: NULL
323: FROM

Line 328: UPDATE MTL_MVT_STATS_RULE_SETS_TL T

324: MTL_MVT_STATS_RULE_SETS_B B
325: WHERE B.Rule_Set_code = T.Rule_Set_code
326: );
327:
328: UPDATE MTL_MVT_STATS_RULE_SETS_TL T
329: SET (Rule_Set_display_name
330: ,Rule_Set_description ) =
331: (SELECT
332: B.Rule_Set_display_name

Line 335: MTL_MVT_STATS_RULE_SETS_TL B

331: (SELECT
332: B.Rule_Set_display_name
333: , B.Rule_Set_description
334: FROM
335: MTL_MVT_STATS_RULE_SETS_TL B
336: WHERE B.Rule_Set_code = T.Rule_Set_code
337: AND B.language = T.source_lang)
338: WHERE (T.Rule_Set_code
339: , T.language

Line 344: MTL_MVT_STATS_RULE_SETS_TL SUBB

340: )IN (SELECT
341: SUBT.Rule_Set_code
342: , SUBT.language
343: FROM
344: MTL_MVT_STATS_RULE_SETS_TL SUBB
345: , MTL_MVT_STATS_RULE_SETS_TL SUBT
346: WHERE SUBB.Rule_Set_code = SUBT.Rule_Set_code
347: AND SUBB.language = SUBT.source_lang
348: AND (SUBB.Rule_Set_display_name <> SUBT.Rule_Set_display_name

Line 345: , MTL_MVT_STATS_RULE_SETS_TL SUBT

341: SUBT.Rule_Set_code
342: , SUBT.language
343: FROM
344: MTL_MVT_STATS_RULE_SETS_TL SUBB
345: , MTL_MVT_STATS_RULE_SETS_TL SUBT
346: WHERE SUBB.Rule_Set_code = SUBT.Rule_Set_code
347: AND SUBB.language = SUBT.source_lang
348: AND (SUBB.Rule_Set_display_name <> SUBT.Rule_Set_display_name
349: OR SUBB.Rule_Set_description <> SUBT.Rule_Set_description));

Line 351: INSERT INTO MTL_MVT_STATS_RULE_SETS_TL

347: AND SUBB.language = SUBT.source_lang
348: AND (SUBB.Rule_Set_display_name <> SUBT.Rule_Set_display_name
349: OR SUBB.Rule_Set_description <> SUBT.Rule_Set_description));
350:
351: INSERT INTO MTL_MVT_STATS_RULE_SETS_TL
352: ( Rule_Set_code
353: , Rule_Set_display_name
354: , Rule_Set_description
355: , created_by

Line 375: MTL_MVT_STATS_RULE_SETS_TL B

371: , B.last_update_login
372: , L.language_CODE
373: , B.source_lang
374: FROM
375: MTL_MVT_STATS_RULE_SETS_TL B
376: , FND_LANGUAGES L
377: WHERE L.INSTALLED_FLAG IN ('I', 'B')
378: AND B.language = USERENV('LANG')
379: AND NOT EXISTS

Line 383: MTL_MVT_STATS_RULE_SETS_TL T

379: AND NOT EXISTS
380: (SELECT
381: NULL
382: FROM
383: MTL_MVT_STATS_RULE_SETS_TL T
384: WHERE T.Rule_Set_code = B.Rule_Set_code
385: AND T.language = L.language_CODE);
386:
387: EXCEPTION

Line 414: UPDATE mtl_mvt_stats_rule_sets_tl

410: )
411: IS
412: BEGIN
413:
414: UPDATE mtl_mvt_stats_rule_sets_tl
415: SET Rule_Set_display_name = p_rule_set_display_name
416: , Rule_Set_description = p_rule_set_description
417: , last_update_date = SYSDATE
418: , last_updated_by = DECODE(p_owner, 'SEED', 1, 0)