Engineering Win

Anonymous block to create a value set using fnd_flex_val_api.create_valueset_independent DECLARE value_set_name         VARCHAR2 (200); description         VARCHAR2 (200); security_available     VARCHAR2 (200); enable_longlist     VARCHAR2 (200); format_type         VARCHAR2 (200); maximum_size        NUMBER; PRECISION         NUMBER; numbers_only         VARCHAR2 (200); uppercase_only         VARCHAR2 (200); right_justify_zero_fill VARCHAR2 (200); min_value         VARCHAR2 (200); max_value         VARCHAR2 (200); v_session_mode         VARCHAR2 (20) := 'customer_data'; x             VARCHAR2 (200); v_msg ...

assigning a value to the independent value set using FND_FLEX_VALUE_PKG.LOAD_ROW Api. DECLARE    v_enabled_flag         VARCHAR2 (2)              := 'Y';    v_summary_flag         VARCHAR2 (2)              := 'Y';    v_start_date_active    DATE                      := SYSDATE;    v_error_msg            VARCHAR2 (1000)           := NULL;    v_who_type             fnd_flex_loader_apis.who_type;    v_request_id    ...