DBA Data[Home] [Help]

APPS.BNE_PARAMETER_UTILS dependencies on BNE_PARAM_LISTS_B

Line 7: -- DESCRIPTION: Inserts into BNE_PARAM_LISTS_B/_TL --

3:
4: ----------------------------------------------------------------------------------
5: -- FUNCTION: CREATE_PARAM_LIST_ALL --
6: -- --
7: -- DESCRIPTION: Inserts into BNE_PARAM_LISTS_B/_TL --
8: -- Parameters are the column values for these tables --
9: -- --
10: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LISTS_B.APPLICATION_ID --
11: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_CODE --

Line 10: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LISTS_B.APPLICATION_ID --

6: -- --
7: -- DESCRIPTION: Inserts into BNE_PARAM_LISTS_B/_TL --
8: -- Parameters are the column values for these tables --
9: -- --
10: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LISTS_B.APPLICATION_ID --
11: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_CODE --
12: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --

Line 11: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_CODE --

7: -- DESCRIPTION: Inserts into BNE_PARAM_LISTS_B/_TL --
8: -- Parameters are the column values for these tables --
9: -- --
10: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LISTS_B.APPLICATION_ID --
11: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_CODE --
12: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --
15: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID --

Line 13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --

9: -- --
10: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LISTS_B.APPLICATION_ID --
11: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_CODE --
12: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --
15: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID --
16: -- P_ATTRIBUTE_CODE = BNE_PARAM_LISTS_B.ATTRIBUTE_ID --
17: -- P_LIST_RESOLVER = BNE_PARAM_LISTS_B.LIST_RESOLVER --

Line 14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --

10: -- PARAMETERS: P_APPLICATION_ID = BNE_PARAM_LISTS_B.APPLICATION_ID --
11: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_CODE --
12: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --
15: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID --
16: -- P_ATTRIBUTE_CODE = BNE_PARAM_LISTS_B.ATTRIBUTE_ID --
17: -- P_LIST_RESOLVER = BNE_PARAM_LISTS_B.LIST_RESOLVER --
18: -- P_PROMPT_LEFT = BNE_PARAM_LISTS_TL.PROMPT_LEFT --

Line 15: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID --

11: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_CODE --
12: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --
15: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID --
16: -- P_ATTRIBUTE_CODE = BNE_PARAM_LISTS_B.ATTRIBUTE_ID --
17: -- P_LIST_RESOLVER = BNE_PARAM_LISTS_B.LIST_RESOLVER --
18: -- P_PROMPT_LEFT = BNE_PARAM_LISTS_TL.PROMPT_LEFT --
19: -- P_PROMPT_ABOVE = BNE_PARAM_LISTS_TL.PROMPT_ABOVE --

Line 16: -- P_ATTRIBUTE_CODE = BNE_PARAM_LISTS_B.ATTRIBUTE_ID --

12: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --
15: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID --
16: -- P_ATTRIBUTE_CODE = BNE_PARAM_LISTS_B.ATTRIBUTE_ID --
17: -- P_LIST_RESOLVER = BNE_PARAM_LISTS_B.LIST_RESOLVER --
18: -- P_PROMPT_LEFT = BNE_PARAM_LISTS_TL.PROMPT_LEFT --
19: -- P_PROMPT_ABOVE = BNE_PARAM_LISTS_TL.PROMPT_ABOVE --
20: -- P_USER_NAME = BNE_PARAM_LISTS_TL.USER_NAME --

Line 17: -- P_LIST_RESOLVER = BNE_PARAM_LISTS_B.LIST_RESOLVER --

13: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
14: -- P_COMMENTS = BNE_PARAM_LISTS_B.COMMENTS --
15: -- P_ATTRIBUTE_APP_ID = BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID --
16: -- P_ATTRIBUTE_CODE = BNE_PARAM_LISTS_B.ATTRIBUTE_ID --
17: -- P_LIST_RESOLVER = BNE_PARAM_LISTS_B.LIST_RESOLVER --
18: -- P_PROMPT_LEFT = BNE_PARAM_LISTS_TL.PROMPT_LEFT --
19: -- P_PROMPT_ABOVE = BNE_PARAM_LISTS_TL.PROMPT_ABOVE --
20: -- P_USER_NAME = BNE_PARAM_LISTS_TL.USER_NAME --
21: -- P_USER_TIP = BNE_PARAM_LISTS_TL.USER_TIP --

Line 33: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,

29: ----------------------------------------------------------------------------------
30:
31: -- all values for BNE_PARAM_LIST/_TL
32:
33: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
34: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,

Line 34: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,

30:
31: -- all values for BNE_PARAM_LIST/_TL
32:
33: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
34: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
38: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,

Line 35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,

31: -- all values for BNE_PARAM_LIST/_TL
32:
33: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
34: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
38: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
39: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,

Line 36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,

32:
33: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
34: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
38: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
39: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
40: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,

Line 37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,

33: FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
34: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
38: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
39: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
40: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
41: P_PROMPT_ABOVE in BNE_PARAM_LISTS_TL.PROMPT_ABOVE%type,

Line 38: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,

34: P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
38: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
39: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
40: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
41: P_PROMPT_ABOVE in BNE_PARAM_LISTS_TL.PROMPT_ABOVE%type,
42: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type,

Line 39: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,

35: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
36: P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
37: P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
38: P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
39: P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
40: P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
41: P_PROMPT_ABOVE in BNE_PARAM_LISTS_TL.PROMPT_ABOVE%type,
42: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type,
43: P_USER_TIP in BNE_PARAM_LISTS_TL.USER_TIP%type )

Line 47: VN_OBJECT_VERSION_NUM BNE_PARAM_LISTS_B.OBJECT_VERSION_NUMBER%type;

43: P_USER_TIP in BNE_PARAM_LISTS_TL.USER_TIP%type )
44:
45: RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type AS VN_KEY BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
46:
47: VN_OBJECT_VERSION_NUM BNE_PARAM_LISTS_B.OBJECT_VERSION_NUMBER%type;
48: VV_PARAM_LIST_CODE BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type;
49:
50: BEGIN
51: -- defaults

Line 48: VV_PARAM_LIST_CODE BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type;

44:
45: RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type AS VN_KEY BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
46:
47: VN_OBJECT_VERSION_NUM BNE_PARAM_LISTS_B.OBJECT_VERSION_NUMBER%type;
48: VV_PARAM_LIST_CODE BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type;
49:
50: BEGIN
51: -- defaults
52:

Line 62: INSERT INTO BNE_PARAM_LISTS_B ( APPLICATION_ID,

58: -- create the key
59: VN_KEY := P_APPLICATION_ID || ':' || VV_PARAM_LIST_CODE;
60:
61:
62: INSERT INTO BNE_PARAM_LISTS_B ( APPLICATION_ID,
63: PARAM_LIST_CODE,
64: OBJECT_VERSION_NUMBER,
65: PERSISTENT_FLAG,
66: COMMENTS,

Line 127: -- DESCRIPTION: Inserts into BNE_PARAM_LISTS_B/_TL --

123:
124: --------------------------------------------------------------------------------
125: -- FUNCTION: CREATE_PARAM_LIST_MINIMAL --
126: -- --
127: -- DESCRIPTION: Inserts into BNE_PARAM_LISTS_B/_TL --
128: -- Parameters are the not NULL values for these tables --
129: -- Uses FND_GLOBAL.RESP_APPL_ID for the APPLICATION_ID --
130: -- --
131: -- PARAMETERS: --

Line 132: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_ID --

128: -- Parameters are the not NULL values for these tables --
129: -- Uses FND_GLOBAL.RESP_APPL_ID for the APPLICATION_ID --
130: -- --
131: -- PARAMETERS: --
132: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_ID --
133: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
134: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
135: -- --
136: -- --

Line 134: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --

130: -- --
131: -- PARAMETERS: --
132: -- P_PARAM_LIST_CODE = BNE_PARAM_LISTS_B.PARAM_LIST_ID --
133: -- P_PARAM_LIST_NAME = BNE_PARAM_LISTS_TL.PARAM_LIST_NAME --
134: -- P_PERSISTENT = BNE_PARAM_LISTS_B.PERSISTENT_FLAG --
135: -- --
136: -- --
137: -- RETURN: parameter list key. E.g. 101:CODE --
138: -- --

Line 147: FUNCTION CREATE_PARAM_LIST_MINIMAL( P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,

143: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
144: --------------------------------------------------------------------------------
145:
146:
147: FUNCTION CREATE_PARAM_LIST_MINIMAL( P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
148: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
149: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type)
150:
151: RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type as VN_KEY BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;

Line 148: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,

144: --------------------------------------------------------------------------------
145:
146:
147: FUNCTION CREATE_PARAM_LIST_MINIMAL( P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
148: P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
149: P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type)
150:
151: RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type as VN_KEY BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
152: