5: -- PACKAGE: BNE_PARAMETERS_UTILS --
6: -- --
7: -- DESCRIPTION: Used For inserting into parameters tables: --
8: -- BNE_PARAM_DEFNS_B/_TL --
9: -- BNE_PARAM_LISTS_B/_TL --
10: -- BNE_PARAM_LIST_ITEMS --
11: -- BNE_ATTRIBUTES --
12: -- --
13: -- MODIFICATION HISTORY --
14: -- Date Username Description --
15: -- 8-5-2002 kdobinso Initial creation --
16: ----------------------------------------------------------------------------------
17:
18: -- insert into BNE_PARAM_LISTS_B/_TL
19:
20: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
21: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
16: ----------------------------------------------------------------------------------
17:
18: -- insert into BNE_PARAM_LISTS_B/_TL
19:
20: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
21: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
17:
18: -- insert into BNE_PARAM_LISTS_B/_TL
19:
20: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
21: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
25: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
18: -- insert into BNE_PARAM_LISTS_B/_TL
19:
20: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
21: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
25: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
26: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
19:
20: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
21: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
25: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
26: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
27: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
20: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
21: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
25: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
26: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
27: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
28: P_PROMPT_ABOVE in BNE_PARAM_LISTS_TL.PROMPT_ABOVE%type,
21: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
25: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
26: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
27: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
28: P_PROMPT_ABOVE in BNE_PARAM_LISTS_TL.PROMPT_ABOVE%type,
29: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type,
22: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
25: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
26: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
27: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
28: P_PROMPT_ABOVE in BNE_PARAM_LISTS_TL.PROMPT_ABOVE%type,
29: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type,
30: P_USER_TIP in BNE_PARAM_LISTS_TL.USER_TIP%type )
32: RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
33:
34:
35:
36: -- insert into BNE_PARAM_LISTS_B/_TL (minimal values required for insert)
37:
38: FUNCTION CREATE_PARAM_LIST_MINIMAL( P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
39: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
40: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type)
34:
35:
36: -- insert into BNE_PARAM_LISTS_B/_TL (minimal values required for insert)
37:
38: FUNCTION CREATE_PARAM_LIST_MINIMAL( P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
39: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
40: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type)
41:
42: RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
35:
36: -- insert into BNE_PARAM_LISTS_B/_TL (minimal values required for insert)
37:
38: FUNCTION CREATE_PARAM_LIST_MINIMAL( P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
39: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
40: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type)
41:
42: RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
43: