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.

APPS.IGS_FI_LOAD_EXT_CHG dependencies on IGS_FI_EXT_INT_ALL

Line 10: the table IGS_FI_EXT_INT_ALL

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,

Line 14: FUNCTION Igs_Fi_Ext_Val (p_person_id igs_fi_ext_int_all.person_id%TYPE,

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,

Line 15: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,

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,

Line 16: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,

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,

Line 17: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,

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,

Line 18: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE DEFAULT SYSDATE,

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)

Line 19: p_currency_cd igs_fi_ext_int_all.currency_cd%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;

Line 20: p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE DEFAULT SYSDATE,

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:

Line 28: p_person_id igs_fi_ext_int_all.person_id%TYPE DEFAULT NULL,

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: );

Line 29: p_fee_type igs_fi_ext_int_all.fee_type%TYPE DEFAULT NULL,

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:

Line 30: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,

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)

Line 31: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE

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;