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.

[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_CA_INST

Line 842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,

838: Who When What
839: vkarthik 21-Jan-2004 Removed recursive search from the function for checking if
840: the passed calendars are related anywhere in the hierarchy */
841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,

Line 843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,

839: vkarthik 21-Jan-2004 Removed recursive search from the function for checking if
840: the passed calendars are related anywhere in the hierarchy */
841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number

Line 844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,

840: the passed calendars are related anywhere in the hierarchy */
841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number
848: FROM igs_ca_inst_rel

Line 845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS

841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number
848: FROM igs_ca_inst_rel
849: WHERE

Line 848: FROM igs_ca_inst_rel

844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number
848: FROM igs_ca_inst_rel
849: WHERE
850: sup_cal_type = cp_sup_cal_ty AND
851: sup_ci_sequence_number = cp_sup_ci_seq_num AND
852: sub_cal_type = cp_sub_cal_ty AND

Line 1255: IGS_CA_INST_REL cr

1251: version_number = sca.version_number) AND
1252: NOT EXISTS (
1253: SELECT person_id
1254: FROM IGS_EN_SU_ATTEMPT sua,
1255: IGS_CA_INST_REL cr
1256: WHERE sua.person_id = sca.person_id AND
1257: sua.course_cd = sca.course_cd AND
1258: sua.cal_type = cr.sub_cal_type AND
1259: sua.ci_sequence_number = cr.sub_ci_sequence_number AND

Line 1274: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS

1270:
1271: CURSOR c_scae (
1272: cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,
1273: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE,
1274: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS
1275: SELECT scae.enrolment_cat
1276: FROM IGS_AS_SC_ATMPT_ENR scae,
1277: IGS_CA_INST ci
1278: WHERE scae.person_id = cp_person_id AND

Line 1277: IGS_CA_INST ci

1273: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE,
1274: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS
1275: SELECT scae.enrolment_cat
1276: FROM IGS_AS_SC_ATMPT_ENR scae,
1277: IGS_CA_INST ci
1278: WHERE scae.person_id = cp_person_id AND
1279: scae.course_cd = cp_course_cd AND
1280: ci.cal_type = scae.cal_type AND
1281: ci.sequence_number = scae.ci_sequence_number AND

Line 1372: IGS_CA_INST_REL cr

1368: version_number = acai.crv_version_number ) AND
1369: NOT EXISTS (
1370: SELECT person_id
1371: FROM IGS_EN_SU_ATTEMPT sua,
1372: IGS_CA_INST_REL cr
1373: WHERE sua.person_id = acai.person_id AND
1374: sua.course_cd = acai.course_cd AND
1375: sua.cal_type = cr.sub_cal_type AND
1376: sua.ci_sequence_number = cr.sub_ci_sequence_number AND

Line 1386: FROM IGS_CA_INST eci

1382: acai.offer_dt DESC;
1383:
1384: CURSOR c_eci IS
1385: SELECT start_dt
1386: FROM IGS_CA_INST eci
1387: WHERE cal_type = p_enr_cal_type AND
1388: sequence_number = p_enr_sequence_number;
1389: --new cursor is by kkillams added w.r.t. to YOP-EN build bug id :2156956
1390: CURSOR c_yop_us_st(cp_person_id NUMBER,

Line 1405: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1401: AND susa.selection_dt IS NOT NULL
1402: AND susa.rqrmnts_complete_dt IS NULL
1403: AND susa.end_dt IS NULL;
1404: r_yop_us_st c_yop_us_st%ROWTYPE;
1405: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1406: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
1408: igs_ca_inst ci,
1409: igs_ca_type cal

Line 1406: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

1402: AND susa.rqrmnts_complete_dt IS NULL
1403: AND susa.end_dt IS NULL;
1404: r_yop_us_st c_yop_us_st%ROWTYPE;
1405: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1406: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
1408: igs_ca_inst ci,
1409: igs_ca_type cal
1410: WHERE rel.sup_cal_type = p_acad_cal_type

Line 1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,

1403: AND susa.end_dt IS NULL;
1404: r_yop_us_st c_yop_us_st%ROWTYPE;
1405: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1406: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
1408: igs_ca_inst ci,
1409: igs_ca_type cal
1410: WHERE rel.sup_cal_type = p_acad_cal_type
1411: AND rel.sup_ci_sequence_number = p_acad_seq_num

Line 1408: igs_ca_inst ci,

1404: r_yop_us_st c_yop_us_st%ROWTYPE;
1405: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1406: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
1408: igs_ca_inst ci,
1409: igs_ca_type cal
1410: WHERE rel.sup_cal_type = p_acad_cal_type
1411: AND rel.sup_ci_sequence_number = p_acad_seq_num
1412: AND rel.sub_cal_type = ci.cal_type

Line 1430: l_load_cal_type igs_ca_inst.cal_type%TYPE;

1426: successful_total NUMBER := 0;
1427: exception_total NUMBER := 0;
1428: v_output_message VARCHAR(255) := NULL;
1429: l_us_count NUMBER := 0;
1430: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1431: l_load_seq_num igs_ca_inst.sequence_number%TYPE;
1432: l_enr_method igs_en_method_type.enr_method_type%TYPE;
1433: l_return_status VARCHAR2(10);
1434: l_message VARCHAR2(100);

Line 1431: l_load_seq_num igs_ca_inst.sequence_number%TYPE;

1427: exception_total NUMBER := 0;
1428: v_output_message VARCHAR(255) := NULL;
1429: l_us_count NUMBER := 0;
1430: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1431: l_load_seq_num igs_ca_inst.sequence_number%TYPE;
1432: l_enr_method igs_en_method_type.enr_method_type%TYPE;
1433: l_return_status VARCHAR2(10);
1434: l_message VARCHAR2(100);
1435: l_mesg_txt VARCHAR2(4000);