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

Line 483: l_sub_ci_seq_num IGS_CA_INST_REL.SUB_CI_SEQUENCE_NUMBER%TYPE;

479:
480: l_enr_cal_type IGS_AS_SC_ATMPT_ENR.CAL_TYPE%TYPE;
481: l_enr_seq_num IGS_AS_SC_ATMPT_ENR.CI_SEQUENCE_NUMBER%TYPE;
482: l_enr_category IGS_AS_SC_ATMPT_ENR.ENROLMENT_CAT%TYPE;
483: l_sub_ci_seq_num IGS_CA_INST_REL.SUB_CI_SEQUENCE_NUMBER%TYPE;
484: l_return_value BOOLEAN;
485: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
486:
487: CURSOR c_get_enrolment_cal_type IS

Line 489: FROM IGS_AS_SC_ATMPT_ENR scae, IGS_CA_INST ci

485: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
486:
487: CURSOR c_get_enrolment_cal_type IS
488: SELECT scae.cal_type, scae.ci_sequence_number, scae.enrolment_cat
489: FROM IGS_AS_SC_ATMPT_ENR scae, IGS_CA_INST ci
490: WHERE scae.person_id = p_person_id AND
491: scae.course_cd = p_src_program_cd AND
492: ci.cal_type = scae.cal_type AND
493: ci.sequence_number = scae.ci_sequence_number

Line 496: CURSOR c_get_cal_rel_dtl_for_enr_cal (c_enr_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE) IS

492: ci.cal_type = scae.cal_type AND
493: ci.sequence_number = scae.ci_sequence_number
494: ORDER BY ci.start_dt DESC;
495:
496: CURSOR c_get_cal_rel_dtl_for_enr_cal (c_enr_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE) IS
497: SELECT cir.sub_ci_sequence_number
498: FROM IGS_CA_INST_REL cir
499: WHERE cir.sup_cal_type = p_acad_cal_type AND
500: cir.sup_ci_sequence_number = p_acad_seq_num AND

Line 498: FROM IGS_CA_INST_REL cir

494: ORDER BY ci.start_dt DESC;
495:
496: CURSOR c_get_cal_rel_dtl_for_enr_cal (c_enr_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE) IS
497: SELECT cir.sub_ci_sequence_number
498: FROM IGS_CA_INST_REL cir
499: WHERE cir.sup_cal_type = p_acad_cal_type AND
500: cir.sup_ci_sequence_number = p_acad_seq_num AND
501: cir.sub_cal_type = c_enr_cal_type;
502:

Line 1172: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1168:
1169: l_deny_warn VARCHAR2(100);
1170: l_message_name VARCHAR2(4000);
1171: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1172: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1173: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1174: l_commencement_type VARCHAR2(20);
1175: l_dummy VARCHAR2(100);
1176: l_enroll_mtd_type IGS_EN_METHOD_TYPE.ENR_METHOD_TYPE%TYPE;

Line 1173: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

1169: l_deny_warn VARCHAR2(100);
1170: l_message_name VARCHAR2(4000);
1171: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1172: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1173: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1174: l_commencement_type VARCHAR2(20);
1175: l_dummy VARCHAR2(100);
1176: l_enroll_mtd_type IGS_EN_METHOD_TYPE.ENR_METHOD_TYPE%TYPE;
1177: l_personsteps_vald_status BOOLEAN;

Line 1597: l_teach_cal_desc IGS_CA_INST.description%TYPE;

1593: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1594: l_return_message FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1595: l_del_sua_tran_status BOOLEAN;
1596: l_del_all_sua_status BOOLEAN;
1597: l_teach_cal_desc IGS_CA_INST.description%TYPE;
1598: l_uooids_str VARCHAR2(1000);
1599: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1600: l_error_occured BOOLEAN;
1601:

Line 1617: CURSOR c_get_teach_cal_dec(c_teach_cal_type IGS_CA_INST.cal_type%TYPE,c_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE) IS

1613: WHERE uv.unit_cd = c_unit_cd AND
1614: uv.version_number = c_unit_version_number AND
1615: uv.research_unit_ind = 'Y';
1616:
1617: CURSOR c_get_teach_cal_dec(c_teach_cal_type IGS_CA_INST.cal_type%TYPE,c_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE) IS
1618: SELECT description
1619: FROM igs_ca_inst
1620: WHERE cal_type = c_teach_cal_type AND
1621: sequence_number = c_teach_cal_seq_num ;

Line 1619: FROM igs_ca_inst

1615: uv.research_unit_ind = 'Y';
1616:
1617: CURSOR c_get_teach_cal_dec(c_teach_cal_type IGS_CA_INST.cal_type%TYPE,c_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE) IS
1618: SELECT description
1619: FROM igs_ca_inst
1620: WHERE cal_type = c_teach_cal_type AND
1621: sequence_number = c_teach_cal_seq_num ;
1622: l_unit_dtls_rec c_get_unit_dtls%ROWTYPE;
1623: