APPS.IEC_G_REP_CONF_PARAMS_PKG dependencies on IEC_G_REP_CONF_PARAMS_TL

Line 39: insert into IEC_G_REP_CONF_PARAMS_TL (

35: X_LAST_UPDATED_BY,
36: X_LAST_UPDATE_LOGIN
37: );
38:
39: insert into IEC_G_REP_CONF_PARAMS_TL (
40: PARAM_NAME,
41: PARAM_ID,
42: CREATED_BY,
43: CREATION_DATE,

Line 65: from IEC_G_REP_CONF_PARAMS_TL T

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

Line 94: from IEC_G_REP_CONF_PARAMS_TL

90:
91: cursor c1 is select
92: PARAM_NAME,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from IEC_G_REP_CONF_PARAMS_TL
95: where PARAM_ID = X_PARAM_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of PARAM_ID nowait;
98: begin

Line 149: update IEC_G_REP_CONF_PARAMS_TL set

145: if (sql%notfound) then
146: raise no_data_found;
147: end if;
148:
149: update IEC_G_REP_CONF_PARAMS_TL set
150: PARAM_NAME = X_PARAM_NAME,
151: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
152: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
153: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 167: delete from IEC_G_REP_CONF_PARAMS_TL

163: procedure DELETE_ROW (
164: X_PARAM_ID in NUMBER
165: ) is
166: begin
167: delete from IEC_G_REP_CONF_PARAMS_TL
168: where PARAM_ID = X_PARAM_ID;
169:
170: if (sql%notfound) then
171: raise no_data_found;

Line 185: delete from IEC_G_REP_CONF_PARAMS_TL T

181:
182: procedure ADD_LANGUAGE
183: is
184: begin
185: delete from IEC_G_REP_CONF_PARAMS_TL T
186: where not exists
187: (select NULL
188: from IEC_G_REP_CONF_PARAMS_B B
189: where B.PARAM_ID = T.PARAM_ID

Line 192: update IEC_G_REP_CONF_PARAMS_TL T set (

188: from IEC_G_REP_CONF_PARAMS_B B
189: where B.PARAM_ID = T.PARAM_ID
190: );
191:
192: update IEC_G_REP_CONF_PARAMS_TL T set (
193: PARAM_NAME
194: ) = (select
195: B.PARAM_NAME
196: from IEC_G_REP_CONF_PARAMS_TL B

Line 196: from IEC_G_REP_CONF_PARAMS_TL B

192: update IEC_G_REP_CONF_PARAMS_TL T set (
193: PARAM_NAME
194: ) = (select
195: B.PARAM_NAME
196: from IEC_G_REP_CONF_PARAMS_TL B
197: where B.PARAM_ID = T.PARAM_ID
198: and B.LANGUAGE = T.SOURCE_LANG)
199: where (
200: T.PARAM_ID,

Line 205: from IEC_G_REP_CONF_PARAMS_TL SUBB, IEC_G_REP_CONF_PARAMS_TL SUBT

201: T.LANGUAGE
202: ) in (select
203: SUBT.PARAM_ID,
204: SUBT.LANGUAGE
205: from IEC_G_REP_CONF_PARAMS_TL SUBB, IEC_G_REP_CONF_PARAMS_TL SUBT
206: where SUBB.PARAM_ID = SUBT.PARAM_ID
207: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
208: and (SUBB.PARAM_NAME <> SUBT.PARAM_NAME
209: ));

Line 211: insert into IEC_G_REP_CONF_PARAMS_TL (

207: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
208: and (SUBB.PARAM_NAME <> SUBT.PARAM_NAME
209: ));
210:
211: insert into IEC_G_REP_CONF_PARAMS_TL (
212: PARAM_NAME,
213: PARAM_ID,
214: CREATED_BY,
215: CREATION_DATE,

Line 233: from IEC_G_REP_CONF_PARAMS_TL B, FND_LANGUAGES L

229: B.LAST_UPDATE_LOGIN,
230: B.OBJECT_VERSION_NUMBER,
231: L.LANGUAGE_CODE,
232: B.SOURCE_LANG
233: from IEC_G_REP_CONF_PARAMS_TL B, FND_LANGUAGES L
234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL

Line 238: from IEC_G_REP_CONF_PARAMS_TL T

234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL
238: from IEC_G_REP_CONF_PARAMS_TL T
239: where T.PARAM_ID = B.PARAM_ID
240: and T.LANGUAGE = L.LANGUAGE_CODE);
241: end ADD_LANGUAGE;
242:

Line 274: update IEC_G_REP_CONF_PARAMS_TL set

270: begin
271:
272: -- only UPDATE rows that have not been altered by user
273:
274: update IEC_G_REP_CONF_PARAMS_TL set
275: SOURCE_LANG = userenv('LANG'),
276: PARAM_NAME = X_PARAM_NAME,
277: LAST_UPDATE_DATE = SYSDATE,
278: LAST_UPDATED_BY = DECODE(X_OWNER, 'SEED', 1, 0),