[Home] [Help]
PACKAGE: APPS.IGS_FI_PAYMENT_PLANS
Source
1 PACKAGE igs_fi_payment_plans AS
2 /* $Header: IGSFI87S.pls 120.0 2005/06/03 15:51:26 appldev noship $ */
3
4 /*=======================================================================+
5 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
6 | All rights reserved. |
7 +=======================================================================+
8 | |
9 | DESCRIPTION |
10 | PL/SQL body for package: IGS_FI_PAYMENT_PLANS |
11 | |
12 | NOTES |
13 | New Package created for Payment Plans concurrent processes. |
14 | Enh # 3045007 |
15 | HISTORY |
16 | Who When What |
17 | vvutukur 27-Aug-2003 Creation of the package. |
18 *=======================================================================*/
19
20 PROCEDURE activate_plan(errbuf OUT NOCOPY VARCHAR2,
21 retcode OUT NOCOPY NUMBER,
22 p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
23 p_v_fee_period IN VARCHAR2 DEFAULT NULL,
24 p_n_offset_days IN NUMBER DEFAULT NULL
25 );
26 ------------------------------------------------------------------
27 --Created by : vvutukur, Oracle IDC
28 --Date created: 04-Sep-2003
29 --
30 --Purpose: Concurrent process that activates the Payment Plans
31 -- that are in a planned status for the Student.
32 --
33 --Known limitations/enhancements and/or remarks:
34 --
35 --Change History:
36 --Who When What
37 -------------------------------------------------------------------
38
39 PROCEDURE assign_students(errbuf OUT NOCOPY VARCHAR2,
40 retcode OUT NOCOPY NUMBER,
41 p_v_payment_plan_name IN igs_fi_pp_templates.payment_plan_name%TYPE,
42 p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
43 p_v_start_date IN VARCHAR2,
44 p_v_fee_period IN VARCHAR2 DEFAULT NULL
45 );
46 ------------------------------------------------------------------
47 --Created by : vvutukur, Oracle IDC
48 --Date created: 04-Sep-2003
49 --
50 --Purpose: Concurrent process that assigns a Payment Plan to a Student.
51 --
52 --Known limitations/enhancements and/or remarks:
53 --
54 --Change History:
55 --Who When What
56 -------------------------------------------------------------------
57
58 PROCEDURE close_status(errbuf OUT NOCOPY VARCHAR2,
59 retcode OUT NOCOPY NUMBER,
60 p_n_tolerance_threshold IN NUMBER,
61 p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE DEFAULT NULL,
62 p_v_test_mode IN VARCHAR2
63 );
64 ------------------------------------------------------------------
65 --Created by : vvutukur, Oracle IDC
66 --Date created: 27-Aug-2003
67 --
68 --Purpose: Concurrent process that closes the Student ACTIVE Payment Plans.
69 --
70 --Known limitations/enhancements and/or remarks:
71 --
72 --Change History:
73 --Who When What
74 -------------------------------------------------------------------
75 END igs_fi_payment_plans;