APPS.ASO_SUP_SECTION_PKG dependencies on ASO_SUP_SECTION_TL

Line 118: insert into ASO_SUP_SECTION_TL (

114: P_ATTRIBUTE19,
115: P_ATTRIBUTE20
116: );
117:
118: insert into ASO_SUP_SECTION_TL (
119: SECTION_ID,
120: LANGUAGE,
121: SOURCE_LANG,
122: SECTION_NAME,

Line 144: from ASO_SUP_SECTION_TL T

140: from FND_LANGUAGES L
141: where L.INSTALLED_FLAG in ('I', 'B')
142: and not exists
143: ( select 'x'
144: from ASO_SUP_SECTION_TL T
145: where T.SECTION_ID = PX_SECTION_ID
146: and T.LANGUAGE = L.LANGUAGE_CODE );
147:
148: open c;

Line 227: update ASO_SUP_SECTION_TL

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: update ASO_SUP_SECTION_TL
228: set
229: SECTION_NAME = P_SECTION_NAME,
230: DESCRIPTION = P_DESCRIPTION,
231: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 255: delete from ASO_SUP_SECTION_TL

251: IS
252:
253: Begin
254:
255: delete from ASO_SUP_SECTION_TL
256: where SECTION_ID = P_SECTION_ID;
257:
258: if (sql%notfound) then
259: raise no_data_found;

Line 339: from ASO_SUP_SECTION_TL

335: select
336: SECTION_NAME,
337: DESCRIPTION,
338: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
339: from ASO_SUP_SECTION_TL
340: where SECTION_ID = P_SECTION_ID
341: for update of SECTION_ID nowait;
342:
343: l_Item_ID NUMBER ;

Line 447: delete from ASO_SUP_SECTION_TL T

443: procedure ADD_LANGUAGE
444: is
445: begin
446:
447: delete from ASO_SUP_SECTION_TL T
448: where not exists
449: ( select NULL
450: from ASO_SUP_SECTION_B B
451: where B.SECTION_ID = T.SECTION_ID

Line 454: update ASO_SUP_SECTION_TL T set (

450: from ASO_SUP_SECTION_B B
451: where B.SECTION_ID = T.SECTION_ID
452: );
453:
454: update ASO_SUP_SECTION_TL T set (
455: SECTION_NAME,
456: DESCRIPTION
457: ) = ( select
458: B.SECTION_NAME,

Line 460: from ASO_SUP_SECTION_TL B

456: DESCRIPTION
457: ) = ( select
458: B.SECTION_NAME,
459: B.DESCRIPTION
460: from ASO_SUP_SECTION_TL B
461: where B.SECTION_ID = T.SECTION_ID
462: and B.LANGUAGE = T.SOURCE_LANG )
463: where (
464: T.SECTION_ID,

Line 469: from ASO_SUP_SECTION_TL SUBB,

465: T.LANGUAGE
466: ) in ( select
467: SUBT.SECTION_ID,
468: SUBT.LANGUAGE
469: from ASO_SUP_SECTION_TL SUBB,
470: ASO_SUP_SECTION_TL SUBT
471: where SUBB.SECTION_ID = SUBT.SECTION_ID
472: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
473: and ( SUBB.SECTION_NAME <> SUBT.SECTION_NAME

Line 470: ASO_SUP_SECTION_TL SUBT

466: ) in ( select
467: SUBT.SECTION_ID,
468: SUBT.LANGUAGE
469: from ASO_SUP_SECTION_TL SUBB,
470: ASO_SUP_SECTION_TL SUBT
471: where SUBB.SECTION_ID = SUBT.SECTION_ID
472: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
473: and ( SUBB.SECTION_NAME <> SUBT.SECTION_NAME
474: or ( SUBB.SECTION_NAME is null and SUBT.SECTION_NAME is not null )

Line 482: insert into ASO_SUP_SECTION_TL (

478: or ( SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null ) )
479:
480: );
481:
482: insert into ASO_SUP_SECTION_TL (
483: SECTION_ID,
484: LANGUAGE,
485: SOURCE_LANG,
486: SECTION_NAME,

Line 504: from ASO_SUP_SECTION_TL B,

500: B.LAST_UPDATED_BY,
501: B.CREATION_DATE,
502: B.CREATED_BY,
503: B.LAST_UPDATE_LOGIN
504: from ASO_SUP_SECTION_TL B,
505: FND_LANGUAGES L
506: where L.INSTALLED_FLAG in ('I', 'B')
507: and B.LANGUAGE = userenv('LANG')
508: and not exists

Line 510: from ASO_SUP_SECTION_TL T

506: where L.INSTALLED_FLAG in ('I', 'B')
507: and B.LANGUAGE = userenv('LANG')
508: and not exists
509: ( select NULL
510: from ASO_SUP_SECTION_TL T
511: where T.SECTION_ID = B.SECTION_ID
512: and T.LANGUAGE = L.LANGUAGE_CODE );
513:
514: end ADD_LANGUAGE;

Line 651: update ASO_SUP_SECTION_TL

647: begin
648:
649: l_user_id := fnd_load_util.owner_id(X_OWNER);
650:
651: update ASO_SUP_SECTION_TL
652: set SECTION_NAME = P_SECTION_NAME,
653: DESCRIPTION = P_DESCRIPTION,
654: source_lang = userenv('LANG'),
655: last_update_date = sysdate,

Line 703: FROM ASO_SUP_SECTION_TL

699: row_id1 VARCHAR2(32767);
700:
701: cursor get_sections is
702: SELECT SECTION_ID
703: FROM ASO_SUP_SECTION_TL
704: WHERE SECTION_ID = P_SECTION_ID;
705:
706: cursor get_mappings is
707: select template_section_map_id