1 PACKAGE igs_fi_prc_appl AUTHID CURRENT_USER AS
2 /* $Header: IGSFI56S.pls 115.10 2002/11/29 00:26:14 nsidana ship $ */
3
4 /******************************************************************
5 Created By : Vinay Chappidi
6 Date Created By : 25-Apr-2001
7 Purpose : This function is used when the user has not passed
8 any low date, returns the min effective date from the
9 credits table
10
11 Known limitations,
12 enhancements,
13 remarks :
14 Change History
15 Who When What
16 smadathi 20-NOV-2002 Enh. Bug 2584986. Added new parameter GL Date to procedure mass_application
17 and mass_apply
18 schodava 19-Sep-2002 Enh # 2564643 - Subaccount Removal
19 Modified procedures mass_application, mass_apply
20 agairola 23-May-2002 Added the procedure get_cal_details for bug 2378182
21 agairola 20-Mar-2002 Created a wrapper procedure mass_apply for the refunds
22 sykrishn 24-jAN-2002 Declaration of PL/SQL table for enh 2191470 -SFCR020
23 ******************************************************************/
24
25 /* The Pl/SQL table introduced in the earlier version intermdiate check in as the design was reverted back
26 Hence the spec will look similar to older versions */
27
28
29
30 PROCEDURE mass_application ( errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY NUMBER,
32 p_org_id NUMBER,
33 p_person_id igs_fi_inv_int_all.person_id%TYPE,
34 p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE DEFAULT NULL,
35 p_credit_number igs_fi_credits_all.credit_number%TYPE,
36 p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
37 p_credit_date_low VARCHAR2,
38 p_credit_date_high VARCHAR2,
39 p_d_gl_date VARCHAR2
40 ) ;
41
42 PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,
43 p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE DEFAULT NULL,
44 p_credit_number igs_fi_credits_all.credit_number%TYPE,
45 p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
46 p_credit_date_low VARCHAR2,
47 p_credit_date_high VARCHAR2,
48 p_d_gl_date DATE
49 ) ;
50
51 PROCEDURE get_cal_details(p_fee_cal_type igs_ca_inst.cal_type%TYPE,
52 p_fee_seq igs_ca_inst.sequence_number%TYPE,
53 p_end_dt OUT NOCOPY igs_ca_inst.end_dt%TYPE,
54 p_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
55 p_status OUT NOCOPY BOOLEAN);
56
57
58 END igs_fi_prc_appl;