APPS.HR_LEGISLATION dependencies on PAY_MAGNETIC_BLOCKS

Line 231: -- 115.51 divicker 26-JUL-2001 pay_magnetic_blocks fix for installing

227: -- def_bal_id but only those matching
228: -- the original balance_type_id as well
229: -- 115.49 divicker 19-JUL-2001 Version sync up
230: -- 115.50 divicker 26-JUL-2001 speed up sequence setting
231: -- 115.51 divicker 26-JUL-2001 pay_magnetic_blocks fix for installing
232: -- data over a previous install for APAC
233: -- 115.52 tbattoo 15-Aug-2001 fixed issue with check_seq on empty hr_s
234: -- tables.
235: -- 115.53 vmehta 25-Aug-2001 Removed calls to translate_us_ele_dev_df

Line 6020: from pay_magnetic_blocks a

6016: If cnt=0 then return; end if;
6017:
6018: select distinct null
6019: into l_null_return
6020: from pay_magnetic_blocks a
6021: where exists
6022: (select null
6023: from hr_s_magnetic_blocks b
6024: where a.magnetic_block_id = b.magnetic_block_id

Line 6049: from pay_magnetic_blocks;

6045: from hr_s_magnetic_blocks;
6046:
6047: select max(magnetic_block_id)
6048: into v_max_live
6049: from pay_magnetic_blocks;
6050:
6051: select pay_magnetic_blocks_s.nextval
6052: into v_sequence_number
6053: from dual;

Line 6051: select pay_magnetic_blocks_s.nextval

6047: select max(magnetic_block_id)
6048: into v_max_live
6049: from pay_magnetic_blocks;
6050:
6051: select pay_magnetic_blocks_s.nextval
6052: into v_sequence_number
6053: from dual;
6054:
6055: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 6060: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

6056: OR (v_sequence_number < v_max_live) THEN
6057:
6058: IF v_max_live > v_max_delivered THEN
6059:
6060: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
6061: v_sequence_number,
6062: v_max_live);
6063: ELSE
6064:

Line 6065: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

6061: v_sequence_number,
6062: v_max_live);
6063: ELSE
6064:
6065: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
6066: v_sequence_number,
6067: v_max_delivered);
6068: END IF;
6069: END IF;

Line 6086: insert_hr_stu_exceptions('pay_magnetic_blocks'

6082: BEGIN
6083:
6084: rollback to new_magnetic_blocks;
6085:
6086: insert_hr_stu_exceptions('pay_magnetic_blocks'
6087: , stu_rec.c_surrogate_key
6088: , exception_type
6089: , stu_rec.c_true_key);
6090:

Line 6108: from pay_magnetic_blocks

6104: BEGIN
6105:
6106: select distinct magnetic_block_id
6107: into l_new_surrogate_key
6108: from pay_magnetic_blocks
6109: where replace(ltrim(rtrim(upper(block_name))), ' ', '_') =
6110: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_')
6111: and replace(ltrim(rtrim(upper(report_format))), ' ', '_') =
6112: replace(ltrim(rtrim(upper(stu_rec.report_format))), ' ', '_')

Line 6118: select pay_magnetic_blocks_s.nextval

6114: replace(ltrim(rtrim(upper(nvl(stu_rec.cursor_name,'X')))), ' ', '_');
6115:
6116: EXCEPTION WHEN NO_DATA_FOUND THEN
6117:
6118: select pay_magnetic_blocks_s.nextval
6119: into l_new_surrogate_key
6120: from dual;
6121:
6122: WHEN TOO_MANY_ROWS THEN

Line 6182: from pay_magnetic_blocks

6178:
6179: BEGIN
6180: select distinct null
6181: into l_null_return
6182: from pay_magnetic_blocks
6183: where magnetic_block_id =l_new_surrogate_key
6184: and block_name = stu_rec.c_true_key
6185: and main_block_flag =stu_rec.main_block_flag
6186: and report_format =stu_rec.report_format

Line 6194: update pay_magnetic_blocks

6190: EXCEPTION WHEN NO_DATA_FOUND THEN
6191:
6192: IF p_phase = 1 THEN return; END IF;
6193:
6194: update pay_magnetic_blocks
6195: set block_name=stu_rec.c_true_key
6196: , main_block_flag=stu_rec.main_block_flag
6197: , report_format=stu_rec.report_format
6198: , cursor_name=stu_rec.cursor_name

Line 6207: insert into pay_magnetic_blocks

6203:
6204: -- No row there to update, must insert
6205:
6206: BEGIN
6207: insert into pay_magnetic_blocks
6208: ( magnetic_block_id ,
6209: block_name ,
6210: main_block_flag ,
6211: report_format ,