APPS.PAY_RAN_INS dependencies on PAY_RANGES_F

Line 87: -- Insert the row into: pay_ranges_f

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: pay_ranges_f
88: --
89: insert into pay_ranges_f
90: (range_id
91: ,range_table_id

Line 89: insert into pay_ranges_f

85: --
86: --
87: -- Insert the row into: pay_ranges_f
88: --
89: insert into pay_ranges_f
90: (range_id
91: ,range_table_id
92: ,low_band
93: ,high_band

Line 189: Cursor C_Sel1 is select pay_ranges_f_s.nextval from sys.dual;

185: Procedure pre_insert
186: (p_rec in out nocopy pay_ran_shd.g_rec_type
187: ) is
188: --
189: Cursor C_Sel1 is select pay_ranges_f_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from pay_ranges_f

Line 193: from pay_ranges_f

189: Cursor C_Sel1 is select pay_ranges_f_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from pay_ranges_f
194: where range_id =
195: pay_ran_ins.g_range_id_i;
196: --
197: l_proc varchar2(72) := g_package||'pre_insert';

Line 215: fnd_message.set_token('TABLE_NAME','pay_ranges_f');

211: --
212: -- The primary key values are already in use.
213: --
214: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
215: fnd_message.set_token('TABLE_NAME','pay_ranges_f');
216: fnd_message.raise_error;
217: End If;
218: Close C_Sel2;
219: --

Line 306: (p_module_name => 'PAY_RANGES_F'

302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'PAY_RANGES_F'
307: ,p_hook_type => 'AI');
308: --
309: end;
310: --