APPS.ASO_SUP_RESPONSE_PKG dependencies on ASO_SUP_RESPONSE_TL

Line 118: insert into ASO_SUP_RESPONSE_TL (

114: P_ATTRIBUTE19,
115: P_ATTRIBUTE20
116: );
117:
118: insert into ASO_SUP_RESPONSE_TL (
119: RESPONSE_ID,
120: LANGUAGE,
121: SOURCE_LANG,
122: RESPONSE_NAME,

Line 144: from ASO_SUP_RESPONSE_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_RESPONSE_TL T
145: where T.RESPONSE_ID = PX_RESPONSE_ID
146: and T.LANGUAGE = L.LANGUAGE_CODE );
147:
148: open c;

Line 226: update ASO_SUP_RESPONSE_TL

222: if (sql%notfound) then
223: raise no_data_found;
224: end if;
225:
226: update ASO_SUP_RESPONSE_TL
227: set
228: RESPONSE_NAME = P_RESPONSE_NAME,
229: DESCRIPTION = P_DESCRIPTION,
230: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 254: delete from ASO_SUP_RESPONSE_TL

250: IS
251:
252: Begin
253:
254: delete from ASO_SUP_RESPONSE_TL
255: where RESPONSE_ID = P_RESPONSE_ID;
256:
257: if (sql%notfound) then
258: raise no_data_found;

Line 339: from ASO_SUP_RESPONSE_TL

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

Line 447: delete from ASO_SUP_RESPONSE_TL T

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

Line 454: update ASO_SUP_RESPONSE_TL T set (

450: from ASO_SUP_RESPONSE_B B
451: where B.RESPONSE_ID = T.RESPONSE_ID
452: );
453:
454: update ASO_SUP_RESPONSE_TL T set (
455: RESPONSE_NAME,
456: DESCRIPTION
457: ) = ( select
458: B.RESPONSE_NAME,

Line 460: from ASO_SUP_RESPONSE_TL B

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

Line 469: from ASO_SUP_RESPONSE_TL SUBB,

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

Line 470: ASO_SUP_RESPONSE_TL SUBT

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

Line 482: insert into ASO_SUP_RESPONSE_TL (

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

Line 504: from ASO_SUP_RESPONSE_TL B,

500: B.LAST_UPDATED_BY,
501: B.CREATION_DATE,
502: B.CREATED_BY,
503: B.LAST_UPDATE_LOGIN
504: from ASO_SUP_RESPONSE_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_RESPONSE_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_RESPONSE_TL T
511: where T.RESPONSE_ID = B.RESPONSE_ID
512: and T.LANGUAGE = L.LANGUAGE_CODE );
513:
514: end ADD_LANGUAGE;

Line 652: update ASO_SUP_RESPONSE_TL

648: begin
649:
650: l_user_id := fnd_load_util.owner_id(X_OWNER);
651:
652: update ASO_SUP_RESPONSE_TL
653: set RESPONSE_NAME = P_RESPONSE_NAME,
654: DESCRIPTION = P_DESCRIPTION,
655: source_lang = userenv('LANG'),
656: last_update_date = sysdate,

Line 704: FROM ASO_SUP_RESPONSE_TL

700: row_id1 VARCHAR2(32767);
701:
702: cursor get_response_id is
703: SELECT RESPONSE_ID
704: FROM ASO_SUP_RESPONSE_TL
705: WHERE RESPONSE_ID = p_RESPONSE_ID;
706:
707: cursor get_mappings is
708: select component_response_ID