Add bank accounts exists for new supplier
In my system Bank Account exists, Nơ i want add thi bank account for new supplier.I Implement the following:But cannot update banking detail for supplier.Be help me research isue and he resovle:CREATE OR REPLACE Procedure /*FUNCTION */ VNG_UPDATE_BANK_SUPPLIER1 /*(
in_bank_sort_code IN ap_bank_branches.bank_num%TYPE,
in_bank_account_name IN ap_bank_accounts_all.bank_account_name%TYPE,
in_bank_account_no IN ap_bank_accounts_all.bank_account_num%TYPE,
in_org_id IN hr_operating_units.organization_id%TYPE,
in_set_of_books_id IN ap_bank_accounts_all.set_of_books_id%TYPE,
in_bank_sort_code IN ap_bank_branches.bank_num%TYPE,
in_bank_account_name IN ap_bank_accounts_all.bank_account_name%TYPE,
in_bank_account_no IN ap_bank_accounts_all.bank_account_num%TYPE,
in_org_id IN hr_operating_units.organization_id%TYPE,
in_set_of_books_id IN ap_bank_accounts_all.set_of_books_id%TYPE,
Tagged:
0