[Home] [Help]
PACKAGE: APPS.IGS_FI_GEN_005
Source
1 PACKAGE igs_fi_gen_005 AS
2 /* $Header: IGSFI05S.pls 120.0 2005/06/01 18:53:22 appldev noship $ */
3 ------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --pathipat 21-Sep-2004 Enh 3880438 - Retention Enhancements
7 -- Removed function get_retention_amount
8 -- pathipat 14-Oct-2003 Enh 3117341 - Audit and Special Fees TD
9 -- Added function get_retention_amount
10 --smadathi 03-Jan-2003 Bug 2684895. Created new generic function
11 -- finp_get_prsid_grp_code which returns group code
12 --sarakshi 13-Sep-2002 Enh#2564643,removed the function validate_psa.
13 --smadathi 27-Feb-2002 Bug 2238413. Pragma associated with
14 -- finp_get_receivables_inst removed.
15 --jbegum 08-Feb-2002 Bug 2201081.Added function validate_psa.
16 --sarakshi 02-Feb-2002 Bug 2195715.Added function finp_get_acct_meth
17 --smadathi 22-Jan-2002 Bug 2170429. Procedure FINP_SET_FSS_EXPIRED
18 -- removed.
19 ------------------------------------------------------------------
20
21
22 FUNCTION finp_val_fee_lblty(
23 p_person_id IN NUMBER ,
24 p_course_cd IN VARCHAR2 ,
25 p_fee_cat IN VARCHAR2 ,
26 p_fee_type IN VARCHAR2 ,
27 p_effective_dt IN DATE ,
28 p_message_name OUT NOCOPY VARCHAR2 )
29 RETURN BOOLEAN ;
30 --pragma restrict_references(finp_val_fee_lblty,wnds);
31 --
32 FUNCTION finp_val_fee_trigger(
33 p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
34 p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
35 p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
36 p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
37 p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
38 p_effective_dt IN DATE ,
39 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
40 p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
41 p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42 p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43 p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
44 p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
45 p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
46 p_trigger_fired OUT NOCOPY VARCHAR2 )
47 RETURN BOOLEAN;
48 --pragma restrict_references(finp_val_fee_trigger,wnds);
49 --
50 FUNCTION fins_val_fee_trigger(
51 p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
52 p_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
53 p_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
54 p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
55 p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
56 p_effective_dt DATE ,
57 p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
58 p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
59 p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60 p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61 p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
62 p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
63 p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
64 RETURN CHAR ;
65 --pragma restrict_references(fins_val_fee_trigger,wnds);
66 --
67 --
68 PROCEDURE finp_set_pymnt_schdl(
69 errbuf out NOCOPY varchar2,
70 retcode out NOCOPY number,
71 P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
72 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
73 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
74 p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
75 p_grace_days IN NUMBER ,
76 p_effective_dt_c IN VARCHAR2 ,
77 p_notification_dt_c IN VARCHAR2 ,
78 p_include_man_entries IN VARCHAR2 DEFAULT 'N',
79 p_next_bus_day IN VARCHAR2 DEFAULT 'N',
80 p_org_id NUMBER
81 );
82 --
83 FUNCTION finp_get_receivables_inst RETURN IGS_FI_CONTROL.Rec_Installed%TYPE;
84
85 FUNCTION finp_get_acct_meth RETURN igs_fi_control.accounting_method%TYPE;
86 pragma restrict_references(finp_get_acct_meth,wnds);
87
88 -- This generic functions returns group code for the person group id passed as parameter to the function
89 FUNCTION finp_get_prsid_grp_code(p_n_group_id IN igs_pe_persid_group.group_id%TYPE) RETURN VARCHAR2;
90
91
92 END igs_fi_gen_005;