511: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
512: --------------------------------------------------------------------------------
513:
514:
515: FUNCTION GET_PARAM_DEFN_ID (P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
516: P_PARAM_DEFN_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
517: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type )
518: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_DEFN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
519:
512: --------------------------------------------------------------------------------
513:
514:
515: FUNCTION GET_PARAM_DEFN_ID (P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
516: P_PARAM_DEFN_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
517: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type )
518: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_DEFN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
519:
520: VN_APPLICATION_ID BNE_PARAM_DEFNS_B.APPLICATION_ID%type;
513:
514:
515: FUNCTION GET_PARAM_DEFN_ID (P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
516: P_PARAM_DEFN_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
517: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type )
518: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_DEFN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
519:
520: VN_APPLICATION_ID BNE_PARAM_DEFNS_B.APPLICATION_ID%type;
521: VV_DEFN_CODE BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
514:
515: FUNCTION GET_PARAM_DEFN_ID (P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
516: P_PARAM_DEFN_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
517: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type )
518: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_DEFN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
519:
520: VN_APPLICATION_ID BNE_PARAM_DEFNS_B.APPLICATION_ID%type;
521: VV_DEFN_CODE BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
522: BEGIN
516: P_PARAM_DEFN_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
517: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type )
518: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_DEFN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
519:
520: VN_APPLICATION_ID BNE_PARAM_DEFNS_B.APPLICATION_ID%type;
521: VV_DEFN_CODE BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
522: BEGIN
523:
524: --dbms_output.put_line('Param Defn Name is ' || P_PARAM_DEFN_NAME);
517: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type )
518: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_DEFN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
519:
520: VN_APPLICATION_ID BNE_PARAM_DEFNS_B.APPLICATION_ID%type;
521: VV_DEFN_CODE BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
522: BEGIN
523:
524: --dbms_output.put_line('Param Defn Name is ' || P_PARAM_DEFN_NAME);
525: --dbms_output.put_line('Param Source is ' || P_PARAM_SOURCE);
525: --dbms_output.put_line('Param Source is ' || P_PARAM_SOURCE);
526:
527: SELECT APPLICATION_ID, PARAM_DEFN_CODE
528: INTO VN_APPLICATION_ID, VV_DEFN_CODE
529: FROM BNE_PARAM_DEFNS_B
530: WHERE PARAM_NAME = P_PARAM_DEFN_NAME
531: AND PARAM_SOURCE = P_PARAM_SOURCE
532: AND APPLICATION_ID = P_APPLICATION_ID;
533:
549:
550: ------------------------------------------------------------------------------------
551: -- FUNCTION: CREATE_PARAM_ALL --
552: -- --
553: -- DESCRIPTION: Create a parameter. Inserts into BNE_PARAM_DEFNS_B/_TL --
554: -- --
555: -- --
556: -- PARAMETERS: all columns in BNE_PARAM_DEFNS_B/_TL --
557: -- --
552: -- --
553: -- DESCRIPTION: Create a parameter. Inserts into BNE_PARAM_DEFNS_B/_TL --
554: -- --
555: -- --
556: -- PARAMETERS: all columns in BNE_PARAM_DEFNS_B/_TL --
557: -- --
558: -- RETURN: parameter KEY. --
559: -- --
560: -- MODIFICATION HISTORY --
563: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
564: ------------------------------------------------------------------------------------
565:
566:
567: FUNCTION CREATE_PARAM_ALL( P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
568: P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
569: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
564: ------------------------------------------------------------------------------------
565:
566:
567: FUNCTION CREATE_PARAM_ALL( P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
568: P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
569: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
565:
566:
567: FUNCTION CREATE_PARAM_ALL( P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
568: P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
569: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
566:
567: FUNCTION CREATE_PARAM_ALL( P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
568: P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
569: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
567: FUNCTION CREATE_PARAM_ALL( P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
568: P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
569: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
568: P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
569: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
569: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
570: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
571: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
572: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
573: P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
574: P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
575: P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
576: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
577: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
578: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
579: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
580: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
581: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
589: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
582: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
589: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
590: P_HELP_URL in BNE_PARAM_DEFNS_B.HELP_URL%type,
583: P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
589: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
590: P_HELP_URL in BNE_PARAM_DEFNS_B.HELP_URL%type,
591: P_FORMAT_MASK in BNE_PARAM_DEFNS_B.FORMAT_MASK%type,
584: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
589: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
590: P_HELP_URL in BNE_PARAM_DEFNS_B.HELP_URL%type,
591: P_FORMAT_MASK in BNE_PARAM_DEFNS_B.FORMAT_MASK%type,
592: P_DEFAULT_DESC in BNE_PARAM_DEFNS_TL.DEFAULT_DESC%type,
585: P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
589: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
590: P_HELP_URL in BNE_PARAM_DEFNS_B.HELP_URL%type,
591: P_FORMAT_MASK in BNE_PARAM_DEFNS_B.FORMAT_MASK%type,
592: P_DEFAULT_DESC in BNE_PARAM_DEFNS_TL.DEFAULT_DESC%type,
593: P_PROMPT_LEFT in BNE_PARAM_DEFNS_TL.PROMPT_LEFT%type,
586: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
589: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
590: P_HELP_URL in BNE_PARAM_DEFNS_B.HELP_URL%type,
591: P_FORMAT_MASK in BNE_PARAM_DEFNS_B.FORMAT_MASK%type,
592: P_DEFAULT_DESC in BNE_PARAM_DEFNS_TL.DEFAULT_DESC%type,
593: P_PROMPT_LEFT in BNE_PARAM_DEFNS_TL.PROMPT_LEFT%type,
594: P_PROMPT_ABOVE in BNE_PARAM_DEFNS_TL.PROMPT_ABOVE%type,
587: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
588: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
589: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
590: P_HELP_URL in BNE_PARAM_DEFNS_B.HELP_URL%type,
591: P_FORMAT_MASK in BNE_PARAM_DEFNS_B.FORMAT_MASK%type,
592: P_DEFAULT_DESC in BNE_PARAM_DEFNS_TL.DEFAULT_DESC%type,
593: P_PROMPT_LEFT in BNE_PARAM_DEFNS_TL.PROMPT_LEFT%type,
594: P_PROMPT_ABOVE in BNE_PARAM_DEFNS_TL.PROMPT_ABOVE%type,
595: P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type,
594: P_PROMPT_ABOVE in BNE_PARAM_DEFNS_TL.PROMPT_ABOVE%type,
595: P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type,
596: P_USER_TIP in BNE_PARAM_DEFNS_TL.USER_TIP%type,
597: P_ACCESS_KEY in BNE_PARAM_DEFNS_TL.ACCESS_KEY%type)
598: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
599:
600: VN_OBJECT_VERSION_NUM BNE_PARAM_DEFNS_B.OBJECT_VERSION_NUMBER%type;
601:
602: BEGIN
596: P_USER_TIP in BNE_PARAM_DEFNS_TL.USER_TIP%type,
597: P_ACCESS_KEY in BNE_PARAM_DEFNS_TL.ACCESS_KEY%type)
598: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VV_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
599:
600: VN_OBJECT_VERSION_NUM BNE_PARAM_DEFNS_B.OBJECT_VERSION_NUMBER%type;
601:
602: BEGIN
603: --default values
604:
609:
610: VV_KEY := P_APPLICATION_ID || ':' || P_PARAM_CODE;
611:
612:
613: INSERT INTO BNE_PARAM_DEFNS_B ( APPLICATION_ID,
614: PARAM_DEFN_CODE,
615: OBJECT_VERSION_NUMBER,
616: PARAM_NAME ,
617: PARAM_SOURCE,
728: -- 8-May-02 KDOBINSO CREATED --
729: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
730: --------------------------------------------------------------------------------
731:
732: FUNCTION CREATE_PARAM_MINIMAL ( P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
733: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
734: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
729: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
730: --------------------------------------------------------------------------------
731:
732: FUNCTION CREATE_PARAM_MINIMAL ( P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
733: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
734: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
730: --------------------------------------------------------------------------------
731:
732: FUNCTION CREATE_PARAM_MINIMAL ( P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
733: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
734: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
731:
732: FUNCTION CREATE_PARAM_MINIMAL ( P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
733: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
734: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
732: FUNCTION CREATE_PARAM_MINIMAL ( P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
733: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
734: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
733: P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
734: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
734: P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
735: P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
736: P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
737: P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
738: P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
746: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
739: P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
746: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
747: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
740: P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
746: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
747: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
748: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
741: P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
746: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
747: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
748: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
749: P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type)
742: P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
746: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
747: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
748: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
749: P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type)
750:
743: P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
746: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
747: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
748: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
749: P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type)
750:
751: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
744: P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
745: P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
746: P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
747: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
748: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
749: P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type)
750:
751: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
752:
747: P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
748: P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
749: P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type)
750:
751: RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type AS VN_KEY BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
752:
753: BEGIN
754:
755: VN_KEY := CREATE_PARAM_ALL( FND_GLOBAL.RESP_APPL_ID, P_PARAM_CODE,P_PARAM_NAME,P_PARAM_SOURCE,P_CATEGORY,P_DATA_TYPE,NULL,