eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_TEXT_UTIL dependencies on EGO_ITEM_TEXT_TL

Line 13: g_Index_Name VARCHAR2(30) := 'EGO_ITEM_TEXT_TL_CTX1';

9:
10: g_Prod_Short_Name CONSTANT VARCHAR2(30) := 'EGO';
11: g_Prod_Schema VARCHAR2(30);
12: g_Index_Owner VARCHAR2(30);
13: g_Index_Name VARCHAR2(30) := 'EGO_ITEM_TEXT_TL_CTX1';
14: g_Indexing_Context VARCHAR2(30) := 'SYNC_INDEX';
15:
16: g_installed BOOLEAN;
17: g_inst_status VARCHAR2(1);

Line 273: ego_item_text_tl eitl

269: --, l_item_catalog_group_id
270: --, l_item_segments
271: , l_text
272: FROM
273: ego_item_text_tl eitl
274: , mtl_system_items_tl msitl
275: WHERE
276: eitl.rowid = p_rowid
277: AND msitl.inventory_item_id = eitl.item_id

Line 319: ego_item_text_tl eitl

315: , l_long_description
316: , l_item_catalog_group_id
317: , l_language
318: FROM
319: ego_item_text_tl eitl
320: , mtl_system_items_tl msitl
321: WHERE
322: eitl.rowid = p_rowid
323: AND msitl.inventory_item_id = eitl.item_id

Line 493: -- ego_item_text_tl would not contain inactive customer items, so this is commented out:

489: mtl_customer_items
490: WHERE
491: customer_item_id = l_item_id;
492:
493: -- ego_item_text_tl would not contain inactive customer items, so this is commented out:
494: -- AND inactive_flag = 'N';
495:
496: -- Only include item code if found in the referenced table
497: v_item_code := l_item_code;

Line 728: , 'EGO_ITEM_TEXT_TL'

724: (
725: mtl_system_items_interface_s.NEXTVAL
726: , p_item_id
727: , p_org_id
728: , 'EGO_ITEM_TEXT_TL'
729: , p_msg_name
730: , SUBSTRB(p_error_text, 1,240)
731: , l_sysdate
732: , 1

Line 943: UPDATE ego_item_text_tl

939:
940: -- Item Code is passed in through a parameter.
941: -- Update rows for all languages.
942:
943: UPDATE ego_item_text_tl
944: SET
945: item_code = DECODE(p_item_code, FND_API.G_MISS_CHAR, item_code, p_item_code)
946: , item_catalog_group_id = DECODE(p_item_catalog_group_id, FND_API.G_MISS_NUM, item_catalog_group_id, p_item_catalog_group_id)
947: , text = l_text_upd

Line 971: INSERT INTO ego_item_text_tl

967: --------------------------------------------------------------------
968:
969: IF ( p_event = 'INSERT' ) THEN
970:
971: INSERT INTO ego_item_text_tl
972: (
973: id_type
974: , item_id
975: , item_code

Line 1011: ( SELECT 1 FROM ego_item_text_tl eitl1

1007: AND msik.organization_id = p_org_id;
1008: /* Bug: 4667452 Commenting out following conditions
1009: AND msik.concatenated_segments IS NOT NULL
1010: AND NOT EXISTS
1011: ( SELECT 1 FROM ego_item_text_tl eitl1
1012: WHERE
1013: eitl1.id_type = l_id_type
1014: AND eitl1.item_id = msik.inventory_item_id
1015: AND eitl1.item_code = msik.concatenated_segments

Line 1023: UPDATE ego_item_text_tl

1019: End Bug: 4667452 */
1020:
1021: ELSIF ( p_event = 'UPDATE' ) THEN
1022:
1023: UPDATE ego_item_text_tl
1024: SET
1025: source_lang = DECODE(p_source_lang, FND_API.G_MISS_CHAR, source_lang, p_source_lang)
1026: , text = l_text_upd
1027: , last_update_date = SYSDATE

Line 1038: DELETE FROM ego_item_text_tl

1034: AND language = p_language;
1035:
1036: ELSIF ( p_event = 'DELETE' ) THEN
1037:
1038: DELETE FROM ego_item_text_tl
1039: WHERE
1040: id_type = l_id_type
1041: AND item_id = p_item_id
1042: AND org_id = p_org_id

Line 1055: UPDATE EGO_ITEM_TEXT_TL

1051:
1052: ELSIF ( p_table_name = 'MTL_MANUFACTURERS' ) THEN
1053: IF (p_manufacturer_id IS NOT NULL) THEN
1054:
1055: UPDATE EGO_ITEM_TEXT_TL
1056: SET text = l_text_upd
1057: , last_update_date = SYSDATE
1058: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
1059: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

Line 1078: UPDATE EGO_ITEM_TEXT_TL

1074:
1075: IF ( p_event = 'UPDATE' OR p_event= 'INSERT' ) THEN
1076:
1077:
1078: UPDATE EGO_ITEM_TEXT_TL
1079: SET text = l_text_upd
1080: , last_update_date = SYSDATE
1081: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
1082: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

Line 1089: UPDATE EGO_ITEM_TEXT_TL

1085: AND org_id = p_org_id
1086: AND item_id IN (NVL(p_old_item_id,p_item_id),p_item_id);
1087:
1088: ELSE
1089: UPDATE EGO_ITEM_TEXT_TL
1090: SET text = l_text_upd
1091: , last_update_date = SYSDATE
1092: WHERE
1093: id_type = l_id_type

Line 1111: UPDATE ego_item_text_tl

1107: IF ( p_event IN ('INSERT', 'UPDATE', 'DELETE') ) THEN
1108: --
1109: -- Update rows for all languages
1110: --
1111: UPDATE ego_item_text_tl
1112: SET
1113: text = l_text_upd
1114: , last_update_date = SYSDATE
1115: WHERE

Line 1127: UPDATE ego_item_text_tl

1123: IF ( p_event IN ('INSERT', 'UPDATE', 'DELETE') ) THEN
1124: --
1125: -- Update rows for a single language
1126: --
1127: UPDATE ego_item_text_tl
1128: SET
1129: text = l_text_upd
1130: , last_update_date = SYSDATE
1131: WHERE

Line 1146: UPDATE ego_item_text_tl

1142:
1143: -- updated item catalog group ID is passed in through a parameter;
1144: -- update rows for all languages.
1145:
1146: UPDATE ego_item_text_tl
1147: SET
1148: text = l_text_upd
1149: , last_update_date = SYSDATE
1150: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)