APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_RPT_FMLY

Line 88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;

84:
85: l_n_coord_person_id igs_ps_unit_ver_all.coord_person_id%TYPE;
86: l_d_owner_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;
88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;
91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;

Line 316: CURSOR c_repeat_code(cp_repeat_code igs_ps_rpt_fmly.repeat_code%TYPE) IS

312: SELECT unit_type_id
313: FROM igs_ps_unit_type_lvl
314: WHERE level_code=cp_level_code;
315:
316: CURSOR c_repeat_code(cp_repeat_code igs_ps_rpt_fmly.repeat_code%TYPE) IS
317: SELECT rpt_fmly_id
318: FROM igs_ps_rpt_fmly
319: WHERE repeat_code=cp_repeat_code;
320:

Line 318: FROM igs_ps_rpt_fmly

314: WHERE level_code=cp_level_code;
315:
316: CURSOR c_repeat_code(cp_repeat_code igs_ps_rpt_fmly.repeat_code%TYPE) IS
317: SELECT rpt_fmly_id
318: FROM igs_ps_rpt_fmly
319: WHERE repeat_code=cp_repeat_code;
320:
321: CURSOR c_curriculum_seq_num IS
322: SELECT igs_ps_unt_crclm_all_s.NEXTVAL

Line 899: IF (NOT igs_ps_rpt_fmly_pkg.get_pk_for_validation(l_n_rpt_fmly_id)) THEN

895: p_unit_ver_rec.status:='E';
896: END IF;
897:
898: IF l_n_rpt_fmly_id IS NOT NULL THEN
899: IF (NOT igs_ps_rpt_fmly_pkg.get_pk_for_validation(l_n_rpt_fmly_id)) THEN
900: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS','UNIT_REPEAT','LEGACY_TOKENS',FALSE);
901: p_unit_ver_rec.status:='E';
902: END IF;
903: END IF;