[Home] [Help]
290: FUNCTION derive_unit_data(
291: p_lgcy_adstunt_rec IN OUT NOCOPY lgcy_adstunt_rec_type,
292: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
293: p_s_adv_stnd_type OUT NOCOPY igs_av_stnd_unit_all. s_adv_stnd_type%TYPE,
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,
291: p_lgcy_adstunt_rec IN OUT NOCOPY lgcy_adstunt_rec_type,
292: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
293: p_s_adv_stnd_type OUT NOCOPY igs_av_stnd_unit_all. s_adv_stnd_type%TYPE,
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,
752: FUNCTION validate_std_unt_db_cons(
753: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
754: p_person_id IN igs_pe_person.person_id%TYPE,
755: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
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,
753: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
754: p_person_id IN igs_pe_person.person_id%TYPE,
755: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
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,
934: FUNCTION validate_unit(
935: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
936: p_person_id IN igs_pe_person.person_id%TYPE,
937: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
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,
935: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
936: p_person_id IN igs_pe_person.person_id%TYPE,
937: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
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
1590: l_ret_status BOOLEAN;
1591: l_b_av_stnd_alt_unit_pk_exist BOOLEAN := TRUE;
1592: l_person_id igs_pe_person.person_id%TYPE;
1593: l_s_adv_stnd_type igs_av_stnd_unit_all. s_adv_stnd_type%TYPE;
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;
1591: l_b_av_stnd_alt_unit_pk_exist BOOLEAN := TRUE;
1592: l_person_id igs_pe_person.person_id%TYPE;
1593: l_s_adv_stnd_type igs_av_stnd_unit_all. s_adv_stnd_type%TYPE;
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;