eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_VLD_PUB dependencies on IBY_DEBIT_AUTHORIZATIONS

Line 856: CURSOR c_mandate (ci_account_use_id IN iby_debit_authorizations.external_bank_account_use_id%TYPE)

852:
853: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Validate_SEPA_Mandate';
854:
855: --13980034 - To fetch the future End dated mandates. comparison to nvl(da.debit_auth_end,sysdate) >= sysdate
856: CURSOR c_mandate (ci_account_use_id IN iby_debit_authorizations.external_bank_account_use_id%TYPE)
857: IS
858: SELECT da.authorization_reference_number
859: ,da.auth_sign_date
860: ,da.creditor_legal_entity_id

Line 863: FROM iby_debit_authorizations da

859: ,da.auth_sign_date
860: ,da.creditor_legal_entity_id
861: ,da.creditor_identifier
862: ,da.cust_addr_id
863: FROM iby_debit_authorizations da
864: WHERE debit_auth_flag = 'Y'
865: --- AND auth_cancel_date is null
866: AND nvl(da.auth_cancel_date,sysdate+10) >= sysdate
867: AND nvl(da.debit_auth_end,sysdate+10) >= sysdate

Line 869: FROM iby_debit_authorizations

865: --- AND auth_cancel_date is null
866: AND nvl(da.auth_cancel_date,sysdate+10) >= sysdate
867: AND nvl(da.debit_auth_end,sysdate+10) >= sysdate
868: AND da.debit_authorization_id = ( SELECT MAX(debit_authorization_id)
869: FROM iby_debit_authorizations
870: WHERE external_bank_account_use_id = ci_account_use_id );
871:
872: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
873: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;

Line 872: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;

868: AND da.debit_authorization_id = ( SELECT MAX(debit_authorization_id)
869: FROM iby_debit_authorizations
870: WHERE external_bank_account_use_id = ci_account_use_id );
871:
872: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
873: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
874: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
875: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
876: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;

Line 873: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;

869: FROM iby_debit_authorizations
870: WHERE external_bank_account_use_id = ci_account_use_id );
871:
872: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
873: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
874: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
875: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
876: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
877: l_payee_address VARCHAR2(4000);

Line 874: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;

870: WHERE external_bank_account_use_id = ci_account_use_id );
871:
872: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
873: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
874: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
875: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
876: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
877: l_payee_address VARCHAR2(4000);
878: l_iban iby_ext_bank_accounts.iban%TYPE;

Line 875: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;

871:
872: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
873: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
874: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
875: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
876: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
877: l_payee_address VARCHAR2(4000);
878: l_iban iby_ext_bank_accounts.iban%TYPE;
879: l_swift_code ce_bank_branches_v.eft_swift_code%TYPE;

Line 876: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;

872: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
873: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
874: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
875: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
876: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
877: l_payee_address VARCHAR2(4000);
878: l_iban iby_ext_bank_accounts.iban%TYPE;
879: l_swift_code ce_bank_branches_v.eft_swift_code%TYPE;
880:

Line 1037: ,iby_debit_authorizations da

1033: ,da.cust_addr_id
1034: ,da.creditor_le_name
1035: ,da.external_bank_account_use_id
1036: from iby_trxn_summaries_all ts
1037: ,iby_debit_authorizations da
1038: where ts.trxnmid = ci_trxnmid
1039: and ts.debit_authorization_id = da.debit_authorization_id
1040: -- and da.auth_cancel_date is NULL
1041: AND nvl(da.auth_cancel_date,sysdate+10) >= sysdate

Line 1067: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;

1063: ,'SEPA_INITIATING_PARTY_NAME' ,'SEPA_BATCH_BOOKING' );
1064:
1065: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
1066:
1067: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1068: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
1069: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
1070: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
1071: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;

Line 1068: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;

1064:
1065: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
1066:
1067: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1068: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
1069: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
1070: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
1071: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
1072:

Line 1069: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;

1065: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
1066:
1067: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1068: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
1069: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
1070: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
1071: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
1072:
1073: l_ini_party_id iby_bep_acct_opt_vals.account_option_value%TYPE;

Line 1070: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;

1066:
1067: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1068: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
1069: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
1070: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
1071: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
1072:
1073: l_ini_party_id iby_bep_acct_opt_vals.account_option_value%TYPE;
1074: l_ini_party_id_issuer iby_bep_acct_opt_vals.account_option_value%TYPE;

Line 1071: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;

1067: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1068: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
1069: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
1070: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
1071: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
1072:
1073: l_ini_party_id iby_bep_acct_opt_vals.account_option_value%TYPE;
1074: l_ini_party_id_issuer iby_bep_acct_opt_vals.account_option_value%TYPE;
1075: l_ini_party_name iby_bep_acct_opt_vals.account_option_value%TYPE;

Line 1080: l_creditor_le_name iby_debit_authorizations.creditor_le_name%TYPE;

1076: l_batch_booking_flag iby_bep_acct_opt_vals.account_option_value%TYPE;
1077:
1078: l_account_option_code iby_bep_acct_opt_vals.account_option_code%TYPE;
1079: l_account_option_value iby_bep_acct_opt_vals.account_option_value%TYPE;
1080: l_creditor_le_name iby_debit_authorizations.creditor_le_name%TYPE;
1081: l_payee_address VARCHAR2(4000);
1082: l_le_name VARCHAR2(4000);
1083: l_external_bank_account_use_id iby_debit_authorizations.external_bank_account_use_id%TYPE;
1084: l_iban iby_ext_bank_accounts.iban%TYPE;

Line 1083: l_external_bank_account_use_id iby_debit_authorizations.external_bank_account_use_id%TYPE;

1079: l_account_option_value iby_bep_acct_opt_vals.account_option_value%TYPE;
1080: l_creditor_le_name iby_debit_authorizations.creditor_le_name%TYPE;
1081: l_payee_address VARCHAR2(4000);
1082: l_le_name VARCHAR2(4000);
1083: l_external_bank_account_use_id iby_debit_authorizations.external_bank_account_use_id%TYPE;
1084: l_iban iby_ext_bank_accounts.iban%TYPE;
1085: l_swift_code ce_bank_branches_v.eft_swift_code%TYPE;
1086:
1087:

Line 1372: update iby_debit_authorizations

1368: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1369: print_debuginfo(G_DEBUG_MODULE, 'Inactivating the One-Off and Final Mandates. ');
1370: END IF;
1371:
1372: update iby_debit_authorizations
1373: set debit_auth_flag = 'N' , debit_auth_end = sysdate
1374: where debit_authorization_id in
1375: ( select debit_authorization_id
1376: from iby_trxn_summaries_all

Line 1421: iby_debit_authorizations da

1417: CURSOR c_mandate(ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE)
1418: IS
1419: SELECT da.authorization_reference_number
1420: FROM iby_trxn_summaries_all ts ,
1421: iby_debit_authorizations da
1422: WHERE ts.trxnmid = ci_trxnmid
1423: AND ts.debit_authorization_id = da.debit_authorization_id
1424: AND NVL(da.auth_cancel_date,sysdate) >= ts.settledate
1425: AND NVL(da.debit_auth_end,sysdate) >= ts.settledate

Line 1429: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;

1425: AND NVL(da.debit_auth_end,sysdate) >= ts.settledate
1426: AND NVL(da.auth_sign_date,sysdate) <= ts.settledate
1427: AND da.curr_rec_indi = 'Y' ;
1428: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
1429: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1430: BEGIN
1431: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1432: print_debuginfo(G_DEBUG_MODULE, 'Entered ... ');
1433: END IF;