[Home] [Help]
720: fnd_file.put_line(fnd_file.log,substr('Error in rangecode '
721: ||sqlerrm(sqlcode),1,80));
722:
723: -- Return cursor that selects no rows
724: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
725: end range_cursor;
726: ------------------------------function check_action-----------------------------
727: -- Function checks if assignment action already created for the payroll action
728: -- and assignment
1073: if l_arch then
1074: -- hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
1075: select pay_assignment_actions_s.nextval
1076: into l_ass_act_id
1077: from dual;
1078: --
1079: -- insert into pay_assignment_actions.
1080: hr_nonrun_asact.insact(l_ass_act_id,
1081: asg_rec.assignment_id,
1094: if l_arch then
1095: -- hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
1096: select pay_assignment_actions_s.nextval
1097: into l_ass_act_id
1098: from dual;
1099: --
1100: -- insert into pay_assignment_actions.
1101: hr_nonrun_asact.insact(l_ass_act_id,
1102: asg_rec.assignment_id,
1568: if l_staff_rec.ethnic_code is not null then
1569: begin
1570: select 'Y'
1571: into l_valid_ethnic_code
1572: from dual
1573: where exists
1574: (select lookup_code
1575: from hr_lookups hl
1576: where hl.lookup_type = 'UK_ETHNIC_CODES'
1628: if l_qts_route is not null then
1629: begin
1630: select 'Y'
1631: into l_valid_ethnic_code
1632: from dual
1633: where exists(select lookup_code
1634: from hr_lookups hl
1635: where hl.lookup_type = 'PQP_GB_SWF_QTS_ROUTES'
1636: and hl.enabled_flag = 'Y'
2985: if l_contract_agg_type is not null then
2986: begin
2987: select 'Y'
2988: into l_valid_flag
2989: from dual
2990: where exists(select lookup_code
2991: from hr_lookups hl
2992: where hl.lookup_type = 'PQP_GB_SWF_CNTRCT_AGRMNT_TYPES'
2993: and hl.enabled_flag = 'Y'
3282: if l_dcsf_destination is not null then
3283: begin
3284: select 'Y'
3285: into l_valid_flag
3286: from dual
3287: where exists
3288: (select lookup_code
3289: from hr_lookups hl
3290: where hl.lookup_type = 'PQP_GB_SWF_DESTINATION_CODES'
3309: if l_dcsf_origin is not null then
3310: begin
3311: select 'Y'
3312: into l_valid_flag
3313: from dual
3314: where exists
3315: (select lookup_code
3316: from hr_lookups hl
3317: where hl.lookup_type = 'PQP_GB_SWF_ORIGIN_CODES'
3807: if l_reg_spinal_point_dcsf is not null then
3808: begin
3809: select 'Y'
3810: into l_valid_flag
3811: from dual
3812: where exists
3813: (select lookup_code
3814: from hr_lookups hl
3815: where hl.lookup_type = 'PQP_GB_REGIONAL_SPINE_CODE'
3834: if l_spinal_point_dcsf is not null then
3835: begin
3836: select 'Y'
3837: into l_valid_flag
3838: from dual
3839: where exists
3840: (select lookup_code
3841: from hr_lookups hl
3842: where hl.lookup_type = 'PQP_GB_DCSF_SPINE_POINTS'