[Home] [Help]
PACKAGE: APPS.IGF_AW_ROLLOVER
Source
1 PACKAGE igf_aw_rollover AS
2 /* $Header: IGFAW08S.pls 120.3 2005/10/20 23:57:40 appldev ship $ */
3
4
5 PROCEDURE main(
6 errbuf OUT NOCOPY VARCHAR2,
7 retcode OUT NOCOPY NUMBER,
8 p_frm_award_year IN VARCHAR2,
9 --p_to_award_year IN VARCHAR2,
10 p_fund_attribute IN VARCHAR2,
11 p_org_id IN igf_aw_award_all.org_id%TYPE,
12 p_rate_table IN VARCHAR2,
13 p_inst_application IN VARCHAR2,
14 p_distribution_plan IN VARCHAR2,
15 p_coa_group IN VARCHAR2,
16 p_todo IN VARCHAR2,
17 p_award_grp IN VARCHAR2
18 );
19
20 FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
21 p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
22 p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
23 p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
24 ) RETURN BOOLEAN;
25
26
27 FUNCTION get_fund_cd (
28 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
29 p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
30 p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
31 ) RETURN igf_aw_fund_mast_all.fund_code%TYPE;
32
33
34 FUNCTION get_plan_cd(
35 p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
36 p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
37 p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
38 ) RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE;
39
40
41 FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42 p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
43 p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
44 p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
45 p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
46 )
47 RETURN VARCHAR;
48
49
50 END igf_aw_rollover;