Amazon

Create Value Set From Back End

BEGIN
FND_FLEX_VAL_API.CREATE_VALUESET_TABLE
(
 VALUE_SET_NAME =>'TEI_PROJECT_NO',
 DESCRIPTION =>'createdfrombackend',
 SECURITY_AVAILABLE =>'N',
 ENABLE_LONGLIST =>'N',
 FORMAT_TYPE   =>'Char',
 MAXIMUM_SIZE =>30,
 precision => NULL,
 numbers_only =>'N',
 uppercase_only  =>'N',
 right_justify_zero_fill =>'N',
 min_value  => NULL,
 MAX_VALUE   => NULL,
 TABLE_APPLICATION => 'Projects',
 table_appl_short_name =>'' ,
 TABLE_NAME =>'pa_projects_all PPA',
 ALLOW_PARENT_VALUES =>'N',
 VALUE_COLUMN_NAME =>'PPA.SEGMENT1',
 VALUE_COLUMN_TYPE  =>'Char',
 value_column_size  =>30,
 meaning_column_name  =>'PPA.NAME',
 meaning_column_type  => 'Char',
 MEANING_COLUMN_SIZE  => 30,
 ID_COLUMN_NAME    =>'PPA.PROJECT_ID',--'PRH.SEGMENT1',
 ID_COLUMN_TYPE   =>'NUMBER',--'Char',
 ID_COLUMN_SIZE   =>30,--u20,
 WHERE_ORDER_BY    =>'',
 ADDITIONAL_COLUMNS => NULL
  );
 Commit;
  Exception
  WHEN OTHERS THEN
  dbms_output.put_line(sqlerrm);
  end;

No comments:

Post a Comment