[Home] [Help]
PACKAGE: APPS.IGF_AW_CANCEL_AWD
Source
1 PACKAGE igf_aw_cancel_awd AS
2 /* $Header: IGFAW06S.pls 120.1 2005/10/06 09:13:23 appldev ship $ */
3
4 /*
5 || Created On : 12-Jun-2001
6 || Purpose :
7 || Known limitations, enhancements or remarks :
8 || Change History :
9 || Who When What
10 || skoppula 19-Apr-2002 Bug 2272349
11 || (reverse chronological order - newest change first)
12 */
13
14 PROCEDURE cancel_award(
15 ERRBUF OUT NOCOPY VARCHAR2,
16 RETCODE OUT NOCOPY NUMBER,
17 p_award_year IN VARCHAR2,
18 p_fund_id IN igf_aw_award_all.fund_id%TYPE,
19 p_run_mode IN igf_lookups_view.lookup_code%TYPE,
20 p_base_id IN igf_ap_fa_con_v.base_id%TYPE,
21 p_org_id IN igf_aw_award_all.org_id%TYPE,
22 p_pig IN igs_pe_all_persid_group_v.group_id%TYPE
23 );
24
25 FUNCTION chk_awd_cancel(p_award_id IN igf_aw_award.award_id%TYPE,
26 p_base_id IN igf_aw_award.base_id%TYPE,
27 p_fund_id IN igf_aw_award.fund_id%TYPE,
28 p_msg_name OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
29
30 PROCEDURE cancel_award_fabase (
31 p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
32 p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
33 p_fund_id IN igf_aw_award_all.fund_id%TYPE,
34 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
35 p_run_mode IN igf_lookups_view.lookup_code%TYPE
36 );
37
38 FUNCTION chk_awd_exp_date (
39 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
40 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
41 p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42 p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
43 p_run_mode IN igf_lookups_view.lookup_code%TYPE
44 ) RETURN BOOLEAN;
45
46 PROCEDURE get_base_id_per_num (
47 p_person_id IN hz_parties.party_id%TYPE,
48 p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49 p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
50 p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
51 p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE
52 );
53
54 END igf_aw_cancel_awd;