DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_MAGNETIC_RECORDS

Line 6050: from pay_magnetic_records

6046: BEGIN
6047:
6048: select distinct null
6049: into l_null_return
6050: from pay_magnetic_records
6051: where formula_id=stu_rec.formula_id
6052: and magnetic_block_id=stu_rec.magnetic_block_id
6053: and next_block_id=stu_rec.next_block_id
6054: and overflow_mode=stu_rec.overflow_mode

Line 6063: update pay_magnetic_records

6059: EXCEPTION WHEN NO_DATA_FOUND THEN
6060:
6061: IF p_phase = 1 THEN return; END IF;
6062:
6063: update pay_magnetic_records
6064: set formula_id=stu_rec.formula_id
6065: , next_block_id=stu_rec.next_block_id
6066: , overflow_mode=stu_rec.overflow_mode
6067: , frequency=stu_rec.frequency

Line 6079: insert into pay_magnetic_records

6075: -- No row there to update, must insert
6076:
6077:
6078: BEGIN
6079: insert into pay_magnetic_records
6080: ( formula_id ,
6081: magnetic_block_id ,
6082: next_block_id ,
6083: overflow_mode ,

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

6093: stu_rec.frequency ,
6094: stu_rec.last_run_executed_mode);
6095: EXCEPTION WHEN OTHERS THEN
6096: hrrunprc_trace_on;
6097: hr_utility.trace('ins pay_magnetic_records');
6098: hr_utility.trace('mag block id: ' ||
6099: to_char(stu_rec.magnetic_block_id));
6100: hr_utility.trace('next blk id: ' ||
6101: to_char(stu_rec.next_block_id));