436: LOOP
437: OPEN next_action_id;
438: FETCH next_action_id into v_next_action_id;
439: CLOSE next_action_id;
440: hr_nonrun_asact.insact(v_next_action_id,
441: csr_rec.assignment_id,
442: p_payroll_action_id,
443: p_chunk,
444: null);
441: csr_rec.assignment_id,
442: p_payroll_action_id,
443: p_chunk,
444: null);
445: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
446: IF g_debug
447: THEN
448: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
449: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
461: open next_action_id;
462: fetch next_action_id into v_next_action_id;
463: close next_action_id;
464: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);
465: hr_nonrun_asact.insact(v_next_action_id,
466: process_rec.assignment_id,
467: p_payroll_action_id,
468: p_chunk,
469: null);
467: p_payroll_action_id,
468: p_chunk,
469: null);
470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
475: end loop;
469: null);
470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
475: end loop;
476: hr_utility.set_location('End of assignment_action_code',5);
477: END IF;
470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
475: end loop;
476: hr_utility.set_location('End of assignment_action_code',5);
477: END IF;
478:
491:
492: OPEN next_action_id;
493: FETCH next_action_id into v_next_action_id;
494: CLOSE next_action_id;
495: hr_nonrun_asact.insact(v_next_action_id,
496: csr_rec.assignment_id,
497: p_payroll_action_id,
498: p_chunk,
499: null);
496: csr_rec.assignment_id,
497: p_payroll_action_id,
498: p_chunk,
499: null);
500: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
501: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
502:
503: IF g_debug
504: THEN
497: p_payroll_action_id,
498: p_chunk,
499: null);
500: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
501: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
502:
503: IF g_debug
504: THEN
505: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
520:
521: OPEN next_action_id;
522: FETCH next_action_id into v_next_action_id;
523: CLOSE next_action_id;
524: hr_nonrun_asact.insact(v_next_action_id,
525: csr_rec.assignment_id,
526: p_payroll_action_id,
527: p_chunk,
528: null);
525: csr_rec.assignment_id,
526: p_payroll_action_id,
527: p_chunk,
528: null);
529: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
530: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
531:
532: IF g_debug
533: THEN
526: p_payroll_action_id,
527: p_chunk,
528: null);
529: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
530: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
531:
532: IF g_debug
533: THEN
534: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);