1 PACKAGE igs_fi_prc_holds AS
2 /* $Header: IGSFI67S.pls 120.1 2005/10/10 08:16:10 appldev ship $ */
3
4 /***************************************************************
5 Created By : bayadav
6 Date Created By : 29-Nov-2001
7 Purpose : Process for batch application of holdsfor a person / group of persons / all persons
8 and release of holds for a person / group of persons / all persons
9 Known Limitations,Enhancements or Remarks:
10 Change History :
11 Who When What
12 smadathi 28-Aug-2003 Enh Bug 3045007. Removed the parameter P_OFFSET_DAYS from
13 procedure finp_apply_holds.
14 pathipat 12-Aug-2003 Enh 3076768 - Automatic Release of Holds
15 Added procedure finp_auto_release_holds()
16 pathipat 25-Feb-2003 Enh:2747341 - Additional Security for Holds build
17 Removed parameter p_auth_person_id in proc finp_apply_holds
18 ***************************************************************/
19
20
21 --procedure for batch application of holdsfor a person / group of persons / all persons
22 PROCEDURE finp_apply_holds(errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY NUMBER,
24 p_person_id IN igs_pe_person_v.person_id%TYPE DEFAULT NULL,
25 p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE DEFAULT NULL,
26 P_process_start_date IN VARCHAR2 ,
27 P_process_end_date IN VARCHAR2 ,
28 P_hold_plan_name IN Igs_fi_hold_plan.hold_plan_name%Type,
29 P_fee_period IN VARCHAR2,
30 P_test_run IN VARCHAR2 DEFAULT 'Y' );
31
32 --procedure for batch release of holds on a person / group of persons / all persons .It can be called from form or as concurrent process by wrapper prcedure
33 PROCEDURE finp_release_holds_main(p_person_id IN igs_pe_person.person_id%TYPE DEFAULT NULL,
34 p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE DEFAULT NULL,
35 P_hold_plan_name IN Igs_fi_hold_plan.hold_plan_name%TYPE DEFAULT NULL,
36 P_test_run IN VARCHAR2 DEFAULT 'Y',
37 P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE);
38
39 --Wrapper procedure to call above procedure for release holds on a person / group of persons / all persons
40 PROCEDURE finp_release_holds( errbuf OUT NOCOPY VARCHAR2,
41 retcode OUT NOCOPY NUMBER,
42 p_person_id IN igs_pe_person.person_id%TYPE ,
43 p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
44 P_hold_plan_name IN Igs_fi_hold_plan.hold_plan_name%Type,
45 P_test_run IN VARCHAR2 ) ;
46
47 -- Wrapper procedure invoked to automatically release holds when a student makes a credit payment
48 -- through Self Service or through the Receipts form.
49 PROCEDURE finp_auto_release_holds ( p_person_id IN NUMBER,
50 p_hold_plan_level IN VARCHAR2,
51 p_release_credit_id IN NUMBER,
52 p_run_application IN VARCHAR2,
53 p_message_name OUT NOCOPY VARCHAR2
54 );
55
56 END igs_fi_prc_holds;