1 PACKAGE IGS_EN_TIMESLOTS AUTHID CURRENT_USER AS
2 /* $Header: IGSEN74S.pls 115.6 2003/01/31 09:20:21 nbehera ship $ */
3
4 /*************************************************************
5 Created By : sraj
6 Date Created By : 2000/13/05
7 Purpose : To set the column values before inserting.
8 Know limitations, enhancements or remarks
9 Change History
10 Who When What
11 Nishikant 31MAR2003 The field full_name modified to last_name in the record
12 type pdata_1 and pdata_2. Bug#2455364.
13 Nishikant 24JUL2002 Added a new function acad_teach_rel_exist.
14 This is being used locally in a cursor only.
15 KNAG.IN 12-APR-2001 Included ecp attribute in pdata_1
16 record type as per enh bug 1710227
17 (reverse chronological order - newest change first)
18 ***************************************************************/
19
20 -- pl/sql table for Holding person ID and full name, gpa, total cp
21 TYPE pdata_1 IS RECORD(
22 person_id NUMBER,
23 last_name VARCHAR2(150),
24 gpa NUMBER,
25 cpc NUMBER,
26 ecp NUMBER);
27 TYPE plsql_table_1 IS TABLE OF pdata_1 INDEX BY BINARY_INTEGER;
28
29 -- pl/sql table for Holding person ID , full name , Start Time and End Time
30 TYPE pdata_2 IS RECORD(
31 person_id NUMBER,
32 last_name VARCHAR2(150),
33 start_time DATE,
34 end_time DATE);
35 TYPE plsql_table_2 IS TABLE OF pdata_2 INDEX BY BINARY_INTEGER;
36
37 --pl/sql table for Holding Start time and End time Of the Timeslot Session
38 TYPE pdata_3 IS RECORD(
39 start_dt_time DATE,
40 end_dt_time DATE);
41 TYPE plsql_table_3 IS TABLE OF pdata_3 INDEX BY BINARY_INTEGER;
42
43 PROCEDURE enrp_para_calculation(
44 p_program_type_group_cd IN VARCHAR2,
45 p_student_type IN VARCHAR2,
46 p_cal_type IN VARCHAR2,
47 p_seq_number IN NUMBER,
48 p_timeslot IN VARCHAR2,
49 p_ts_start_dt IN DATE,
50 p_ts_end_dt IN DATE,
51 p_length_of_time IN VARCHAR2,
52 p_start_time IN DATE,
53 p_end_time IN DATE,
54 p_total_num_students OUT NOCOPY NUMBER,
55 p_num_ts_sessions OUT NOCOPY NUMBER);
56
57 FUNCTION enrp_total_students(
58 p_prg_type_gr_cd IN VARCHAR2,
59 p_stdnt_type IN VARCHAR2,
60 p_cal_type IN VARCHAR2,
61 p_seq_num IN NUMBER)
62 RETURN plsql_table_1 ;
63
64 PROCEDURE enrp_assign_timeslot(
65 ERRBUF OUT NOCOPY VARCHAR2,
66 RETCODE OUT NOCOPY NUMBER,
67 p_prg_type_gr_cd IN VARCHAR2,
68 p_cal_type IN VARCHAR2,
69 p_seq_num IN NUMBER,
70 p_stud_type IN VARCHAR2,
71 p_timeslot IN VARCHAR2,
72 p_start_date IN DATE,
73 p_end_date IN DATE,
74 p_max_headcount IN NUMBER,
75 p_length_of_time IN NUMBER,
76 p1_start_time IN VARCHAR2,
77 p1_end_time IN VARCHAR2,
78 p_mode IN VARCHAR2,
79 p_orgid IN NUMBER);
80
81 FUNCTION acad_teach_rel_exist(
82 p_acad_cal_type IN VARCHAR2,
83 p_teach_cal_type IN VARCHAR2,
84 p_teach_seq_num IN NUMBER)
85 RETURN VARCHAR2;
86
87 END IGS_EN_TIMESLOTS;