APPS.AR_BPA_TEMPLATES_PKG dependencies on AR_BPA_TEMPLATES_TL

Line 130: insert into AR_BPA_TEMPLATES_TL (

126: X_LAST_UPDATED_BY,
127: X_LAST_UPDATE_LOGIN
128: );
129:
130: insert into AR_BPA_TEMPLATES_TL (
131: TEMPLATE_ID,
132: TEMPLATE_NAME,
133: TEMPLATE_DESCRIPTION,
134: CREATED_BY,

Line 156: from AR_BPA_TEMPLATES_TL T

152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from AR_BPA_TEMPLATES_TL T
157: where T.TEMPLATE_ID = X_TEMPLATE_ID
158: and T.LANGUAGE = L.LANGUAGE_CODE);
159:
160: open c;

Line 249: from AR_BPA_TEMPLATES_TL

245: cursor c1 is select
246: TEMPLATE_NAME,
247: TEMPLATE_DESCRIPTION,
248: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
249: from AR_BPA_TEMPLATES_TL
250: where TEMPLATE_ID = X_TEMPLATE_ID
251: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
252: for update of TEMPLATE_ID nowait;
253: begin

Line 431: update AR_BPA_TEMPLATES_TL set

427: if (sql%notfound) then
428: raise no_data_found;
429: end if;
430:
431: update AR_BPA_TEMPLATES_TL set
432: TEMPLATE_NAME = X_TEMPLATE_NAME,
433: TEMPLATE_DESCRIPTION = X_TEMPLATE_DESCRIPTION,
434: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
435: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 471: delete from AR_BPA_TEMPLATES_TL

467:
468: delete from AR_BPA_TEMPLATE_FIELDS
469: where TEMPLATE_ID = X_TEMPLATE_ID;
470:
471: delete from AR_BPA_TEMPLATES_TL
472: where TEMPLATE_ID = X_TEMPLATE_ID;
473:
474: if (sql%notfound) then
475: raise no_data_found;

Line 489: delete from AR_BPA_TEMPLATES_TL T

485:
486: procedure ADD_LANGUAGE
487: is
488: begin
489: delete from AR_BPA_TEMPLATES_TL T
490: where not exists
491: (select NULL
492: from AR_BPA_TEMPLATES_B B
493: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 496: update AR_BPA_TEMPLATES_TL T set (

492: from AR_BPA_TEMPLATES_B B
493: where B.TEMPLATE_ID = T.TEMPLATE_ID
494: );
495:
496: update AR_BPA_TEMPLATES_TL T set (
497: TEMPLATE_NAME,
498: TEMPLATE_DESCRIPTION
499: ) = (select
500: B.TEMPLATE_NAME,

Line 502: from AR_BPA_TEMPLATES_TL B

498: TEMPLATE_DESCRIPTION
499: ) = (select
500: B.TEMPLATE_NAME,
501: B.TEMPLATE_DESCRIPTION
502: from AR_BPA_TEMPLATES_TL B
503: where B.TEMPLATE_ID = T.TEMPLATE_ID
504: and B.LANGUAGE = T.SOURCE_LANG)
505: where (
506: T.TEMPLATE_ID,

Line 511: from AR_BPA_TEMPLATES_TL SUBB, AR_BPA_TEMPLATES_TL SUBT

507: T.LANGUAGE
508: ) in (select
509: SUBT.TEMPLATE_ID,
510: SUBT.LANGUAGE
511: from AR_BPA_TEMPLATES_TL SUBB, AR_BPA_TEMPLATES_TL SUBT
512: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
513: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
514: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
515: or SUBB.TEMPLATE_DESCRIPTION <> SUBT.TEMPLATE_DESCRIPTION

Line 520: insert into AR_BPA_TEMPLATES_TL (

516: or (SUBB.TEMPLATE_DESCRIPTION is null and SUBT.TEMPLATE_DESCRIPTION is not null)
517: or (SUBB.TEMPLATE_DESCRIPTION is not null and SUBT.TEMPLATE_DESCRIPTION is null)
518: ));
519:
520: insert into AR_BPA_TEMPLATES_TL (
521: TEMPLATE_ID,
522: TEMPLATE_NAME,
523: TEMPLATE_DESCRIPTION,
524: CREATED_BY,

Line 542: from AR_BPA_TEMPLATES_TL B, FND_LANGUAGES L

538: B.LAST_UPDATE_DATE,
539: B.LAST_UPDATE_LOGIN,
540: L.LANGUAGE_CODE,
541: B.SOURCE_LANG
542: from AR_BPA_TEMPLATES_TL B, FND_LANGUAGES L
543: where L.INSTALLED_FLAG in ('I', 'B')
544: and B.LANGUAGE = userenv('LANG')
545: and not exists
546: (select NULL

Line 547: from AR_BPA_TEMPLATES_TL T

543: where L.INSTALLED_FLAG in ('I', 'B')
544: and B.LANGUAGE = userenv('LANG')
545: and not exists
546: (select NULL
547: from AR_BPA_TEMPLATES_TL T
548: where T.TEMPLATE_ID = B.TEMPLATE_ID
549: and T.LANGUAGE = L.LANGUAGE_CODE);
550: end ADD_LANGUAGE;
551:

Line 692: update AR_BPA_TEMPLATES_TL

688: X_TEMPLATE_DESCRIPTION in VARCHAR2,
689: X_OWNER in VARCHAR2) IS
690: begin
691:
692: update AR_BPA_TEMPLATES_TL
693: set TEMPLATE_NAME = X_TEMPLATE_NAME,
694: TEMPLATE_DESCRIPTION = X_TEMPLATE_DESCRIPTION,
695: source_lang = userenv('LANG'),
696: last_update_date = sysdate,