[Home] [Help]
798:
799: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
800: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
801: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
802: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
803: l_msg_count number;
804: l_step number;
805:
806: cursor l_party_id_cur is
988: from IBY_TEMP_EXT_BANK_ACCTS temp
989: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id;
990:
991: l_temp_account_rec l_temp_account_cur%ROWTYPE;
992: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
993: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
994: l_payee_rec IBY_DISBURSEMENT_SETUP_PUB.PayeeContext_Rec_Type;
995: l_pay_instr_rec IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
996: l_pay_assign_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1225:
1226: l_msg_count number;
1227: l_step number;
1228:
1229: l_record_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1230: l_end_date DATE;
1231: l_start_date DATE;
1232: l_count NUMBER;
1233: l_msg_data varchar(2000);
1255:
1256: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
1257: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1258: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
1259: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1260: l_primary_owner_id HZ_PARTIES.party_id%TYPE;
1261: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;
1262: l_joint_acct_owner_id NUMBER;
1263:
1763: l_step number;
1764: l_bank_id HZ_PARTIES.party_id%TYPE;
1765: l_branch_id HZ_PARTIES.party_id%TYPE;
1766: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;
1767: l_record_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1768: l_end_date DATE;
1769: l_start_date DATE;
1770: l_msg_count NUMBER;
1771: l_count NUMBER;