APPS.IEC_O_VALIDATION_RULES_PKG dependencies on IEC_O_VALIDATION_RULES_TL

Line 42: insert into IEC_O_VALIDATION_RULES_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into IEC_O_VALIDATION_RULES_TL (
43: VALIDATION_RULE_ID,
44: VALIDATION_RULE_NAME,
45: CREATED_BY,
46: CREATION_DATE,

Line 68: from IEC_O_VALIDATION_RULES_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_VALIDATION_RULES_TL T
69: where T.VALIDATION_RULE_ID = X_VALIDATION_RULE_ID
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 99: from IEC_O_VALIDATION_RULES_TL

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

Line 158: update IEC_O_VALIDATION_RULES_TL set

154: if (sql%notfound) then
155: raise no_data_found;
156: end if;
157:
158: update IEC_O_VALIDATION_RULES_TL set
159: VALIDATION_RULE_NAME = X_VALIDATION_RULE_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_VALIDATION_RULES_TL

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

Line 194: delete from IEC_O_VALIDATION_RULES_TL T

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

Line 201: update IEC_O_VALIDATION_RULES_TL T set (

197: from IEC_O_VALIDATION_RULES_B B
198: where B.VALIDATION_RULE_ID = T.VALIDATION_RULE_ID
199: );
200:
201: update IEC_O_VALIDATION_RULES_TL T set (
202: VALIDATION_RULE_NAME
203: ) = (select
204: B.VALIDATION_RULE_NAME
205: from IEC_O_VALIDATION_RULES_TL B

Line 205: from IEC_O_VALIDATION_RULES_TL B

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

Line 214: from IEC_O_VALIDATION_RULES_TL SUBB, IEC_O_VALIDATION_RULES_TL SUBT

210: T.LANGUAGE
211: ) in (select
212: SUBT.VALIDATION_RULE_ID,
213: SUBT.LANGUAGE
214: from IEC_O_VALIDATION_RULES_TL SUBB, IEC_O_VALIDATION_RULES_TL SUBT
215: where SUBB.VALIDATION_RULE_ID = SUBT.VALIDATION_RULE_ID
216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
217: and (SUBB.VALIDATION_RULE_NAME <> SUBT.VALIDATION_RULE_NAME
218: or (SUBB.VALIDATION_RULE_NAME is null and SUBT.VALIDATION_RULE_NAME is not null)

Line 222: insert into IEC_O_VALIDATION_RULES_TL (

218: or (SUBB.VALIDATION_RULE_NAME is null and SUBT.VALIDATION_RULE_NAME is not null)
219: or (SUBB.VALIDATION_RULE_NAME is not null and SUBT.VALIDATION_RULE_NAME is null)
220: ));
221:
222: insert into IEC_O_VALIDATION_RULES_TL (
223: VALIDATION_RULE_ID,
224: VALIDATION_RULE_NAME,
225: CREATED_BY,
226: CREATION_DATE,

Line 244: from IEC_O_VALIDATION_RULES_TL B, FND_LANGUAGES L

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

Line 249: from IEC_O_VALIDATION_RULES_TL T

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

Line 302: update IEC_O_VALIDATION_RULES_TL set

298: begin
299:
300: -- only UPDATE rows that have not been altered by user
301:
302: update IEC_O_VALIDATION_RULES_TL set
303: SOURCE_LANG = userenv('LANG'),
304: VALIDATION_RULE_NAME = X_VALIDATION_RULE_NAME,
305: LAST_UPDATE_DATE = SYSDATE,
306: LAST_UPDATED_BY = DECODE(X_OWNER, 'SEED', 1, 0),