APPS.WMS_RULES_PKG dependencies on WMS_RULES_TL

Line 112: insert into WMS_RULES_TL (

108: ,X_ALLOCATION_MODE_ID
109: ,X_wms_enabled_flag
110: );
111:
112: insert into WMS_RULES_TL (
113: RULE_ID,
114: LAST_UPDATED_BY,
115: LAST_UPDATE_DATE,
116: CREATED_BY,

Line 138: from WMS_RULES_TL T

134: from FND_LANGUAGES L
135: where L.INSTALLED_FLAG in ('I', 'B')
136: and not exists
137: (select NULL
138: from WMS_RULES_TL T
139: where T.RULE_ID = X_RULE_ID
140: and T.LANGUAGE = L.LANGUAGE_CODE);
141:
142: open c;

Line 217: from WMS_RULES_TL

213: cursor c1 is select
214: NAME,
215: DESCRIPTION,
216: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
217: from WMS_RULES_TL
218: where RULE_ID = X_RULE_ID
219: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
220: for update of RULE_ID nowait;
221: begin

Line 368: update WMS_RULES_TL set

364: if (sql%notfound) then
365: raise no_data_found;
366: end if;
367:
368: update WMS_RULES_TL set
369: NAME = X_NAME,
370: DESCRIPTION = X_DESCRIPTION,
371: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
372: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 396: delete from WMS_RULES_TL

392: l_cursor := DBMS_SQL.open_cursor;
393: l_package_name := 'WMS_RULE_' || x_rule_id;
394: l_sql := 'DROP PACKAGE ' || l_package_name ;
395: /* 11858604 End */
396: delete from WMS_RULES_TL
397: where RULE_ID = X_RULE_ID;
398:
399: if (sql%notfound) then
400: raise no_data_found;

Line 423: delete from WMS_RULES_TL T

419:
420: procedure ADD_LANGUAGE
421: is
422: begin
423: delete from WMS_RULES_TL T
424: where not exists
425: (select NULL
426: from WMS_RULES_B B
427: where B.RULE_ID = T.RULE_ID

Line 430: update WMS_RULES_TL T set (

426: from WMS_RULES_B B
427: where B.RULE_ID = T.RULE_ID
428: );
429:
430: update WMS_RULES_TL T set (
431: NAME,
432: DESCRIPTION
433: ) = (select
434: B.NAME,

Line 436: from WMS_RULES_TL B

432: DESCRIPTION
433: ) = (select
434: B.NAME,
435: B.DESCRIPTION
436: from WMS_RULES_TL B
437: where B.RULE_ID = T.RULE_ID
438: and B.LANGUAGE = T.SOURCE_LANG)
439: where (
440: T.RULE_ID,

Line 445: from WMS_RULES_TL SUBB, WMS_RULES_TL SUBT

441: T.LANGUAGE
442: ) in (select
443: SUBT.RULE_ID,
444: SUBT.LANGUAGE
445: from WMS_RULES_TL SUBB, WMS_RULES_TL SUBT
446: where SUBB.RULE_ID = SUBT.RULE_ID
447: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
448: and (SUBB.NAME <> SUBT.NAME
449: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 454: insert into WMS_RULES_TL (

450: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
451: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
452: ));
453:
454: insert into WMS_RULES_TL (
455: RULE_ID,
456: LAST_UPDATED_BY,
457: LAST_UPDATE_DATE,
458: CREATED_BY,

Line 476: from WMS_RULES_TL B, FND_LANGUAGES L

472: B.NAME,
473: B.DESCRIPTION,
474: L.LANGUAGE_CODE,
475: B.SOURCE_LANG
476: from WMS_RULES_TL B, FND_LANGUAGES L
477: where L.INSTALLED_FLAG in ('I', 'B')
478: and B.LANGUAGE = userenv('LANG')
479: and not exists
480: (select NULL

Line 481: from WMS_RULES_TL T

477: where L.INSTALLED_FLAG in ('I', 'B')
478: and B.LANGUAGE = userenv('LANG')
479: and not exists
480: (select NULL
481: from WMS_RULES_TL T
482: where T.RULE_ID = B.RULE_ID
483: and T.LANGUAGE = L.LANGUAGE_CODE);
484: end ADD_LANGUAGE;
485: --

Line 493: UPDATE wms_rules_tl SET

489: x_description IN VARCHAR2,
490: x_owner IN VARCHAR2
491: ) IS
492: BEGIN
493: UPDATE wms_rules_tl SET
494: name = x_name,
495: description = x_description,
496: last_update_date = Sysdate,
497: last_updated_by = Decode(x_owner, 'SEED', 1, 0),