382: WHERE person_id = c_person_id;
383:
384: CURSOR c_assignment_set_id
385: IS
386: SELECT hr_assignment_sets_s.nextval
387: FROM dual;
388:
389: CURSOR c_assignment_set_exists(assign_set_name VARCHAR2)
390: IS
388:
389: CURSOR c_assignment_set_exists(assign_set_name VARCHAR2)
390: IS
391: SELECT assignment_set_id
392: FROM hr_assignment_sets
393: WHERE assignment_set_name=assign_set_name;
394:
395: CURSOR c_assignment_amd_exists(c_assignment_id number,c_assignment_set_id number)
396: IS
606: hr_utility.trace('assignment set not exists');
607: OPEN c_assignment_set_id;
608: FETCH c_assignment_set_id into lv_assignment_set_id;
609: CLOSE c_assignment_set_id;
610: hr_assignment_sets_pkg.insert_row(row_id,
611: lv_assignment_set_id,
612: lv_business_group_id,
613: lv_payroll_id,
614: lv_assignment_set,