APPS.IEC_P_RES_GRP_TYPES_PKG dependencies on IEC_P_RES_GRP_TYPES_TL

Line 43: insert into IEC_P_RES_GRP_TYPES_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into IEC_P_RES_GRP_TYPES_TL (
44: RES_GROUP_TYPE_ID,
45: CREATED_BY,
46: CREATION_DATE,
47: LAST_UPDATED_BY,

Line 69: from IEC_P_RES_GRP_TYPES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from IEC_P_RES_GRP_TYPES_TL T
70: where T.RES_GROUP_TYPE_ID = X_RES_GROUP_TYPE_ID
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 104: from IEC_P_RES_GRP_TYPES_TL

100: cursor c1 is select
101: RES_GROUP_TYPE_NAME,
102: RES_GROUP_TYPE_DESCRIPTION,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from IEC_P_RES_GRP_TYPES_TL
105: where RES_GROUP_TYPE_ID = X_RES_GROUP_TYPE_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of RES_GROUP_TYPE_ID nowait;
108: begin

Line 169: update IEC_P_RES_GRP_TYPES_TL set

165: if (sql%notfound) then
166: raise no_data_found;
167: end if;
168:
169: update IEC_P_RES_GRP_TYPES_TL set
170: RES_GROUP_TYPE_NAME = X_RES_GROUP_TYPE_NAME,
171: RES_GROUP_TYPE_DESCRIPTION = X_RES_GROUP_TYPE_DESCRIPTION,
172: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
173: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 188: delete from IEC_P_RES_GRP_TYPES_TL

184: procedure DELETE_ROW (
185: X_RES_GROUP_TYPE_ID in NUMBER
186: ) is
187: begin
188: delete from IEC_P_RES_GRP_TYPES_TL
189: where RES_GROUP_TYPE_ID = X_RES_GROUP_TYPE_ID;
190:
191: if (sql%notfound) then
192: raise no_data_found;

Line 206: delete from IEC_P_RES_GRP_TYPES_TL T

202:
203: procedure ADD_LANGUAGE
204: is
205: begin
206: delete from IEC_P_RES_GRP_TYPES_TL T
207: where not exists
208: (select NULL
209: from IEC_P_RES_GRP_TYPES_B B
210: where B.RES_GROUP_TYPE_ID = T.RES_GROUP_TYPE_ID

Line 213: update IEC_P_RES_GRP_TYPES_TL T set (

209: from IEC_P_RES_GRP_TYPES_B B
210: where B.RES_GROUP_TYPE_ID = T.RES_GROUP_TYPE_ID
211: );
212:
213: update IEC_P_RES_GRP_TYPES_TL T set (
214: RES_GROUP_TYPE_NAME,
215: RES_GROUP_TYPE_DESCRIPTION
216: ) = (select
217: B.RES_GROUP_TYPE_NAME,

Line 219: from IEC_P_RES_GRP_TYPES_TL B

215: RES_GROUP_TYPE_DESCRIPTION
216: ) = (select
217: B.RES_GROUP_TYPE_NAME,
218: B.RES_GROUP_TYPE_DESCRIPTION
219: from IEC_P_RES_GRP_TYPES_TL B
220: where B.RES_GROUP_TYPE_ID = T.RES_GROUP_TYPE_ID
221: and B.LANGUAGE = T.SOURCE_LANG)
222: where (
223: T.RES_GROUP_TYPE_ID,

Line 228: from IEC_P_RES_GRP_TYPES_TL SUBB, IEC_P_RES_GRP_TYPES_TL SUBT

224: T.LANGUAGE
225: ) in (select
226: SUBT.RES_GROUP_TYPE_ID,
227: SUBT.LANGUAGE
228: from IEC_P_RES_GRP_TYPES_TL SUBB, IEC_P_RES_GRP_TYPES_TL SUBT
229: where SUBB.RES_GROUP_TYPE_ID = SUBT.RES_GROUP_TYPE_ID
230: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
231: and (SUBB.RES_GROUP_TYPE_NAME <> SUBT.RES_GROUP_TYPE_NAME
232: or SUBB.RES_GROUP_TYPE_DESCRIPTION <> SUBT.RES_GROUP_TYPE_DESCRIPTION

Line 237: insert into IEC_P_RES_GRP_TYPES_TL (

233: or (SUBB.RES_GROUP_TYPE_DESCRIPTION is null and SUBT.RES_GROUP_TYPE_DESCRIPTION is not null)
234: or (SUBB.RES_GROUP_TYPE_DESCRIPTION is not null and SUBT.RES_GROUP_TYPE_DESCRIPTION is null)
235: ));
236:
237: insert into IEC_P_RES_GRP_TYPES_TL (
238: RES_GROUP_TYPE_ID,
239: CREATED_BY,
240: CREATION_DATE,
241: LAST_UPDATED_BY,

Line 259: from IEC_P_RES_GRP_TYPES_TL B, FND_LANGUAGES L

255: B.RES_GROUP_TYPE_NAME,
256: B.RES_GROUP_TYPE_DESCRIPTION,
257: L.LANGUAGE_CODE,
258: B.SOURCE_LANG
259: from IEC_P_RES_GRP_TYPES_TL B, FND_LANGUAGES L
260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL

Line 264: from IEC_P_RES_GRP_TYPES_TL T

260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL
264: from IEC_P_RES_GRP_TYPES_TL T
265: where T.RES_GROUP_TYPE_ID = B.RES_GROUP_TYPE_ID
266: and T.LANGUAGE = L.LANGUAGE_CODE);
267: end ADD_LANGUAGE;
268:

Line 323: update IEC_P_RES_GRP_TYPES_TL set

319: begin
320:
321: -- only UPDATE rows that have not been altered by user
322:
323: update IEC_P_RES_GRP_TYPES_TL set
324: RES_GROUP_TYPE_NAME = X_RES_GROUP_TYPE_NAME,
325: RES_GROUP_TYPE_DESCRIPTION = X_RES_GROUP_TYPE_DESCRIPTION,
326: SOURCE_LANG = userenv('LANG'),
327: LAST_UPDATE_DATE = SYSDATE,