[Home] [Help]
PACKAGE: APPS.IGF_AW_GEN_005
Source
1 PACKAGE igf_aw_gen_005 AS
2 /* $Header: IGFAW14S.pls 120.0 2005/06/02 15:53:50 appldev noship $ */
3 /*======================================================================+
4 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | |
8 | DESCRIPTION |
9 | PL/SQL spec for package: IGF_AW_GEN_005 |
10 | |
11 | NOTES |
12 | Holds all the generic Routines |
13 | |
14 | HISTORY |
15 | Who When What |
16 | veramach Oct 2004 FA 152/FA 137 - Changes to wrappers to|
17 | bring in the awarding period setup |
18 | veramach 1-NOV-2003 FA 125 Multiple Distribution Methods |
19 | Added procedures update_plan, |
20 | update_dist_plan,delete_plan, |
21 | check_plan_code |
22 | brajendr 08-Jan-2003 Bug # 2710314 |
23 | Added a Function validate_student_efc |
24 | for checking the validity of EFC |
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
34 PROCEDURE update_dist_plan(
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(
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(
49 p_orig IN VARCHAR2,
50 p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
51 p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE DEFAULT NULL,
52 p_date IN DATE DEFAULT NULL
53 ) RETURN VARCHAR2;
54
55
56 FUNCTION validate_student_efc(
57 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
58 p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
59 ) RETURN VARCHAR2;
60 END igf_aw_gen_005;