DBA Data[Home] [Help]

PACKAGE: APPS.IGS_FI_GEN_003

Source


1 PACKAGE IGS_FI_GEN_003 AS
2 /* $Header: IGSFI03S.pls 120.2 2005/08/26 07:00:09 appldev ship $ */
3 
4 /***********************************************
5 Change History
6 svuppala  23-JUN-2005   Bug 3392088 Modifications as part of CPF build
7                         Added 2 functions finp_del_fsert, finp_del_fser
8 rnirwani   05-May-02 removed reference to IGS_FI_DSBR_SPSHT bug# 2329407
9 rnirwani - 25-APR-02 Obsoleted the procedures:
10                                     finp_ins_disb_jnl
11                                     FINP_DEL_DISB_JNL
12                                     Bug# 2329407
13 ************************************************/
14 
15 --
16 PROCEDURE FINP_DEL_DISB_SNPSHT(
17   errbuf  out NOCOPY  varchar2,
18   retcode out NOCOPY  NUMBER,
19   p_fee_period IN VARCHAR2,
20   p_fee_type VARCHAR2 ,
21   p_snapshot_create_dt_C VARCHAR2,
22   p_delete_ds_ind  VARCHAR2 ,
23   p_delete_dsd_ind  VARCHAR2 ,
24   p_delete_dda_ind  VARCHAR2,
25   p_org_id NUMBER
26   );
27 --
28 FUNCTION finp_del_err(
29   p_fee_type IN VARCHAR2 ,
30   p_fee_cal_type IN VARCHAR2 ,
31   p_fee_ci_sequence_number IN NUMBER ,
32   p_s_relation_type IN VARCHAR2 ,
33   p_fee_cat IN VARCHAR2 ,
34   p_range_number IN NUMBER ,
35   p_rate_number IN NUMBER ,
36   p_message_name OUT NOCOPY VARCHAR2 )
37 RETURN BOOLEAN ;
38 --
39 PROCEDURE finp_del_minor_debt(
40   errbuf  out NOCOPY  varchar2,
41   retcode out NOCOPY  number,
42   P_FEE_ASSESSMENT_PERIOD IN VARCHAR2 ,
43   p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
44   p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
45   p_course_cd IN igs_ps_course.course_cd%type,
46   p_person_id	   IN HZ_PARTIES.PARTY_ID%type,
47   p_group_id IN IGS_PE_PERSID_GROUP_ALL.group_id%TYPE ,
48   p_min_days_overdue IN NUMBER,
49   p_max_outstanding IN IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
50   p_comments IN igs_fi_fee_as_all.comments%type,
51   p_org_id NUMBER );
52 --
53 FUNCTION finp_ins_cfar(
54   p_person_id  IGS_FI_FEE_AS_RT.person_id%TYPE ,
55   p_course_cd  IGS_FI_FEE_AS_RT.course_cd%TYPE ,
56   p_fee_type  IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57   p_start_dt  IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58   p_end_dt  IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59   p_location_cd  IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60   p_attendance_type  IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61   p_attendance_mode  IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
62   p_chg_rate  IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
63   p_lower_nrml_rate_ovrd_ind  IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
64   p_message_name OUT NOCOPY VARCHAR2 )
65 RETURN BOOLEAN ;
66 --
67 FUNCTION finp_del_fsert(
68   p_sub_er_id NUMBER,
69   p_message_name OUT NOCOPY VARCHAR2 )
70 RETURN BOOLEAN;
71 
72 --
73 FUNCTION finp_del_fser(
74   p_er_id NUMBER,
75   p_message_name OUT NOCOPY VARCHAR2 )
76 RETURN BOOLEAN;
77 
78 --
79 FUNCTION finp_del_sub_rt(
80   p_sub_err_id NUMBER,
81   p_message_name OUT NOCOPY VARCHAR2 )
82 RETURN BOOLEAN;
83 --
84 END IGS_FI_GEN_003;