APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_USER_EFT_PF_B

Line 2337: cursor C is select ROWID from IBY_FNDCPT_USER_EFT_PF_B

2333: X_LAST_UPDATE_DATE in DATE,
2334: X_LAST_UPDATED_BY in NUMBER,
2335: X_LAST_UPDATE_LOGIN in NUMBER
2336: ) is
2337: cursor C is select ROWID from IBY_FNDCPT_USER_EFT_PF_B
2338: where USER_EFT_PROFILE_CODE = X_USER_EFT_PROFILE_CODE
2339: ;
2340: begin
2341: insert into IBY_FNDCPT_USER_EFT_PF_B (

Line 2341: insert into IBY_FNDCPT_USER_EFT_PF_B (

2337: cursor C is select ROWID from IBY_FNDCPT_USER_EFT_PF_B
2338: where USER_EFT_PROFILE_CODE = X_USER_EFT_PROFILE_CODE
2339: ;
2340: begin
2341: insert into IBY_FNDCPT_USER_EFT_PF_B (
2342: OBJECT_VERSION_NUMBER,
2343: BEP_ACCOUNT_ID,
2344: VERIFY_TRANS_CONFIG_ID,
2345: USER_EFT_PROFILE_CODE,

Line 2426: update IBY_FNDCPT_USER_EFT_PF_B set

2422: X_LAST_UPDATED_BY in NUMBER,
2423: X_LAST_UPDATE_LOGIN in NUMBER
2424: ) is
2425: begin
2426: update IBY_FNDCPT_USER_EFT_PF_B set
2427: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
2428: BEP_ACCOUNT_ID = X_BEP_ACCOUNT_ID,
2429: VERIFY_TRANS_CONFIG_ID = X_VERIFY_TRANS_CONFIG_ID,
2430: SYS_EFT_PROFILE_CODE = X_SYS_EFT_PROFILE_CODE,

Line 2468: delete from IBY_FNDCPT_USER_EFT_PF_B

2464: if (sql%notfound) then
2465: raise no_data_found;
2466: end if;
2467:
2468: delete from IBY_FNDCPT_USER_EFT_PF_B
2469: where USER_EFT_PROFILE_CODE = X_USER_EFT_PROFILE_CODE;
2470:
2471: if (sql%notfound) then
2472: raise no_data_found;

Line 2482: from IBY_FNDCPT_USER_EFT_PF_B B

2478: begin
2479: delete from IBY_FNDCPT_USER_EFT_PF_TL T
2480: where not exists
2481: (select NULL
2482: from IBY_FNDCPT_USER_EFT_PF_B B
2483: where B.USER_EFT_PROFILE_CODE = T.USER_EFT_PROFILE_CODE
2484: );
2485:
2486: update IBY_FNDCPT_USER_EFT_PF_TL T set (