APPS.IGS_PS_GEN_004 dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 98: p_cal_type IN IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE ,

94: END crsp_ins_fsr_hist;
95:
96:
97: FUNCTION crsp_val_call_nbr(
98: p_cal_type IN IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE ,
99: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE,
100: p_call_number IN IGS_PS_UNIT_OFR_OPT_ALL.call_number%TYPE
101: )RETURN BOOLEAN AS
102: v_dummy VARCHAR2(1) DEFAULT NULL;

Line 99: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE,

95:
96:
97: FUNCTION crsp_val_call_nbr(
98: p_cal_type IN IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE ,
99: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE,
100: p_call_number IN IGS_PS_UNIT_OFR_OPT_ALL.call_number%TYPE
101: )RETURN BOOLEAN AS
102: v_dummy VARCHAR2(1) DEFAULT NULL;
103: CURSOR c_val_call_nbr is

Line 100: p_call_number IN IGS_PS_UNIT_OFR_OPT_ALL.call_number%TYPE

96:
97: FUNCTION crsp_val_call_nbr(
98: p_cal_type IN IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE ,
99: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE,
100: p_call_number IN IGS_PS_UNIT_OFR_OPT_ALL.call_number%TYPE
101: )RETURN BOOLEAN AS
102: v_dummy VARCHAR2(1) DEFAULT NULL;
103: CURSOR c_val_call_nbr is
104: SELECT 'x'

Line 182: FROM igs_ps_unit_ofr_opt_all

178: c_call_cnstr_disc_rec c_call_cnstr_disc%ROWTYPE;
179:
180: CURSOR c_st_end_dt IS
181: SELECT UNIT_SECTION_START_DATE, UNIT_SECTION_END_DATE
182: FROM igs_ps_unit_ofr_opt_all
183: WHERE uoo_id = p_v_uoo_id;
184: c_st_end_dt_rec c_st_end_dt%ROWTYPE;
185:
186: weekends_count BOOLEAN := FALSE;

Line 310: CURSOR cur_teach_cal (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

306: Meeting_day VARCHAR2(10) ;
307:
308: -- Cursor to obtain the Teach Calendar end date
309: -- modifying the following cursor to select start date also. Also modified the from and where clause
310: CURSOR cur_teach_cal (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
311: SELECT ci.start_dt, ci.end_dt
312: FROM igs_ca_inst_all ci,
313: igs_ps_unit_ofr_opt_all uoo
314: WHERE uoo.uoo_id = cp_n_uoo_id

Line 313: igs_ps_unit_ofr_opt_all uoo

309: -- modifying the following cursor to select start date also. Also modified the from and where clause
310: CURSOR cur_teach_cal (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
311: SELECT ci.start_dt, ci.end_dt
312: FROM igs_ca_inst_all ci,
313: igs_ps_unit_ofr_opt_all uoo
314: WHERE uoo.uoo_id = cp_n_uoo_id
315: AND uoo.cal_type = ci.cal_type
316: AND uoo.ci_sequence_number = ci.sequence_number;
317:

Line 1664: l_d_us_st_dt igs_ps_unit_ofr_opt_all.unit_section_start_date%TYPE; -- Holds Unit Section Start Date

1660: Change History (in reverse chronological order)
1661: Who When What
1662: ********************************************************************************************** */
1663:
1664: l_d_us_st_dt igs_ps_unit_ofr_opt_all.unit_section_start_date%TYPE; -- Holds Unit Section Start Date
1665: l_d_end_dt igs_ps_unit_ofr_opt_all.unit_section_end_date%TYPE; -- Holds Effection Unit Section End Date (i.e, if available, unit section end date otherwise teaching calendar end date)
1666:
1667: CURSOR c_date(cp_n_uoo_id IN NUMBER) IS
1668: SELECT a.unit_section_start_date,

Line 1665: l_d_end_dt igs_ps_unit_ofr_opt_all.unit_section_end_date%TYPE; -- Holds Effection Unit Section End Date (i.e, if available, unit section end date otherwise teaching calendar end date)

1661: Who When What
1662: ********************************************************************************************** */
1663:
1664: l_d_us_st_dt igs_ps_unit_ofr_opt_all.unit_section_start_date%TYPE; -- Holds Unit Section Start Date
1665: l_d_end_dt igs_ps_unit_ofr_opt_all.unit_section_end_date%TYPE; -- Holds Effection Unit Section End Date (i.e, if available, unit section end date otherwise teaching calendar end date)
1666:
1667: CURSOR c_date(cp_n_uoo_id IN NUMBER) IS
1668: SELECT a.unit_section_start_date,
1669: NVL(a.unit_section_end_date,b.end_dt)

Line 1670: FROM igs_ps_unit_ofr_opt_all a,

1666:
1667: CURSOR c_date(cp_n_uoo_id IN NUMBER) IS
1668: SELECT a.unit_section_start_date,
1669: NVL(a.unit_section_end_date,b.end_dt)
1670: FROM igs_ps_unit_ofr_opt_all a,
1671: igs_ca_inst_all b
1672: WHERE a.uoo_id = cp_n_uoo_id
1673: AND a.cal_type = b.cal_type
1674: AND a.ci_sequence_number = b.sequence_number;