eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_GEN_004 dependencies on IGS_PS_UNIT_OFR_OPT

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 105: FROM IGS_PS_UNIT_OFR_OPT uoo

101: )RETURN BOOLEAN AS
102: v_dummy VARCHAR2(1) DEFAULT NULL;
103: CURSOR c_val_call_nbr is
104: SELECT 'x'
105: FROM IGS_PS_UNIT_OFR_OPT uoo
106: WHERE uoo.cal_type = p_cal_type AND
107: uoo.ci_sequence_number = p_ci_sequence_number AND
108: uoo.call_number = p_call_number;
109: BEGIN

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 318: l_d_teach_end_dt igs_ps_unit_ofr_opt_v.cal_end_dt%TYPE;

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:
318: l_d_teach_end_dt igs_ps_unit_ofr_opt_v.cal_end_dt%TYPE;
319: l_d_teach_start_dt igs_ca_inst_all.start_dt%TYPE;
320: l_d_temp_end_dt igs_ca_inst_all.end_dt%TYPE;
321: l_d_temp_date igs_ca_inst_all.end_dt%TYPE;
322:

Line 1569: FROM igs_ps_unit_ofr_opt

1565:
1566: -- Cursor to get the cal type and sequence number for a given uoo_id
1567: CURSOR cur_cal_seq (cp_uoo_id igs_ps_usec_occurs.uoo_id%TYPE) IS
1568: SELECT cal_type,ci_sequence_number
1569: FROM igs_ps_unit_ofr_opt
1570: WHERE uoo_id = cp_uoo_id;
1571:
1572: --Cursor to get unit_sec_end_date
1573: CURSOR cur_unit_sec_end_date (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 1573: CURSOR cur_unit_sec_end_date (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1569: FROM igs_ps_unit_ofr_opt
1570: WHERE uoo_id = cp_uoo_id;
1571:
1572: --Cursor to get unit_sec_end_date
1573: CURSOR cur_unit_sec_end_date (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1574: SELECT unit_section_end_date
1575: FROM igs_ps_unit_ofr_opt
1576: WHERE uoo_id = cp_uoo_id;
1577:

Line 1575: FROM igs_ps_unit_ofr_opt

1571:
1572: --Cursor to get unit_sec_end_date
1573: CURSOR cur_unit_sec_end_date (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1574: SELECT unit_section_end_date
1575: FROM igs_ps_unit_ofr_opt
1576: WHERE uoo_id = cp_uoo_id;
1577:
1578:
1579: --Cursor to fetch the Calendar Instance End Date

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;