[Home] [Help]
PACKAGE: APPS.IGS_FI_LOAD_EXT_CHG
Source
1 PACKAGE igs_fi_load_ext_chg AS
2 /* $Header: IGSFI50S.pls 120.0 2005/06/01 21:52:41 appldev noship $ */
3
4 /*********************************************************************
5 Who When What
6 pmarada 30-nov-2004 Bug 4003908, Added get_std_formerstd_ind funcation to return whether person is
7 of student and former student person type
8 pathipat 16-Nov-2002 Enh Bug 2584986 - Added parameter p_d_gl_date in igs_fi_Ext_val()
9 sykrishn 03-JUL-2002 Declaration of transaction_dt is changed since transaction_dt no longer exist in
10 the table IGS_FI_EXT_INT_ALL
11
12 **********************************************************************/
13
14 FUNCTION Igs_Fi_Ext_Val (p_person_id igs_fi_ext_int_all.person_id%TYPE,
15 p_fee_type igs_fi_ext_int_all.fee_type%TYPE,
16 p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
17 p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
18 p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE DEFAULT SYSDATE,
19 p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,
20 p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE DEFAULT SYSDATE,
21 p_d_gl_date DATE,
22 p_message_name OUT NOCOPY VARCHAR2)
23 RETURN BOOLEAN;
24
25 PROCEDURE igs_fi_extto_imp (errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY NUMBER,
27 p_org_id NUMBER,
28 p_person_id igs_fi_ext_int_all.person_id%TYPE DEFAULT NULL,
29 p_fee_type igs_fi_ext_int_all.fee_type%TYPE DEFAULT NULL,
30 p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
31 p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE
32 );
33
34 FUNCTION get_std_formerstd_ind(p_person_id IN igs_pe_typ_instances_all.person_id%TYPE)
35 RETURN VARCHAR2;
36 PRAGMA RESTRICT_REFERENCES(get_std_formerstd_ind, WNDS);
37
38 END igs_fi_load_ext_chg;