APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_VALIDATION_PARAMS_TL

Line 316: insert into IBY_VALIDATION_PARAMS_TL (

312: X_LAST_UPDATED_BY,
313: X_LAST_UPDATE_LOGIN
314: );
315:
316: insert into IBY_VALIDATION_PARAMS_TL (
317: VALIDATION_SET_CODE,
318: VALIDATION_PARAMETER_CODE,
319: VALIDATION_PARAM_DISPLAY_NAME,
320: CREATED_BY,

Line 344: from IBY_VALIDATION_PARAMS_TL T

340: from FND_LANGUAGES L
341: where L.INSTALLED_FLAG in ('I', 'B')
342: and not exists
343: (select NULL
344: from IBY_VALIDATION_PARAMS_TL T
345: where T.VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
346: and T.VALIDATION_PARAMETER_CODE = X_VALIDATION_PARAMETER_CODE
347: and T.LANGUAGE = L.LANGUAGE_CODE);
348:

Line 385: update IBY_VALIDATION_PARAMS_TL set

381: if (sql%notfound) then
382: raise no_data_found;
383: end if;
384:
385: update IBY_VALIDATION_PARAMS_TL set
386: VALIDATION_PARAM_DISPLAY_NAME = X_VALIDATION_PARAM_DISPLAY_NAM,
387: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
388: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
389: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 405: delete from IBY_VALIDATION_PARAMS_TL

401: X_VALIDATION_SET_CODE in VARCHAR2,
402: X_VALIDATION_PARAMETER_CODE in VARCHAR2
403: ) is
404: begin
405: delete from IBY_VALIDATION_PARAMS_TL
406: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
407: and VALIDATION_PARAMETER_CODE = X_VALIDATION_PARAMETER_CODE;
408:
409: if (sql%notfound) then

Line 425: delete from IBY_VALIDATION_PARAMS_TL T

421:
422: procedure VAL_PARAM_ADD_LANGUAGE
423: is
424: begin
425: delete from IBY_VALIDATION_PARAMS_TL T
426: where not exists
427: (select NULL
428: from IBY_VALIDATION_PARAMS_B B
429: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE

Line 433: update IBY_VALIDATION_PARAMS_TL T set (

429: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE
430: and B.VALIDATION_PARAMETER_CODE = T.VALIDATION_PARAMETER_CODE
431: );
432:
433: update IBY_VALIDATION_PARAMS_TL T set (
434: VALIDATION_PARAM_DISPLAY_NAME
435: ) = (select
436: B.VALIDATION_PARAM_DISPLAY_NAME
437: from IBY_VALIDATION_PARAMS_TL B

Line 437: from IBY_VALIDATION_PARAMS_TL B

433: update IBY_VALIDATION_PARAMS_TL T set (
434: VALIDATION_PARAM_DISPLAY_NAME
435: ) = (select
436: B.VALIDATION_PARAM_DISPLAY_NAME
437: from IBY_VALIDATION_PARAMS_TL B
438: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE
439: and B.VALIDATION_PARAMETER_CODE = T.VALIDATION_PARAMETER_CODE
440: and B.LANGUAGE = T.SOURCE_LANG)
441: where (

Line 449: from IBY_VALIDATION_PARAMS_TL SUBB, IBY_VALIDATION_PARAMS_TL SUBT

445: ) in (select
446: SUBT.VALIDATION_SET_CODE,
447: SUBT.VALIDATION_PARAMETER_CODE,
448: SUBT.LANGUAGE
449: from IBY_VALIDATION_PARAMS_TL SUBB, IBY_VALIDATION_PARAMS_TL SUBT
450: where SUBB.VALIDATION_SET_CODE = SUBT.VALIDATION_SET_CODE
451: and SUBB.VALIDATION_PARAMETER_CODE = SUBT.VALIDATION_PARAMETER_CODE
452: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
453: and (SUBB.VALIDATION_PARAM_DISPLAY_NAME <> SUBT.VALIDATION_PARAM_DISPLAY_NAME

Line 456: insert into IBY_VALIDATION_PARAMS_TL (

452: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
453: and (SUBB.VALIDATION_PARAM_DISPLAY_NAME <> SUBT.VALIDATION_PARAM_DISPLAY_NAME
454: ));
455:
456: insert into IBY_VALIDATION_PARAMS_TL (
457: VALIDATION_SET_CODE,
458: VALIDATION_PARAMETER_CODE,
459: VALIDATION_PARAM_DISPLAY_NAME,
460: CREATED_BY,

Line 480: from IBY_VALIDATION_PARAMS_TL B, FND_LANGUAGES L

476: B.LAST_UPDATE_LOGIN,
477: B.OBJECT_VERSION_NUMBER,
478: L.LANGUAGE_CODE,
479: B.SOURCE_LANG
480: from IBY_VALIDATION_PARAMS_TL B, FND_LANGUAGES L
481: where L.INSTALLED_FLAG in ('I', 'B')
482: and B.LANGUAGE = userenv('LANG')
483: and not exists
484: (select NULL

Line 485: from IBY_VALIDATION_PARAMS_TL T

481: where L.INSTALLED_FLAG in ('I', 'B')
482: and B.LANGUAGE = userenv('LANG')
483: and not exists
484: (select NULL
485: from IBY_VALIDATION_PARAMS_TL T
486: where T.VALIDATION_SET_CODE = B.VALIDATION_SET_CODE
487: and T.VALIDATION_PARAMETER_CODE = B.VALIDATION_PARAMETER_CODE
488: and T.LANGUAGE = L.LANGUAGE_CODE);
489: end VAL_PARAM_ADD_LANGUAGE;

Line 539: update iby_validation_params_tl set

535: X_LAST_UPDATE_DATE in DATE,
536: X_OWNER in VARCHAR2)
537: is
538: begin
539: update iby_validation_params_tl set
540: VALIDATION_PARAM_DISPLAY_NAME = X_VALIDATION_PARAM_DISPLAY_NAM,
541: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
542: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
543: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,