EBS: API导入GL科目交叉验证规则要素
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | declare cursor c1 is select tmp.application_id, tmp.id_flex_code, tmp.id_flex_num, tmp.id_flex_structure_code, tmp.flex_validation_rule_name, tmp.include_exclude_indicator, tmp.concatenated_segments_low, tmp.concatenated_segments_high, tmp.enabled_flag, tmp.description from CUX.CUX_KFF_CVR_LINE_TMP tmp where 1=1 ; begin for r1 in c1 loop FND_FLEX_LOADER_APIS.up_kff_cvr_line( p_upload_phase => 'BEGIN' , -- IN VARCHAR2 DEFAULT NULL, p_upload_mode => '' , -- IN VARCHAR2, p_custom_mode => 'FORCE' , -- IN VARCHAR2 DEFAULT NULL, p_application_short_name => 'SQLGL' , -- IN VARCHAR2, p_id_flex_code => 'GL#' , -- IN VARCHAR2, p_id_flex_structure_code => 'CUX_COA' , -- IN VARCHAR2, p_flex_validation_rule_name =>r1.flex_validation_rule_name, -- IN VARCHAR2, p_include_exclude_indicator =>r1.include_exclude_indicator, -- IN VARCHAR2, p_concatenated_segments_low =>r1.concatenated_segments_low, -- IN VARCHAR2, p_concatenated_segments_high =>r1.concatenated_segments_high, -- IN VARCHAR2, p_owner => 'IT-CUX' , -- IN VARCHAR2, p_last_update_date => TO_CHAR(SYSDATE, 'YYYY/MM/DD' ), -- IN VARCHAR2 DEFAULT NULL, p_enabled_flag => 'Y' , -- IN VARCHAR2, p_description => r1.description -- IN VARCHAR2 ); end loop; end ; w例子 |
如下图例子
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了