APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FORMATS_TL

Line 387: insert into IBY_FORMATS_TL (

383: X_LAST_UPDATED_BY,
384: X_LAST_UPDATE_LOGIN
385: );
386:
387: insert into IBY_FORMATS_TL (
388: CREATION_DATE,
389: LAST_UPDATED_BY,
390: LAST_UPDATE_DATE,
391: LAST_UPDATE_LOGIN,

Line 413: from IBY_FORMATS_TL T

409: from FND_LANGUAGES L
410: where L.INSTALLED_FLAG in ('I', 'B')
411: and not exists
412: (select NULL
413: from IBY_FORMATS_TL T
414: where T.FORMAT_CODE = X_FORMAT_CODE
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416:
417: open c;

Line 489: update IBY_FORMATS_TL set

485: if (sql%notfound) then
486: raise no_data_found;
487: end if;
488:
489: update IBY_FORMATS_TL set
490: FORMAT_NAME = X_FORMAT_NAME,
491: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
492: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
493: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 507: delete from IBY_FORMATS_TL

503: procedure FORMAT_DELETE_ROW (
504: X_FORMAT_CODE in VARCHAR2
505: ) is
506: begin
507: delete from IBY_FORMATS_TL
508: where FORMAT_CODE = X_FORMAT_CODE;
509:
510: if (sql%notfound) then
511: raise no_data_found;

Line 525: delete from IBY_FORMATS_TL T

521:
522: procedure FORMAT_ADD_LANGUAGE
523: is
524: begin
525: delete from IBY_FORMATS_TL T
526: where not exists
527: (select NULL
528: from IBY_FORMATS_B B
529: where B.FORMAT_CODE = T.FORMAT_CODE

Line 532: update IBY_FORMATS_TL T set (

528: from IBY_FORMATS_B B
529: where B.FORMAT_CODE = T.FORMAT_CODE
530: );
531:
532: update IBY_FORMATS_TL T set (
533: FORMAT_NAME
534: ) = (select
535: B.FORMAT_NAME
536: from IBY_FORMATS_TL B

Line 536: from IBY_FORMATS_TL B

532: update IBY_FORMATS_TL T set (
533: FORMAT_NAME
534: ) = (select
535: B.FORMAT_NAME
536: from IBY_FORMATS_TL B
537: where B.FORMAT_CODE = T.FORMAT_CODE
538: and B.LANGUAGE = T.SOURCE_LANG)
539: where (
540: T.FORMAT_CODE,

Line 545: from IBY_FORMATS_TL SUBB, IBY_FORMATS_TL SUBT

541: T.LANGUAGE
542: ) in (select
543: SUBT.FORMAT_CODE,
544: SUBT.LANGUAGE
545: from IBY_FORMATS_TL SUBB, IBY_FORMATS_TL SUBT
546: where SUBB.FORMAT_CODE = SUBT.FORMAT_CODE
547: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
548: and (SUBB.FORMAT_NAME <> SUBT.FORMAT_NAME
549: ));

Line 551: insert into IBY_FORMATS_TL (

547: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
548: and (SUBB.FORMAT_NAME <> SUBT.FORMAT_NAME
549: ));
550:
551: insert into IBY_FORMATS_TL (
552: CREATION_DATE,
553: LAST_UPDATED_BY,
554: LAST_UPDATE_DATE,
555: LAST_UPDATE_LOGIN,

Line 573: from IBY_FORMATS_TL B, FND_LANGUAGES L

569: B.CREATED_BY,
570: B.FORMAT_CODE,
571: L.LANGUAGE_CODE,
572: B.SOURCE_LANG
573: from IBY_FORMATS_TL B, FND_LANGUAGES L
574: where L.INSTALLED_FLAG in ('I', 'B')
575: and B.LANGUAGE = userenv('LANG')
576: and not exists
577: (select NULL

Line 578: from IBY_FORMATS_TL T

574: where L.INSTALLED_FLAG in ('I', 'B')
575: and B.LANGUAGE = userenv('LANG')
576: and not exists
577: (select NULL
578: from IBY_FORMATS_TL T
579: where T.FORMAT_CODE = B.FORMAT_CODE
580: and T.LANGUAGE = L.LANGUAGE_CODE);
581: end FORMAT_ADD_LANGUAGE;
582:

Line 684: update iby_formats_tl set

680: X_LAST_UPDATE_DATE in DATE,
681: X_OWNER in VARCHAR2)
682: is
683: begin
684: update iby_formats_tl set
685: FORMAT_NAME = X_FORMAT_NAME,
686: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
687: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
688: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,