9: --
10: -- ----------------------------------------------------------------------------
11: -- | Private Procedures |
12: -- ----------------------------------------------------------------------------
13: -- Called from load row and will insert new rows into ff_formula_types table
14: Procedure insert_formula_types(
15: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
16: ,p_type_description in ff_formula_types.type_description%TYPE
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
11: -- | Private Procedures |
12: -- ----------------------------------------------------------------------------
13: -- Called from load row and will insert new rows into ff_formula_types table
14: Procedure insert_formula_types(
15: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
16: ,p_type_description in ff_formula_types.type_description%TYPE
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
18: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
12: -- ----------------------------------------------------------------------------
13: -- Called from load row and will insert new rows into ff_formula_types table
14: Procedure insert_formula_types(
15: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
16: ,p_type_description in ff_formula_types.type_description%TYPE
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
18: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
13: -- Called from load row and will insert new rows into ff_formula_types table
14: Procedure insert_formula_types(
15: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
16: ,p_type_description in ff_formula_types.type_description%TYPE
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
18: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
14: Procedure insert_formula_types(
15: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
16: ,p_type_description in ff_formula_types.type_description%TYPE
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
18: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
22:
15: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
16: ,p_type_description in ff_formula_types.type_description%TYPE
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
18: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
22:
23: -- Called from load row and will update existing rows in ff_formula_types table
16: ,p_type_description in ff_formula_types.type_description%TYPE
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
18: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
22:
23: -- Called from load row and will update existing rows in ff_formula_types table
24: Procedure update_formula_types(
17: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
18: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
22:
23: -- Called from load row and will update existing rows in ff_formula_types table
24: Procedure update_formula_types(
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
22:
23: -- Called from load row and will update existing rows in ff_formula_types table
24: Procedure update_formula_types(
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
26: ,p_type_description in ff_formula_types.type_description%TYPE
27: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
22:
23: -- Called from load row and will update existing rows in ff_formula_types table
24: Procedure update_formula_types(
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
26: ,p_type_description in ff_formula_types.type_description%TYPE
27: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
28: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
29: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
22:
23: -- Called from load row and will update existing rows in ff_formula_types table
24: Procedure update_formula_types(
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
26: ,p_type_description in ff_formula_types.type_description%TYPE
27: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
28: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
29: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
30:
23: -- Called from load row and will update existing rows in ff_formula_types table
24: Procedure update_formula_types(
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
26: ,p_type_description in ff_formula_types.type_description%TYPE
27: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
28: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
29: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
30:
31: -- Called from load_row_context_usages and will insert new rows
24: Procedure update_formula_types(
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
26: ,p_type_description in ff_formula_types.type_description%TYPE
27: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
28: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
29: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
30:
31: -- Called from load_row_context_usages and will insert new rows
32: -- into FF_FTYPE_CONTEXT_USAGES table
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
26: ,p_type_description in ff_formula_types.type_description%TYPE
27: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
28: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
29: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
30:
31: -- Called from load_row_context_usages and will insert new rows
32: -- into FF_FTYPE_CONTEXT_USAGES table
33: Procedure insert_fcontext_usages(
30:
31: -- Called from load_row_context_usages and will insert new rows
32: -- into FF_FTYPE_CONTEXT_USAGES table
33: Procedure insert_fcontext_usages(
34: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE
35: ,p_context_name in FF_CONTEXTS.context_name%TYPE);
36:
37: -- Called from insert_fcontext_usages and will
38: -- check if the formula type id is valid one......
35: ,p_context_name in FF_CONTEXTS.context_name%TYPE);
36:
37: -- Called from insert_fcontext_usages and will
38: -- check if the formula type id is valid one......
39: Function chk_formula_type_name(p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE) Return Number;
40:
41: -- Called from insert_fcontext_usages and will
42: -- check if the context is valid one......
43: Function chk_context_name(p_context_name in FF_CONTEXTS.context_name%TYPE) Return Number;
44: -- ----------------------------------------------------------------------------
45: -- |---------------------------< LOAD_ROW >------------------------------------|
46: -- ----------------------------------------------------------------------------
47: Procedure load_row (
48: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
49: ,p_type_description in ff_formula_types.type_description%TYPE
50: ) is
51: --
52: l_existing_form_id number;
45: -- |---------------------------< LOAD_ROW >------------------------------------|
46: -- ----------------------------------------------------------------------------
47: Procedure load_row (
48: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
49: ,p_type_description in ff_formula_types.type_description%TYPE
50: ) is
51: --
52: l_existing_form_id number;
53: --WHO variables
51: --
52: l_existing_form_id number;
53: --WHO variables
54: l_sysdate date := sysdate;
55: l_created_by ff_formula_types.CREATED_BY%TYPE;
56: l_creation_date ff_formula_types.CREATION_DATE%TYPE;
57: l_last_updated_by ff_formula_types.LAST_UPDATED_BY%TYPE;
58: l_last_update_login ff_formula_types.LAST_UPDATE_LOGIN%TYPE;
59: l_last_update_date ff_formula_types.LAST_UPDATE_DATE%TYPE;
52: l_existing_form_id number;
53: --WHO variables
54: l_sysdate date := sysdate;
55: l_created_by ff_formula_types.CREATED_BY%TYPE;
56: l_creation_date ff_formula_types.CREATION_DATE%TYPE;
57: l_last_updated_by ff_formula_types.LAST_UPDATED_BY%TYPE;
58: l_last_update_login ff_formula_types.LAST_UPDATE_LOGIN%TYPE;
59: l_last_update_date ff_formula_types.LAST_UPDATE_DATE%TYPE;
60: --
53: --WHO variables
54: l_sysdate date := sysdate;
55: l_created_by ff_formula_types.CREATED_BY%TYPE;
56: l_creation_date ff_formula_types.CREATION_DATE%TYPE;
57: l_last_updated_by ff_formula_types.LAST_UPDATED_BY%TYPE;
58: l_last_update_login ff_formula_types.LAST_UPDATE_LOGIN%TYPE;
59: l_last_update_date ff_formula_types.LAST_UPDATE_DATE%TYPE;
60: --
61: l_proc varchar2(100) := g_package || 'load_row';
54: l_sysdate date := sysdate;
55: l_created_by ff_formula_types.CREATED_BY%TYPE;
56: l_creation_date ff_formula_types.CREATION_DATE%TYPE;
57: l_last_updated_by ff_formula_types.LAST_UPDATED_BY%TYPE;
58: l_last_update_login ff_formula_types.LAST_UPDATE_LOGIN%TYPE;
59: l_last_update_date ff_formula_types.LAST_UPDATE_DATE%TYPE;
60: --
61: l_proc varchar2(100) := g_package || 'load_row';
62: --
55: l_created_by ff_formula_types.CREATED_BY%TYPE;
56: l_creation_date ff_formula_types.CREATION_DATE%TYPE;
57: l_last_updated_by ff_formula_types.LAST_UPDATED_BY%TYPE;
58: l_last_update_login ff_formula_types.LAST_UPDATE_LOGIN%TYPE;
59: l_last_update_date ff_formula_types.LAST_UPDATE_DATE%TYPE;
60: --
61: l_proc varchar2(100) := g_package || 'load_row';
62: --
63: --Cursor to see if the existing formula type is updated.....
62: --
63: --Cursor to see if the existing formula type is updated.....
64: cursor csr_existing is
65: select fft.formula_type_id
66: from ff_formula_types fft
67: where fft.formula_type_name = p_formula_type_name;
68:
69: BEGIN
70:
113: -- -------------------------------------------------------------------------------------------
114: -- |---------------------------< load_row_context_usages >------------------------------------|
115: -- -------------------------------------------------------------------------------------------
116: Procedure load_row_context_usages (
117: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE
118: ,p_context_name in FF_CONTEXTS.context_name%TYPE)
119: is
120: --
121: l_exist_form_con_id number;
124: --Cursor to see if the formula type context usage is existing.....
125: Cursor csr_existing IS
126: SELECT fcu.FORMULA_TYPE_ID
127: FROM FF_FTYPE_CONTEXT_USAGES fcu
128: ,FF_FORMULA_TYPES fft
129: ,FF_CONTEXTS fco
130: WHERE fcu.FORMULA_TYPE_ID = fft.FORMULA_TYPE_ID
131: AND fcu.context_id = fco.context_id
132: AND fft.FORMULA_TYPE_NAME = p_formula_type_name
158: --
159: -- ----------------------------------------------------------------------------
160: -- | Private Procedures |
161: -- ----------------------------------------------------------------------------
162: -- Called from load row and will insert new rows into ff_formula_types table
163: Procedure insert_formula_types(
164: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
165: ,p_type_description in ff_formula_types.type_description%TYPE
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
160: -- | Private Procedures |
161: -- ----------------------------------------------------------------------------
162: -- Called from load row and will insert new rows into ff_formula_types table
163: Procedure insert_formula_types(
164: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
165: ,p_type_description in ff_formula_types.type_description%TYPE
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
161: -- ----------------------------------------------------------------------------
162: -- Called from load row and will insert new rows into ff_formula_types table
163: Procedure insert_formula_types(
164: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
165: ,p_type_description in ff_formula_types.type_description%TYPE
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
169: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
162: -- Called from load row and will insert new rows into ff_formula_types table
163: Procedure insert_formula_types(
164: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
165: ,p_type_description in ff_formula_types.type_description%TYPE
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
169: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
170: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
163: Procedure insert_formula_types(
164: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
165: ,p_type_description in ff_formula_types.type_description%TYPE
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
169: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
170: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
171: l_proc varchar2(100) := g_package || 'insert_formula_types';
164: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
165: ,p_type_description in ff_formula_types.type_description%TYPE
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
169: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
170: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
171: l_proc varchar2(100) := g_package || 'insert_formula_types';
172: Begin
165: ,p_type_description in ff_formula_types.type_description%TYPE
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
169: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
170: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
171: l_proc varchar2(100) := g_package || 'insert_formula_types';
172: Begin
173:
166: ,p_created_by in ff_formula_types.CREATED_BY%TYPE
167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE
168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
169: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
170: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
171: l_proc varchar2(100) := g_package || 'insert_formula_types';
172: Begin
173:
174: --
172: Begin
173:
174: --
175: hr_utility.set_location('Entering:'|| l_proc, 10);
176: --Insert into ff_formula_types table
177: Insert Into FF_FORMULA_TYPES(
178: FORMULA_TYPE_ID
179: ,FORMULA_TYPE_NAME
180: ,TYPE_DESCRIPTION
173:
174: --
175: hr_utility.set_location('Entering:'|| l_proc, 10);
176: --Insert into ff_formula_types table
177: Insert Into FF_FORMULA_TYPES(
178: FORMULA_TYPE_ID
179: ,FORMULA_TYPE_NAME
180: ,TYPE_DESCRIPTION
181: ,LAST_UPDATE_DATE
182: ,LAST_UPDATED_BY
183: ,LAST_UPDATE_LOGIN
184: ,CREATED_BY
185: ,CREATION_DATE) Values
186: (FF_FORMULA_TYPES_S.NEXTVAL
187: ,p_formula_type_name
188: ,p_type_description
189: ,p_last_update_date
190: ,p_last_updated_by
194: --
195: hr_utility.set_location('Leaving:'|| l_proc, 20);
196: End insert_formula_types;
197: --
198: -- Called from load row and will update existing rows in ff_formula_types table
199: Procedure update_formula_types(
200: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
201: ,p_type_description in ff_formula_types.type_description%TYPE
202: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
196: End insert_formula_types;
197: --
198: -- Called from load row and will update existing rows in ff_formula_types table
199: Procedure update_formula_types(
200: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
201: ,p_type_description in ff_formula_types.type_description%TYPE
202: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
203: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
204: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
197: --
198: -- Called from load row and will update existing rows in ff_formula_types table
199: Procedure update_formula_types(
200: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
201: ,p_type_description in ff_formula_types.type_description%TYPE
202: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
203: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
204: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
205: --
198: -- Called from load row and will update existing rows in ff_formula_types table
199: Procedure update_formula_types(
200: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
201: ,p_type_description in ff_formula_types.type_description%TYPE
202: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
203: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
204: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
205: --
206: l_proc varchar2(100) := g_package || 'update_formula_types';
199: Procedure update_formula_types(
200: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
201: ,p_type_description in ff_formula_types.type_description%TYPE
202: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
203: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
204: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
205: --
206: l_proc varchar2(100) := g_package || 'update_formula_types';
207:
200: p_formula_type_name in ff_formula_types.formula_type_name%TYPE
201: ,p_type_description in ff_formula_types.type_description%TYPE
202: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE
203: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
204: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
205: --
206: l_proc varchar2(100) := g_package || 'update_formula_types';
207:
208: Begin
207:
208: Begin
209: hr_utility.set_location('Entering:'|| l_proc, 10);
210: --
211: Update ff_formula_types
212: set type_description = p_type_description
213: ,last_update_date = p_last_update_date
214: ,last_updated_by = p_last_updated_by
215: ,last_update_login = p_last_update_login
221:
222: --
223: -- Called from load_row_context_usages and will insert new rows into FF_FTYPE_CONTEXT_USAGES table
224: Procedure insert_fcontext_usages(
225: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE
226: ,p_context_name in FF_CONTEXTS.context_name%TYPE) IS
227:
228: l_proc varchar2(100) := g_package || 'insert_fcontext_usages';
229:
226: ,p_context_name in FF_CONTEXTS.context_name%TYPE) IS
227:
228: l_proc varchar2(100) := g_package || 'insert_fcontext_usages';
229:
230: l_formula_type_id FF_FORMULA_TYPES.formula_type_id%TYPE := 0;
231: l_context_id FF_CONTEXTS.context_name%TYPE := 0;
232: Begin
233: hr_utility.set_location('Entering:'|| l_proc, 10);
234: --Check if the formula type id is valid one......
251: --
252:
253: -- Called from insert_fcontext_usages and will
254: -- check if the formula type id is valid one, also will return the formula_type_id......
255: Function chk_formula_type_name(p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE)
256: Return Number
257: IS
258: --Cursor to see if the formula_type_id exists
259: Cursor csr_ftype_id Is
257: IS
258: --Cursor to see if the formula_type_id exists
259: Cursor csr_ftype_id Is
260: Select formula_type_id
261: From FF_FORMULA_TYPES
262: Where formula_type_name = p_formula_type_name;
263:
264: --local variable
265: l_formula_type_id NUMBER;