APPS.IEC_O_VALIDATION_RECOMM_PKG dependencies on IEC_O_VALIDATION_RECOMM_TL

Line 40: insert into IEC_O_VALIDATION_RECOMM_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into IEC_O_VALIDATION_RECOMM_TL (
41: RECOMMENDATION_CODE,
42: RECOMMENDATION,
43: CREATED_BY,
44: CREATION_DATE,

Line 66: from IEC_O_VALIDATION_RECOMM_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from IEC_O_VALIDATION_RECOMM_TL T
67: where T.RECOMMENDATION_CODE = X_RECOMMENDATION_CODE
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 96: from IEC_O_VALIDATION_RECOMM_TL

92:
93: cursor c1 is select
94: RECOMMENDATION,
95: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
96: from IEC_O_VALIDATION_RECOMM_TL
97: where RECOMMENDATION_CODE = X_RECOMMENDATION_CODE
98: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
99: for update of RECOMMENDATION_CODE nowait;
100:

Line 153: update IEC_O_VALIDATION_RECOMM_TL set

149: if (sql%notfound) then
150: raise no_data_found;
151: end if;
152:
153: update IEC_O_VALIDATION_RECOMM_TL set
154: RECOMMENDATION = X_RECOMMENDATION,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
157: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 172: delete from IEC_O_VALIDATION_RECOMM_TL

168: procedure DELETE_ROW (
169: X_RECOMMENDATION_CODE in VARCHAR2
170: ) is
171: begin
172: delete from IEC_O_VALIDATION_RECOMM_TL
173: where RECOMMENDATION_CODE = X_RECOMMENDATION_CODE;
174:
175: if (sql%notfound) then
176: raise no_data_found;

Line 192: delete from IEC_O_VALIDATION_RECOMM_TL T

188:
189: procedure ADD_LANGUAGE
190: is
191: begin
192: delete from IEC_O_VALIDATION_RECOMM_TL T
193: where not exists
194: (select NULL
195: from IEC_O_VALIDATION_RECOMM_B B
196: where B.RECOMMENDATION_CODE = T.RECOMMENDATION_CODE

Line 199: update IEC_O_VALIDATION_RECOMM_TL T set (

195: from IEC_O_VALIDATION_RECOMM_B B
196: where B.RECOMMENDATION_CODE = T.RECOMMENDATION_CODE
197: );
198:
199: update IEC_O_VALIDATION_RECOMM_TL T set (
200: RECOMMENDATION
201: ) = (select
202: B.RECOMMENDATION
203: from IEC_O_VALIDATION_RECOMM_TL B

Line 203: from IEC_O_VALIDATION_RECOMM_TL B

199: update IEC_O_VALIDATION_RECOMM_TL T set (
200: RECOMMENDATION
201: ) = (select
202: B.RECOMMENDATION
203: from IEC_O_VALIDATION_RECOMM_TL B
204: where B.RECOMMENDATION_CODE = T.RECOMMENDATION_CODE
205: and B.LANGUAGE = T.SOURCE_LANG)
206: where (
207: T.RECOMMENDATION_CODE,

Line 212: from IEC_O_VALIDATION_RECOMM_TL SUBB, IEC_O_VALIDATION_RECOMM_TL SUBT

208: T.LANGUAGE
209: ) in (select
210: SUBT.RECOMMENDATION_CODE,
211: SUBT.LANGUAGE
212: from IEC_O_VALIDATION_RECOMM_TL SUBB, IEC_O_VALIDATION_RECOMM_TL SUBT
213: where SUBB.RECOMMENDATION_CODE = SUBT.RECOMMENDATION_CODE
214: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
215: and (SUBB.RECOMMENDATION <> SUBT.RECOMMENDATION
216: or (SUBB.RECOMMENDATION is null and SUBT.RECOMMENDATION is not null)

Line 220: insert into IEC_O_VALIDATION_RECOMM_TL (

216: or (SUBB.RECOMMENDATION is null and SUBT.RECOMMENDATION is not null)
217: or (SUBB.RECOMMENDATION is not null and SUBT.RECOMMENDATION is null)
218: ));
219:
220: insert into IEC_O_VALIDATION_RECOMM_TL (
221: RECOMMENDATION_CODE,
222: RECOMMENDATION,
223: CREATED_BY,
224: CREATION_DATE,

Line 242: from IEC_O_VALIDATION_RECOMM_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_LOGIN,
239: B.OBJECT_VERSION_NUMBER,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from IEC_O_VALIDATION_RECOMM_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from IEC_O_VALIDATION_RECOMM_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from IEC_O_VALIDATION_RECOMM_TL T
248: where T.RECOMMENDATION_CODE = B.RECOMMENDATION_CODE
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:

Line 317: update IEC_O_VALIDATION_RECOMM_TL set

313: begin
314:
315: -- only UPDATE rows that have not been altered by user
316:
317: update IEC_O_VALIDATION_RECOMM_TL set
318: SOURCE_LANG = userenv('LANG'),
319: RECOMMENDATION = X_RECOMMENDATION,
320: LAST_UPDATE_DATE = SYSDATE,
321: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),