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 387: delete from WMS_RULES_TL

383: procedure DELETE_ROW (
384: X_RULE_ID in NUMBER
385: ) is
386: begin
387: delete from WMS_RULES_TL
388: where RULE_ID = X_RULE_ID;
389:
390: if (sql%notfound) then
391: raise no_data_found;

Line 405: delete from WMS_RULES_TL T

401:
402: procedure ADD_LANGUAGE
403: is
404: begin
405: delete from WMS_RULES_TL T
406: where not exists
407: (select NULL
408: from WMS_RULES_B B
409: where B.RULE_ID = T.RULE_ID

Line 412: update WMS_RULES_TL T set (

408: from WMS_RULES_B B
409: where B.RULE_ID = T.RULE_ID
410: );
411:
412: update WMS_RULES_TL T set (
413: NAME,
414: DESCRIPTION
415: ) = (select
416: B.NAME,

Line 418: from WMS_RULES_TL B

414: DESCRIPTION
415: ) = (select
416: B.NAME,
417: B.DESCRIPTION
418: from WMS_RULES_TL B
419: where B.RULE_ID = T.RULE_ID
420: and B.LANGUAGE = T.SOURCE_LANG)
421: where (
422: T.RULE_ID,

Line 427: from WMS_RULES_TL SUBB, WMS_RULES_TL SUBT

423: T.LANGUAGE
424: ) in (select
425: SUBT.RULE_ID,
426: SUBT.LANGUAGE
427: from WMS_RULES_TL SUBB, WMS_RULES_TL SUBT
428: where SUBB.RULE_ID = SUBT.RULE_ID
429: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
430: and (SUBB.NAME <> SUBT.NAME
431: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 436: insert into WMS_RULES_TL (

432: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
433: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
434: ));
435:
436: insert into WMS_RULES_TL (
437: RULE_ID,
438: LAST_UPDATED_BY,
439: LAST_UPDATE_DATE,
440: CREATED_BY,

Line 458: from WMS_RULES_TL B, FND_LANGUAGES L

454: B.NAME,
455: B.DESCRIPTION,
456: L.LANGUAGE_CODE,
457: B.SOURCE_LANG
458: from WMS_RULES_TL B, FND_LANGUAGES L
459: where L.INSTALLED_FLAG in ('I', 'B')
460: and B.LANGUAGE = userenv('LANG')
461: and not exists
462: (select NULL

Line 463: from WMS_RULES_TL T

459: where L.INSTALLED_FLAG in ('I', 'B')
460: and B.LANGUAGE = userenv('LANG')
461: and not exists
462: (select NULL
463: from WMS_RULES_TL T
464: where T.RULE_ID = B.RULE_ID
465: and T.LANGUAGE = L.LANGUAGE_CODE);
466: end ADD_LANGUAGE;
467: --

Line 475: UPDATE wms_rules_tl SET

471: x_description IN VARCHAR2,
472: x_owner IN VARCHAR2
473: ) IS
474: BEGIN
475: UPDATE wms_rules_tl SET
476: name = x_name,
477: description = x_description,
478: last_update_date = Sysdate,
479: last_updated_by = Decode(x_owner, 'SEED', 1, 0),