APPS.EGO_ITEMS_ATTRS_CHANGES_PKG dependencies on EGO_ITEMS_ATTRS_CHANGES_TL

Line 19: delete from EGO_ITEMS_ATTRS_CHANGES_TL T

15:
16: PROCEDURE ADD_LANGUAGE
17: IS
18: BEGIN
19: delete from EGO_ITEMS_ATTRS_CHANGES_TL T
20: where not exists
21: (select NULL
22: from EGO_ITEMS_ATTRS_CHANGES_B B
23: where B.EXTENSION_ID = T.EXTENSION_ID

Line 28: update EGO_ITEMS_ATTRS_CHANGES_TL T set (

24: and B.ACD_TYPE = T.ACD_TYPE
25: and B.CHANGE_LINE_ID = T.CHANGE_LINE_ID
26: );
27:
28: update EGO_ITEMS_ATTRS_CHANGES_TL T set (
29: TL_EXT_ATTR1,
30: TL_EXT_ATTR2,
31: TL_EXT_ATTR3,
32: TL_EXT_ATTR4,

Line 111: from EGO_ITEMS_ATTRS_CHANGES_TL B

107: B.TL_EXT_ATTR37,
108: B.TL_EXT_ATTR38,
109: B.TL_EXT_ATTR39,
110: B.TL_EXT_ATTR40
111: from EGO_ITEMS_ATTRS_CHANGES_TL B
112: where B.EXTENSION_ID = T.EXTENSION_ID
113: and B.ACD_TYPE = T.ACD_TYPE
114: and B.CHANGE_LINE_ID = T.CHANGE_LINE_ID
115: and B.LANGUAGE = T.SOURCE_LANG)

Line 126: from EGO_ITEMS_ATTRS_CHANGES_TL SUBB, EGO_ITEMS_ATTRS_CHANGES_TL SUBT

122: SUBT.EXTENSION_ID,
123: SUBT.ACD_TYPE,
124: SUBT.CHANGE_LINE_ID,
125: SUBT.LANGUAGE
126: from EGO_ITEMS_ATTRS_CHANGES_TL SUBB, EGO_ITEMS_ATTRS_CHANGES_TL SUBT
127: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
128: and SUBB.ACD_TYPE = SUBT.ACD_TYPE
129: and SUBB.CHANGE_LINE_ID = SUBT.CHANGE_LINE_ID
130: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 253: insert into EGO_ITEMS_ATTRS_CHANGES_TL (

249: or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
250: or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
251: ));
252:
253: insert into EGO_ITEMS_ATTRS_CHANGES_TL (
254: TL_EXT_ATTR23,
255: TL_EXT_ATTR24,
256: TL_EXT_ATTR25,
257: TL_EXT_ATTR26,

Line 369: from EGO_ITEMS_ATTRS_CHANGES_TL B, FND_LANGUAGES L

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

Line 374: from EGO_ITEMS_ATTRS_CHANGES_TL T

370: where L.INSTALLED_FLAG in ('I', 'B')
371: and B.LANGUAGE = userenv('LANG')
372: and not exists
373: (select NULL
374: from EGO_ITEMS_ATTRS_CHANGES_TL T
375: where T.EXTENSION_ID = B.EXTENSION_ID
376: and T.ACD_TYPE = B.ACD_TYPE
377: and T.CHANGE_LINE_ID = B.CHANGE_LINE_ID
378: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 479: l_delete_table_tl := 'EGO_ITEMS_ATTRS_CHANGES_TL';

475: END IF;
476:
477: IF l_object_row.obj_name IN ('EGO_ITEM', 'EGO_ITEM_REVISION') THEN
478: l_delete_table_b := 'EGO_ITEMS_ATTRS_CHANGES_B';
479: l_delete_table_tl := 'EGO_ITEMS_ATTRS_CHANGES_TL';
480: IF p_change_id IS NULL THEN
481: IF p_change_line_id IS NULL THEN
482: -- you will never come here
483: l_dynamic_sql := ' WHERE 1 = 1 ';