eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_FI_VAL_FAS

Source


1 PACKAGE IGS_FI_VAL_FAS AS
2 /* $Header: IGSFI23S.pls 120.0 2005/06/01 17:30:25 appldev noship $ */
3 --
4 -- Change History
5 -- Who             When             What
6 -- masehgal        17-Jan-2002      ENH # 2170429
7 --                                  Obsoletion of SPONSOR_CD related paramaters
8   --
9   -- Validate fee assessable indicator value.
10   -- Enh # 2122257 (SFCR015 : Change In Fee Category)
11   -- Changed the signature of this function.
12   -- Added params fee_cal_type and fee_ci_sequence_number
13   FUNCTION finp_val_fas_ass_ind(
14   p_person_id IN NUMBER ,
15   p_course_cd IN VARCHAR2 ,
16   p_fee_cat IN VARCHAR2 ,
17   p_effective_dt IN DATE ,
18   p_transaction_type IN VARCHAR2 ,
19   p_fee_cal_type IN VARCHAR2 DEFAULT NULL,
20   p_fee_ci_sequence_number IN NUMBER DEFAULT NULL,
21   p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 PRAGMA RESTRICT_REFERENCES(finp_val_fas_ass_ind,WNDS);
24   --
25   -- Validate retrospective date of fee assessment period.
26   FUNCTION finp_val_fas_retro(
27   p_fee_type IN VARCHAR2 ,
28   p_fee_cal_type IN VARCHAR2 ,
29   p_fee_ci_sequence_number IN NUMBER ,
30   p_fee_cat IN VARCHAR2 ,
31   p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33 PRAGMA RESTRICT_REFERENCES(finp_val_fas_retro,WNDS);
34   --
35   -- Validate IGS_FI_FEE_AS_ALL.SI_FI_S_TRN_TYPE for a manual assessment.
36   FUNCTION finp_val_fas_cat(
37   p_transaction_type IN VARCHAR2 ,
38   p_message_name OUT NOCOPY VARCHAR2 )
39 RETURN BOOLEAN;
40 PRAGMA RESTRICT_REFERENCES(finp_val_fas_cat,WNDS);
41   --
42   -- Check if contract fee assessment rate exists for the student.
43   FUNCTION finp_val_fas_cntrct(
44   p_person_id IN NUMBER ,
45   p_course_cd IN VARCHAR2 ,
46   p_fee_type IN VARCHAR2 ,
47   p_effective_dt IN DATE ,
48   p_message_name OUT NOCOPY VARCHAR2 )
49 RETURN BOOLEAN;
50 PRAGMA RESTRICT_REFERENCES(finp_val_fas_cntrct,WNDS);
51   --
52   -- Validate that appropriate optional fields are entered for IGS_FI_FEE_AS.
53   FUNCTION finp_val_fas_create(
54   p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
55   p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
56   p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
57   p_message_name OUT NOCOPY VARCHAR2 )
58 RETURN BOOLEAN;
59 PRAGMA RESTRICT_REFERENCES(finp_val_fas_create,WNDS);
60   --
61   -- Ensure comment is recorded for a manual fee assessment.
62   FUNCTION finp_val_fas_com(
63   p_transaction_type IN VARCHAR2 ,
64   p_comments IN VARCHAR2 ,
65   p_message_name OUT NOCOPY VARCHAR2 )
66 RETURN BOOLEAN;
67 PRAGMA RESTRICT_REFERENCES(finp_val_fas_com,WNDS);
68   --
69   -- Validate effective date of fee assessment.
70   FUNCTION finp_val_fas_eff_dt(
71   p_fee_type IN VARCHAR2 ,
72   p_fee_cal_type IN VARCHAR2 ,
73   p_fee_ci_sequence_number IN NUMBER ,
74   p_fee_cat IN VARCHAR2 ,
75   p_effective_dt IN DATE ,
76   p_s_transaction_type IN VARCHAR2 ,
77   p_message_name OUT NOCOPY VARCHAR2 )
78 RETURN BOOLEAN;
79 PRAGMA RESTRICT_REFERENCES(finp_val_fas_eff_dt,WNDS);
80   --
81   -- Validate effect of transaction amount on student's balance.
82   FUNCTION finp_val_fas_balance(
83   p_person_id IN NUMBER ,
84   p_fee_type IN VARCHAR2 ,
85   p_fee_cal_type IN VARCHAR2 ,
86   p_fee_ci_sequence_number IN NUMBER ,
87   p_fee_cat IN VARCHAR2 ,
88   p_course_cd IN VARCHAR2 ,
89   p_transaction_amount IN NUMBER ,
90   p_message_name OUT NOCOPY VARCHAR2 )
91 RETURN BOOLEAN;
92 PRAGMA RESTRICT_REFERENCES(finp_val_fas_balance,WNDS);
93   --
94   -- Validate update to columns in the IGS_FI_FEE_AS table.
95 
96 -- Change History
97 -- Who           When           What
98 -- masehgal      17-Jan-2002    ENH # 2170429
99 --                              Obsoletion of SPONSOR_CD related parameters
100 
101   FUNCTION finp_val_fas_upd(
102   p_new_person_id  IGS_FI_FEE_AS_ALL.person_id%TYPE ,
103   p_old_person_id  IGS_FI_FEE_AS_ALL.person_id%TYPE ,
104   p_new_transaction_id  IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105   p_old_transaction_id  IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106   p_new_fee_type  IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107   p_old_fee_type  IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108   p_new_fee_cal_type  IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109   p_old_fee_cal_type  IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110   p_new_fee_ci_seq_num  IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111   p_old_fee_ci_seq_num  IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112   p_new_fee_cat  IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113   p_old_fee_cat  IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114   p_new_transaction_type  IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115   p_old_transaction_type  IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116   p_new_transaction_dt  IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117   p_old_transaction_dt  IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118   p_new_transaction_amount  IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119   p_old_transaction_amount  IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120   p_new_currency_cd  IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121   p_old_currency_cd  IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122   p_new_exchange_rate  IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123   p_old_exchange_rate  IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124   p_new_chg_elements  IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125   p_old_chg_elements  IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126   p_new_effective_dt  IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127   p_old_effective_dt  IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128   p_new_course_cd  IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129   p_old_course_cd  IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130   p_new_notification_dt  IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131   p_old_notification_dt  IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
132   p_new_logical_delete_dt  IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
133   p_old_logical_delete_dt  IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
134   p_message_name OUT NOCOPY VARCHAR2 )
135 RETURN BOOLEAN;
136 PRAGMA RESTRICT_REFERENCES(finp_val_fas_upd,WNDS);
137 END IGS_FI_VAL_FAS;