{"id":691,"date":"2012-09-21T15:52:23","date_gmt":"2012-09-21T07:52:23","guid":{"rendered":"http:\/\/j178.mtgbb.com\/?p=691"},"modified":"2013-03-15T10:44:32","modified_gmt":"2013-03-15T02:44:32","slug":"%e4%bd%bf%e7%94%a8-api-%e5%bb%ba%e7%ab%8b-valueset","status":"publish","type":"post","link":"https:\/\/j178.mtgbb.com\/?p=691","title":{"rendered":"\u4f7f\u7528 API \u5efa\u7acb valueset"},"content":{"rendered":"<p>\u4f7f\u7528 API \u5982\u4e0b:<\/p>\n<pre lang=\"oracle8\">\r\n--1-1. \u5efa\u7acb independent SET\r\nfnd_flex_val_api.create_valueset_independent(\r\n       v_set_name,\r\n       v_description,\r\n       v_security,\r\n       v_enable_longlist,\r\n       v_format_type,\r\n       v_maximum_size,\r\n       v_numbers_only,\r\n       v_uppercase_only,\r\n       v_right_justify_zero_fill,\r\n       v_min_value,\r\n       v_max_value);\r\n\r\n--1-2. \u5efa\u7acb dependent SET\r\nfnd_flex_val_api.create_valueset_dependent(\r\n       v_set_name,\r\n       v_description,\r\n       v_security,\r\n       v_enable_longlist,\r\n       v_format_type,\r\n       v_maximum_size,\r\n       v_numbers_only,\r\n       v_uppercase_only,\r\n       v_right_justify_zero_fill,\r\n       v_min_value,\r\n       v_max_value,\r\n       v_parent_value_set,\r\n       v_default_value,\r\n       v_default_meaning);\r\n       \r\n-- 2.\u522a\u9664SET\r\nfnd_flex_val_api.delete_valueset(v_value_set_name);\r\n \r\n-- 3-1. \u589e\u52a0 independent VALUE\r\nfnd_flex_val_api.create_independent_vset_value(\r\n   v_value_set_name,\r\n   v_value,\r\n   v_storage_value --output parameter\r\n);\r\n\r\n-- 3-2. \u589e\u52a0 dependent VALUE\r\nfnd_flex_val_api.create_dependent_vset_value(\r\n   v_value_set_name,\r\n   v_parent_value,\r\n   v_value,\r\n   v_storage_value --output parameter\r\n);\r\n<\/pre>\n<p>Sample Code:<\/p>\n<pre lang=\"oracle8\">\r\nDECLARE\r\n  v_storage_value VARCHAR2(1000);\r\nBEGIN\r\n  -- Test statements here\r\n  fnd_flex_val_api.create_dependent_vset_value(\r\n     p_flex_value_set_name => 'XIN_INV_MINOR_CATEGORY',\r\n     p_parent_flex_value   => 'SubPart',\r\n     p_flex_value          => 'AA123', --v_value,\r\n     p_description         => 'AA123D',\r\n     x_storage_value       => v_storage_value --output parameter\r\n     );\r\n  dbms_output.put_line('out:' || v_storage_value);\r\nEND;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4f7f\u7528 API \u5982\u4e0b: &#8211;1-1. \u5efa\u7acb independent SET fnd_flex_val_api.c &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[45,57],"class_list":["post-691","post","type-post","status-publish","format-standard","hentry","category-oracle-erp","tag-api","tag-oracle-erp"],"_links":{"self":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/691","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=691"}],"version-history":[{"count":0,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/691\/revisions"}],"wp:attachment":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}