APPS.EGO_ITEM_GTN_ATTRS_PKG dependencies on EGO_ITEM_GTN_ATTRS_TL

Line 354: insert into EGO_ITEM_GTN_ATTRS_TL (

350: X_LAST_UPDATED_BY,
351: X_LAST_UPDATE_LOGIN
352: );
353:
354: insert into EGO_ITEM_GTN_ATTRS_TL (
355: REQUEST_ID,
356: EXTENSION_ID,
357: INVENTORY_ITEM_ID,
358: ORGANIZATION_ID,

Line 400: from EGO_ITEM_GTN_ATTRS_TL T

396: from FND_LANGUAGES L
397: where L.INSTALLED_FLAG in ('I', 'B')
398: and not exists
399: (select NULL
400: from EGO_ITEM_GTN_ATTRS_TL T
401: where T.EXTENSION_ID = X_EXTENSION_ID
402: and T.LANGUAGE = L.LANGUAGE_CODE);
403:
404: open c;

Line 649: from EGO_ITEM_GTN_ATTRS_TL

645: WARRANTY_DESCRIPTION,
646: TRADE_ITEM_FINISH_DESCRIPTION,
647: DESCRIPTION_SHORT,
648: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
649: from EGO_ITEM_GTN_ATTRS_TL
650: where EXTENSION_ID = X_EXTENSION_ID
651: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
652: for update of EXTENSION_ID nowait;
653: begin

Line 1138: update EGO_ITEM_GTN_ATTRS_TL set

1134: if (sql%notfound) then
1135: raise no_data_found;
1136: end if;
1137:
1138: update EGO_ITEM_GTN_ATTRS_TL set
1139: INVOICE_NAME = X_INVOICE_NAME,
1140: DESCRIPTIVE_SIZE = X_DESCRIPTIVE_SIZE,
1141: FUNCTIONAL_NAME = X_FUNCTIONAL_NAME,
1142: TRADE_ITEM_FORM_DESCRIPTION = X_TRADE_ITEM_FORM_DESCRIPTION,

Line 1162: delete from EGO_ITEM_GTN_ATTRS_TL

1158: procedure DELETE_ROW (
1159: X_EXTENSION_ID in NUMBER
1160: ) is
1161: begin
1162: delete from EGO_ITEM_GTN_ATTRS_TL
1163: where EXTENSION_ID = X_EXTENSION_ID;
1164:
1165: if (sql%notfound) then
1166: raise no_data_found;

Line 1180: delete from EGO_ITEM_GTN_ATTRS_TL T

1176:
1177: procedure ADD_LANGUAGE
1178: is
1179: begin
1180: delete from EGO_ITEM_GTN_ATTRS_TL T
1181: where not exists
1182: (select NULL
1183: from EGO_ITEM_GTN_ATTRS_B B
1184: where B.EXTENSION_ID = T.EXTENSION_ID

Line 1187: update EGO_ITEM_GTN_ATTRS_TL T set (

1183: from EGO_ITEM_GTN_ATTRS_B B
1184: where B.EXTENSION_ID = T.EXTENSION_ID
1185: );
1186:
1187: update EGO_ITEM_GTN_ATTRS_TL T set (
1188: INVOICE_NAME,
1189: DESCRIPTIVE_SIZE,
1190: FUNCTIONAL_NAME,
1191: TRADE_ITEM_FORM_DESCRIPTION,

Line 1203: from EGO_ITEM_GTN_ATTRS_TL B

1199: B.TRADE_ITEM_FORM_DESCRIPTION,
1200: B.WARRANTY_DESCRIPTION,
1201: B.TRADE_ITEM_FINISH_DESCRIPTION,
1202: B.DESCRIPTION_SHORT
1203: from EGO_ITEM_GTN_ATTRS_TL B
1204: where B.EXTENSION_ID = T.EXTENSION_ID
1205: and B.LANGUAGE = T.SOURCE_LANG)
1206: where (
1207: T.EXTENSION_ID,

Line 1212: from EGO_ITEM_GTN_ATTRS_TL SUBB, EGO_ITEM_GTN_ATTRS_TL SUBT

1208: T.LANGUAGE
1209: ) in (select
1210: SUBT.EXTENSION_ID,
1211: SUBT.LANGUAGE
1212: from EGO_ITEM_GTN_ATTRS_TL SUBB, EGO_ITEM_GTN_ATTRS_TL SUBT
1213: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1214: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1215: and (SUBB.INVOICE_NAME <> SUBT.INVOICE_NAME
1216: or (SUBB.INVOICE_NAME is null and SUBT.INVOICE_NAME is not null)

Line 1238: insert into EGO_ITEM_GTN_ATTRS_TL (

1234: or (SUBB.DESCRIPTION_SHORT is null and SUBT.DESCRIPTION_SHORT is not null)
1235: or (SUBB.DESCRIPTION_SHORT is not null and SUBT.DESCRIPTION_SHORT is null)
1236: ));
1237:
1238: insert into EGO_ITEM_GTN_ATTRS_TL (
1239: REQUEST_ID,
1240: EXTENSION_ID,
1241: INVENTORY_ITEM_ID,
1242: ORGANIZATION_ID,

Line 1280: from EGO_ITEM_GTN_ATTRS_TL B, FND_LANGUAGES L

1276: B.TRADE_ITEM_FINISH_DESCRIPTION,
1277: B.DESCRIPTION_SHORT,
1278: L.LANGUAGE_CODE,
1279: B.SOURCE_LANG
1280: from EGO_ITEM_GTN_ATTRS_TL B, FND_LANGUAGES L
1281: where L.INSTALLED_FLAG in ('I', 'B')
1282: and B.LANGUAGE = userenv('LANG')
1283: and not exists
1284: (select NULL

Line 1285: from EGO_ITEM_GTN_ATTRS_TL T

1281: where L.INSTALLED_FLAG in ('I', 'B')
1282: and B.LANGUAGE = userenv('LANG')
1283: and not exists
1284: (select NULL
1285: from EGO_ITEM_GTN_ATTRS_TL T
1286: where T.EXTENSION_ID = B.EXTENSION_ID
1287: and T.LANGUAGE = L.LANGUAGE_CODE);
1288: end ADD_LANGUAGE;
1289: