[Home] [Help]
1247: temp.bank_account_name_alt, temp.bank_account_type,
1248: temp.description, temp.end_date, temp.start_date, temp.agency_location_code,
1249: temp.status, temp.note, temp.note_alt, temp.account_suffix, temp.exchange_rate,
1250: temp.exchange_rate_agreement_num, temp.exchange_rate_agreement_type, temp.payment_factor_flag
1251: from IBY_TEMP_EXT_BANK_ACCTS temp, pos_acnt_gen_req req
1252: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id
1253: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1254: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1255:
1263:
1264: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1265: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1266: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1267: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1268: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1269: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1270: l_bank_party_site_id number;
1271: l_bank_party_site_number varchar2(2000);
1710: object_version_number = object_version_number + 1
1711: where account_request_id = p_account_request_id;
1712:
1713: l_step := 2;
1714: update pos_acnt_gen_req
1715: set ext_bank_account_id = p_ext_bank_account_id,
1716: last_update_date = sysdate,
1717: last_updated_by = fnd_global.user_id,
1718: last_update_login = fnd_global.login_id,
1771: l_count NUMBER;
1772: l_msg_data varchar(2000);
1773:
1774: cursor dup_temp_act_cur is
1775: select count(*) from iby_temp_ext_bank_accts iby, pos_acnt_gen_req pos
1776: where pos.mapping_id = p_mapping_id
1777: and pos.temp_ext_bank_acct_id = iby.temp_ext_bank_acct_id
1778: and (
1779: (iby.currency_code = p_currency_code