DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on HR_S_MAGNETIC_RECORDS

Line 5780: update hr_s_magnetic_records

5776:
5777: update hr_s_magnetic_blocks
5778: set magnetic_block_id=magnetic_block_id -50000000;
5779:
5780: update hr_s_magnetic_records
5781: set magnetic_block_id=magnetic_block_id -50000000;
5782:
5783: update hr_s_magnetic_records
5784: set next_block_id=next_block_id -50000000;

Line 5783: update hr_s_magnetic_records

5779:
5780: update hr_s_magnetic_records
5781: set magnetic_block_id=magnetic_block_id -50000000;
5782:
5783: update hr_s_magnetic_records
5784: set next_block_id=next_block_id -50000000;
5785:
5786: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
5787:

Line 5896: update hr_s_magnetic_records

5892: set key_value = to_char(l_new_surrogate_key)
5893: where key_value = to_char(stu_rec.c_surrogate_key)
5894: and key_name = 'MAGNETIC_BLOCK_ID';
5895:
5896: update hr_s_magnetic_records
5897: set magnetic_block_id = l_new_surrogate_key
5898: where magnetic_block_id = stu_rec.c_surrogate_key;
5899:
5900: update hr_s_magnetic_records

Line 5900: update hr_s_magnetic_records

5896: update hr_s_magnetic_records
5897: set magnetic_block_id = l_new_surrogate_key
5898: where magnetic_block_id = stu_rec.c_surrogate_key;
5899:
5900: update hr_s_magnetic_records
5901: set next_block_id= l_new_surrogate_key
5902: where next_block_id=stu_rec.c_surrogate_key;
5903:
5904: END update_uid;

Line 6024: from hr_s_magnetic_records;

6020: overflow_mode ,
6021: sequence ,
6022: frequency ,
6023: last_run_executed_mode
6024: from hr_s_magnetic_records;
6025:
6026: stu_rec stu%ROWTYPE;
6027:
6028:

Line 6034: delete from hr_s_magnetic_records

6030: ----------------
6031: IS
6032: -- Remove a row from either the startup tables or the installed tables
6033: BEGIN
6034: delete from hr_s_magnetic_records
6035: where magnetic_block_id = stu_rec.magnetic_block_id
6036: and sequence = stu_rec.sequence;
6037: END remove;
6038: