APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on DUAL

Line 746: from dual;

742: 0, DECODE(INSTR(l_leg_param, p_token), 0, .5, LENGTH(l_leg_param)),
743: INSTR(l_leg_param, ' ', INSTR(l_leg_param, p_token))
744: - (INSTR(l_leg_param, p_token) + (LENGTH(p_token) + 1)))))
745: into l_ret
746: from dual;
747: return l_ret; */
748: x := instr(l_leg_param,p_token);
749: y := length(p_token);
750: if instr(l_leg_param, ' ', x) <> 0 then

Line 887: FROM DUAL;

883: THEN
884: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
885: SELECT pay_assignment_actions_s.NEXTVAL
886: INTO l_actid
887: FROM DUAL;
888:
889: hr_utility.set_location('Archive assignment Action ', 30);
890: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
891: l_prev_assignment_id := csr_rec.assignment_id;

Line 919: FROM DUAL;

915: THEN
916: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
917: SELECT pay_assignment_actions_s.NEXTVAL
918: INTO l_actid
919: FROM DUAL;
920:
921: hr_utility.set_location('Archive assignment Action ', 30);
922: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
923: l_prev_assignment_id := csr_rec.assignment_id;

Line 952: FROM DUAL;

948: THEN
949: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
950: SELECT pay_assignment_actions_s.NEXTVAL
951: INTO l_actid
952: FROM DUAL;
953: hr_utility.set_location('Archive assignment Action ', 30);
954: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
955: l_prev_assignment_id := csr_rec.assignment_id;
956: hr_utility.TRACE(' Created Assignment action ');

Line 2607: from dual;

2603: close csr_ni;
2604:
2605: select hr_gb_utility.ni_validate(l_nat_number,p_eff_date)
2606: into l_var_value
2607: from dual;
2608:
2609: if l_var_value <> 0 then
2610: -- Setup warning message
2611: l_warn:=1;

Line 4261: select length(l_msg) into l_msg_length from dual;

4257: l_count number;
4258: l_temp number;
4259: l_pos number;
4260: BEGIN
4261: select length(l_msg) into l_msg_length from dual;
4262: l_first := true;
4263: while l_msg_length > 57 loop
4264: l_count := 1;
4265: l_pos := 0;

Line 4269: select instr(l_msg,' ',1,l_count) into l_temp from dual;

4265: l_pos := 0;
4266: l_temp := 1;
4267: while l_temp > 0 and l_temp < 56 loop
4268: l_pos := l_temp;
4269: select instr(l_msg,' ',1,l_count) into l_temp from dual;
4270: l_count := l_count + 1;
4271: end loop;
4272: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4273: select length(l_msg) into l_msg_length from dual;

Line 4272: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;

4268: l_pos := l_temp;
4269: select instr(l_msg,' ',1,l_count) into l_temp from dual;
4270: l_count := l_count + 1;
4271: end loop;
4272: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4273: select length(l_msg) into l_msg_length from dual;
4274: if l_first then
4275: l_first := false;
4276: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||

Line 4273: select length(l_msg) into l_msg_length from dual;

4269: select instr(l_msg,' ',1,l_count) into l_temp from dual;
4270: l_count := l_count + 1;
4271: end loop;
4272: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4273: select length(l_msg) into l_msg_length from dual;
4274: if l_first then
4275: l_first := false;
4276: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||
4277: rpad(p_emp_no, 17) || ' ' ||