APPS.PAY_TDF_INS dependencies on PAY_TIME_DEFINITIONS

Line 135: -- Insert the row into: pay_time_definitions

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

Line 137: insert into pay_time_definitions

133: pay_tdf_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: pay_time_definitions
136: --
137: insert into pay_time_definitions
138: (time_definition_id
139: ,short_name
140: ,definition_name
141: ,period_type

Line 239: Cursor C_Sel1 is select pay_time_definitions_s.nextval from sys.dual;

235: Procedure pre_insert
236: (p_rec in out nocopy pay_tdf_shd.g_rec_type
237: ) is
238: --
239: Cursor C_Sel1 is select pay_time_definitions_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from pay_time_definitions

Line 243: from pay_time_definitions

239: Cursor C_Sel1 is select pay_time_definitions_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from pay_time_definitions
244: where time_definition_id =
245: pay_tdf_ins.g_time_definition_id_i;
246: --
247: l_proc varchar2(72) := g_package||'pre_insert';

Line 265: fnd_message.set_token('TABLE_NAME','pay_time_definitions');

261: --
262: -- The primary key values are already in use.
263: --
264: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
265: fnd_message.set_token('TABLE_NAME','pay_time_definitions');
266: fnd_message.raise_error;
267: End If;
268: Close C_Sel2;
269: --

Line 380: (p_module_name => 'PAY_TIME_DEFINITIONS'

376: --
377: when hr_api.cannot_find_prog_unit then
378: --
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'PAY_TIME_DEFINITIONS'
381: ,p_hook_type => 'AI');
382: --
383: end;
384: --