PACKAGE: APPS.IGS_PS_GEN_001

Source

1 PACKAGE IGS_PS_GEN_001 AS
2   /* $Header: IGSPS01S.pls 120.1 2005/10/04 00:43:14 appldev ship $ */
3 
4 /*
5 Who       When          What
6 sarakshi  24-Apr-2003   Enh#2858431,added procedure change_unit_section_status
7 jdeekoll    06-May-03       Added 4 procedure as part of HR Integration(# 2833853)
8 
9 */
10 
11   PROCEDURE crsp_ins_crs_ver (
12   p_old_course_cd IN VARCHAR2 ,
13   p_old_version_number IN NUMBER ,
14   p_new_course_cd IN VARCHAR2 ,
15   p_new_version_number IN NUMBER ,
16   p_message_name OUT NOCOPY VARCHAR2 )
17   ;
18 
19   PROCEDURE crsp_ins_unit_section(
20   p_old_uoo_id IN NUMBER,
21   p_new_uoo_id IN NUMBER,
22   p_message_name OUT NOCOPY VARCHAR2,
23   p_log_creation_date DATE DEFAULT NULL);
24 
25   PROCEDURE change_unit_section_status(
26   p_c_old_cal_status      IN VARCHAR2,
27   p_c_new_cal_status      IN VARCHAR2,
28   p_c_cal_type            IN VARCHAR2,
29   p_n_ci_sequence_number  IN NUMBER,
30   p_b_ret_status          OUT NOCOPY BOOLEAN,
31   p_c_message_name        OUT NOCOPY VARCHAR2) ;
32 
33   FUNCTION fac_exceed_exp_wl(
34                              p_c_cal_type IN VARCHAR2,
35                              p_n_cal_seq_num IN NUMBER,
36                              p_n_person_id IN NUMBER,
37                              p_n_curr_wl IN NUMBER,
38                              p_n_tot_fac_wl OUT NOCOPY NUMBER,
39                              p_n_exp_wl OUT NOCOPY NUMBER) RETURN BOOLEAN;
40 
41   FUNCTION teach_fac_wl(
42                          p_c_cal_type IN VARCHAR2,
43                          p_n_cal_seq_num IN NUMBER,
44                          p_n_person_id IN NUMBER,
45                          p_n_curr_wl IN NUMBER,
46                          p_n_tot_fac_wl OUT NOCOPY NUMBER,
47                          p_n_exp_wl OUT NOCOPY NUMBER) RETURN BOOLEAN;
48 
49 END IGS_PS_GEN_001;