1 PACKAGE igs_pr_user_class_std
2 /* $Header: IGSPR39S.pls 120.0 2006/04/29 02:15:56 swaghmar noship $ */
3 AS
4 -------------------------------------------------------------------------------------------
5 --Creation:
6 --User Hook procedure to allow users to use their own logic to derive the Class Standing.
7 --If there is no Institution specific Class Standing logic then set customized_class_standing_flag to 'N'
8 --If Class Standing logic is being customized set customized_class_standing_flag to 'Y'
9 --Change History:
10 --Who When What
11 -- swaghmar 20-Apr-2006 Created for Bug# 5171158
12 -------------------------------------------------------------------------------------------
13
14 customized_class_standing_flag VARCHAR2(1) := 'N';
15
16 FUNCTION get_customized_class_std (
17 p_person_id IN NUMBER,
18 p_course_cd IN VARCHAR2,
19 p_predictive_ind IN VARCHAR2 DEFAULT 'N',
20 p_effective_dt IN DATE,
21 p_load_cal_type IN VARCHAR2,
22 p_load_ci_sequence_number IN NUMBER,
23 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
24 ) RETURN VARCHAR2;
25
26 END igs_pr_user_class_std;