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例子 

如下图例子

 

posted @   samrv  阅读(236)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示