DBA Data[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_PS_TYPE

Line 1171: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;

1167: --------------------------------------------------------------------------------------------
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);

Line 3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;

3062: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
3063: l_src_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3064: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3065: l_src_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3067:
3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;

Line 3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;

3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%TYPE;
3074: l_dest_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3075: l_course_attempt_status IGS_EN_STDNT_PS_ATT.COURSE_ATTEMPT_STATUS%TYPE;
3076: l_status_date CONSTANT DATE := SYSDATE;

Line 3097: IGS_PS_TYPE cty

3093: course_cd = c_program_cd;
3094: CURSOR c_get_progam_type(c_course_cd IGS_PS_VER.course_cd%TYPE,c_course_ver IGS_PS_VER.version_number%TYPE) IS
3095: SELECT cty.research_type_ind
3096: FROM IGS_PS_VER crv,
3097: IGS_PS_TYPE cty
3098: WHERE crv.course_cd = c_course_cd AND
3099: crv.version_number = c_course_ver AND
3100: crv.course_type = cty.course_type ;
3101: