APPS.HR_LEGISLATION dependencies on PAY_MAGNETIC_RECORDS

Line 6300: from pay_magnetic_records

6296: BEGIN
6297:
6298: select distinct null
6299: into l_null_return
6300: from pay_magnetic_records
6301: where formula_id=stu_rec.formula_id
6302: and magnetic_block_id=stu_rec.magnetic_block_id
6303: and next_block_id=stu_rec.next_block_id
6304: and overflow_mode=stu_rec.overflow_mode

Line 6313: update pay_magnetic_records

6309: EXCEPTION WHEN NO_DATA_FOUND THEN
6310:
6311: IF p_phase = 1 THEN return; END IF;
6312:
6313: update pay_magnetic_records
6314: set formula_id=stu_rec.formula_id
6315: , next_block_id=stu_rec.next_block_id
6316: , overflow_mode=stu_rec.overflow_mode
6317: , frequency=stu_rec.frequency

Line 6329: insert into pay_magnetic_records

6325: -- No row there to update, must insert
6326:
6327:
6328: BEGIN
6329: insert into pay_magnetic_records
6330: ( formula_id ,
6331: magnetic_block_id ,
6332: next_block_id ,
6333: overflow_mode ,

Line 6347: hr_utility.trace('ins pay_magnetic_records');

6343: stu_rec.frequency ,
6344: stu_rec.last_run_executed_mode);
6345: EXCEPTION WHEN OTHERS THEN
6346: hrrunprc_trace_on;
6347: hr_utility.trace('ins pay_magnetic_records');
6348: hr_utility.trace('mag block id: ' ||
6349: to_char(stu_rec.magnetic_block_id));
6350: hr_utility.trace('next blk id: ' ||
6351: to_char(stu_rec.next_block_id));