Tuesday, September 12, 2017

API to Create Table Value Set (FND_FLEX_VAL_API.CREATE_VALUESET_TABLE)

BEGIN
   FND_FLEX_VAL_API.SET_SESSION_MODE ('customer_data');          /*Mandatory*/
   FND_FLEX_VAL_API.CREATE_VALUESET_TABLE (
      value_set_name            => 'XX_VALUESET',
      description               => 'createdfrombackend',
      security_available        => 'N',
      enable_longlist           => 'N',
      format_type               => 'Char',
      maximum_size              => 20,
      PRECISION                 => NULL,
      numbers_only              => 'N',
      uppercase_only            => 'N',
      right_justify_zero_fill   => 'N',
      min_value                 => NULL,
      max_value                 => NULL,
      table_application         => 'Application Object Library',
      table_appl_short_name     => 'AOL',
      table_name                => 'FND_LOOKUP_VALUES FND',
      allow_parent_values       => 'N',
      value_column_name         => 'FND.LOOKUP_CODE',
      value_column_type         => 'Char',
      value_column_size         => 40,
      meaning_column_name       => NULL,
      meaning_column_type       => NULL,
      meaning_column_size       => 40,
      id_column_name            => 'FND.MEANING',
      id_column_type            => 'Char',
      id_column_size            => 40,
      where_order_by            => 'where lookup_type=''XXTEST_LOOKUP''',
      additional_columns        => NULL
   );
   COMMIT;
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line (SQLERRM);
END;
/

No comments:

Post a Comment

API to Delete FND Application (FND_APPLICATION_PKG.DELETE_ROW)

BEGIN    FND_APPLICATION_PKG.DELETE_ROW (X_APPLICATION_ID => 20003); END; /