APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_AS_SC_ATMPT_ENR

Line 480: l_enr_cal_type IGS_AS_SC_ATMPT_ENR.CAL_TYPE%TYPE;

476: --Who When What
477:
478: -------------------------------------------------------------------------------------------
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;

Line 481: l_enr_seq_num IGS_AS_SC_ATMPT_ENR.CI_SEQUENCE_NUMBER%TYPE;

477:
478: -------------------------------------------------------------------------------------------
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;

Line 482: l_enr_category IGS_AS_SC_ATMPT_ENR.ENROLMENT_CAT%TYPE;

478: -------------------------------------------------------------------------------------------
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:

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