337:
338: --------------------------------------------------------------------------------------
339: -- FUNCTION: CREATE_LIST_ITEMS_ALL --
340: -- --
341: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --
342: -- --
343: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LIST_ITEMS.APPLICATION_ID --
344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
339: -- FUNCTION: CREATE_LIST_ITEMS_ALL --
340: -- --
341: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --
342: -- --
343: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LIST_ITEMS.APPLICATION_ID --
344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
340: -- --
341: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --
342: -- --
343: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LIST_ITEMS.APPLICATION_ID --
344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
341: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --
342: -- --
343: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LIST_ITEMS.APPLICATION_ID --
344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
342: -- --
343: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LIST_ITEMS.APPLICATION_ID --
344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
343: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LIST_ITEMS.APPLICATION_ID --
344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
354: -- P_FORMULA = BNE_PARAM_LIST_ITEMS.FORMULA_VALUE --
347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
354: -- P_FORMULA = BNE_PARAM_LIST_ITEMS.FORMULA_VALUE --
355: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
354: -- P_FORMULA = BNE_PARAM_LIST_ITEMS.FORMULA_VALUE --
355: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
356: -- --
349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
354: -- P_FORMULA = BNE_PARAM_LIST_ITEMS.FORMULA_VALUE --
355: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
356: -- --
357: -- RETURN: sequence number of item --
350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
354: -- P_FORMULA = BNE_PARAM_LIST_ITEMS.FORMULA_VALUE --
355: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
356: -- --
357: -- RETURN: sequence number of item --
358: -- --
351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
354: -- P_FORMULA = BNE_PARAM_LIST_ITEMS.FORMULA_VALUE --
355: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
356: -- --
357: -- RETURN: sequence number of item --
358: -- --
359: -- MODIFICATION HISTORY --
362: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
363: --------------------------------------------------------------------------------------
364:
365:
366: FUNCTION CREATE_LIST_ITEMS_ALL (P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
367: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
363: --------------------------------------------------------------------------------------
364:
365:
366: FUNCTION CREATE_LIST_ITEMS_ALL (P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
367: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
364:
365:
366: FUNCTION CREATE_LIST_ITEMS_ALL (P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
367: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
365:
366: FUNCTION CREATE_LIST_ITEMS_ALL (P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
367: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
366: FUNCTION CREATE_LIST_ITEMS_ALL (P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
367: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
367: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
379:
372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
379:
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
379:
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
381:
374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
379:
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
381:
382: VN_OBJECT_VERSION_NUM BNE_PARAM_LIST_ITEMS.OBJECT_VERSION_NUMBER%type;
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
379:
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
381:
382: VN_OBJECT_VERSION_NUM BNE_PARAM_LIST_ITEMS.OBJECT_VERSION_NUMBER%type;
383: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
384: VV_LIST_CODE BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
379:
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
381:
382: VN_OBJECT_VERSION_NUM BNE_PARAM_LIST_ITEMS.OBJECT_VERSION_NUMBER%type;
383: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
384: VV_LIST_CODE BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
385: BEGIN
386: --default value
379:
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
381:
382: VN_OBJECT_VERSION_NUM BNE_PARAM_LIST_ITEMS.OBJECT_VERSION_NUMBER%type;
383: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
384: VV_LIST_CODE BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
385: BEGIN
386: --default value
387: VN_OBJECT_VERSION_NUM := 1;
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
381:
382: VN_OBJECT_VERSION_NUM BNE_PARAM_LIST_ITEMS.OBJECT_VERSION_NUMBER%type;
383: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
384: VV_LIST_CODE BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
385: BEGIN
386: --default value
387: VN_OBJECT_VERSION_NUM := 1;
388:
394: VN_SEQ_NUM := GET_NEXT_ITEM_SEQ(P_APPLICATION_ID , VV_LIST_CODE);
395:
396: --dbms_output.put_line('BNE_PARAMETER_UTILS. Seq Num is ' || VN_SEQ_NUM);
397:
398: INSERT INTO BNE_PARAM_LIST_ITEMS ( APPLICATION_ID,
399: PARAM_LIST_CODE,
400: SEQUENCE_NUM,
401: OBJECT_VERSION_NUMBER,
402: PARAM_DEFN_APP_ID,
445:
446: ------------------------------------------------------------------------------------------
447: -- FUNCTION: CREATE_LIST_ITEMS_MINIMAL --
448: -- --
449: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --
450: -- APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID --
451: -- --
452: -- PARAMETERS: P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
448: -- --
449: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --
450: -- APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID --
451: -- --
452: -- PARAMETERS: P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
449: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --
450: -- APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID --
451: -- --
452: -- PARAMETERS: P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
450: -- APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID --
451: -- --
452: -- PARAMETERS: P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
451: -- --
452: -- PARAMETERS: P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
459: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
452: -- PARAMETERS: P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --
453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
459: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
460: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --
454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
459: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
460: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
461: -- --
454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
459: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
460: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
461: -- --
462: -- RETURN: sequence number of item --
455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
459: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
460: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
461: -- --
462: -- RETURN: sequence number of item --
463: -- --
456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --
457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_VALUE --
458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --
459: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --
460: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --
461: -- --
462: -- RETURN: sequence number of item --
463: -- --
464: -- MODIFICATION HISTORY --
467: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
468: ------------------------------------------------------------------------------------------
469:
470:
471: FUNCTION CREATE_LIST_ITEMS_MINIMAL(P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
472: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
468: ------------------------------------------------------------------------------------------
469:
470:
471: FUNCTION CREATE_LIST_ITEMS_MINIMAL(P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
472: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
469:
470:
471: FUNCTION CREATE_LIST_ITEMS_MINIMAL(P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
472: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
470:
471: FUNCTION CREATE_LIST_ITEMS_MINIMAL(P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
472: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
471: FUNCTION CREATE_LIST_ITEMS_MINIMAL(P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
472: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
472: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
480:
473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
480:
481: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
480:
481: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
482:
475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
480:
481: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
482:
483: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
480:
481: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
482:
483: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
484:
485: BEGIN
479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
480:
481: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
482:
483: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;
484:
485: BEGIN
486:
487: VN_SEQ_NUM := CREATE_LIST_ITEMS_ALL(FND_GLOBAL.RESP_APPL_ID, P_PARAM_LIST_CODE, P_PARAM_DEFN_APP_ID,
780: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
781: --------------------------------------------------------------------------------
782:
783:
784: FUNCTION GET_NEXT_ITEM_SEQ ( P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
785: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type)
786: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
787:
788:
781: --------------------------------------------------------------------------------
782:
783:
784: FUNCTION GET_NEXT_ITEM_SEQ ( P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
785: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type)
786: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
787:
788:
789: BEGIN
782:
783:
784: FUNCTION GET_NEXT_ITEM_SEQ ( P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
785: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type)
786: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
787:
788:
789: BEGIN
790: SELECT MAX(SEQUENCE_NUM)
788:
789: BEGIN
790: SELECT MAX(SEQUENCE_NUM)
791: INTO VN_SEQ_NUM
792: FROM BNE_PARAM_LIST_ITEMS
793: WHERE PARAM_LIST_CODE = P_PARAM_LIST_CODE
794: AND APPLICATION_ID = P_APPLICATION_ID;
795:
796: