DBA Data[Home] [Help]

APPS.IGS_PR_GEN_003 dependencies on IGS_PR_GEN_001

Line 175: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT (

171: CURSOR c_sopc IS
172: SELECT sopc.org_unit_cd,
173: sopc.ou_start_dt
174: FROM IGS_PR_S_OU_PRG_CONF sopc
175: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT (
176: p_course_cd,
177: p_version_number,
178: sopc.org_unit_cd,
179: sopc.ou_start_dt) = 'Y';

Line 184: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT (

180: CURSOR c_sopca IS
181: SELECT sopca.org_unit_cd,
182: sopca.ou_start_dt
183: FROM IGS_PR_S_OU_PRG_CAL sopca
184: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT (
185: p_course_cd,
186: p_version_number,
187: sopca.org_unit_cd,
188: sopca.ou_start_dt) = 'Y';

Line 598: BEGIN -- IGS_PR_GEN_001.IGS_PR_INS_PRG_MSR

594: since this file is not being modified as part of the bug#3031749
595: -------------------------------------------------------------------*/
596:
597: gv_other_detail VARCHAR2(255);
598: BEGIN -- IGS_PR_GEN_001.IGS_PR_INS_PRG_MSR
599: -- Insert the appropriate progression measures for a nominated
600: -- student course attempt within a nominated progression period.
601: --
602: --The routine checks the system parameters applying to the students