eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BNE_PARAMETER_UTILS dependencies on BNE_PARAM_LIST_ITEMS

Line 341: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --

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

Line 343: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LIST_ITEMS.APPLICATION_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 --

Line 344: -- P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --

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

Line 345: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_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 --

Line 346: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_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 --

Line 347: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --

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

Line 348: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_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 --
352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --

Line 349: -- P_ATTRIBUTE_CODE = BNE_PARAM_LIST_ITEMS.ATTRIBUTE_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 --
353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --

Line 350: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --

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

Line 351: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_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 --

Line 352: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_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: -- --

Line 353: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --

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

Line 354: -- P_FORMULA = BNE_PARAM_LIST_ITEMS.FORMULA_VALUE --

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

Line 355: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_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: -- --
359: -- MODIFICATION HISTORY --

Line 366: FUNCTION CREATE_LIST_ITEMS_ALL (P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,

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,

Line 367: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%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,

Line 368: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_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,

Line 369: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_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,

Line 370: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%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,

Line 371: P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_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,
375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,

Line 372: P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_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,
376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,

Line 373: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%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,

Line 374: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_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 )

Line 375: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_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:

Line 376: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%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:
380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;

Line 377: P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%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:

Line 378: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_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:
382: VN_OBJECT_VERSION_NUM BNE_PARAM_LIST_ITEMS.OBJECT_VERSION_NUMBER%type;

Line 380: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%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;

Line 382: VN_OBJECT_VERSION_NUM BNE_PARAM_LIST_ITEMS.OBJECT_VERSION_NUMBER%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

Line 383: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%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
387: VN_OBJECT_VERSION_NUM := 1;

Line 384: VV_LIST_CODE BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;

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:

Line 398: INSERT INTO BNE_PARAM_LIST_ITEMS ( APPLICATION_ID,

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,

Line 449: -- DESCRIPTION: Inserts into BNE_PARAM_LIST_ITEMS --

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

Line 452: -- PARAMETERS: P_PARAM_LIST_CODE = BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE --

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

Line 453: -- P_PARAM_DEFN_APP_ID = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID --

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

Line 454: -- P_PARAM_DEFN_CODE = BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE --

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

Line 455: -- P_PARAM_NAME = BNE_PARAM_LIST_ITEMS.PARAM_NAME --

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

Line 456: -- P_STRING_VAL = BNE_PARAM_LIST_ITEMS.STRING_VALUE --

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

Line 457: -- P_DATE_VAL = BNE_PARAM_LIST_ITEMS.DATE_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: -- --

Line 458: -- P_NUMBER_VAL = BNE_PARAM_LIST_ITEMS.NUMBER_VALUE --

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

Line 459: -- P_BOOLEAN_VAL = BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG --

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

Line 460: -- P_DESC_VAL = BNE_PARAM_LIST_ITEMS.DESC_VALUE --

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

Line 471: FUNCTION CREATE_LIST_ITEMS_MINIMAL(P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,

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,

Line 472: P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%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,

Line 473: P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%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,

Line 474: P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%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,

Line 475: P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%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 )

Line 476: P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_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:

Line 477: P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%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:
481: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;

Line 478: P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%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:

Line 479: P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %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:
483: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type;

Line 481: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%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

Line 483: VN_LIST_KEY BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%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
486:
487: VN_SEQ_NUM := CREATE_LIST_ITEMS_ALL(FND_GLOBAL.RESP_APPL_ID, P_PARAM_LIST_CODE, P_PARAM_DEFN_APP_ID,

Line 784: FUNCTION GET_NEXT_ITEM_SEQ ( P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,

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:

Line 785: P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type)

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

Line 786: RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type AS VN_SEQ_NUM BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;

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)

Line 792: FROM BNE_PARAM_LIST_ITEMS

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: