1 PACKAGE Igs_ps_usec_schedule AS
2 /* $Header: IGSPS77S.pls 120.1 2005/06/29 05:23:50 appldev ship $ */
3 /* Change History
4 Who When What
5 jbegum 12-Apr-2003 Enh bug #2833850.
6 Added a new parameter p_c_del_flag to the procedure Prgp_Init_Prs_sched
7 Added a new public function get_enrollment_max
8 (reverse chronological order - newest change first)
9 */
10
11 PROCEDURE Prgp_Init_Prs_sched(
12 errbuf OUT NOCOPY VARCHAR2,
13 retcode OUT NOCOPY NUMBER,
14 p_teach_prd IN VARCHAR2,
15 p_uoo_id IN NUMBER,
16 p_usec_id IN NUMBER,
17 p_sch_type IN VARCHAR2,
18 p_org_id IN NUMBER);
19
20 -- Hooker Procedure
21 PROCEDURE prgp_init_scheduling;
22
23 -- Scheduled Status Function
24 FUNCTION prgp_get_schd_status (
25 p_uoo_id IN NUMBER,
26 p_usec_id IN NUMBER DEFAULT NULL,
27 p_message_name OUT NOCOPY VARCHAR2)
28 RETURN BOOLEAN ;
29
30 --Purge Data Procedure
31 PROCEDURE prgp_schd_purge_data(
32 errbuf OUT NOCOPY VARCHAR2,
33 retcode OUT NOCOPY NUMBER,
34 p_teach_prd IN VARCHAR2,
35 p_org_id IN NUMBER );
36
37 -- Unit Section Changes Update
38 FUNCTION prgp_upd_usec_dtls (
39 p_uoo_id IN NUMBER,
40 p_location_cd IN VARCHAR2 DEFAULT NULL,
41 p_usec_status IN VARCHAR2 DEFAULT NULL,
42 p_max_enrollments IN NUMBER DEFAULT NULL,
43 p_override_enrollment_max IN NUMBER DEFAULT NULL,
44 p_enrollment_expected IN NUMBER DEFAULT NULL,
45 p_request_id OUT NOCOPY NUMBER,
46 p_message_name OUT NOCOPY VARCHAR2
47 ) RETURN BOOLEAN;
48
49 -- Get Scheduled Records
50
51 PROCEDURE prgp_get_schd_records(
52 errbuf OUT NOCOPY varchar2,
53 retcode OUT NOCOPY number,
54 p_org_id IN NUMBER
55 );
56
57 -- Export data to Flat files
58
59 PROCEDURE PRGP_WRITE_REF_FILE (
60 errbuf OUT NOCOPY VARCHAR2,
61 retcode OUT NOCOPY NUMBER,
62 p_column_sep IN VARCHAR2,
63 p_org_id IN NUMBER);
64
65 --Aborts the scheduling
66 PROCEDURE abort_sched(
67 errbuf out NOCOPY varchar2,
68 retcode out NOCOPY number,
69 p_teach_calendar IN VARCHAR2 ,
70 p_unit_cd IN VARCHAR2 ,
71 p_version_number IN NUMBER,
72 p_location IN VARCHAR2,
73 p_unit_class IN VARCHAR2,
74 p_cancel_only IN VARCHAR2)
75 ;
76
77
78 -- Function to return maximum enrollment for a unit section
79 FUNCTION get_enrollment_max(
80 p_n_uoo_id IN NUMBER)
81 RETURN NUMBER;
82
83 PROCEDURE update_occurrence_status(
84 p_unit_section_occurrence_id IN NUMBER,
85 p_scheduled_status IN VARCHAR2,
86 p_cancel_flag IN VARCHAR2
87 );
88
89 END igs_ps_usec_schedule;