PACKAGE: APPS.IGS_PS_WF_EVENT_HOOK_PKG

Source

1 PACKAGE IGS_PS_WF_EVENT_HOOK_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSPS79S.pls 115.4 2002/11/29 03:12:33 nsidana ship $ */
3 TYPE OccurNew IS REF CURSOR;
4 TYPE OccurOld IS REF CURSOR;
5 TYPE UnitDtls IS REF CURSOR;
6 TYPE StudentDetails IS REF CURSOR;
7 TYPE InstructorDetails IS REF CURSOR;
8 TYPE rec_OccurNew IS RECORD (monday IGS_PS_USEC_OCCURS.monday%TYPE,
9 			     tuesday IGS_PS_USEC_OCCURS.tuesday%TYPE,
10 			     wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11 			     thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12 			     friday IGS_PS_USEC_OCCURS.friday%TYPE,
13 			     saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14 			     sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15 			     start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16 			     end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
17 			     building_code IGS_PS_USEC_OCCURS.building_code%TYPE,
18 			     room_code IGS_PS_USEC_OCCURS.room_code%TYPE);
19 
20 TYPE rec_OccurOld IS RECORD (unit_section_occurrence_id IGS_PS_SH_USEC_OCCURS.unit_section_occurrence_id%TYPE,
21 			     monday IGS_PS_SH_USEC_OCCURS.monday%TYPE,
22 			     tuesday IGS_PS_SH_USEC_OCCURS.tuesday%TYPE,
23 			     wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24 			     thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25 			     friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26 			     saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27 			     sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28 			     start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29 			     end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,
30 			     building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,
31 			     room_code IGS_PS_SH_USEC_OCCURS.room_code%TYPE);
32 
33 TYPE rec_UnitDtls IS RECORD (unit_cd IGS_PS_UNIT_OFR_OPT_V.unit_cd%TYPE,
34                            title IGS_PS_UNIT_OFR_OPT_V.title%TYPE,
35 	                   cal_start_dt IGS_PS_UNIT_OFR_OPT_V.cal_start_dt%TYPE,
36 	                   cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37 	                   location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38 	                   location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39 	                   unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40 TYPE rec_StudentDetails IS RECORD (  person_id igs_pe_person.person_id%TYPE,
41                            unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42 	                   person_number igs_pe_person.person_number%TYPE,
43 	                   email_addr igs_pe_person.email_addr%TYPE,
44 	                   full_name igs_pe_person.full_name%TYPE);
45 TYPE rec_InstructorDetails IS RECORD (person_number IGS_PE_PERSON.person_number%TYPE,
46                            email_addr IGS_PE_PERSON.email_addr%TYPE,
47 	                   full_name igs_pe_person.full_name%TYPE);
48 PROCEDURE wf_get_shadow_values (p_uoo_id IN NUMBER,
49                            p_unit_section_occurrence_id IN NUMBER,
50                            p_type IN VARCHAR2,
51                            p_old_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCUROLD,
52                            p_new_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCURNEW,
53 			   p_unit_dtls  IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.UNITDTLS);
54 
55 PROCEDURE wf_event_audience (p_uoo_id IN NUMBER,
56                            p_unit_section_occurrence_id IN NUMBER,
57                            p_type IN VARCHAR2,
58                            p_students IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.StudentDetails,
59                            p_instructors IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.InstructorDetails);
60 END IGS_PS_WF_EVENT_HOOK_PKG;