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 5770: from pay_magnetic_blocks a

5766: If cnt=0 then return; end if;
5767:
5768: select distinct null
5769: into l_null_return
5770: from pay_magnetic_blocks a
5771: where exists
5772: (select null
5773: from hr_s_magnetic_blocks b
5774: where a.magnetic_block_id = b.magnetic_block_id

Line 5799: from pay_magnetic_blocks;

5795: from hr_s_magnetic_blocks;
5796:
5797: select max(magnetic_block_id)
5798: into v_max_live
5799: from pay_magnetic_blocks;
5800:
5801: select pay_magnetic_blocks_s.nextval
5802: into v_sequence_number
5803: from dual;

Line 5801: select pay_magnetic_blocks_s.nextval

5797: select max(magnetic_block_id)
5798: into v_max_live
5799: from pay_magnetic_blocks;
5800:
5801: select pay_magnetic_blocks_s.nextval
5802: into v_sequence_number
5803: from dual;
5804:
5805: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 5810: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

5806: OR (v_sequence_number < v_max_live) THEN
5807:
5808: IF v_max_live > v_max_delivered THEN
5809:
5810: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
5811: v_sequence_number,
5812: v_max_live);
5813: ELSE
5814:

Line 5815: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

5811: v_sequence_number,
5812: v_max_live);
5813: ELSE
5814:
5815: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
5816: v_sequence_number,
5817: v_max_delivered);
5818: END IF;
5819: END IF;

Line 5836: insert_hr_stu_exceptions('pay_magnetic_blocks'

5832: BEGIN
5833:
5834: rollback to new_magnetic_blocks;
5835:
5836: insert_hr_stu_exceptions('pay_magnetic_blocks'
5837: , stu_rec.c_surrogate_key
5838: , exception_type
5839: , stu_rec.c_true_key);
5840:

Line 5858: from pay_magnetic_blocks

5854: BEGIN
5855:
5856: select distinct magnetic_block_id
5857: into l_new_surrogate_key
5858: from pay_magnetic_blocks
5859: where replace(ltrim(rtrim(upper(block_name))), ' ', '_') =
5860: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_')
5861: and replace(ltrim(rtrim(upper(report_format))), ' ', '_') =
5862: replace(ltrim(rtrim(upper(stu_rec.report_format))), ' ', '_')

Line 5868: select pay_magnetic_blocks_s.nextval

5864: replace(ltrim(rtrim(upper(nvl(stu_rec.cursor_name,'X')))), ' ', '_');
5865:
5866: EXCEPTION WHEN NO_DATA_FOUND THEN
5867:
5868: select pay_magnetic_blocks_s.nextval
5869: into l_new_surrogate_key
5870: from dual;
5871:
5872: WHEN TOO_MANY_ROWS THEN

Line 5932: from pay_magnetic_blocks

5928:
5929: BEGIN
5930: select distinct null
5931: into l_null_return
5932: from pay_magnetic_blocks
5933: where magnetic_block_id =l_new_surrogate_key
5934: and block_name = stu_rec.c_true_key
5935: and main_block_flag =stu_rec.main_block_flag
5936: and report_format =stu_rec.report_format

Line 5944: update pay_magnetic_blocks

5940: EXCEPTION WHEN NO_DATA_FOUND THEN
5941:
5942: IF p_phase = 1 THEN return; END IF;
5943:
5944: update pay_magnetic_blocks
5945: set block_name=stu_rec.c_true_key
5946: , main_block_flag=stu_rec.main_block_flag
5947: , report_format=stu_rec.report_format
5948: , cursor_name=stu_rec.cursor_name

Line 5957: insert into pay_magnetic_blocks

5953:
5954: -- No row there to update, must insert
5955:
5956: BEGIN
5957: insert into pay_magnetic_blocks
5958: ( magnetic_block_id ,
5959: block_name ,
5960: main_block_flag ,
5961: report_format ,