APPS.IGS_PR_GEN_005 dependencies on IGS_PR_GEN_006

Line 364: IF igs_pr_gen_006.igs_pr_ins_ssp_cmp_dtl (

360: v_ssp_sequence_number
361: );
362: --Insert the result of the evaluation of the rules.
363: --Note: the v_message_text will be null if p_evaluate_ind = 'N'
364: IF igs_pr_gen_006.igs_pr_ins_ssp_cmp_dtl (
365: v_rule_text,
366: v_message_text,
367: p_log_dt,
368: p_key || '|' || p_s_rule_call_cd || '|DETAIL',

Line 905: AND igs_pr_gen_006.igs_pr_get_spo_expiry (

901: AND spo.course_cd = p_course_cd
902: AND spo.decision_status IN (cst_approved, cst_pending)
903: AND spo.prg_cal_type = cp_latest_cal_type
904: AND spo.prg_ci_sequence_number = cp_latest_sequence_number
905: AND igs_pr_gen_006.igs_pr_get_spo_expiry (
906: spo.person_id,
907: spo.course_cd,
908: spo.sequence_number,
909: spo.expiry_dt) <> 'EXPIRED';