APPS.ASO_SUP_COMPONENT_PKG dependencies on ASO_SUP_COMPONENT_TL

Line 128: insert into ASO_SUP_COMPONENT_TL (

124: P_ATTRIBUTE19 ,
125: P_ATTRIBUTE20
126: );
127:
128: insert into ASO_SUP_COMPONENT_TL (
129: COMPONENT_ID,
130: LANGUAGE,
131: SOURCE_LANG,
132: COMPONENT_NAME,

Line 156: from ASO_SUP_COMPONENT_TL T

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

Line 246: update ASO_SUP_COMPONENT_TL

242: if (sql%notfound) then
243: raise no_data_found;
244: end if;
245:
246: update ASO_SUP_COMPONENT_TL
247: set
248: COMPONENT_NAME = P_COMPONENT_NAME,
249: DESCRIPTION = P_DESCRIPTION,
250: INSTRUCTION = P_INSTRUCTION,

Line 275: delete from ASO_SUP_COMPONENT_TL

271: IS
272:
273: Begin
274:
275: delete from ASO_SUP_COMPONENT_TL
276: where COMPONENT_ID = P_COMPONENT_ID;
277:
278: if (sql%notfound) then
279: raise no_data_found;

Line 366: from ASO_SUP_COMPONENT_TL

362: COMPONENT_NAME,
363: DESCRIPTION,
364: INSTRUCTION,
365: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
366: from ASO_SUP_COMPONENT_TL
367: where COMPONENT_ID = P_COMPONENT_ID
368: for update of COMPONENT_ID nowait;
369:
370: l_Item_ID NUMBER ;

Line 481: delete from ASO_SUP_COMPONENT_TL T

477: procedure ADD_LANGUAGE
478: is
479: begin
480:
481: delete from ASO_SUP_COMPONENT_TL T
482: where not exists
483: ( select NULL
484: from ASO_SUP_COMPONENT_B B
485: where B.COMPONENT_ID = T.COMPONENT_ID

Line 488: update ASO_SUP_COMPONENT_TL T set (

484: from ASO_SUP_COMPONENT_B B
485: where B.COMPONENT_ID = T.COMPONENT_ID
486: );
487:
488: update ASO_SUP_COMPONENT_TL T set (
489: COMPONENT_NAME,
490: DESCRIPTION,
491: INSTRUCTION
492: ) = ( select

Line 496: from ASO_SUP_COMPONENT_TL B

492: ) = ( select
493: B.COMPONENT_NAME,
494: B.DESCRIPTION,
495: B.INSTRUCTION
496: from ASO_SUP_COMPONENT_TL B
497: where B.COMPONENT_ID = T.COMPONENT_ID
498: and B.LANGUAGE = T.SOURCE_LANG )
499: where (
500: T.COMPONENT_ID,

Line 505: from ASO_SUP_COMPONENT_TL SUBB,

501: T.LANGUAGE
502: ) in ( select
503: SUBT.COMPONENT_ID,
504: SUBT.LANGUAGE
505: from ASO_SUP_COMPONENT_TL SUBB,
506: ASO_SUP_COMPONENT_TL SUBT
507: where SUBB.COMPONENT_ID = SUBT.COMPONENT_ID
508: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
509: and ( SUBB.COMPONENT_NAME <> SUBT.COMPONENT_NAME

Line 506: ASO_SUP_COMPONENT_TL SUBT

502: ) in ( select
503: SUBT.COMPONENT_ID,
504: SUBT.LANGUAGE
505: from ASO_SUP_COMPONENT_TL SUBB,
506: ASO_SUP_COMPONENT_TL SUBT
507: where SUBB.COMPONENT_ID = SUBT.COMPONENT_ID
508: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
509: and ( SUBB.COMPONENT_NAME <> SUBT.COMPONENT_NAME
510: or ( SUBB.COMPONENT_NAME is null and SUBT.COMPONENT_NAME is not null )

Line 520: insert into ASO_SUP_COMPONENT_TL (

516: or ( SUBB.INSTRUCTION is null and SUBT.INSTRUCTION is not null )
517: or ( SUBB.INSTRUCTION is not null and SUBT.INSTRUCTION is null ) )
518: );
519:
520: insert into ASO_SUP_COMPONENT_TL (
521: COMPONENT_ID,
522: LANGUAGE,
523: SOURCE_LANG,
524: COMPONENT_NAME,

Line 544: from ASO_SUP_COMPONENT_TL B,

540: B.LAST_UPDATED_BY,
541: B.CREATION_DATE,
542: B.CREATED_BY,
543: B.LAST_UPDATE_LOGIN
544: from ASO_SUP_COMPONENT_TL B,
545: FND_LANGUAGES L
546: where L.INSTALLED_FLAG in ('I', 'B')
547: and B.LANGUAGE = userenv('LANG')
548: and not exists

Line 550: from ASO_SUP_COMPONENT_TL T

546: where L.INSTALLED_FLAG in ('I', 'B')
547: and B.LANGUAGE = userenv('LANG')
548: and not exists
549: ( select NULL
550: from ASO_SUP_COMPONENT_TL T
551: where T.COMPONENT_ID = B.COMPONENT_ID
552: and T.LANGUAGE = L.LANGUAGE_CODE );
553:
554: end ADD_LANGUAGE;

Line 703: update ASO_SUP_COMPONENT_TL

699: begin
700:
701: l_user_id := fnd_load_util.owner_id(X_OWNER);
702:
703: update ASO_SUP_COMPONENT_TL
704: set COMPONENT_NAME = P_COMPONENT_NAME,
705: DESCRIPTION = P_DESCRIPTION,
706: INSTRUCTION = P_INSTRUCTION,
707: source_lang = userenv('LANG'),

Line 766: FROM ASO_SUP_COMPONENT_TL

762: row_id1 VARCHAR2(32767);
763:
764: cursor get_components is
765: SELECT COMPONENT_ID
766: FROM ASO_SUP_COMPONENT_TL
767: WHERE COMPONENT_ID = P_COMPONENT_ID;
768:
769: cursor get_mappings is
770: select sect_comp_map_id