APPS.IEC_O_RELEASE_CTLS_PKG dependencies on IEC_O_RELEASE_CTLS_TL

Line 42: insert into IEC_O_RELEASE_CTLS_TL (

38: X_LAST_UPDATE_LOGIN,
39: X_PARENT_ID
40: );
41:
42: insert into IEC_O_RELEASE_CTLS_TL (
43: RELEASE_CONTROL_ID,
44: RELEASE_CONTROL_NAME,
45: CREATED_BY,
46: CREATION_DATE,

Line 68: from IEC_O_RELEASE_CTLS_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_RELEASE_CTLS_TL T
69: where T.RELEASE_CONTROL_ID = X_RELEASE_CONTROL_ID
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 99: from IEC_O_RELEASE_CTLS_TL

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

Line 157: update IEC_O_RELEASE_CTLS_TL set

153: if (sql%notfound) then
154: raise no_data_found;
155: end if;
156:
157: update IEC_O_RELEASE_CTLS_TL set
158: RELEASE_CONTROL_NAME = X_RELEASE_CONTROL_NAME,
159: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
160: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
161: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 175: delete from IEC_O_RELEASE_CTLS_TL

171: procedure DELETE_ROW (
172: X_RELEASE_CONTROL_ID in NUMBER
173: ) is
174: begin
175: delete from IEC_O_RELEASE_CTLS_TL
176: where RELEASE_CONTROL_ID = X_RELEASE_CONTROL_ID;
177:
178: if (sql%notfound) then
179: raise no_data_found;

Line 193: delete from IEC_O_RELEASE_CTLS_TL T

189:
190: procedure ADD_LANGUAGE
191: is
192: begin
193: delete from IEC_O_RELEASE_CTLS_TL T
194: where not exists
195: (select NULL
196: from IEC_O_RELEASE_CTLS_B B
197: where B.RELEASE_CONTROL_ID = T.RELEASE_CONTROL_ID

Line 200: update IEC_O_RELEASE_CTLS_TL T set (

196: from IEC_O_RELEASE_CTLS_B B
197: where B.RELEASE_CONTROL_ID = T.RELEASE_CONTROL_ID
198: );
199:
200: update IEC_O_RELEASE_CTLS_TL T set (
201: RELEASE_CONTROL_NAME
202: ) = (select
203: B.RELEASE_CONTROL_NAME
204: from IEC_O_RELEASE_CTLS_TL B

Line 204: from IEC_O_RELEASE_CTLS_TL B

200: update IEC_O_RELEASE_CTLS_TL T set (
201: RELEASE_CONTROL_NAME
202: ) = (select
203: B.RELEASE_CONTROL_NAME
204: from IEC_O_RELEASE_CTLS_TL B
205: where B.RELEASE_CONTROL_ID = T.RELEASE_CONTROL_ID
206: and B.LANGUAGE = T.SOURCE_LANG)
207: where (
208: T.RELEASE_CONTROL_ID,

Line 213: from IEC_O_RELEASE_CTLS_TL SUBB, IEC_O_RELEASE_CTLS_TL SUBT

209: T.LANGUAGE
210: ) in (select
211: SUBT.RELEASE_CONTROL_ID,
212: SUBT.LANGUAGE
213: from IEC_O_RELEASE_CTLS_TL SUBB, IEC_O_RELEASE_CTLS_TL SUBT
214: where SUBB.RELEASE_CONTROL_ID = SUBT.RELEASE_CONTROL_ID
215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
216: and (SUBB.RELEASE_CONTROL_NAME <> SUBT.RELEASE_CONTROL_NAME
217: ));

Line 219: insert into IEC_O_RELEASE_CTLS_TL (

215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
216: and (SUBB.RELEASE_CONTROL_NAME <> SUBT.RELEASE_CONTROL_NAME
217: ));
218:
219: insert into IEC_O_RELEASE_CTLS_TL (
220: RELEASE_CONTROL_ID,
221: RELEASE_CONTROL_NAME,
222: CREATED_BY,
223: CREATION_DATE,

Line 241: from IEC_O_RELEASE_CTLS_TL B, FND_LANGUAGES L

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

Line 246: from IEC_O_RELEASE_CTLS_TL T

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