APPS.EGO_ITM_GTN_MUL_ATTRS_PKG dependencies on EGO_ITM_GTN_MUL_ATTRS_TL

Line 112: insert into EGO_ITM_GTN_MUL_ATTRS_TL (

108: X_LAST_UPDATED_BY,
109: X_LAST_UPDATE_LOGIN
110: );
111:
112: insert into EGO_ITM_GTN_MUL_ATTRS_TL (
113: REQUEST_ID,
114: EXTENSION_ID,
115: INVENTORY_ITEM_ID,
116: ORGANIZATION_ID,

Line 150: from EGO_ITM_GTN_MUL_ATTRS_TL T

146: from FND_LANGUAGES L
147: where L.INSTALLED_FLAG in ('I', 'B')
148: and not exists
149: (select NULL
150: from EGO_ITM_GTN_MUL_ATTRS_TL T
151: where T.EXTENSION_ID = X_EXTENSION_ID
152: and T.LANGUAGE = L.LANGUAGE_CODE);
153:
154: open c;

Line 231: from EGO_ITM_GTN_MUL_ATTRS_TL

227: cursor c1 is select
228: HANDLING_INSTRUCTIONS_CODE,
229: DANGEROUS_GOODS_TECHNICAL_NAME,
230: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
231: from EGO_ITM_GTN_MUL_ATTRS_TL
232: where EXTENSION_ID = X_EXTENSION_ID
233: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
234: for update of EXTENSION_ID nowait;
235: begin

Line 389: update EGO_ITM_GTN_MUL_ATTRS_TL set

385: if (sql%notfound) then
386: raise no_data_found;
387: end if;
388:
389: update EGO_ITM_GTN_MUL_ATTRS_TL set
390: HANDLING_INSTRUCTIONS_CODE = X_HANDLING_INSTRUCTIONS_CODE,
391: DANGEROUS_GOODS_TECHNICAL_NAME = X_DANGEROUS_GOODS_TECHNICAL_NA,
392: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
393: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 408: delete from EGO_ITM_GTN_MUL_ATTRS_TL

404: procedure DELETE_ROW (
405: X_EXTENSION_ID in NUMBER
406: ) is
407: begin
408: delete from EGO_ITM_GTN_MUL_ATTRS_TL
409: where EXTENSION_ID = X_EXTENSION_ID;
410:
411: if (sql%notfound) then
412: raise no_data_found;

Line 426: delete from EGO_ITM_GTN_MUL_ATTRS_TL T

422:
423: procedure ADD_LANGUAGE
424: is
425: begin
426: delete from EGO_ITM_GTN_MUL_ATTRS_TL T
427: where not exists
428: (select NULL
429: from EGO_ITM_GTN_MUL_ATTRS_B B
430: where B.EXTENSION_ID = T.EXTENSION_ID

Line 433: update EGO_ITM_GTN_MUL_ATTRS_TL T set (

429: from EGO_ITM_GTN_MUL_ATTRS_B B
430: where B.EXTENSION_ID = T.EXTENSION_ID
431: );
432:
433: update EGO_ITM_GTN_MUL_ATTRS_TL T set (
434: HANDLING_INSTRUCTIONS_CODE,
435: DANGEROUS_GOODS_TECHNICAL_NAME
436: ) = (select
437: B.HANDLING_INSTRUCTIONS_CODE,

Line 439: from EGO_ITM_GTN_MUL_ATTRS_TL B

435: DANGEROUS_GOODS_TECHNICAL_NAME
436: ) = (select
437: B.HANDLING_INSTRUCTIONS_CODE,
438: B.DANGEROUS_GOODS_TECHNICAL_NAME
439: from EGO_ITM_GTN_MUL_ATTRS_TL B
440: where B.EXTENSION_ID = T.EXTENSION_ID
441: and B.LANGUAGE = T.SOURCE_LANG)
442: where (
443: T.EXTENSION_ID,

Line 448: from EGO_ITM_GTN_MUL_ATTRS_TL SUBB, EGO_ITM_GTN_MUL_ATTRS_TL SUBT

444: T.LANGUAGE
445: ) in (select
446: SUBT.EXTENSION_ID,
447: SUBT.LANGUAGE
448: from EGO_ITM_GTN_MUL_ATTRS_TL SUBB, EGO_ITM_GTN_MUL_ATTRS_TL SUBT
449: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
450: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
451: and (SUBB.HANDLING_INSTRUCTIONS_CODE <> SUBT.HANDLING_INSTRUCTIONS_CODE
452: or (SUBB.HANDLING_INSTRUCTIONS_CODE is null and SUBT.HANDLING_INSTRUCTIONS_CODE is not null)

Line 459: insert into EGO_ITM_GTN_MUL_ATTRS_TL (

455: or (SUBB.DANGEROUS_GOODS_TECHNICAL_NAME is null and SUBT.DANGEROUS_GOODS_TECHNICAL_NAME is not null)
456: or (SUBB.DANGEROUS_GOODS_TECHNICAL_NAME is not null and SUBT.DANGEROUS_GOODS_TECHNICAL_NAME is null)
457: ));
458:
459: insert into EGO_ITM_GTN_MUL_ATTRS_TL (
460: REQUEST_ID,
461: EXTENSION_ID,
462: INVENTORY_ITEM_ID,
463: ORGANIZATION_ID,

Line 493: from EGO_ITM_GTN_MUL_ATTRS_TL B, FND_LANGUAGES L

489: B.HANDLING_INSTRUCTIONS_CODE,
490: B.DANGEROUS_GOODS_TECHNICAL_NAME,
491: L.LANGUAGE_CODE,
492: B.SOURCE_LANG
493: from EGO_ITM_GTN_MUL_ATTRS_TL B, FND_LANGUAGES L
494: where L.INSTALLED_FLAG in ('I', 'B')
495: and B.LANGUAGE = userenv('LANG')
496: and not exists
497: (select NULL

Line 498: from EGO_ITM_GTN_MUL_ATTRS_TL T

494: where L.INSTALLED_FLAG in ('I', 'B')
495: and B.LANGUAGE = userenv('LANG')
496: and not exists
497: (select NULL
498: from EGO_ITM_GTN_MUL_ATTRS_TL T
499: where T.EXTENSION_ID = B.EXTENSION_ID
500: and T.LANGUAGE = L.LANGUAGE_CODE);
501: end ADD_LANGUAGE;
502: