APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_FAC_WL

Line 574: l_fac_wl_id igs_ps_fac_wl.fac_wl_id%TYPE DEFAULT NULL;

570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;
572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;
573: l_dest_cal_cat igs_ca_type.s_cal_cat%TYPE ;
574: l_fac_wl_id igs_ps_fac_wl.fac_wl_id%TYPE DEFAULT NULL;
575:
576:
577: --get the calendar category for the passed calendar
578: --

Line 588: FROM igs_ps_fac_wl fw

584: --get all the faculty records
585: --
586: CURSOR cur_fac_wl IS
587: SELECT person_id , fac_wl_id
588: FROM igs_ps_fac_wl fw
589: WHERE fw.cal_type = l_source_cal_type AND
590: fw.ci_sequence_number = l_source_sequence_number AND
591: fw.person_id = p_person_id;
592:

Line 596: FROM igs_ps_fac_wl fw

592:
593:
594: CURSOR cur_fac_wl_null IS
595: SELECT person_id , fac_wl_id
596: FROM igs_ps_fac_wl fw
597: WHERE fw.cal_type = l_source_cal_type
598: AND fw.ci_sequence_number = l_source_sequence_number
599: AND fw.person_id > -1
600: ORDER BY person_id ;

Line 610: CURSOR cur_fac_wl_exists(cp_person_id igs_ps_fac_wl.person_id%TYPE) IS

606: AND NVL(rollover_flag,' ') <> 'S';
607: cur_fac_asg_task_rec cur_fac_asg_task%ROWTYPE;
608: -- check if the faculty record already exists for the dest calendar
609: --
610: CURSOR cur_fac_wl_exists(cp_person_id igs_ps_fac_wl.person_id%TYPE) IS
611: SELECT fac_wl_id
612: FROM igs_ps_fac_wl
613: WHERE person_id = cp_person_id AND
614: cal_type = l_dest_cal_type AND

Line 612: FROM igs_ps_fac_wl

608: -- check if the faculty record already exists for the dest calendar
609: --
610: CURSOR cur_fac_wl_exists(cp_person_id igs_ps_fac_wl.person_id%TYPE) IS
611: SELECT fac_wl_id
612: FROM igs_ps_fac_wl
613: WHERE person_id = cp_person_id AND
614: cal_type = l_dest_cal_type AND
615: ci_sequence_number = l_dest_sequence_number ;
616:

Line 780: IGS_PS_FAC_WL_PKG.INSERT_ROW (

776: IF cur_fac_wl_exists%NOTFOUND THEN
777: DECLARE
778: l_rowid VARCHAR2(40) ;
779: BEGIN
780: IGS_PS_FAC_WL_PKG.INSERT_ROW (
781: X_ROWID => l_rowid ,
782: X_FAC_WL_ID => l_fac_wl_id ,
783: X_PERSON_ID => l_tab_person_id(i).person_id ,
784: X_CALENDAR_CAT => l_dest_cal_cat ,