[Home] [Help]
1266: temp.bank_account_name_alt, temp.bank_account_type,
1267: temp.description, temp.end_date, temp.start_date, temp.agency_location_code,
1268: temp.status, temp.note, temp.note_alt, temp.account_suffix, temp.exchange_rate,
1269: temp.exchange_rate_agreement_num, temp.exchange_rate_agreement_type, temp.payment_factor_flag
1270: from IBY_TEMP_EXT_BANK_ACCTS temp, pos_acnt_gen_req req
1271: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id
1272: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1273: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1274:
1282:
1283: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1284: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1285: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1286: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1287: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1288: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1289: l_bank_party_site_id number;
1290: l_bank_party_site_number varchar2(2000);
1745: object_version_number = object_version_number + 1
1746: where account_request_id = p_account_request_id;
1747:
1748: l_step := 2;
1749: update pos_acnt_gen_req
1750: set ext_bank_account_id = p_ext_bank_account_id,
1751: last_update_date = sysdate,
1752: last_updated_by = fnd_global.user_id,
1753: last_update_login = fnd_global.login_id,
1806: l_count NUMBER;
1807: l_msg_data varchar(2000);
1808:
1809: cursor dup_temp_act_cur is
1810: select count(*) from iby_temp_ext_bank_accts iby, pos_acnt_gen_req pos
1811: where pos.mapping_id = p_mapping_id
1812: and pos.temp_ext_bank_acct_id = iby.temp_ext_bank_acct_id
1813: and (
1814: (iby.currency_code = p_currency_code