PL/SQL (MOSC)

MOSC Banner

API - add bank

edited Nov 24, 2015 4:59AM in PL/SQL (MOSC) 10 commentsAnswered

Dear All,

im trying to add a new bank account using API, and the procedure is running wih no error but when  i run a select query i didint find the account ive added:

the code is: 

Create or replace PROCEDURE  XX_create_Bank_api (nb in number) IS

lc_output VARCHAR2(3000);

lc_msg_dummy VARCHAR2(3000);

lc_return_status VARCHAR2(3000);

lc_msg_data VARCHAR2(3000);

ln_bank_id NUMBER;

ln_msg_count NUMBER;

lr_extbank_rec apps.iby_ext_bankacct_pub.extbank_rec_type;

lr_response_rec apps.iby_fndcpt_common_pub.result_rec_type;

BEGIN

lc_return_status := '';

ln_msg_count := '';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center