APPS.IGF_AW_GEN dependencies on IGF_AW_AWD_DIST_PLANS

Line 1738: PROCEDURE check_ld_cal_tps( p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

1734: END IF;
1735: END update_award;
1736:
1737:
1738: PROCEDURE check_ld_cal_tps( p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1739: p_found OUT NOCOPY VARCHAR2 ) IS
1740: ------------------------------------------------------------------
1741: --Created by :
1742: --Date created:

Line 1758: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

1754: -------------------------------------------------------------------
1755:
1756: --Get all terms using linked to the distribution plan
1757: CURSOR cur_check_terms(
1758: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1759: ) IS
1760: SELECT terms.adterms_id
1761: FROM igf_aw_dp_terms terms
1762: WHERE terms.adplans_id = p_adplans_id;

Line 1766: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

1762: WHERE terms.adplans_id = p_adplans_id;
1763: l_check_terms cur_check_terms%ROWTYPE;
1764: --Get incomplete terms
1765: CURSOR cur_check_teach(
1766: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1767: ) IS
1768: SELECT terms.adterms_id
1769: FROM igf_aw_dp_terms terms
1770: WHERE terms.adplans_id = p_adplans_id