001 | DECLARE |
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; |
010 | BEGIN |
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