APPS.IEC_O_RECYCLING_ALGS_PKG dependencies on IEC_O_RECYCLING_ALGS_TL

Line 42: insert into IEC_O_RECYCLING_ALGS_TL (

38: X_LAST_UPDATE_LOGIN,
39: X_PARENT_ID
40: );
41:
42: insert into IEC_O_RECYCLING_ALGS_TL (
43: OBJECT_VERSION_NUMBER,
44: LAST_UPDATE_DATE,
45: LAST_UPDATE_LOGIN,
46: LAST_UPDATED_BY,

Line 68: from IEC_O_RECYCLING_ALGS_TL T

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

Line 99: from IEC_O_RECYCLING_ALGS_TL

95:
96: cursor c1 is select
97: ALGORITHM_NAME,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from IEC_O_RECYCLING_ALGS_TL
100: where ALGORITHM_ID = X_ALGORITHM_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of ALGORITHM_ID nowait;
103: begin

Line 158: update IEC_O_RECYCLING_ALGS_TL set

154: if (sql%notfound) then
155: raise no_data_found;
156: end if;
157:
158: update IEC_O_RECYCLING_ALGS_TL set
159: ALGORITHM_NAME = X_ALGORITHM_NAME,
160: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
161: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
162: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 176: delete from IEC_O_RECYCLING_ALGS_TL

172: procedure DELETE_ROW (
173: X_ALGORITHM_ID in NUMBER
174: ) is
175: begin
176: delete from IEC_O_RECYCLING_ALGS_TL
177: where ALGORITHM_ID = X_ALGORITHM_ID;
178:
179: if (sql%notfound) then
180: raise no_data_found;

Line 194: delete from IEC_O_RECYCLING_ALGS_TL T

190:
191: procedure ADD_LANGUAGE
192: is
193: begin
194: delete from IEC_O_RECYCLING_ALGS_TL T
195: where not exists
196: (select NULL
197: from IEC_O_RECYCLING_ALGS_B B
198: where B.ALGORITHM_ID = T.ALGORITHM_ID

Line 201: update IEC_O_RECYCLING_ALGS_TL T set (

197: from IEC_O_RECYCLING_ALGS_B B
198: where B.ALGORITHM_ID = T.ALGORITHM_ID
199: );
200:
201: update IEC_O_RECYCLING_ALGS_TL T set (
202: ALGORITHM_NAME
203: ) = (select
204: B.ALGORITHM_NAME
205: from IEC_O_RECYCLING_ALGS_TL B

Line 205: from IEC_O_RECYCLING_ALGS_TL B

201: update IEC_O_RECYCLING_ALGS_TL T set (
202: ALGORITHM_NAME
203: ) = (select
204: B.ALGORITHM_NAME
205: from IEC_O_RECYCLING_ALGS_TL B
206: where B.ALGORITHM_ID = T.ALGORITHM_ID
207: and B.LANGUAGE = T.SOURCE_LANG)
208: where (
209: T.ALGORITHM_ID,

Line 214: from IEC_O_RECYCLING_ALGS_TL SUBB, IEC_O_RECYCLING_ALGS_TL SUBT

210: T.LANGUAGE
211: ) in (select
212: SUBT.ALGORITHM_ID,
213: SUBT.LANGUAGE
214: from IEC_O_RECYCLING_ALGS_TL SUBB, IEC_O_RECYCLING_ALGS_TL SUBT
215: where SUBB.ALGORITHM_ID = SUBT.ALGORITHM_ID
216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
217: and (SUBB.ALGORITHM_NAME <> SUBT.ALGORITHM_NAME
218: ));

Line 220: insert into IEC_O_RECYCLING_ALGS_TL (

216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
217: and (SUBB.ALGORITHM_NAME <> SUBT.ALGORITHM_NAME
218: ));
219:
220: insert into IEC_O_RECYCLING_ALGS_TL (
221: OBJECT_VERSION_NUMBER,
222: LAST_UPDATE_DATE,
223: LAST_UPDATE_LOGIN,
224: LAST_UPDATED_BY,

Line 242: from IEC_O_RECYCLING_ALGS_TL B, FND_LANGUAGES L

238: B.ALGORITHM_ID,
239: B.ALGORITHM_NAME,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from IEC_O_RECYCLING_ALGS_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_RECYCLING_ALGS_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_RECYCLING_ALGS_TL T
248: where T.ALGORITHM_ID = B.ALGORITHM_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251: