[Home] [Help]
128: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
129: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
130: p_course_version IN igs_ps_ver.version_number%type,
131: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
132: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type
133: )
134: RETURN BOOLEAN;
135:
136: /*
167: RETURN BOOLEAN;
168:
169: /*
170: validate_lvl_bas_db_cons function performs all the data integrity validation
171: before inserting into the table IGS_AV_STD_ULVLBASIS_ALL
172: */
173: FUNCTION validate_lvl_bas_db_cons
174: (
175: p_person_id IN igs_pe_person.person_id%type,
172: */
173: FUNCTION validate_lvl_bas_db_cons
174: (
175: p_person_id IN igs_pe_person.person_id%type,
176: p_av_stnd_unit_lvl_id IN igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type,
177: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
178: )
179: RETURN VARCHAR2;
180:
179: RETURN VARCHAR2;
180:
181: /*
182: validate_lvl_bas function performs all the business validation before
183: inserting into the table IGS_AV_STD_ULVLBASIS_ALL
184: */
185: FUNCTION validate_lvl_bas
186: (
187: p_course_version IN igs_ps_ver.version_number%type,
254: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%type;
255: l_as_version_number igs_en_stdnt_ps_att.version_number%type;
256:
257: -- variable declared to fetch data from validate_lvl_db_cons
258: l_av_stnd_unit_lvl_id igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type;
259:
260: l_check VARCHAR2(1) := 'N'; -- check whether to insert into parent
261: l_skip VARCHAR2(1) := 'N'; -- check whether to to skip the steps
262: l_return VARCHAR2(1) ;
381: p_lgcy_adstlvl_rec => p_lgcy_adstlvl_rec
382: )
383: THEN
384: /*
385: insert into IGS_AV_STD_ULVLBASIS_ALL
386: */
387: INSERT INTO IGS_AV_STD_ULVLBASIS_ALL (
388: AV_STND_UNIT_LVL_ID,
389: BASIS_COURSE_TYPE,
383: THEN
384: /*
385: insert into IGS_AV_STD_ULVLBASIS_ALL
386: */
387: INSERT INTO IGS_AV_STD_ULVLBASIS_ALL (
388: AV_STND_UNIT_LVL_ID,
389: BASIS_COURSE_TYPE,
390: BASIS_YEAR,
391: BASIS_COMPLETION_IND,
589: p_course_version => l_as_version_number,
590: p_lgcy_adstlvl_rec => p_lgcy_adstlvl_rec
591: ) THEN
592: /*
593: insert into IGS_AV_STD_ULVLBASIS_ALL
594: */
595: INSERT INTO IGS_AV_STD_ULVLBASIS_ALL (
596: AV_STND_UNIT_LVL_ID,
597: BASIS_COURSE_TYPE,
591: ) THEN
592: /*
593: insert into IGS_AV_STD_ULVLBASIS_ALL
594: */
595: INSERT INTO IGS_AV_STD_ULVLBASIS_ALL (
596: AV_STND_UNIT_LVL_ID,
597: BASIS_COURSE_TYPE,
598: BASIS_YEAR,
599: BASIS_COMPLETION_IND,
1332: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1333: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
1334: p_course_version IN igs_ps_ver.version_number%type,
1335: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
1336: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type
1337: )
1338: RETURN BOOLEAN
1339: /******************************************************************************************
1340: Created By : smanglm
1774:
1775: FUNCTION validate_lvl_bas_db_cons
1776: (
1777: p_person_id IN igs_pe_person.person_id%type,
1778: p_av_stnd_unit_lvl_id IN igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type,
1779: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1780: )
1781: RETURN VARCHAR2
1782: /*************************************************************
1784: Date Created on : 2002/11/13
1785: Purpose :
1786: validate_lvl_bas_db_cons function performs all the
1787: data integrity validation before inserting
1788: into the table IGS_AV_STD_ULVLBASIS_ALL
1789: Know limitations, enhancements or remarks
1790: Change History
1791: Who When What
1792: swaghmar 19-Oct-2005 Changed for bug# 4676359
1865: Date Created on : 2002/11/13
1866: Purpose :
1867: validate_lvl_bas function performs all the business
1868: validation before inserting into the table
1869: IGS_AV_STD_ULVLBASIS_ALL
1870: Know limitations, enhancements or remarks
1871: Change History
1872: Who When What
1873: (reverse chronological order - newest change first)