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    ...

Adding a Responsibility to an Oracle User in R12 Oracle Apps using API -- FND_USER_PKG.ADDRESP to add responsibility ‘System Administrator’ for the user ‘USERZEE’ using the API. DECLARE    v_user_name              VARCHAR2 (100) := 'USERZEE';    v_responsibility_name    VARCHAR2 (100) := 'System Administrator';    v_application_name       VARCHAR2 (100) := NULL;    v_responsibility_key     VARCHAR2 (100) := NULL;    v_security_group         VARCHAR2 (100) := NULL;    v_description            VARCHAR2 (100) := NULL; BEGIN    SELECT fa.application_short_name,                  fr.responsibility_key, ...