[Home] [Help]
PACKAGE: APPS.IGF_AW_COA_GEN
Source
1 PACKAGE igf_aw_coa_gen AS
2 /* $Header: IGFAW17S.pls 120.1 2005/08/10 01:27:18 appldev noship $ */
3 ------------------------------------------------------------------
4 --Created by : veramach, Oracle India
5 --Date created: 07-Oct-2004
6 --
7 --Purpose:Generic APIs for COA module
8 --
9 --
10 --Known limitations/enhancements and/or remarks:
11 --
12 --Change History:
13 --Who When What
14 -------------------------------------------------------------------
15
16 FUNCTION coa_amount(
17 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
18 p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL,
19 p_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE DEFAULT 'N'
20 ) RETURN NUMBER;
21
22 FUNCTION award_amount(
23 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
24 p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL,
25 p_award_id igf_aw_award_all.award_id%TYPE DEFAULT NULL
26 ) RETURN NUMBER;
27
28 FUNCTION isCoaLocked(
29 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
30 p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
31 p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
32 p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
33 ) RETURN BOOLEAN;
34
35 FUNCTION doLock(
36 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
37 p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
38 p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
39 p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
40 ) RETURN VARCHAR2;
41
42 FUNCTION doUnlock(
43 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
44 p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
45 p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
46 p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
47 ) RETURN VARCHAR2;
48
49 TYPE base_details IS RECORD(
50 org_unit_cd igf_aw_coa_rate_det.org_unit_cd%TYPE,
51 program_type igf_aw_coa_rate_det.program_type%TYPE,
52 program_location_cd igf_aw_coa_rate_det.program_location_cd%TYPE,
53 program_cd igf_aw_coa_rate_det.program_cd%TYPE,
54 version_number igs_en_spa_terms.program_version%TYPE,
55 class_standing igf_aw_coa_rate_det.class_standing%TYPE,
56 residency_status_code igf_aw_coa_rate_det.residency_status_code%TYPE,
57 housing_status_code igf_aw_coa_rate_det.housing_status_code%TYPE,
58 attendance_type igf_aw_coa_rate_det.attendance_type%TYPE,
59 attendance_mode igf_aw_coa_rate_det.attendance_mode%TYPE,
60 months_enrolled_num NUMBER,
61 credit_points_num NUMBER
62 );
63
64 FUNCTION getBaseDetails(
65 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
66 p_ld_cal_type igs_ca_inst.cal_type%TYPE,
67 p_ld_sequence_number igs_ca_inst.sequence_number%TYPE
68 ) RETURN base_details;
69
70 PROCEDURE ins_coa_todo(
71 p_person_id hz_parties.party_id%TYPE DEFAULT NULL,
72 p_calling_module VARCHAR2,
73 p_program_code igs_ps_ver.course_cd%TYPE DEFAULT NULL,
74 p_version_number igs_ps_ver.version_number%TYPE DEFAULT NULL
75 );
76 ------------------------------------------------------------------
77 --Created by : veramach, Oracle India
78 --Date created: 07-OCT-2004
79 --
80 --Purpose:
81 -- Inserts records into IGS_PE_STD_TODO and IGS_PE_STD_TODO_REF for the given person_id,
82 -- thereby scheduling a COA Recomputation via concurrent process for the given person, in all open award years
83 --
84 -- Parameters:
85 -- IN Parameters:
86 -- 1.p_person_id - person_id of the student for whom COA needs to be recomputed
87 -- 2.p_calling_module - Module which schedules the COA recomputation because of a change in student attributes
88 -- 3.p_program_cd - This is passed when the key program is changed for the person
89 -- 4.p_version_number - This is passed when the key program is changed for the person
90 -- OUT Parameters:
91 -- None
92 --
93 --
94 --Known limitations/enhancements and/or remarks:
95 --
96 --Change History:
97 --Who When What
98 -------------------------------------------------------------------
99
100 PROCEDURE get_coa_months(
101 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
102 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
103 p_start_dt OUT NOCOPY DATE,
104 p_end_dt OUT NOCOPY DATE,
105 p_coa_months OUT NOCOPY NUMBER
106 );
107
108 FUNCTION set_awd_proc_status(
109 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
110 p_award_prd_code IN igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL
111 ) RETURN VARCHAR2;
112
113 PROCEDURE get_award_period_dates(
114 p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
115 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
116 p_award_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
117 p_start_date OUT NOCOPY DATE,
118 p_end_date OUT NOCOPY DATE
119 );
120
121 FUNCTION canUseAnticipVal RETURN BOOLEAN;
122
123 PROCEDURE check_oss_attrib(
124 p_org_unit_code IN igf_ap_fa_ant_data.org_unit_cd%TYPE,
125 p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,
126 p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,
127 p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,
128 p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,
129 p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,
130 p_ret_status OUT NOCOPY VARCHAR2
131 );
132 FUNCTION coa_duration(
133 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
134 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
135 ) RETURN NUMBER;
136 END igf_aw_coa_gen;