234: , 177
235: , sysdate
236: , 1
237: , sysdate
238: , fnd_global.user_id
239: , sysdate
240: , fnd_global.user_id
241: , fnd_global.login_id
242: , p_BANK_ID
236: , 1
237: , sysdate
238: , fnd_global.user_id
239: , sysdate
240: , fnd_global.user_id
241: , fnd_global.login_id
242: , p_BANK_ID
243: , p_BANK_NAME
244: , p_BANK_NAME_ALT
237: , sysdate
238: , fnd_global.user_id
239: , sysdate
240: , fnd_global.user_id
241: , fnd_global.login_id
242: , p_BANK_ID
243: , p_BANK_NAME
244: , p_BANK_NAME_ALT
245: , p_BANK_NUMBER
506: , account_owner_party_id = p_party_id
507: , owner_primary_flag = p_owner_primary_flag
508: , payment_factor_flag = p_payment_factor_flag
509: , last_update_date = sysdate
510: , last_updated_by = fnd_global.user_id
511: , last_update_login = fnd_global.login_id
512: , BANK_ID = p_bank_id
513: , BANK_NAME = p_bank_name
514: , BANK_NAME_ALT = p_bank_name_alt
507: , owner_primary_flag = p_owner_primary_flag
508: , payment_factor_flag = p_payment_factor_flag
509: , last_update_date = sysdate
510: , last_updated_by = fnd_global.user_id
511: , last_update_login = fnd_global.login_id
512: , BANK_ID = p_bank_id
513: , BANK_NAME = p_bank_name
514: , BANK_NAME_ALT = p_bank_name_alt
515: , BANK_NUMBER = p_bank_number
1704: l_step := 0;
1705: update pos_acnt_addr_summ_req
1706: set ext_bank_account_id = p_ext_bank_account_id,
1707: last_update_date = sysdate,
1708: last_updated_by = fnd_global.user_id,
1709: last_update_login = fnd_global.login_id,
1710: object_version_number = object_version_number + 1
1711: where account_request_id = p_account_request_id;
1712:
1705: update pos_acnt_addr_summ_req
1706: set ext_bank_account_id = p_ext_bank_account_id,
1707: last_update_date = sysdate,
1708: last_updated_by = fnd_global.user_id,
1709: last_update_login = fnd_global.login_id,
1710: object_version_number = object_version_number + 1
1711: where account_request_id = p_account_request_id;
1712:
1713: l_step := 2;
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,
1719: object_version_number = object_version_number + 1
1720: where account_request_id = p_account_request_id;
1721:
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,
1719: object_version_number = object_version_number + 1
1720: where account_request_id = p_account_request_id;
1721:
1722: l_step := 3;
1723: update iby_temp_ext_bank_accts
1724: set bank_id = p_bank_id,
1725: branch_id = p_branch_id,
1726: last_update_date = sysdate,
1727: last_updated_by = fnd_global.user_id,
1728: last_update_login = fnd_global.login_id,
1729: object_version_number = object_version_number + 1,
1730: ext_bank_account_id = p_ext_bank_account_id
1731: where temp_ext_bank_acct_id = p_temp_ext_bank_account_id;
1724: set bank_id = p_bank_id,
1725: branch_id = p_branch_id,
1726: last_update_date = sysdate,
1727: last_updated_by = fnd_global.user_id,
1728: last_update_login = fnd_global.login_id,
1729: object_version_number = object_version_number + 1,
1730: ext_bank_account_id = p_ext_bank_account_id
1731: where temp_ext_bank_acct_id = p_temp_ext_bank_account_id;
1732: