DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on HR_S_MAGNETIC_RECORDS

Line 6030: update hr_s_magnetic_records

6026:
6027: update hr_s_magnetic_blocks
6028: set magnetic_block_id=magnetic_block_id -50000000;
6029:
6030: update hr_s_magnetic_records
6031: set magnetic_block_id=magnetic_block_id -50000000;
6032:
6033: update hr_s_magnetic_records
6034: set next_block_id=next_block_id -50000000;

Line 6033: update hr_s_magnetic_records

6029:
6030: update hr_s_magnetic_records
6031: set magnetic_block_id=magnetic_block_id -50000000;
6032:
6033: update hr_s_magnetic_records
6034: set next_block_id=next_block_id -50000000;
6035:
6036: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
6037:

Line 6146: update hr_s_magnetic_records

6142: set key_value = to_char(l_new_surrogate_key)
6143: where key_value = to_char(stu_rec.c_surrogate_key)
6144: and key_name = 'MAGNETIC_BLOCK_ID';
6145:
6146: update hr_s_magnetic_records
6147: set magnetic_block_id = l_new_surrogate_key
6148: where magnetic_block_id = stu_rec.c_surrogate_key;
6149:
6150: update hr_s_magnetic_records

Line 6150: update hr_s_magnetic_records

6146: update hr_s_magnetic_records
6147: set magnetic_block_id = l_new_surrogate_key
6148: where magnetic_block_id = stu_rec.c_surrogate_key;
6149:
6150: update hr_s_magnetic_records
6151: set next_block_id= l_new_surrogate_key
6152: where next_block_id=stu_rec.c_surrogate_key;
6153:
6154: END update_uid;

Line 6274: from hr_s_magnetic_records;

6270: overflow_mode ,
6271: sequence ,
6272: frequency ,
6273: last_run_executed_mode
6274: from hr_s_magnetic_records;
6275:
6276: stu_rec stu%ROWTYPE;
6277:
6278:

Line 6284: delete from hr_s_magnetic_records

6280: ----------------
6281: IS
6282: -- Remove a row from either the startup tables or the installed tables
6283: BEGIN
6284: delete from hr_s_magnetic_records
6285: where magnetic_block_id = stu_rec.magnetic_block_id
6286: and sequence = stu_rec.sequence;
6287: END remove;
6288: