APPS.IGS_PR_GEN_005 dependencies on IGS_PR_GEN_001

Line 587: AND igs_pr_gen_001.prgp_get_cal_stream (

583: FROM igs_pr_stdnt_pr_ck spc,
584: igs_ca_inst ci1
585: WHERE spc.person_id = p_person_id
586: AND spc.course_cd = p_course_cd
587: AND igs_pr_gen_001.prgp_get_cal_stream (
588: p_course_cd,
589: p_version_number,
590: p_prg_cal_type,
591: spc.prg_cal_type

Line 1285: WHERE igs_pr_gen_001.prgp_get_crv_cmt (

1281: AND spc1.stream_num = spc2.stream_num)
1282: OR EXISTS ( SELECT 'x'
1283: FROM igs_pr_s_ou_prg_cal sopc1,
1284: igs_pr_s_ou_prg_cal sopc2
1285: WHERE igs_pr_gen_001.prgp_get_crv_cmt (
1286: p_course_cd,
1287: p_course_version_number,
1288: sopc1.org_unit_cd,
1289: sopc1.ou_start_dt

Line 1332: IF igs_pr_gen_001.prgp_get_crv_cmt (

1328: OR p_course_version_number <> p_pra_crv_version_number THEN
1329: RETURN 'N';
1330: END IF;
1331: ELSIF p_pra_s_relation_type = 'OU' THEN
1332: IF igs_pr_gen_001.prgp_get_crv_cmt (
1333: p_course_cd,
1334: p_course_version_number,
1335: p_pra_ou_org_unit_cd,
1336: p_pra_ou_start_dt

Line 1365: IF igs_pr_gen_001.prgp_get_drtn_efctv (

1361: RETURN 'Y';
1362: ELSE
1363: v_count_of_records := 0;
1364: FOR v_ci_rec IN c_ci_ct_cs LOOP
1365: IF igs_pr_gen_001.prgp_get_drtn_efctv (
1366: v_ci_rec.cal_type,
1367: v_ci_rec.sequence_number,
1368: p_person_id,
1369: p_course_cd