创建银行分行的API
2024-08-24 02:20:11
DECLARE
p_api_version NUMBER := 1.0;
p_init_msg_list VARCHAR2(1) := 'F';
v_bank_id NUMBER := 530705;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER(5);
x_msg_data VARCHAR2(2000);
x_branch_id NUMBER;
p_count NUMBER; x_response iby_fndcpt_common_pub.result_rec_type;
p_ext_bank_branch_rec iby_ext_bankacct_pub.extbankbranch_rec_type; BEGIN
dbms_output.put_line ('BEFORE BANK BRANCH API'); p_ext_bank_branch_rec.bch_object_version_number := 1.0;
p_ext_bank_branch_rec.branch_name := 'TEST BANK BRANCH';
p_ext_bank_branch_rec.branch_type := 'ABA';
p_ext_bank_branch_rec.bank_party_id := v_bank_id; IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH
( -- -----------------------------
-- Input data elements
-- -----------------------------
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_ext_bank_branch_rec => p_ext_bank_branch_rec,
-- --------------------------------
-- Output data elements
-- --------------------------------
x_branch_id => x_branch_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_response => x_response
); dbms_output.put_line ('x_branch_id = ' || x_branch_id); IF (x_msg_count = 1)
THEN
dbms_output.put_line ('x_msg_data ' || x_msg_data); ELSIF (x_msg_count > 1)
THEN
LOOP
p_count := p_count + 1;
x_msg_data := fnd_msg_pub.get (fnd_msg_pub.g_next, fnd_api.g_false); IF (x_msg_data IS NULL)
THEN
EXIT;
END IF; dbms_output.put_line ('Message' || p_count || ' ---' || x_msg_data);
END LOOP;
END IF; COMMIT; EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
dbms_output.put_line(SQLERRM);
END;
/ SHOW ERR;
最新文章
- seL4之hello-2旅途(完成更新)
- Python基本数据类型之str
- Web的Ajax应用开发模式(三)——Ajax的开发
- vb6 枚举对象属性
- JavaScript面向对象(OOP)
- RE模块错误已解决.
- Django小技巧——使用package管理app
- [转]Github 下载指定文件夹
- Java反射的简单入门
- Netty学习4—NIO服务端报错:远程主机强迫关闭了一个现有的连接
- javascript的作用域和优先级
- 关于SAN和NAS的区别-转
- Flask详解
- 选择问题 and 字谜游戏问题
- halcon之屌炸天的自标定(1)
- Hadoop源码学习笔记(3) ——初览DataNode及学习线程
- jQuery调用ajax获取json格式数据
- cocoaspod使用 引用头文件找不到
- (转载)一位资深程序员大牛给予Java初学者的学习建议
- 转载JAVA八大经典书籍,你看过几本?