APPS.ASO_SUP_TEMPLATE_PKG dependencies on ASO_SUP_TEMPLATE_TL

Line 126: insert into ASO_SUP_TEMPLATE_TL (

122: P_ATTRIBUTE19,
123: P_ATTRIBUTE20
124: );
125:
126: insert into ASO_SUP_TEMPLATE_TL (
127: TEMPLATE_ID,
128: LANGUAGE,
129: SOURCE_LANG,
130: TEMPLATE_NAME,

Line 152: from ASO_SUP_TEMPLATE_TL T

148: from FND_LANGUAGES L
149: where L.INSTALLED_FLAG in ('I', 'B')
150: and not exists
151: ( select 'x'
152: from ASO_SUP_TEMPLATE_TL T
153: where T.TEMPLATE_ID = PX_TEMPLATE_ID
154: and T.LANGUAGE = L.LANGUAGE_CODE );
155:
156: open c;

Line 239: update ASO_SUP_TEMPLATE_TL

235: if (sql%notfound) then
236: raise no_data_found;
237: end if;
238:
239: update ASO_SUP_TEMPLATE_TL
240: set
241: TEMPLATE_NAME = decode(P_TEMPLATE_NAME,FND_API.G_MISS_CHAR,template_name,P_TEMPLATE_NAME),
242: DESCRIPTION = decode(P_DESCRIPTION,FND_API.G_MISS_CHAR,description,P_DESCRIPTION),
243: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 267: delete from ASO_SUP_TEMPLATE_TL

263: IS
264:
265: Begin
266:
267: delete from ASO_SUP_TEMPLATE_TL
268: where TEMPLATE_ID = P_TEMPLATE_ID;
269:
270: if (sql%notfound) then
271: raise no_data_found;

Line 355: from ASO_SUP_TEMPLATE_TL

351: select
352: TEMPLATE_NAME,
353: DESCRIPTION,
354: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
355: from ASO_SUP_TEMPLATE_TL
356: where TEMPLATE_ID = P_TEMPLATE_ID
357: for update of TEMPLATE_ID nowait;
358:
359: l_Item_ID NUMBER ;

Line 473: delete from ASO_SUP_TEMPLATE_TL T

469: procedure ADD_LANGUAGE
470: is
471: begin
472:
473: delete from ASO_SUP_TEMPLATE_TL T
474: where not exists
475: ( select NULL
476: from ASO_SUP_TEMPLATE_B B
477: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 480: update ASO_SUP_TEMPLATE_TL T set (

476: from ASO_SUP_TEMPLATE_B B
477: where B.TEMPLATE_ID = T.TEMPLATE_ID
478: );
479:
480: update ASO_SUP_TEMPLATE_TL T set (
481: TEMPLATE_NAME,
482: DESCRIPTION
483: ) = ( select
484: B.TEMPLATE_NAME,

Line 486: from ASO_SUP_TEMPLATE_TL B

482: DESCRIPTION
483: ) = ( select
484: B.TEMPLATE_NAME,
485: B.DESCRIPTION
486: from ASO_SUP_TEMPLATE_TL B
487: where B.TEMPLATE_ID = T.TEMPLATE_ID
488: and B.LANGUAGE = T.SOURCE_LANG )
489: where (
490: T.TEMPLATE_ID,

Line 495: from ASO_SUP_TEMPLATE_TL SUBB,

491: T.LANGUAGE
492: ) in ( select
493: SUBT.TEMPLATE_ID,
494: SUBT.LANGUAGE
495: from ASO_SUP_TEMPLATE_TL SUBB,
496: ASO_SUP_TEMPLATE_TL SUBT
497: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
498: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
499: and ( SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME

Line 496: ASO_SUP_TEMPLATE_TL SUBT

492: ) in ( select
493: SUBT.TEMPLATE_ID,
494: SUBT.LANGUAGE
495: from ASO_SUP_TEMPLATE_TL SUBB,
496: ASO_SUP_TEMPLATE_TL SUBT
497: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
498: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
499: and ( SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
500: or ( SUBB.TEMPLATE_NAME is null and SUBT.TEMPLATE_NAME is not null )

Line 508: insert into ASO_SUP_TEMPLATE_TL (

504: or ( SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null ) )
505:
506: );
507:
508: insert into ASO_SUP_TEMPLATE_TL (
509: TEMPLATE_ID,
510: LANGUAGE,
511: SOURCE_LANG,
512: TEMPLATE_NAME,

Line 530: from ASO_SUP_TEMPLATE_TL B,

526: B.LAST_UPDATED_BY,
527: B.CREATION_DATE,
528: B.CREATED_BY,
529: B.LAST_UPDATE_LOGIN
530: from ASO_SUP_TEMPLATE_TL B,
531: FND_LANGUAGES L
532: where L.INSTALLED_FLAG in ('I', 'B')
533: and B.LANGUAGE = userenv('LANG')
534: and not exists

Line 536: from ASO_SUP_TEMPLATE_TL T

532: where L.INSTALLED_FLAG in ('I', 'B')
533: and B.LANGUAGE = userenv('LANG')
534: and not exists
535: ( select NULL
536: from ASO_SUP_TEMPLATE_TL T
537: where T.TEMPLATE_ID = B.TEMPLATE_ID
538: and T.LANGUAGE = L.LANGUAGE_CODE );
539:
540: end ADD_LANGUAGE;

Line 682: update ASO_SUP_TEMPLATE_TL

678: begin
679:
680: -- only update rows that have not been altered by user
681:
682: update ASO_SUP_TEMPLATE_TL
683: set TEMPLATE_NAME = P_TEMPLATE_NAME,
684: DESCRIPTION = P_DESCRIPTION,
685: source_lang = userenv('LANG'),
686: last_update_date = sysdate,

Line 732: FROM ASO_SUP_TEMPLATE_tl

728: row_id1 VARCHAR2(32767);
729:
730: cursor get_templates is
731: SELECT template_id
732: FROM ASO_SUP_TEMPLATE_tl
733: WHERE TEMPLATE_ID = PX_TEMPLATE_ID;
734: BEGIN
735: if (P_UPLOAD_MODE = 'NLS') then
736: