25: *======================================================================*/
26:
27:
28: PROCEDURE update_plan(
29: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
30: p_method_code IN VARCHAR2,
31: p_result OUT NOCOPY VARCHAR2
32: );
33:
35: p_award_id igf_aw_award.award_id%TYPE
36: );
37:
38: PROCEDURE check_plan_code(
39: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
40: p_result OUT NOCOPY VARCHAR2
41: );
42:
43: PROCEDURE delete_plan(
40: p_result OUT NOCOPY VARCHAR2
41: );
42:
43: PROCEDURE delete_plan(
44: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
45: p_adterms_id igf_aw_dp_terms.adterms_id%TYPE DEFAULT NULL
46: );
47:
48: FUNCTION get_stud_hold_effect(