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 FND_API

Line 945: item_code = DECODE(p_item_code, FND_API.G_MISS_CHAR, item_code, p_item_code)

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
948: , last_update_date = SYSDATE
949: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)

Line 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)

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
948: , last_update_date = SYSDATE
949: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
950: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

Line 949: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)

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
948: , last_update_date = SYSDATE
949: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
950: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)
951: WHERE
952: id_type = l_id_type
953: AND item_id = p_item_id

Line 950: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

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
948: , last_update_date = SYSDATE
949: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
950: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)
951: WHERE
952: id_type = l_id_type
953: AND item_id = p_item_id
954: AND org_id = p_org_id;

Line 994: , DECODE(p_source_lang, FND_API.G_MISS_CHAR, p_language, p_source_lang)

990: , msik.inventory_item_id
991: , msik.concatenated_segments
992: , msik.organization_id
993: , p_language
994: , DECODE(p_source_lang, FND_API.G_MISS_CHAR, p_language, p_source_lang)
995: , msik.item_catalog_group_id
996: , msik.inventory_item_id
997: , l_text_ins
998: , SYSDATE

Line 1001: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, msik.last_updated_by, p_last_updated_by)

997: , l_text_ins
998: , SYSDATE
999: , msik.created_by
1000: , SYSDATE
1001: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, msik.last_updated_by, p_last_updated_by)
1002: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, msik.last_update_login, p_last_update_login)
1003: FROM
1004: mtl_system_items_b_kfv msik
1005: WHERE

Line 1002: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, msik.last_update_login, p_last_update_login)

998: , SYSDATE
999: , msik.created_by
1000: , SYSDATE
1001: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, msik.last_updated_by, p_last_updated_by)
1002: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, msik.last_update_login, p_last_update_login)
1003: FROM
1004: mtl_system_items_b_kfv msik
1005: WHERE
1006: msik.inventory_item_id = p_item_id

Line 1025: source_lang = DECODE(p_source_lang, FND_API.G_MISS_CHAR, source_lang, p_source_lang)

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
1028: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
1029: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

Line 1028: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)

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
1028: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
1029: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)
1030: WHERE
1031: id_type = l_id_type
1032: AND item_id = p_item_id

Line 1029: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

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
1028: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
1029: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)
1030: WHERE
1031: id_type = l_id_type
1032: AND item_id = p_item_id
1033: AND org_id = p_org_id

Line 1058: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)

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)
1060: WHERE
1061: id_type = l_id_type
1062: AND (item_id,org_id) IN ( SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID

Line 1059: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

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)
1060: WHERE
1061: id_type = l_id_type
1062: AND (item_id,org_id) IN ( SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID
1063: FROM MTL_MFG_PART_NUMBERS

Line 1081: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)

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)
1083: WHERE
1084: id_type = l_id_type
1085: AND org_id = p_org_id

Line 1082: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

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)
1083: WHERE
1084: id_type = l_id_type
1085: AND org_id = p_org_id
1086: AND item_id IN (NVL(p_old_item_id,p_item_id),p_item_id);

Line 1150: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)

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)
1151: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)
1152: WHERE
1153: id_type = l_id_type
1154: AND item_catalog_group_id = NVL(p_item_catalog_group_id, -1);

Line 1151: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

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)
1151: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)
1152: WHERE
1153: id_type = l_id_type
1154: AND item_catalog_group_id = NVL(p_item_catalog_group_id, -1);
1155:

Line 1200: , p_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

1196: (
1197: p_table_name IN VARCHAR2
1198: , p_event IN VARCHAR2
1199: , p_scope IN VARCHAR2
1200: , p_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1201: , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE

Line 1201: , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

1197: p_table_name IN VARCHAR2
1198: , p_event IN VARCHAR2
1199: , p_scope IN VARCHAR2
1200: , p_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1201: , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

Line 1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1198: , p_event IN VARCHAR2
1199: , p_scope IN VARCHAR2
1200: , p_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1201: , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

Line 1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1199: , p_scope IN VARCHAR2
1200: , p_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1201: , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE

1200: , p_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1201: , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

1201: , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1209: , p_item_catalog_group_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

Line 1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

1202: , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1209: , p_item_catalog_group_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1210: )

Line 1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1203: , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1209: , p_item_catalog_group_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1210: )
1211: IS

Line 1208: , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1204: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1209: , p_item_catalog_group_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1210: )
1211: IS
1212:

Line 1209: , p_item_catalog_group_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

1205: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1206: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1207: , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1209: , p_item_catalog_group_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
1210: )
1211: IS
1212:
1213: l_manufacturer_id NUMBER :=NULL;