APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_SYS_EFT_PF_B

Line 1353: cursor C is select ROWID from IBY_FNDCPT_SYS_EFT_PF_B

1349: X_OVERRIDE_PAYER_DELIVERY_FLAG IN VARCHAR2,
1350: X_ACCOMPANY_LETTER_FORMAT IN VARCHAR2,
1351: X_AUTOMATIC_PN_SUBMIT_FLAG IN VARCHAR2
1352: ) is
1353: cursor C is select ROWID from IBY_FNDCPT_SYS_EFT_PF_B
1354: where SYS_EFT_PROFILE_CODE = X_SYS_EFT_PROFILE_CODE
1355: ;
1356: begin
1357: insert into IBY_FNDCPT_SYS_EFT_PF_B (

Line 1357: insert into IBY_FNDCPT_SYS_EFT_PF_B (

1353: cursor C is select ROWID from IBY_FNDCPT_SYS_EFT_PF_B
1354: where SYS_EFT_PROFILE_CODE = X_SYS_EFT_PROFILE_CODE
1355: ;
1356: begin
1357: insert into IBY_FNDCPT_SYS_EFT_PF_B (
1358: SETTLE_REQUIRE_VRFY_FLAG,
1359: SYS_EFT_PROFILE_CODE,
1360: PAYMENT_SYSTEM_ID,
1361: VERIFY_FORMAT_CODE,

Line 1505: update IBY_FNDCPT_SYS_EFT_PF_B set

1501: X_ACCOMPANY_LETTER_FORMAT IN VARCHAR2,
1502: X_AUTOMATIC_PN_SUBMIT_FLAG IN VARCHAR2
1503: ) is
1504: begin
1505: update IBY_FNDCPT_SYS_EFT_PF_B set
1506: SETTLE_REQUIRE_VRFY_FLAG = X_SETTLE_REQUIRE_VRFY_FLAG,
1507: PAYMENT_SYSTEM_ID = X_PAYMENT_SYSTEM_ID,
1508: VERIFY_FORMAT_CODE = X_VERIFY_FORMAT_CODE,
1509: VERIFY_TRANS_PRTCL_CODE = X_VERIFY_TRANS_PRTCL_CODE,

Line 1568: delete from IBY_FNDCPT_SYS_EFT_PF_B

1564: if (sql%notfound) then
1565: raise no_data_found;
1566: end if;
1567:
1568: delete from IBY_FNDCPT_SYS_EFT_PF_B
1569: where SYS_EFT_PROFILE_CODE = X_SYS_EFT_PROFILE_CODE;
1570:
1571: if (sql%notfound) then
1572: raise no_data_found;

Line 1582: from IBY_FNDCPT_SYS_EFT_PF_B B

1578: begin
1579: delete from IBY_FNDCPT_SYS_EFT_PF_TL T
1580: where not exists
1581: (select NULL
1582: from IBY_FNDCPT_SYS_EFT_PF_B B
1583: where B.SYS_EFT_PROFILE_CODE = T.SYS_EFT_PROFILE_CODE
1584: );
1585:
1586: update IBY_FNDCPT_SYS_EFT_PF_TL T set (