APPS.AR_BPA_RULES_PKG dependencies on AR_BPA_RULES_TL

Line 70: insert into AR_BPA_RULES_TL (

66: X_LAST_UPDATED_BY,
67: X_LAST_UPDATE_LOGIN
68: );
69:
70: insert into AR_BPA_RULES_TL (
71: RULE_ID,
72: RULE_NAME,
73: RULE_DESCRIPTION,
74: CREATED_BY,

Line 96: from AR_BPA_RULES_TL T

92: from FND_LANGUAGES L
93: where L.INSTALLED_FLAG in ('I', 'B')
94: and not exists
95: (select NULL
96: from AR_BPA_RULES_TL T
97: where T.RULE_ID = X_RULE_ID
98: and T.LANGUAGE = L.LANGUAGE_CODE);
99:
100: open c;

Line 149: from AR_BPA_RULES_TL

145: cursor c1 is select
146: RULE_NAME,
147: RULE_DESCRIPTION,
148: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
149: from AR_BPA_RULES_TL
150: where RULE_ID = X_RULE_ID
151: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
152: for update of RULE_ID nowait;
153: begin

Line 251: update AR_BPA_RULES_TL set

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: update AR_BPA_RULES_TL set
252: RULE_NAME = X_RULE_NAME,
253: RULE_DESCRIPTION = X_RULE_DESCRIPTION,
254: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
255: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 270: delete from AR_BPA_RULES_TL

266: procedure DELETE_ROW (
267: X_RULE_ID in NUMBER
268: ) is
269: begin
270: delete from AR_BPA_RULES_TL
271: where RULE_ID = X_RULE_ID;
272:
273: if (sql%notfound) then
274: raise no_data_found;

Line 288: delete from AR_BPA_RULES_TL T

284:
285: procedure ADD_LANGUAGE
286: is
287: begin
288: delete from AR_BPA_RULES_TL T
289: where not exists
290: (select NULL
291: from AR_BPA_RULES_B B
292: where B.RULE_ID = T.RULE_ID

Line 295: update AR_BPA_RULES_TL T set (

291: from AR_BPA_RULES_B B
292: where B.RULE_ID = T.RULE_ID
293: );
294:
295: update AR_BPA_RULES_TL T set (
296: RULE_NAME,
297: RULE_DESCRIPTION
298: ) = (select
299: B.RULE_NAME,

Line 301: from AR_BPA_RULES_TL B

297: RULE_DESCRIPTION
298: ) = (select
299: B.RULE_NAME,
300: B.RULE_DESCRIPTION
301: from AR_BPA_RULES_TL B
302: where B.RULE_ID = T.RULE_ID
303: and B.LANGUAGE = T.SOURCE_LANG)
304: where (
305: T.RULE_ID,

Line 310: from AR_BPA_RULES_TL SUBB, AR_BPA_RULES_TL SUBT

306: T.LANGUAGE
307: ) in (select
308: SUBT.RULE_ID,
309: SUBT.LANGUAGE
310: from AR_BPA_RULES_TL SUBB, AR_BPA_RULES_TL SUBT
311: where SUBB.RULE_ID = SUBT.RULE_ID
312: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
313: and (SUBB.RULE_NAME <> SUBT.RULE_NAME
314: or SUBB.RULE_DESCRIPTION <> SUBT.RULE_DESCRIPTION

Line 319: insert into AR_BPA_RULES_TL (

315: or (SUBB.RULE_DESCRIPTION is null and SUBT.RULE_DESCRIPTION is not null)
316: or (SUBB.RULE_DESCRIPTION is not null and SUBT.RULE_DESCRIPTION is null)
317: ));
318:
319: insert into AR_BPA_RULES_TL (
320: RULE_ID,
321: RULE_NAME,
322: RULE_DESCRIPTION,
323: CREATED_BY,

Line 341: from AR_BPA_RULES_TL B, FND_LANGUAGES L

337: B.LAST_UPDATE_DATE,
338: B.LAST_UPDATE_LOGIN,
339: L.LANGUAGE_CODE,
340: B.SOURCE_LANG
341: from AR_BPA_RULES_TL B, FND_LANGUAGES L
342: where L.INSTALLED_FLAG in ('I', 'B')
343: and B.LANGUAGE = userenv('LANG')
344: and not exists
345: (select NULL

Line 346: from AR_BPA_RULES_TL T

342: where L.INSTALLED_FLAG in ('I', 'B')
343: and B.LANGUAGE = userenv('LANG')
344: and not exists
345: (select NULL
346: from AR_BPA_RULES_TL T
347: where T.RULE_ID = B.RULE_ID
348: and T.LANGUAGE = L.LANGUAGE_CODE);
349: end ADD_LANGUAGE;
350:

Line 358: update AR_BPA_RULES_TL

354: X_RULE_DESCRIPTION in VARCHAR2,
355: X_OWNER in VARCHAR2) IS
356: begin
357:
358: update AR_BPA_RULES_TL
359: set RULE_NAME = X_RULE_NAME,
360: RULE_DESCRIPTION = X_RULE_DESCRIPTION,
361: source_lang = userenv('LANG'),
362: last_update_date = sysdate,