1 PACKAGE igs_fi_gen_006 AUTHID CURRENT_USER AS
2 /* $Header: IGSFI44S.pls 115.8 2003/02/21 14:40:39 vchappid ship $ */
3 --
4 -- vchappid 20-Feb-2003 Bug# 2747335, new function created, validates user-defined
5 -- Person Type Id exists in system.
6 -- nalkumar 11-Dec-2001 Removed the function finp_mnt_fee_encmb from this package.
7 -- This is as per the SFCR015-HOLDS DLD. Bug:2126091
8 --
9 -- Nalin Kumar 16-Jan-2002 Added 'SET VERIFY OFF' before whenever sqlerr... |
10 PROCEDURE finp_ins_stmnt_o_acc(
11 errbuf out NOCOPY varchar2,
12 retcode out NOCOPY number,
13 p_correspondence_type IN VARCHAR2 ,
14 P_FIN_PERD IN VARCHAR2,
15 P_FEE_PERD IN VARCHAR2,
16 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
17 p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
18 p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
19 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
20 p_person_group_id IN NUMBER ,
21 p_institution_cd IN VARCHAR2 ,
22 p_addr_type IN VARCHAR2 ,
23 P_DATE_OF_ISSUE_C IN VARCHAR2,
24 p_comment IN VARCHAR2 ,
25 p_test_extraction IN VARCHAR2 ,
26 p_org_id NUMBER
27 );
28
29 PROCEDURE finp_mnt_pymnt_schdl(
30 errbuf out NOCOPY varchar2,
31 retcode out NOCOPY number,
32 P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
33 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
34 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
35 p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
36 p_notification_dt_c IN VARCHAR2,
37 p_num_days_to_notification NUMBER ,
38 p_next_bus_day_ind IN VARCHAR,
39 p_org_id NUMBER
40 );
41
42 FUNCTION finp_mnt_hecs_pymnt_optn(
43 p_effective_dt IN DATE ,
44 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
45 p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
46 p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
47 p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
48 p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
49 p_update_ind IN VARCHAR2 DEFAULT 'N',
50 p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE ,
51 p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE ,
52 p_creation_dt IN OUT NOCOPY IGS_GE_S_LOG.creation_dt%TYPE ,
53 p_hecs_payment_type OUT NOCOPY fnd_lookup_values.LOOKUP_CODE%TYPE ,
54 p_message_name OUT NOCOPY VARCHAR2)
55 RETURN BOOLEAN ;
56
57 PROCEDURE validate_prsn_id_typ(p_c_usr_alt_prs_id_typ IN VARCHAR2,
58 p_c_unique IN VARCHAR2,
59 p_b_status OUT NOCOPY BOOLEAN,
60 p_c_sys_alt_prs_id_typ OUT NOCOPY VARCHAR2);
61
62 END igs_fi_gen_006;