Infolinks

Friday 6 July 2012

API to Load Values into Value Sets

001DECLARE
002----------------------------Local Variables---------------------------
003   l_enabled_flag             VARCHAR2 (2);
004   l_summary_flag             VARCHAR2 (2);
005   l_who_type                 FND_FLEX_LOADER_APIS.WHO_TYPE;
006   l_user_id                  NUMBER                := FND_GLOBAL.USER_ID;
007   l_login_id                 NUMBER                := FND_GLOBAL.LOGIN_ID;
008   l_value_set_name           FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE;
009   l_value_set_value          FND_FLEX_VALUES.FLEX_VALUE%TYPE;
010BEGIN
011 
012   l_value_set_name             :='VALUE_SET_NAME';
013   l_value_set_value            :='VALUE_SET_VALUE';
014   l_enabled_flag               := 'Y';
015   l_summary_flag               := 'N';
016   l_who_type.created_by        := l_user_id;
017   l_who_type.creation_date     := SYSDATE;
018   l_who_type.last_updated_by   := l_user_id;
019   l_who_type.last_update_date  := SYSDATE;
020   l_who_type.last_update_login := l_login_id;
021 
022     fnd_flex_loader_apis.up_value_set_value
023                  (p_upload_phase               => 'BEGIN',
024                   p_upload_mode                => NULL,
025                   p_custom_mode                => 'FORCE',
026                   p_flex_value_set_name        => l_value_set_name,
027                   p_parent_flex_value_low      => NULL,
028                   p_flex_value                 => l_value_set_value,
029                   p_owner                      => NULL,
030                   p_last_update_date           => TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS'),
031                   p_enabled_flag               => l_enabled_flag,
032                   p_summary_flag               => l_summary_flag,
033                   p_start_date_active          => TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS'),
034                   p_end_date_active            => NULL,
035                   p_parent_flex_value_high     => NULL,
036                   p_rollup_flex_value_set_name => NULL,
037                   p_rollup_hierarchy_code      => NULL,
038                   p_hierarchy_level            => NULL,
039                   p_compiled_value_attributes  => NULL,
040                   p_value_category             => 'VALUE_SET_NAME',
041                   p_attribute1                 => '40912',
042                   p_attribute2                 => NULL,
043                   p_attribute3                 => NULL,
044                   p_attribute4                 => NULL,
045                   p_attribute5                 => NULL,
046                   p_attribute6                 => NULL,
047                   p_attribute7                 => NULL,
048                   p_attribute8                 => NULL,
049                   p_attribute9                 => NULL,
050                   p_attribute10                => NULL,
051                   p_attribute11                => NULL,
052                   p_attribute12                => NULL,
053                   p_attribute13                => NULL,
054                   p_attribute14                => NULL,
055                   p_attribute15                => NULL,
056                   p_attribute16                => NULL,
057                   p_attribute17                => NULL,
058                   p_attribute18                => NULL,
059                   p_attribute19                => NULL,
060                   p_attribute20                => NULL,
061                   p_attribute21                => NULL,
062                   p_attribute22                => NULL,
063                   p_attribute23                => NULL,
064                   p_attribute24                => NULL,
065                   p_attribute25                => NULL,
066                   p_attribute26                => NULL,
067                   p_attribute27                => NULL,
068                   p_attribute28                => NULL,
069                   p_attribute29                => NULL,
070                   p_attribute30                => NULL,
071                   p_attribute31                => NULL,
072                   p_attribute32                => NULL,
073                   p_attribute33                => NULL,
074                   p_attribute34                => NULL,
075                   p_attribute35                => NULL,
076                   p_attribute36                => NULL,
077                   p_attribute37                => NULL,
078                   p_attribute38                => NULL,
079                   p_attribute39                => NULL,
080                   p_attribute40                => NULL,
081                   p_attribute41                => NULL,
082                   p_attribute42                => NULL,
083                   p_attribute43                => NULL,
084                   p_attribute44                => NULL,
085                   p_attribute45                => NULL,
086                   p_attribute46                => NULL,
087                   p_attribute47                => NULL,
088                   p_attribute48                => NULL,
089                   p_attribute49                => NULL,
090                   P_ATTRIBUTE50                => NULL,
091                   p_flex_value_meaning         => l_value_set_value,
092                   p_description                => NULL
093                   );
094      COMMIT;
095 
096   EXCEPTION
097      WHEN OTHERS
098      THEN
099         DBMS_OUTPUT,PUT_LINE('Error is ' || SUBSTR (SQLERRM, 1, 1000));
100   END;

No comments:

Post a Comment