APPS.IBY_SYS_PMT_PROFILES_PKG dependencies on IBY_SYS_PMT_PROFILES_TL

Line 190: insert into IBY_SYS_PMT_PROFILES_TL (

186: X_LAST_UPDATED_BY,
187: X_LAST_UPDATE_LOGIN
188: );
189:
190: insert into IBY_SYS_PMT_PROFILES_TL (
191: LAST_UPDATE_DATE,
192: LAST_UPDATE_LOGIN,
193: OBJECT_VERSION_NUMBER,
194: SYSTEM_PROFILE_DESCRIPTION,

Line 218: from IBY_SYS_PMT_PROFILES_TL T

214: from FND_LANGUAGES L
215: where L.INSTALLED_FLAG in ('I', 'B')
216: and not exists
217: (select NULL
218: from IBY_SYS_PMT_PROFILES_TL T
219: where T.SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
220: and T.LANGUAGE = L.LANGUAGE_CODE);
221:
222: open c;

Line 351: from IBY_SYS_PMT_PROFILES_TL

347: cursor c1 is select
348: SYSTEM_PROFILE_NAME,
349: SYSTEM_PROFILE_DESCRIPTION,
350: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
351: from IBY_SYS_PMT_PROFILES_TL
352: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
353: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
354: for update of SYSTEM_PROFILE_CODE nowait;
355: begin

Line 604: update IBY_SYS_PMT_PROFILES_TL set

600: if (sql%notfound) then
601: raise no_data_found;
602: end if;
603:
604: update IBY_SYS_PMT_PROFILES_TL set
605: SYSTEM_PROFILE_NAME = X_SYSTEM_PROFILE_NAME,
606: SYSTEM_PROFILE_DESCRIPTION = X_SYSTEM_PROFILE_DESCRIPTION,
607: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
608: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 623: delete from IBY_SYS_PMT_PROFILES_TL

619: procedure DELETE_ROW (
620: X_SYSTEM_PROFILE_CODE in VARCHAR2
621: ) is
622: begin
623: delete from IBY_SYS_PMT_PROFILES_TL
624: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE;
625:
626: if (sql%notfound) then
627: raise no_data_found;

Line 641: delete from IBY_SYS_PMT_PROFILES_TL T

637:
638: procedure ADD_LANGUAGE
639: is
640: begin
641: delete from IBY_SYS_PMT_PROFILES_TL T
642: where not exists
643: (select NULL
644: from IBY_SYS_PMT_PROFILES_B B
645: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE

Line 648: update IBY_SYS_PMT_PROFILES_TL T set (

644: from IBY_SYS_PMT_PROFILES_B B
645: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
646: );
647:
648: update IBY_SYS_PMT_PROFILES_TL T set (
649: SYSTEM_PROFILE_NAME,
650: SYSTEM_PROFILE_DESCRIPTION
651: ) = (select
652: B.SYSTEM_PROFILE_NAME,

Line 654: from IBY_SYS_PMT_PROFILES_TL B

650: SYSTEM_PROFILE_DESCRIPTION
651: ) = (select
652: B.SYSTEM_PROFILE_NAME,
653: B.SYSTEM_PROFILE_DESCRIPTION
654: from IBY_SYS_PMT_PROFILES_TL B
655: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
656: and B.LANGUAGE = T.SOURCE_LANG)
657: where (
658: T.SYSTEM_PROFILE_CODE,

Line 663: from IBY_SYS_PMT_PROFILES_TL SUBB, IBY_SYS_PMT_PROFILES_TL SUBT

659: T.LANGUAGE
660: ) in (select
661: SUBT.SYSTEM_PROFILE_CODE,
662: SUBT.LANGUAGE
663: from IBY_SYS_PMT_PROFILES_TL SUBB, IBY_SYS_PMT_PROFILES_TL SUBT
664: where SUBB.SYSTEM_PROFILE_CODE = SUBT.SYSTEM_PROFILE_CODE
665: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
666: and (SUBB.SYSTEM_PROFILE_NAME <> SUBT.SYSTEM_PROFILE_NAME
667: or SUBB.SYSTEM_PROFILE_DESCRIPTION <> SUBT.SYSTEM_PROFILE_DESCRIPTION

Line 672: insert into IBY_SYS_PMT_PROFILES_TL (

668: or (SUBB.SYSTEM_PROFILE_DESCRIPTION is null and SUBT.SYSTEM_PROFILE_DESCRIPTION is not null)
669: or (SUBB.SYSTEM_PROFILE_DESCRIPTION is not null and SUBT.SYSTEM_PROFILE_DESCRIPTION is null)
670: ));
671:
672: insert into IBY_SYS_PMT_PROFILES_TL (
673: LAST_UPDATE_DATE,
674: LAST_UPDATE_LOGIN,
675: OBJECT_VERSION_NUMBER,
676: SYSTEM_PROFILE_DESCRIPTION,

Line 696: from IBY_SYS_PMT_PROFILES_TL B, FND_LANGUAGES L

692: B.SYSTEM_PROFILE_CODE,
693: B.SYSTEM_PROFILE_NAME,
694: L.LANGUAGE_CODE,
695: B.SOURCE_LANG
696: from IBY_SYS_PMT_PROFILES_TL B, FND_LANGUAGES L
697: where L.INSTALLED_FLAG in ('I', 'B')
698: and B.LANGUAGE = userenv('LANG')
699: and not exists
700: (select NULL

Line 701: from IBY_SYS_PMT_PROFILES_TL T

697: where L.INSTALLED_FLAG in ('I', 'B')
698: and B.LANGUAGE = userenv('LANG')
699: and not exists
700: (select NULL
701: from IBY_SYS_PMT_PROFILES_TL T
702: where T.SYSTEM_PROFILE_CODE = B.SYSTEM_PROFILE_CODE
703: and T.LANGUAGE = L.LANGUAGE_CODE);
704: end ADD_LANGUAGE;
705: