DBA Data[Home] [Help]

APPS.FF_FFN_INS dependencies on FF_FUNCTIONS

Line 135: -- Insert the row into: ff_functions

131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: ff_ffn_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: ff_functions
136: --
137: insert into ff_functions
138: (function_id
139: ,business_group_id

Line 137: insert into ff_functions

133: ff_ffn_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: ff_functions
136: --
137: insert into ff_functions
138: (function_id
139: ,business_group_id
140: ,legislation_code
141: ,class

Line 227: Cursor C_Sel1 is select ff_functions_s.nextval from sys.dual;

223: Procedure pre_insert
224: (p_rec in out nocopy ff_ffn_shd.g_rec_type
225: ) is
226: --
227: Cursor C_Sel1 is select ff_functions_s.nextval from sys.dual;
228: --
229: Cursor C_Sel2 is
230: Select null
231: from ff_functions

Line 231: from ff_functions

227: Cursor C_Sel1 is select ff_functions_s.nextval from sys.dual;
228: --
229: Cursor C_Sel2 is
230: Select null
231: from ff_functions
232: where function_id =
233: ff_ffn_ins.g_function_id_i;
234: --
235: l_proc varchar2(72) := g_package||'pre_insert';

Line 253: fnd_message.set_token('TABLE_NAME','ff_functions');

249: --
250: -- The primary key values are already in use.
251: --
252: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
253: fnd_message.set_token('TABLE_NAME','ff_functions');
254: fnd_message.raise_error;
255: End If;
256: Close C_Sel2;
257: --

Line 346: (p_module_name => 'FF_FUNCTIONS'

342: --
343: when hr_api.cannot_find_prog_unit then
344: --
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'FF_FUNCTIONS'
347: ,p_hook_type => 'AI');
348: --
349: end;
350: --