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

Line 441: p_cal_type igs_ca_inst.cal_type%TYPE, --load calendar

437:
438: /* Function to validate programs-New Validations - */
439:
440: FUNCTION validate_prog (p_person_id igs_en_su_attempt.person_id%TYPE,
441: p_cal_type igs_ca_inst.cal_type%TYPE, --load calendar
442: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, --load calendar
443: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
444: p_course_cd igs_en_su_attempt.course_cd%TYPE,
445: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

Line 442: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, --load calendar

438: /* Function to validate programs-New Validations - */
439:
440: FUNCTION validate_prog (p_person_id igs_en_su_attempt.person_id%TYPE,
441: p_cal_type igs_ca_inst.cal_type%TYPE, --load calendar
442: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, --load calendar
443: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
444: p_course_cd igs_en_su_attempt.course_cd%TYPE,
445: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
446: p_message_name OUT NOCOPY VARCHAR2,

Line 489: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

485: lv_deny_warn VARCHAR2(20);
486: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
487: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
488: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
489: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
493: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

Line 490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

486: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
487: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
488: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
489: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
493: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
494: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

487: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
488: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
489: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
493: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
494: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
495: l_dummy VARCHAR2(200);

Line 492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

488: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
489: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
493: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
494: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
495: l_dummy VARCHAR2(200);
496:

Line 493: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

489: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
493: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
494: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
495: l_dummy VARCHAR2(200);
496:
497: BEGIN

Line 494: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
493: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
494: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
495: l_dummy VARCHAR2(200);
496:
497: BEGIN
498: lv_message := NULL;

Line 569: p_cal_type igs_ca_inst.cal_type%TYPE,

565:
566: END validate_prog;
567:
568: FUNCTION validate_unit_steps (p_person_id igs_en_su_attempt.person_id%TYPE,
569: p_cal_type igs_ca_inst.cal_type%TYPE,
570: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
571: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
572: p_course_cd igs_en_su_attempt.course_cd%TYPE,
573: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

Line 570: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

566: END validate_prog;
567:
568: FUNCTION validate_unit_steps (p_person_id igs_en_su_attempt.person_id%TYPE,
569: p_cal_type igs_ca_inst.cal_type%TYPE,
570: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
571: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
572: p_course_cd igs_en_su_attempt.course_cd%TYPE,
573: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
574: p_message_name OUT NOCOPY VARCHAR2,

Line 603: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;

599: lv_message VARCHAR2(2000);
600: lv_deny_warn VARCHAR2(20);
601: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
602: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
603: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
604: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
605:
606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 604: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;

600: lv_deny_warn VARCHAR2(20);
601: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
602: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
603: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
604: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
605:
606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
608: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

Line 606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

602: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
603: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
604: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
605:
606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
608: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
609: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
610: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

603: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
604: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
605:
606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
608: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
609: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
610: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
611: l_dummy VARCHAR2(200);

Line 608: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

604: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
605:
606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
608: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
609: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
610: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
611: l_dummy VARCHAR2(200);
612:

Line 609: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

605:
606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
608: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
609: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
610: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
611: l_dummy VARCHAR2(200);
612:
613:

Line 610: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

606: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
607: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
608: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
609: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
610: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
611: l_dummy VARCHAR2(200);
612:
613:
614: BEGIN

Line 700: p_cal_type igs_ca_inst.cal_type%TYPE,

696: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
697: p_called_from_wlst VARCHAR2,
698: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
700: p_cal_type igs_ca_inst.cal_type%TYPE,
701: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
702: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
703: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
704: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

Line 701: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

697: p_called_from_wlst VARCHAR2,
698: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
700: p_cal_type igs_ca_inst.cal_type%TYPE,
701: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
702: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
703: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
704: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
705: p_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar

1305: FUNCTION validate_combined_unit (
1306: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1307: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1308: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar
1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar
1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
1312: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1313: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

Line 1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar

1306: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1307: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1308: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar
1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar
1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
1312: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1313: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
1314: p_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 1332: lv_teach_cal_type igs_ca_inst.cal_type%TYPE;

1328: SELECT cal_type, ci_sequence_number
1329: FROM igs_ps_unit_ofr_opt
1330: WHERE uoo_id = cp_uoo_id;
1331:
1332: lv_teach_cal_type igs_ca_inst.cal_type%TYPE;
1333: lv_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1334:
1335: BEGIN
1336: /* Call old validate unit first and then unit steps if true else return false with message */

Line 1333: lv_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1329: FROM igs_ps_unit_ofr_opt
1330: WHERE uoo_id = cp_uoo_id;
1331:
1332: lv_teach_cal_type igs_ca_inst.cal_type%TYPE;
1333: lv_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1334:
1335: BEGIN
1336: /* Call old validate unit first and then unit steps if true else return false with message */
1337:

Line 1509: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,

1505: ln_message_count NUMBER(4);
1506: lv_dummy_message fnd_new_messages.message_name%TYPE;
1507:
1508: -- cursor to fetch the First Load Calendar for the Teaching Calendar
1509: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,
1510: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1511: SELECT load_cal_type,load_ci_sequence_number
1512: FROM IGS_CA_TEACH_TO_LOAD_V
1513: WHERE teach_cal_type = p_cal_type AND

Line 1510: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1506: lv_dummy_message fnd_new_messages.message_name%TYPE;
1507:
1508: -- cursor to fetch the First Load Calendar for the Teaching Calendar
1509: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,
1510: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1511: SELECT load_cal_type,load_ci_sequence_number
1512: FROM IGS_CA_TEACH_TO_LOAD_V
1513: WHERE teach_cal_type = p_cal_type AND
1514: teach_ci_sequence_number = p_sequence_number AND

Line 1940: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

1936: END get_message_count;
1937:
1938: PROCEDURE ss_eval_min_or_max_cp(
1939: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1940: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1941: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1942: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
1943: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
1944: p_step_type IN igs_en_cpd_ext.s_enrolment_step_type%TYPE,

Line 1941: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1937:
1938: PROCEDURE ss_eval_min_or_max_cp(
1939: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1940: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1941: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1942: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
1943: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
1944: p_step_type IN igs_en_cpd_ext.s_enrolment_step_type%TYPE,
1945: p_credit_points IN NUMBER,

Line 1982: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1978: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
1979: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1980: l_enr_method igs_en_cat_prc_dtl.enr_method_type%TYPE;
1981: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
1982: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1983: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1984: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1985: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1986: l_ret_value BOOLEAN := TRUE;

Line 1983: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

1979: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1980: l_enr_method igs_en_cat_prc_dtl.enr_method_type%TYPE;
1981: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
1982: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1983: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1984: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1985: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1986: l_ret_value BOOLEAN := TRUE;
1987: -- lv_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE;

Line 1984: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1980: l_enr_method igs_en_cat_prc_dtl.enr_method_type%TYPE;
1981: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
1982: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1983: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1984: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1985: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1986: l_ret_value BOOLEAN := TRUE;
1987: -- lv_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE;
1988: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

Line 1988: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

1984: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1985: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1986: l_ret_value BOOLEAN := TRUE;
1987: -- lv_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE;
1988: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1989: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1990: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1991:
1992: -- Below Two local variables added as part of Enrl Elgbl and Validation Build. Bug#2616692

Line 1989: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

1985: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1986: l_ret_value BOOLEAN := TRUE;
1987: -- lv_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE;
1988: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1989: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1990: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1991:
1992: -- Below Two local variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1993: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE := NULL;

Line 1990: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

1986: l_ret_value BOOLEAN := TRUE;
1987: -- lv_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE;
1988: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1989: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1990: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1991:
1992: -- Below Two local variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1993: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE := NULL;
1994: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE := NULL;