APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_BEP_ACCT_OPT_NAME_TL

Line 745: insert into IBY_BEP_ACCT_OPT_NAME_TL (

741: X_SECURED_FLAG,
742: X_UNIQUE_PER_BATCH_FLAG
743: );
744:
745: insert into IBY_BEP_ACCT_OPT_NAME_TL (
746: ACCOUNT_OPTION_NAME,
747: CREATED_BY,
748: CREATION_DATE,
749: LAST_UPDATED_BY,

Line 773: from IBY_BEP_ACCT_OPT_NAME_TL T

769: from FND_LANGUAGES L
770: where L.INSTALLED_FLAG in ('I', 'B')
771: and not exists
772: (select NULL
773: from IBY_BEP_ACCT_OPT_NAME_TL T
774: where T.BEPID = X_BEPID
775: and T.ACCOUNT_OPTION_CODE = X_ACCOUNT_OPTION_CODE
776: and T.LANGUAGE = L.LANGUAGE_CODE);
777:

Line 818: update IBY_BEP_ACCT_OPT_NAME_TL set

814: if (sql%notfound) then
815: raise no_data_found;
816: end if;
817:
818: update IBY_BEP_ACCT_OPT_NAME_TL set
819: ACCOUNT_OPTION_NAME = X_ACCOUNT_OPTION_NAME,
820: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
821: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
822: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 838: delete from IBY_BEP_ACCT_OPT_NAME_TL

834: X_BEPID in NUMBER,
835: X_ACCOUNT_OPTION_CODE in VARCHAR2
836: ) is
837: begin
838: delete from IBY_BEP_ACCT_OPT_NAME_TL
839: where BEPID = X_BEPID
840: and ACCOUNT_OPTION_CODE = X_ACCOUNT_OPTION_CODE;
841:
842: if (sql%notfound) then

Line 858: delete from IBY_BEP_ACCT_OPT_NAME_TL T

854:
855: procedure BEP_OPT_ADD_LANGUAGE
856: is
857: begin
858: delete from IBY_BEP_ACCT_OPT_NAME_TL T
859: where not exists
860: (select NULL
861: from IBY_BEP_ACCT_OPT_NAME_B B
862: where B.BEPID = T.BEPID

Line 866: update IBY_BEP_ACCT_OPT_NAME_TL T set (

862: where B.BEPID = T.BEPID
863: and B.ACCOUNT_OPTION_CODE = T.ACCOUNT_OPTION_CODE
864: );
865:
866: update IBY_BEP_ACCT_OPT_NAME_TL T set (
867: ACCOUNT_OPTION_NAME
868: ) = (select
869: B.ACCOUNT_OPTION_NAME
870: from IBY_BEP_ACCT_OPT_NAME_TL B

Line 870: from IBY_BEP_ACCT_OPT_NAME_TL B

866: update IBY_BEP_ACCT_OPT_NAME_TL T set (
867: ACCOUNT_OPTION_NAME
868: ) = (select
869: B.ACCOUNT_OPTION_NAME
870: from IBY_BEP_ACCT_OPT_NAME_TL B
871: where B.BEPID = T.BEPID
872: and B.ACCOUNT_OPTION_CODE = T.ACCOUNT_OPTION_CODE
873: and B.LANGUAGE = T.SOURCE_LANG)
874: where (

Line 882: from IBY_BEP_ACCT_OPT_NAME_TL SUBB, IBY_BEP_ACCT_OPT_NAME_TL SUBT

878: ) in (select
879: SUBT.BEPID,
880: SUBT.ACCOUNT_OPTION_CODE,
881: SUBT.LANGUAGE
882: from IBY_BEP_ACCT_OPT_NAME_TL SUBB, IBY_BEP_ACCT_OPT_NAME_TL SUBT
883: where SUBB.BEPID = SUBT.BEPID
884: and SUBB.ACCOUNT_OPTION_CODE = SUBT.ACCOUNT_OPTION_CODE
885: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
886: and (SUBB.ACCOUNT_OPTION_NAME <> SUBT.ACCOUNT_OPTION_NAME

Line 889: insert into IBY_BEP_ACCT_OPT_NAME_TL (

885: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
886: and (SUBB.ACCOUNT_OPTION_NAME <> SUBT.ACCOUNT_OPTION_NAME
887: ));
888:
889: insert into IBY_BEP_ACCT_OPT_NAME_TL (
890: ACCOUNT_OPTION_NAME,
891: CREATED_BY,
892: CREATION_DATE,
893: LAST_UPDATED_BY,

Line 913: from IBY_BEP_ACCT_OPT_NAME_TL B, FND_LANGUAGES L

909: B.BEPID,
910: B.ACCOUNT_OPTION_CODE,
911: L.LANGUAGE_CODE,
912: B.SOURCE_LANG
913: from IBY_BEP_ACCT_OPT_NAME_TL B, FND_LANGUAGES L
914: where L.INSTALLED_FLAG in ('I', 'B')
915: and B.LANGUAGE = userenv('LANG')
916: and not exists
917: (select NULL

Line 918: from IBY_BEP_ACCT_OPT_NAME_TL T

914: where L.INSTALLED_FLAG in ('I', 'B')
915: and B.LANGUAGE = userenv('LANG')
916: and not exists
917: (select NULL
918: from IBY_BEP_ACCT_OPT_NAME_TL T
919: where T.BEPID = B.BEPID
920: and T.ACCOUNT_OPTION_CODE = B.ACCOUNT_OPTION_CODE
921: and T.LANGUAGE = L.LANGUAGE_CODE);
922: end BEP_OPT_ADD_LANGUAGE;

Line 977: update iby_bep_acct_opt_name_tl set

973: X_ACCOUNT_OPTION_NAME in VARCHAR2,
974: X_OWNER in VARCHAR2)
975: is
976: begin
977: update iby_bep_acct_opt_name_tl set
978: ACCOUNT_OPTION_NAME = X_ACCOUNT_OPTION_NAME,
979: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
980: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
981: LAST_UPDATE_DATE = trunc(sysdate),