APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_AV_VAL_ASU

Line 1681: (igs_av_val_asu.granted_adv_standing(person_id,as_course_cd,as_version_number,

1677: WHERE asu.person_id = p_person_id AND
1678: asu.as_course_cd = p_course_cd AND
1679: asu.s_adv_stnd_granting_status = 'GRANTED' AND
1680: asu.s_adv_stnd_recognition_type = 'CREDIT' AND
1681: (igs_av_val_asu.granted_adv_standing(person_id,as_course_cd,as_version_number,
1682: asu.unit_cd,asu.version_number,'GRANTED',NULL) ='TRUE') AND
1683: asu.unit_cd = uv.unit_cd AND
1684: asu.version_number = uv.version_number
1685: GROUP BY person_id,as_course_cd,as_version_number,asu.unit_cd,asu.version_number,uv.short_title,

Line 1737: l_advgrant := igs_av_val_asu.adv_Credit_pts(p_person_id,p_course_cd,v_Asu_rec.as_version_number,

1733: FOR v_asu_rec IN c_asu LOOP
1734: -- Store the UNIT in the PL/SQL table.
1735: -- Increment the counter.
1736:
1737: l_advgrant := igs_av_val_asu.adv_Credit_pts(p_person_id,p_course_cd,v_Asu_rec.as_version_number,
1738: v_asu_rec.unit_cd,v_asu_rec.version_number,
1739: 'GRANTED',NULL,l_credits,l_s_adv_atnd_granting_status,l_message);-- academic records maint. DLD
1740: IF NOT l_advgrant THEN
1741: l_credits := 0;

Line 1843: -- logic in the c_adv cursor is modified to look into igs_av_val_Asu.granted_Adv_standing

1839: -- which the advanced standing has been granted. This is not possible
1840: -- until the application component of advanced standing is built.
1841: --
1842: -- CHANGE : As part of academic records maintenance DLD the existing credit percentage
1843: -- logic in the c_adv cursor is modified to look into igs_av_val_Asu.granted_Adv_standing
1844: DECLARE
1845: v_out_string VARCHAR2(255);
1846: v_index BINARY_INTEGER;
1847: v_dummy VARCHAR2(1);

Line 1862: (igs_av_val_asu.granted_adv_standing(person_id,as_course_cd,as_version_number,

1858: WHERE asu.person_id = adv.person_id AND
1859: asu.as_course_cd = adv.course_cd AND
1860: asu.s_adv_stnd_granting_status = 'GRANTED' AND
1861: asu.s_adv_stnd_recognition_type = 'CREDIT' AND
1862: (igs_av_val_asu.granted_adv_standing(person_id,as_course_cd,as_version_number,
1863: unit_cd,version_number,'GRANTED',NULL) ='TRUE')) OR
1864: EXISTS (SELECT 'x'
1865: FROM IGS_AV_STND_UNIT_LVL asule
1866: WHERE asule.person_id = adv.person_id AND