[Home] [Help]
294: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
295: p_seq_number OUT NOCOPY igs_ca_inst. sequence_number%TYPE,
296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,
297: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE,
298: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
299: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE,
300: p_reference_code_id OUT NOCOPY igs_ge_ref_cd.reference_code_id%TYPE
301: )RETURN BOOLEAN IS
302: /*===========================================================================+
360: igs_ad_test_segments.test_segment_name%TYPE,
361: cp_person_id igs_ad_test_results.person_id%TYPE) IS
362: SELECT b.tst_rslt_dtls_id
363: FROM igs_ad_test_results a,
364: igs_ad_tst_rslt_dtls b,
365: igs_ad_test_segments c
366: WHERE a.test_results_id = b.test_results_id
367: AND c.admission_test_type = cp_admission_test_type
368: AND b.test_segment_id = c.test_segment_id
756: p_cal_type IN igs_ca_inst.cal_type%TYPE,
757: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
759: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
760: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
761: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
762: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_stnd_unit_all.av_stnd_unit_id%TYPE
763: )RETURN BOOLEAN IS
764: /*===========================================================================+
826: FND_MSG_PUB.ADD;
827: x_return_status := FALSE;
828: mydebug('validate_std_unt_db_cons p_unit_details_id ');
829: END IF;
830: -- Foreign Key with Table IGS_AD_TST_RSLT_DTLS
831: IF p_tst_rslt_dtls_id IS NULL AND p_lgcy_adstunt_rec.tst_admission_test_type IS NOT NULL THEN
832: FND_MESSAGE.SET_NAME('IGS','IGS_AV_ADM_TST_RSLT_NOT_EXISTS');
833: FND_MSG_PUB.ADD;
834: x_return_status := FALSE;
938: p_cal_type IN igs_ca_inst.cal_type%TYPE,
939: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
940: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
941: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
942: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
943: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE
944: )RETURN BOOLEAN IS
945: /*===========================================================================+
946: | FUNCTION |
1165: FUNCTION create_post_unit(
1166: p_person_id IN igs_pe_person.person_id%type,
1167: p_course_version IN igs_ps_ver.version_number%type,
1168: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%type,
1169: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1170: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
1171: )RETURN BOOLEAN IS
1172: /*===========================================================================+
1173: | FUNCTION |
1248: p_av_stnd_unit_id IN IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE ,
1249: p_s_adv_stnd_type IN IGS_AV_STND_UNIT_ALL.S_ADV_STND_TYPE%TYPE ,
1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,
1252: p_tst_rslt_dtls_id IN IGS_AD_TST_RSLT_DTLS.TST_RSLT_DTLS_ID%TYPE ,
1253: p_as_version_number IN IGS_AV_STND_UNIT_ALL.AS_VERSION_NUMBER%TYPE ,
1254: p_av_stnd_unit_lvl_id OUT NOCOPY IGS_AV_STND_ALT_UNIT.AV_STND_UNIT_ID%TYPE ,
1255: x_return_status OUT NOCOPY VARCHAR2
1256: )
1594: l_cal_type igs_ca_inst.cal_type%TYPE;
1595: l_seq_number igs_ca_inst. sequence_number%TYPE;
1596: l_auth_pers_id igs_pe_person.person_id%TYPE;
1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1598: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE;
1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;
1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;