1 PACKAGE IGS_AD_UHK_PSTATS_PKG AS
2 /* $Header: IGSADD7S.pls 120.0 2006/05/02 05:20:32 apadegal noship $ */
3
4 --
5 -- User Hook - which can be customisable by the customer.
6 --
7
8 PROCEDURE Derive_Person_Stats(
9 p_person_id IN NUMBER,
10 x_init_cal_type OUT NOCOPY VARCHAR2,
11 x_init_sequence_number OUT NOCOPY NUMBER,
12 x_recent_cal_type OUT NOCOPY VARCHAR2,
13 x_recent_sequence_number OUT NOCOPY NUMBER
14 ) ;
15
16 -- Who When What
17 -- apadegal 16/02/2006 Created the procedure
18
19 --
20 -- Parameters Description:
21 --
22 -- IN :
23 --
24 -- p_person_id parametet Applicant Person Identifier
25 --
26 -- OUT:
27 --
28 -- x_init_cal_type -- captures Calander Type of the Initial Admittance Term
29 -- x_init_sequence_number -- captures Calendar Sequence number of the Initial Admittance Term
30 -- x_recent_cal_type number -- captures Calander Type of the Most Recent Admittance Term
31 -- x_recent_sequence_number -- captures Calendar Sequence number of the Most Recent Initial Admittance Term
32 --
33 -- Note:
34 -- 1. The person statistics form ( IGSPE013) allows only active load calendars/academic calendars
35 -- for Initial and Most Recent Admittance term values. (If any other values are set, Form would give an error)
36 -- 2. Even if this user hook passes back values of Most recent admittance term,
37 -- these values will not be saved unless the profile value of IGS:Person Most Recent Admittance Term
38 -- is set to Accepted Application Offer Only
39
40 END IGS_AD_UHK_PSTATS_PKG;