APPS.IGS_PR_GEN_004 dependencies on IGS_PR_GEN_001

Line 442: IGS_PR_GEN_001.PRGP_get_crv_cmt

438: AND
439: (
440: p_org_unit_cd IS NULL
441: OR
442: IGS_PR_GEN_001.PRGP_get_crv_cmt
443: (
444: sca.course_cd,
445: sca.version_number,
446: p_org_unit_cd,

Line 2955: 'AND igs_pr_gen_001.prgp_get_crv_cmt (sca.course_cd, sca.version_number, ' ||

2951: -- Append Organization Unit filter to the Where clause only when it is passed
2952: --
2953: IF (p_org_unit_cd IS NOT NULL AND p_ou_start_dt IS NOT NULL) THEN
2954: stmt_str := stmt_str ||
2955: 'AND igs_pr_gen_001.prgp_get_crv_cmt (sca.course_cd, sca.version_number, ' ||
2956: '''' || p_org_unit_cd || ''', TO_DATE (''' || TO_CHAR(p_ou_start_dt, 'YYYY/MM/DD') || ''', ''YYYY/MM/DD'')) = ''Y'' ';
2957: END IF;
2958: --
2959: -- Append Attendance Mode filter to the Where clause only when it is passed

Line 3113: IGS_PR_GEN_001.prgp_get_crv_cmt (

3109: NVL(p_location_cd, sca.location_cd)
3110: = sca.location_cd AND
3111: (p_org_unit_cd IS NULL OR
3112: p_ou_start_dt IS NULL OR
3113: IGS_PR_GEN_001.prgp_get_crv_cmt (
3114: sca.course_cd,
3115: sca.version_number,
3116: p_org_unit_cd,
3117: p_ou_start_dt) = 'Y') AND

Line 5532: AND igs_pr_gen_001.prgp_get_crv_cmt (

5528: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5529: WHERE pra.s_relation_type = cst_ou
5530: AND pra.progression_rule_cat = cp_prg_rule_cat
5531: AND pra.logical_delete_dt IS NULL
5532: AND igs_pr_gen_001.prgp_get_crv_cmt (
5533: cp_course_cd,
5534: cp_version_number,
5535: pra.ou_org_unit_cd,
5536: pra.ou_start_dt