EBS 导入值集的值

向已存在的独立值集里面导入值。

DECLARE
  l_rowid ROWID;
BEGIN
  fnd_flex_loader_apis.up_value_set_value(p_upload_phase               => 'BEGIN',
                                          p_upload_mode                => '',
                                          p_custom_mode                => 'FORCE',
                                          p_flex_value_set_name        => 'XY_COA_PROJ' /*值集名*/,
                                          p_parent_flex_value_low      => '',
                                          p_flex_value                 => '100103000003' /*值*/,
                                          p_owner                      => '',
                                          p_last_update_date           => '2020-01-01',
                                          p_enabled_flag               => 'Y' /*启用*/,
                                          p_summary_flag               => 'N' /*父*/,
                                          p_start_date_active          => '' /*有效期自*/,
                                          p_end_date_active            => '' /*有效期至*/,
                                          p_parent_flex_value_high     => '',
                                          p_rollup_flex_value_set_name => '',
                                          p_rollup_hierarchy_code      => '',
                                          p_hierarchy_level            => '' /*层*/,
                                          p_compiled_value_attributes  => 'Y'||chr(10)||'Y' /*限定词*/,
                                          p_value_category             => 'XY_COA_PROJ', -- 弹性域
                                          p_attribute1                 => '10',  
                                          p_attribute2                 => '',
                                          p_attribute3                 => '',
                                          p_attribute4                 => '',
                                          p_attribute5                 => '',
                                          p_attribute6                 => '',
                                          p_attribute7                 => '',
                                          p_attribute8                 => '',
                                          p_attribute9                 => '',
                                          p_attribute10                => '',
                                          p_attribute11                => '',
                                          p_attribute12                => '',
                                          p_attribute13                => '',
                                          p_attribute14                => '',
                                          p_attribute15                => '',
                                          p_attribute16                => '',
                                          p_attribute17                => '',
                                          p_attribute18                => '',
                                          p_attribute19                => '',
                                          p_attribute20                => '',
                                          p_attribute21                => '',
                                          p_attribute22                => '',
                                          p_attribute23                => '',
                                          p_attribute24                => '',
                                          p_attribute25                => '',
                                          p_attribute26                => '',
                                          p_attribute27                => '',
                                          p_attribute28                => '',
                                          p_attribute29                => '',
                                          p_attribute30                => '',
                                          p_attribute31                => '',
                                          p_attribute32                => '',
                                          p_attribute33                => '',
                                          p_attribute34                => '',
                                          p_attribute35                => '',
                                          p_attribute36                => '',
                                          p_attribute37                => '',
                                          p_attribute38                => '',
                                          p_attribute39                => '',
                                          p_attribute40                => '',
                                          p_attribute41                => '',
                                          p_attribute42                => '',
                                          p_attribute43                => '',
                                          p_attribute44                => '',
                                          p_attribute45                => '',
                                          p_attribute46                => '',
                                          p_attribute47                => '',
                                          p_attribute48                => '',
                                          p_attribute49                => '',
                                          p_attribute50                => '',
                                          p_flex_value_meaning         => '100103000003' /*转换的值*/,
                                          p_description                => '100103000003' /*说明*/);
  COMMIT;
END;