1 PACKAGE IGS_FI_GEN_004 AS
2 /* $Header: IGSFI04S.pls 120.1 2005/06/07 01:31:12 appldev $ */
3 --
4 /*************************************************************
5 Created By :
6 Date Created By :
7 Purpose :
8 Know limitations, enhancements or remarks
9 Change History
10 Who When What
11 bannamal 27-May-05 Fee Calculation Performance Enhancement. Changes done as per TD.
12 vchappid 11-Nov-02 Bug# 2584986, GL- Interface Build New Date parameter.
13 p_d_gl_date is added to the finp_prc_enr_fa_todo, finp_prc_enr_fee_ass procedure specification
14 vchappid 17-Oct-02 Bug#2595962.Removed the IN parameter p_predictive_ass_ind
15 from the procedure finp_prc_enr_fee_ass.
16 rnirwani 05-May-02 Bug# 2329407 removeal of reference to IGS_FI_DSBR_SPSHT
17 vchappid 02-Jan-02 Enh Bug#2162747, Key Program Implementation, Fin Cal Inst parameters
18 removed, new parameter p_c_career is added
19 (reverse chronological order - newest change first)
20 ***************************************************************/
21
22 FUNCTION finp_prc_cfar(
23 p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
24 p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
25 p_commencement_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
26 p_completion_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
27 p_message_name OUT NOCOPY VARCHAR2 )
28 RETURN BOOLEAN ;
29
30 --
31 PROCEDURE finp_prc_disb_jnl(
32 errbuf out NOCOPY varchar2,
33 retcode out NOCOPY NUMBER,
34 p_fin_period IN VARCHAR2 ,
35 p_fee_period IN VARCHAR2,
36 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
37 p_snapshot_create_dt_c IN DATE ,
38 p_income_type IN VARCHAR2 ,
39 p_ignore_prior_journals IN CHAR ,
40 p_percent_disbursement IN NUMBER,
41 p_org_id NUMBER
42 );
43 --
44 PROCEDURE finp_prc_disb_snpsht(
45 errbuf out NOCOPY varchar2,
46 retcode out NOCOPY NUMBER,
47 p_fin_period IN VARCHAR2,
48 p_fee_period IN VARCHAR2,
49 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
50 p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE,
51 p_org_id NUMBER
52 );
53 --
54 PROCEDURE finp_prc_enr_fa_todo(
55 errbuf out NOCOPY varchar2,
56 retcode out NOCOPY number,
57 P_FEE_CAL IN VARCHAR2 ,
58 p_org_id NUMBER,
59 p_d_gl_date IN VARCHAR2 DEFAULT NULL
60 );
61 --
62 PROCEDURE finp_prc_enr_fee_ass(
63 errbuf OUT NOCOPY VARCHAR2,
64 retcode OUT NOCOPY NUMBER,
65 p_person_id IN VARCHAR2,
66 p_person_grp_id IN VARCHAR2 DEFAULT NULL,
67 p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
68 p_fee_cal IN VARCHAR2,
69 p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
70 p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
71 p_trace_on IN VARCHAR2 ,
72 p_test_run IN VARCHAR2 ,
73 p_org_id NUMBER,
74 p_process_mode IN VARCHAR2 DEFAULT 'ACTUAL',
75 p_c_career IN igs_ps_ver.course_type%TYPE DEFAULT NULL,
76 p_d_gl_date IN VARCHAR2 DEFAULT NULL,
77 p_comments IN VARCHAR2 DEFAULT NULL
78 );
79 -- prameters process mode , init process prior calendar instance
80 -- and person id group have been added as a part
81 -- of the build for fee calc undertaken in July 2001.
82 -- Bug# 1851586
83
84 --
85 PROCEDURE finp_prc_hecs_pymnt_optn(
86 errbuf out NOCOPY varchar2,
87 retcode out NOCOPY NUMBER,
88 p_effective_dt_c IN OUT NOCOPY VARCHAR2 ,
89 P_fee_assessment_period IN VARCHAR2,
90 p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
91 p_fee_cat IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
92 p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
93 p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
94 p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
95 p_org_id NUMBER
96 );
97 --
98 PROCEDURE finp_prc_penalties(
99 errbuf out NOCOPY varchar2,
100 retcode out NOCOPY number,
101 p_effective_dt_c IN VARCHAR2 ,
102 P_fee_assessment_period IN VARCHAR2,
103 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
104 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
105 p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
106 p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
107 p_pending_fee_encmb_status IN VARCHAR2,
108 p_n_authorising_person_id IN NUMBER,
109 p_org_id NUMBER
110 );
111 --
112 PROCEDURE finp_prc_sca_unconf(
113 p_person_id IN NUMBER ,
114 p_course_cd IN VARCHAR2 ,
115 p_course_attempt_status IN VARCHAR2 ,
116 p_fee_cat IN VARCHAR2 ,
117 p_log_creation_dt IN DATE ,
118 p_key IN VARCHAR2 ,
119 p_admission_appl_number IN NUMBER ,
120 p_nominated_course_cd IN VARCHAR2 ,
121 p_acai_sequence_number IN NUMBER ,
122 p_fee_ass_log_creation_dt IN OUT NOCOPY DATE ,
123 p_delete_sca_ind OUT NOCOPY VARCHAR2 );
124 --
125 END IGS_FI_GEN_004;