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.FF_LOAD_FTYPES_PKG dependencies on FF_FORMULA_TYPES

Line 13: -- Called from load row and will insert new rows into ff_formula_types table

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

Line 15: p_formula_type_name in ff_formula_types.formula_type_name%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

Line 16: ,p_type_description in ff_formula_types.type_description%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

Line 17: ,p_created_by in ff_formula_types.CREATED_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);

Line 18: ,p_creation_date in ff_formula_types.CREATION_DATE%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:

Line 19: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE

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

Line 20: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%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
24: Procedure update_formula_types(

Line 21: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%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(
25: p_formula_type_name in ff_formula_types.formula_type_name%TYPE

Line 23: -- Called from load row and will update existing rows in ff_formula_types table

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

Line 25: p_formula_type_name in ff_formula_types.formula_type_name%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);

Line 26: ,p_type_description in ff_formula_types.type_description%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:

Line 27: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE

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

Line 28: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE

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

Line 29: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);

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(

Line 34: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%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(
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......

Line 39: Function chk_formula_type_name(p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE) Return Number;

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;

Line 48: p_formula_type_name in ff_formula_types.formula_type_name%TYPE

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;

Line 49: ,p_type_description in ff_formula_types.type_description%TYPE

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

Line 55: l_created_by ff_formula_types.CREATED_BY%TYPE;

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;

Line 56: l_creation_date ff_formula_types.CREATION_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: --

Line 57: l_last_updated_by ff_formula_types.LAST_UPDATED_BY%TYPE;

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

Line 58: l_last_update_login ff_formula_types.LAST_UPDATE_LOGIN%TYPE;

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

Line 59: l_last_update_date ff_formula_types.LAST_UPDATE_DATE%TYPE;

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

Line 66: from ff_formula_types fft

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:

Line 117: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE

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;

Line 128: ,FF_FORMULA_TYPES fft

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

Line 162: -- Called from load row and will insert new rows into ff_formula_types table

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

Line 164: p_formula_type_name in ff_formula_types.formula_type_name%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

Line 165: ,p_type_description in ff_formula_types.type_description%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

Line 166: ,p_created_by in ff_formula_types.CREATED_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

Line 167: ,p_creation_date in ff_formula_types.CREATION_DATE%TYPE

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

Line 168: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE

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

Line 169: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%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
173:

Line 170: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is

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

Line 176: --Insert into ff_formula_types table

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

Line 177: Insert Into FF_FORMULA_TYPES(

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

Line 186: (FF_FORMULA_TYPES_S.NEXTVAL

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

Line 198: -- Called from load row and will update existing rows in ff_formula_types table

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

Line 200: p_formula_type_name in ff_formula_types.formula_type_name%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

Line 201: ,p_type_description in ff_formula_types.type_description%TYPE

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

Line 202: ,p_last_update_date in ff_formula_types.LAST_UPDATE_DATE%TYPE

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

Line 203: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE

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:

Line 204: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is

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

Line 211: Update ff_formula_types

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

Line 225: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE

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:

Line 230: l_formula_type_id FF_FORMULA_TYPES.formula_type_id%TYPE := 0;

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

Line 255: Function chk_formula_type_name(p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE)

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

Line 261: From FF_FORMULA_TYPES

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;