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_USEC_SCHEDULE dependencies on IGS_CA_INST

Line 82: CURSOR uoo_cur( l_cal_type igs_ca_inst.cal_type%TYPE,

78: ***************************************************************/
79:
80: -- All active and inactive unit sections
81: -- Added location_description in the following cursor as part of enh bug#2833850
82: CURSOR uoo_cur( l_cal_type igs_ca_inst.cal_type%TYPE,
83: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
84: cp_unit_cd VARCHAR2,
85: cp_version_number IN NUMBER,
86: cp_location_cd IN VARCHAR2,

Line 83: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

79:
80: -- All active and inactive unit sections
81: -- Added location_description in the following cursor as part of enh bug#2833850
82: CURSOR uoo_cur( l_cal_type igs_ca_inst.cal_type%TYPE,
83: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
84: cp_unit_cd VARCHAR2,
85: cp_version_number IN NUMBER,
86: cp_location_cd IN VARCHAR2,
87: cp_unit_class IN VARCHAR2) IS

Line 106: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv,igs_ca_inst_all ci, igs_ad_location_all loc

102: ci.alternate_code teaching_cal_alternate_code,
103: NULL subtitle,
104: uv.subtitle_id,
105: NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd) owner_org_unit_cd
106: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv,igs_ca_inst_all ci, igs_ad_location_all loc
107: WHERE uoo.cal_type = l_cal_type
108: AND uoo.ci_sequence_number = l_ci_sequence_number
109: AND uoo.unit_cd=cp_unit_cd
110: AND uoo.version_number=cp_version_number

Line 143: FROM igs_ps_unit_ofr_opt_all uoo, igs_ca_inst_all ci

139:
140: -- Get the calendar end date for the particular unit section for Bug # 2383553
141: CURSOR c_end_dt (cp_uoo_id IGS_PS_UNIT_OFR_OPT_V.UOO_ID%TYPE) IS
142: SELECT ci.end_dt cal_end_dt
143: FROM igs_ps_unit_ofr_opt_all uoo, igs_ca_inst_all ci
144: WHERE UOO_ID =cp_uoo_id
145: AND uoo.cal_type = ci.cal_type
146: AND uoo.ci_sequence_number = ci.sequence_number;
147:

Line 171: FROM igs_ps_unit_ofr_pat us, igs_ca_inst_all b,igs_ps_unit_ver c, igs_ps_unit_stat d

167:
168: CURSOR pat_cur(cp_cal_type IN VARCHAR2, cp_ci_sequence_number IN NUMBER,
169: cp_unit_cd IN VARCHAR2, cp_version_number IN NUMBER) IS
170: SELECT us.*,b.alternate_code ,b.start_dt,b.end_dt,c.unit_status,c.enrollment_expected,c.enrollment_maximum,c.override_enrollment_max
171: FROM igs_ps_unit_ofr_pat us, igs_ca_inst_all b,igs_ps_unit_ver c, igs_ps_unit_stat d
172: WHERE us.cal_type=cp_cal_type
173: AND us.ci_sequence_number=cp_ci_sequence_number
174: AND (us.unit_cd=cp_unit_cd OR cp_unit_cd IS NULL)
175: AND (us.version_number=cp_version_number OR cp_version_number IS NULL)

Line 227: l_cal_type igs_ca_inst.cal_type%TYPE;

223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;
224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;
225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553
226: l_int_sch_status igs_ps_sch_int_all.transaction_type%TYPE;
227: l_cal_type igs_ca_inst.cal_type%TYPE;
228: l_enrollment_maximum igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
229: l_enrollment_expected igs_ps_usec_lim_wlst.enrollment_expected%TYPE;
230: l_override_enrollment_max igs_ps_usec_lim_wlst.override_enrollment_max%TYPE;
231: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 231: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

227: l_cal_type igs_ca_inst.cal_type%TYPE;
228: l_enrollment_maximum igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
229: l_enrollment_expected igs_ps_usec_lim_wlst.enrollment_expected%TYPE;
230: l_override_enrollment_max igs_ps_usec_lim_wlst.override_enrollment_max%TYPE;
231: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
232: l_start_date igs_ca_inst.start_dt%TYPE;
233: l_end_date igs_ca_inst.end_dt%TYPE;
234: l_trans_type igs_ps_sch_int_all.transaction_type%TYPE;
235: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE;

Line 232: l_start_date igs_ca_inst.start_dt%TYPE;

228: l_enrollment_maximum igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
229: l_enrollment_expected igs_ps_usec_lim_wlst.enrollment_expected%TYPE;
230: l_override_enrollment_max igs_ps_usec_lim_wlst.override_enrollment_max%TYPE;
231: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
232: l_start_date igs_ca_inst.start_dt%TYPE;
233: l_end_date igs_ca_inst.end_dt%TYPE;
234: l_trans_type igs_ps_sch_int_all.transaction_type%TYPE;
235: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE;
236: l_max_enr_meet_grp igs_ps_uso_clas_meet_v.enrollment_maximum%TYPE;

Line 233: l_end_date igs_ca_inst.end_dt%TYPE;

229: l_enrollment_expected igs_ps_usec_lim_wlst.enrollment_expected%TYPE;
230: l_override_enrollment_max igs_ps_usec_lim_wlst.override_enrollment_max%TYPE;
231: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
232: l_start_date igs_ca_inst.start_dt%TYPE;
233: l_end_date igs_ca_inst.end_dt%TYPE;
234: l_trans_type igs_ps_sch_int_all.transaction_type%TYPE;
235: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE;
236: l_max_enr_meet_grp igs_ps_uso_clas_meet_v.enrollment_maximum%TYPE;
237: l_lead_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE;

Line 2619: l_c_t_cal_type igs_ca_inst_all.cal_type%TYPE;

2615: l_set_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;
2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;
2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850
2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850
2619: l_c_t_cal_type igs_ca_inst_all.cal_type%TYPE;
2620: l_n_t_seq_num igs_ca_inst_all.sequence_number%TYPE;
2621: l_n_t_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2622: l_b_print_cal BOOLEAN;
2623: l_b_print_uoo BOOLEAN;

Line 2620: l_n_t_seq_num igs_ca_inst_all.sequence_number%TYPE;

2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;
2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850
2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850
2619: l_c_t_cal_type igs_ca_inst_all.cal_type%TYPE;
2620: l_n_t_seq_num igs_ca_inst_all.sequence_number%TYPE;
2621: l_n_t_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2622: l_b_print_cal BOOLEAN;
2623: l_b_print_uoo BOOLEAN;
2624:

Line 2673: igs_ca_inst_all b

2669: a.unit_section_end_date us_end_date,
2670: b.start_dt tp_start_date,
2671: b.end_dt tp_end_date
2672: FROM igs_ps_unit_ofr_opt_all a,
2673: igs_ca_inst_all b
2674: WHERE a.uoo_id = cp_n_uoo_id
2675: AND a.cal_type = b.cal_type
2676: AND a.ci_sequence_number = b.sequence_number;
2677:

Line 3639: l_cal_type igs_ca_inst.cal_type%TYPE;

3635:
3636: c_prod_pat_rec c_prod_pat%ROWTYPE;
3637:
3638:
3639: l_cal_type igs_ca_inst.cal_type%TYPE;
3640: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3641: l_start_date igs_ca_inst.start_dt%TYPE;
3642: l_end_date igs_ca_inst.end_dt%TYPE;
3643: l_uso_count NUMBER(10);

Line 3640: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

3636: c_prod_pat_rec c_prod_pat%ROWTYPE;
3637:
3638:
3639: l_cal_type igs_ca_inst.cal_type%TYPE;
3640: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3641: l_start_date igs_ca_inst.start_dt%TYPE;
3642: l_end_date igs_ca_inst.end_dt%TYPE;
3643: l_uso_count NUMBER(10);
3644: l_abort_flag VARCHAR2(2);

Line 3641: l_start_date igs_ca_inst.start_dt%TYPE;

3637:
3638:
3639: l_cal_type igs_ca_inst.cal_type%TYPE;
3640: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3641: l_start_date igs_ca_inst.start_dt%TYPE;
3642: l_end_date igs_ca_inst.end_dt%TYPE;
3643: l_uso_count NUMBER(10);
3644: l_abort_flag VARCHAR2(2);
3645: l_abort_count NUMBER(10);

Line 3642: l_end_date igs_ca_inst.end_dt%TYPE;

3638:
3639: l_cal_type igs_ca_inst.cal_type%TYPE;
3640: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3641: l_start_date igs_ca_inst.start_dt%TYPE;
3642: l_end_date igs_ca_inst.end_dt%TYPE;
3643: l_uso_count NUMBER(10);
3644: l_abort_flag VARCHAR2(2);
3645: l_abort_count NUMBER(10);
3646: l_proc_count NUMBER(10);

Line 3988: CURSOR cur_dates (cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,

3984: FROM igs_ps_sch_prg_cfig
3985: WHERE teaching_calendar_type=cp_teaching_calendar_type;
3986: l_teaching_calendar_type igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE;
3987:
3988: CURSOR cur_dates (cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
3989: cp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE) IS
3990: SELECT start_dt,end_dt
3991: FROM igs_ca_inst_all
3992: WHERE cal_type=cp_cal_type

Line 3989: cp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE) IS

3985: WHERE teaching_calendar_type=cp_teaching_calendar_type;
3986: l_teaching_calendar_type igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE;
3987:
3988: CURSOR cur_dates (cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
3989: cp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE) IS
3990: SELECT start_dt,end_dt
3991: FROM igs_ca_inst_all
3992: WHERE cal_type=cp_cal_type
3993: AND sequence_number=cp_sequence_number;

Line 3991: FROM igs_ca_inst_all

3987:
3988: CURSOR cur_dates (cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
3989: cp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE) IS
3990: SELECT start_dt,end_dt
3991: FROM igs_ca_inst_all
3992: WHERE cal_type=cp_cal_type
3993: AND sequence_number=cp_sequence_number;
3994:
3995: -- cursor to select occurrence interface records for purging

Line 4316: CURSOR c_alt_cd(cp_c_cal_type igs_ca_inst.cal_type%TYPE,cp_n_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

4312: Who When What
4313: (reverse chronological order - newest change first)
4314: ************************************************************************/
4315:
4316: CURSOR c_alt_cd(cp_c_cal_type igs_ca_inst.cal_type%TYPE,cp_n_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4317: SELECT alternate_code
4318: FROM igs_ca_inst
4319: WHERE cal_type = cp_c_cal_type
4320: AND sequence_number = cp_n_ci_sequence_number;

Line 4318: FROM igs_ca_inst

4314: ************************************************************************/
4315:
4316: CURSOR c_alt_cd(cp_c_cal_type igs_ca_inst.cal_type%TYPE,cp_n_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4317: SELECT alternate_code
4318: FROM igs_ca_inst
4319: WHERE cal_type = cp_c_cal_type
4320: AND sequence_number = cp_n_ci_sequence_number;
4321:
4322: l_alt_code igs_ca_inst.alternate_code%TYPE;

Line 4322: l_alt_code igs_ca_inst.alternate_code%TYPE;

4318: FROM igs_ca_inst
4319: WHERE cal_type = cp_c_cal_type
4320: AND sequence_number = cp_n_ci_sequence_number;
4321:
4322: l_alt_code igs_ca_inst.alternate_code%TYPE;
4323:
4324: BEGIN
4325:
4326: OPEN c_alt_cd(p_c_cal_type,p_n_ci_sequence_number);

Line 4525: CURSOR c_alt_code (cp_c_cal_type igs_ca_inst_all.cal_type%TYPE, cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

4521:
4522: FUNCTION get_alternate_code (p_c_cal_type IN VARCHAR2,
4523: p_n_seq_num IN NUMBER)RETURN VARCHAR2 AS
4524:
4525: CURSOR c_alt_code (cp_c_cal_type igs_ca_inst_all.cal_type%TYPE, cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
4526: SELECT alternate_code
4527: FROM IGS_CA_INST_ALL
4528: WHERE cal_type = cp_c_cal_type
4529: AND sequence_number = cp_n_seq_num;

Line 4527: FROM IGS_CA_INST_ALL

4523: p_n_seq_num IN NUMBER)RETURN VARCHAR2 AS
4524:
4525: CURSOR c_alt_code (cp_c_cal_type igs_ca_inst_all.cal_type%TYPE, cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
4526: SELECT alternate_code
4527: FROM IGS_CA_INST_ALL
4528: WHERE cal_type = cp_c_cal_type
4529: AND sequence_number = cp_n_seq_num;
4530:
4531: l_c_alt_code IGS_CA_INST_ALL.alternate_code%TYPE;

Line 4531: l_c_alt_code IGS_CA_INST_ALL.alternate_code%TYPE;

4527: FROM IGS_CA_INST_ALL
4528: WHERE cal_type = cp_c_cal_type
4529: AND sequence_number = cp_n_seq_num;
4530:
4531: l_c_alt_code IGS_CA_INST_ALL.alternate_code%TYPE;
4532:
4533: BEGIN
4534: OPEN c_alt_code(p_c_cal_type,p_n_seq_num) ;
4535: FETCH c_alt_code INTO l_c_alt_code;