APPS.WMS_CROSSDOCK_CRITERIA_PKG dependencies on WMS_CROSSDOCK_CRITERIA_TL

Line 82: insert into WMS_CROSSDOCK_CRITERIA_TL (

78: X_LAST_UPDATED_BY,
79: X_LAST_UPDATE_LOGIN
80: );
81:
82: insert into WMS_CROSSDOCK_CRITERIA_TL (
83: CRITERION_ID,
84: LAST_UPDATED_BY,
85: LAST_UPDATE_DATE,
86: CREATED_BY,

Line 108: from WMS_CROSSDOCK_CRITERIA_TL T

104: from FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and not exists
107: (select NULL
108: from WMS_CROSSDOCK_CRITERIA_TL T
109: where T.CRITERION_ID = X_CRITERION_ID
110: and T.LANGUAGE = L.LANGUAGE_CODE);
111:
112: open c;

Line 169: from WMS_CROSSDOCK_CRITERIA_TL

165: cursor c1 is select
166: CRITERION_NAME,
167: DESCRIPTION,
168: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
169: from WMS_CROSSDOCK_CRITERIA_TL
170: where CRITERION_ID = X_CRITERION_ID
171: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
172: for update of CRITERION_ID nowait;
173: begin

Line 278: update WMS_CROSSDOCK_CRITERIA_TL set

274: if (sql%notfound) then
275: raise no_data_found;
276: end if;
277:
278: update WMS_CROSSDOCK_CRITERIA_TL set
279: CRITERION_NAME = X_CRITERION_NAME,
280: DESCRIPTION = X_DESCRIPTION,
281: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
282: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 297: delete from WMS_CROSSDOCK_CRITERIA_TL

293: procedure DELETE_ROW (
294: X_CRITERION_ID in NUMBER
295: ) is
296: begin
297: delete from WMS_CROSSDOCK_CRITERIA_TL
298: where CRITERION_ID = X_CRITERION_ID;
299:
300: if (sql%notfound) then
301: raise no_data_found;

Line 315: delete from WMS_CROSSDOCK_CRITERIA_TL T

311:
312: procedure ADD_LANGUAGE
313: is
314: begin
315: delete from WMS_CROSSDOCK_CRITERIA_TL T
316: where not exists
317: (select NULL
318: from WMS_CROSSDOCK_CRITERIA_B B
319: where B.CRITERION_ID = T.CRITERION_ID

Line 322: update WMS_CROSSDOCK_CRITERIA_TL T set (

318: from WMS_CROSSDOCK_CRITERIA_B B
319: where B.CRITERION_ID = T.CRITERION_ID
320: );
321:
322: update WMS_CROSSDOCK_CRITERIA_TL T set (
323: CRITERION_NAME,
324: DESCRIPTION
325: ) = (select
326: B.CRITERION_NAME,

Line 328: from WMS_CROSSDOCK_CRITERIA_TL B

324: DESCRIPTION
325: ) = (select
326: B.CRITERION_NAME,
327: B.DESCRIPTION
328: from WMS_CROSSDOCK_CRITERIA_TL B
329: where B.CRITERION_ID = T.CRITERION_ID
330: and B.LANGUAGE = T.SOURCE_LANG)
331: where (
332: T.CRITERION_ID,

Line 337: from WMS_CROSSDOCK_CRITERIA_TL SUBB, WMS_CROSSDOCK_CRITERIA_TL SUBT

333: T.LANGUAGE
334: ) in (select
335: SUBT.CRITERION_ID,
336: SUBT.LANGUAGE
337: from WMS_CROSSDOCK_CRITERIA_TL SUBB, WMS_CROSSDOCK_CRITERIA_TL SUBT
338: where SUBB.CRITERION_ID = SUBT.CRITERION_ID
339: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
340: and (SUBB.CRITERION_NAME <> SUBT.CRITERION_NAME
341: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 346: insert into WMS_CROSSDOCK_CRITERIA_TL (

342: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
343: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
344: ));
345:
346: insert into WMS_CROSSDOCK_CRITERIA_TL (
347: CRITERION_ID,
348: LAST_UPDATED_BY,
349: LAST_UPDATE_DATE,
350: CREATED_BY,

Line 368: from WMS_CROSSDOCK_CRITERIA_TL B, FND_LANGUAGES L

364: B.CRITERION_NAME,
365: B.DESCRIPTION,
366: L.LANGUAGE_CODE,
367: B.SOURCE_LANG
368: from WMS_CROSSDOCK_CRITERIA_TL B, FND_LANGUAGES L
369: where L.INSTALLED_FLAG in ('I', 'B')
370: and B.LANGUAGE = userenv('LANG')
371: and not exists
372: (select NULL

Line 373: from WMS_CROSSDOCK_CRITERIA_TL T

369: where L.INSTALLED_FLAG in ('I', 'B')
370: and B.LANGUAGE = userenv('LANG')
371: and not exists
372: (select NULL
373: from WMS_CROSSDOCK_CRITERIA_TL T
374: where T.CRITERION_ID = B.CRITERION_ID
375: and T.LANGUAGE = L.LANGUAGE_CODE);
376: end ADD_LANGUAGE;
377: