APPS.ITA_SETUP_REC_VALUES_PKG dependencies on ITA_SETUP_REC_VALUES_TL

Line 189: insert into ITA_SETUP_REC_VALUES_TL (

185: );
186:
187: custom_debug('In to the INSERT_ROW callin insert in TL X_REC_VALUE_ID :: ' || X_REC_VALUE_ID);
188:
189: insert into ITA_SETUP_REC_VALUES_TL (
190: REC_VALUE_ID,
191: PARAMETER_CODE,
192: CONTEXT_ORG_NAME,
193: RECOMMENDED_VALUE,

Line 221: from ITA_SETUP_REC_VALUES_TL tl

217: from FND_LANGUAGES L
218: where L.INSTALLED_FLAG in ('I', 'B')
219: and not exists (
220: select null
221: from ITA_SETUP_REC_VALUES_TL tl
222: where
223: (tl.REC_VALUE_ID = X_REC_VALUE_ID or
224: (PARAMETER_CODE = X_PARAMETER_CODE and CONTEXT_ORG_NAME = X_CONTEXT_ORG_NAME)) and
225: tl.LANGUAGE = L.LANGUAGE_CODE);

Line 269: update ITA_SETUP_REC_VALUES_TL set

265: if (sql%notfound) then
266: raise no_data_found;
267: end if;
268:
269: update ITA_SETUP_REC_VALUES_TL set
270: REC_VALUE_ID = X_REC_VALUE_ID,
271: PARAMETER_CODE = X_PARAMETER_CODE,
272: CONTEXT_ORG_NAME = X_CONTEXT_ORG_NAME,
273: RECOMMENDED_VALUE = X_RECOMMENDED_VALUE,

Line 431: delete from ITA_SETUP_REC_VALUES_TL tl

427:
428: procedure ADD_LANGUAGE
429: is
430: begin
431: delete from ITA_SETUP_REC_VALUES_TL tl
432: where not exists (
433: select null
434: from ITA_SETUP_REC_VALUES_B b
435: where

Line 440: update ITA_SETUP_REC_VALUES_TL tl set (

436: b.PARAMETER_CODE = tl.PARAMETER_CODE and
437: b.CONTEXT_ORG_NAME = tl.CONTEXT_ORG_NAME
438: );
439:
440: update ITA_SETUP_REC_VALUES_TL tl set (
441: RECOMMENDED_VALUE
442: ) = (select
443: b.RECOMMENDED_VALUE
444: from ITA_SETUP_REC_VALUES_TL b

Line 444: from ITA_SETUP_REC_VALUES_TL b

440: update ITA_SETUP_REC_VALUES_TL tl set (
441: RECOMMENDED_VALUE
442: ) = (select
443: b.RECOMMENDED_VALUE
444: from ITA_SETUP_REC_VALUES_TL b
445: where
446: b.PARAMETER_CODE = tl.PARAMETER_CODE and
447: b.CONTEXT_ORG_NAME = tl.CONTEXT_ORG_NAME and
448: b.LANGUAGE = tl.SOURCE_LANG)

Line 457: from ITA_SETUP_REC_VALUES_TL subb, ITA_SETUP_REC_VALUES_TL subtl

453: ) in (select
454: subtl.PARAMETER_CODE,
455: subtl.CONTEXT_ORG_NAME,
456: subtl.LANGUAGE
457: from ITA_SETUP_REC_VALUES_TL subb, ITA_SETUP_REC_VALUES_TL subtl
458: where
459: subb.PARAMETER_CODE = subtl.PARAMETER_CODE and
460: subb.CONTEXT_ORG_NAME = subtl.CONTEXT_ORG_NAME and
461: subb.LANGUAGE = subtl.SOURCE_LANG and

Line 466: insert into ITA_SETUP_REC_VALUES_TL (

462: (subb.RECOMMENDED_VALUE <> subtl.RECOMMENDED_VALUE or
463: (subb.RECOMMENDED_VALUE is null and subtl.RECOMMENDED_VALUE is not null) or
464: (subb.RECOMMENDED_VALUE is not null and subtl.RECOMMENDED_VALUE is null)));
465:
466: insert into ITA_SETUP_REC_VALUES_TL (
467: PARAMETER_CODE,
468: CONTEXT_ORG_ID,
469: CONTEXT_ORG_NAME,
470: RECOMMENDED_VALUE,

Line 504: from ITA_SETUP_REC_VALUES_TL b, FND_LANGUAGES L

500: b.REQUEST_ID,
501: b.PROGRAM_APPLICATION_ID,
502: b.PROGRAM_ID,
503: b.PROGRAM_UPDATE_DATE
504: from ITA_SETUP_REC_VALUES_TL b, FND_LANGUAGES L
505: where
506: L.INSTALLED_FLAG in ('I', 'B') and
507: b.LANGUAGE = userenv('LANG') and
508: not exists (

Line 510: from ITA_SETUP_REC_VALUES_TL tl

506: L.INSTALLED_FLAG in ('I', 'B') and
507: b.LANGUAGE = userenv('LANG') and
508: not exists (
509: select null
510: from ITA_SETUP_REC_VALUES_TL tl
511: where
512: tl.PARAMETER_CODE = b.PARAMETER_CODE and
513: tl.CONTEXT_ORG_NAME = b.CONTEXT_ORG_NAME and
514: tl.LANGUAGE = L.LANGUAGE_CODE);