APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_BEP_ACCT_OPT_NAME_B

Line 712: cursor C is select ROWID from IBY_BEP_ACCT_OPT_NAME_B

708: X_LAST_UPDATE_LOGIN in NUMBER,
709: X_SECURED_FLAG in VARCHAR2,
710: X_UNIQUE_PER_BATCH_FLAG in VARCHAR2
711: ) is
712: cursor C is select ROWID from IBY_BEP_ACCT_OPT_NAME_B
713: where BEPID = X_BEPID
714: and ACCOUNT_OPTION_CODE = X_ACCOUNT_OPTION_CODE
715: ;
716: begin

Line 717: insert into IBY_BEP_ACCT_OPT_NAME_B (

713: where BEPID = X_BEPID
714: and ACCOUNT_OPTION_CODE = X_ACCOUNT_OPTION_CODE
715: ;
716: begin
717: insert into IBY_BEP_ACCT_OPT_NAME_B (
718: BEPID,
719: ACCOUNT_OPTION_CODE,
720: ACCOUNT_OPTION_DATATYPE,
721: OBJECT_VERSION_NUMBER,

Line 802: update IBY_BEP_ACCT_OPT_NAME_B set

798: X_SECURED_FLAG in VARCHAR2,
799: X_UNIQUE_PER_BATCH_FLAG in VARCHAR2
800: ) is
801: begin
802: update IBY_BEP_ACCT_OPT_NAME_B set
803: ACCOUNT_OPTION_DATATYPE = X_ACCOUNT_OPTION_DATATYPE,
804: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
805: DISPLAY_ORDER = X_DISPLAY_ORDER,
806: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 846: delete from IBY_BEP_ACCT_OPT_NAME_B

842: if (sql%notfound) then
843: raise no_data_found;
844: end if;
845:
846: delete from IBY_BEP_ACCT_OPT_NAME_B
847: where BEPID = X_BEPID
848: and ACCOUNT_OPTION_CODE = X_ACCOUNT_OPTION_CODE;
849:
850: if (sql%notfound) then

Line 861: from IBY_BEP_ACCT_OPT_NAME_B B

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
863: and B.ACCOUNT_OPTION_CODE = T.ACCOUNT_OPTION_CODE
864: );
865: