APPS.IC_ITEM_MST_PKG dependencies on IC_ITEM_MST_TL

Line 362: insert into IC_ITEM_MST_TL (

358: X_LAST_UPDATED_BY,
359: X_LAST_UPDATE_LOGIN
360: );
361:
362: insert into IC_ITEM_MST_TL (
363: ITEM_ID,
364: ITEM_DESC1,
365: ITEM_DESC2,
366: CREATION_DATE,

Line 388: from IC_ITEM_MST_TL T

384: from FND_LANGUAGES L
385: where L.INSTALLED_FLAG in ('I', 'B')
386: and not exists
387: (select NULL
388: from IC_ITEM_MST_TL T
389: where T.ITEM_ID = X_ITEM_ID
390: and T.LANGUAGE = L.LANGUAGE_CODE);
391:
392: open c;

Line 633: from IC_ITEM_MST_TL

629: cursor c1 is select
630: ITEM_DESC1,
631: ITEM_DESC2,
632: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
633: from IC_ITEM_MST_TL
634: where ITEM_ID = X_ITEM_ID
635: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
636: for update of ITEM_ID nowait;
637: begin

Line 1099: update IC_ITEM_MST_TL set

1095: if (sql%notfound) then
1096: raise no_data_found;
1097: end if;
1098:
1099: update IC_ITEM_MST_TL set
1100: ITEM_DESC1 = X_ITEM_DESC1,
1101: ITEM_DESC2 = X_ITEM_DESC2,
1102: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1103: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1119: delete from IC_ITEM_MST_TL

1115: X_ITEM_ID in NUMBER
1116: ) is
1117: begin
1118: /*********
1119: delete from IC_ITEM_MST_TL
1120: where ITEM_ID = X_ITEM_ID;
1121:
1122: if (sql%notfound) then
1123: raise no_data_found;

Line 1138: delete from IC_ITEM_MST_TL T

1134:
1135: procedure ADD_LANGUAGE
1136: is
1137: begin
1138: delete from IC_ITEM_MST_TL T
1139: where not exists
1140: (select NULL
1141: from IC_ITEM_MST_B B
1142: where B.ITEM_ID = T.ITEM_ID

Line 1145: update IC_ITEM_MST_TL T set (

1141: from IC_ITEM_MST_B B
1142: where B.ITEM_ID = T.ITEM_ID
1143: );
1144:
1145: update IC_ITEM_MST_TL T set (
1146: ITEM_DESC1,
1147: ITEM_DESC2
1148: ) = (select
1149: B.ITEM_DESC1,

Line 1151: from IC_ITEM_MST_TL B

1147: ITEM_DESC2
1148: ) = (select
1149: B.ITEM_DESC1,
1150: B.ITEM_DESC2
1151: from IC_ITEM_MST_TL B
1152: where B.ITEM_ID = T.ITEM_ID
1153: and B.LANGUAGE = T.SOURCE_LANG)
1154: where (
1155: T.ITEM_ID,

Line 1160: from IC_ITEM_MST_TL SUBB, IC_ITEM_MST_TL SUBT

1156: T.LANGUAGE
1157: ) in (select
1158: SUBT.ITEM_ID,
1159: SUBT.LANGUAGE
1160: from IC_ITEM_MST_TL SUBB, IC_ITEM_MST_TL SUBT
1161: where SUBB.ITEM_ID = SUBT.ITEM_ID
1162: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1163: and (SUBB.ITEM_DESC1 <> SUBT.ITEM_DESC1
1164: or SUBB.ITEM_DESC2 <> SUBT.ITEM_DESC2

Line 1169: insert into IC_ITEM_MST_TL (

1165: or (SUBB.ITEM_DESC2 is null and SUBT.ITEM_DESC2 is not null)
1166: or (SUBB.ITEM_DESC2 is not null and SUBT.ITEM_DESC2 is null)
1167: ));
1168:
1169: insert into IC_ITEM_MST_TL (
1170: ITEM_ID,
1171: ITEM_DESC1,
1172: ITEM_DESC2,
1173: CREATION_DATE,

Line 1191: from IC_ITEM_MST_TL B, FND_LANGUAGES L

1187: B.LAST_UPDATED_BY,
1188: B.LAST_UPDATE_LOGIN,
1189: L.LANGUAGE_CODE,
1190: B.SOURCE_LANG
1191: from IC_ITEM_MST_TL B, FND_LANGUAGES L
1192: where L.INSTALLED_FLAG in ('I', 'B')
1193: and B.LANGUAGE = userenv('LANG')
1194: and not exists
1195: (select NULL

Line 1196: from IC_ITEM_MST_TL T

1192: where L.INSTALLED_FLAG in ('I', 'B')
1193: and B.LANGUAGE = userenv('LANG')
1194: and not exists
1195: (select NULL
1196: from IC_ITEM_MST_TL T
1197: where T.ITEM_ID = B.ITEM_ID
1198: and T.LANGUAGE = L.LANGUAGE_CODE);
1199: end ADD_LANGUAGE;
1200: