DBA Data[Home] [Help]

APPS.FF_FCU_INS dependencies on FF_FUNCTION_CONTEXT_USAGES

Line 90: -- Insert the row into: ff_function_context_usages

86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: ff_fcu_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ff_function_context_usages
91: --
92: insert into ff_function_context_usages
93: (function_id
94: ,sequence_number

Line 92: insert into ff_function_context_usages

88: ff_fcu_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ff_function_context_usages
91: --
92: insert into ff_function_context_usages
93: (function_id
94: ,sequence_number
95: ,context_id
96: ,object_version_number

Line 170: -- Cursor C_Sel1 is select ff_function_context_usages_s.nextval from sys.dual;

166: Procedure pre_insert
167: (p_rec in out nocopy ff_fcu_shd.g_rec_type
168: ) is
169: --
170: -- Cursor C_Sel1 is select ff_function_context_usages_s.nextval from sys.dual;
171: Cursor C_Sel1 is
172: select nvl(max(sequence_number) + 1, 1)
173: from ff_function_context_usages
174: where function_id = p_rec.function_id;

Line 173: from ff_function_context_usages

169: --
170: -- Cursor C_Sel1 is select ff_function_context_usages_s.nextval from sys.dual;
171: Cursor C_Sel1 is
172: select nvl(max(sequence_number) + 1, 1)
173: from ff_function_context_usages
174: where function_id = p_rec.function_id;
175:
176: --
177: Cursor C_Sel2 is

Line 179: from ff_function_context_usages

175:
176: --
177: Cursor C_Sel2 is
178: Select null
179: from ff_function_context_usages
180: where function_id =
181: ff_fcu_ins.g_function_id_i
182: or sequence_number =
183: ff_fcu_ins.g_sequence_number_i;

Line 204: fnd_message.set_token('TABLE_NAME','ff_function_context_usages');

200: --
201: -- The primary key values are already in use.
202: --
203: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
204: fnd_message.set_token('TABLE_NAME','ff_function_context_usages');
205: fnd_message.raise_error;
206: End If;
207: Close C_Sel2;
208: --

Line 286: (p_module_name => 'FF_FUNCTION_CONTEXT_USAGES'

282: --
283: when hr_api.cannot_find_prog_unit then
284: --
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'FF_FUNCTION_CONTEXT_USAGES'
287: ,p_hook_type => 'AI');
288: --
289: end;
290: --