eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_EN_GEN_009

Source


1 PACKAGE IGS_EN_GEN_009 AS
2 /* $Header: IGSEN09S.pls 120.1 2005/09/30 02:59:08 appldev ship $ */
3 
4 /*=======================================================================+
5  | HISTORY
6  | sarakshi    17-Nov-2004  Enh#4000939, added parameter p_trans_approved_dt,p_term_cal_type,p_term_seq_num and
7  |                          p_discontinue_src_flag in function Enrp_Ins_Sct_Trnsfr
8  | Nalin Kumar 23-Nov-2001 Added enrp_ins_award_aim procedure as the part of
9  |                         UK Award Aims DLD Bug ID: 1366899
10  | svenkata 25-02-02       Removed the procedure ENRP_INS_ENRL_FORM as part of CCR
11  |                         ENCR024 .Bug # 2239050
12  | amuthu   10-JUN-2003    modified as per the UK Streaming and Repeat TD (bug 2829265)
13  | kkillams 17-Jun-2003    Three New parameters are added to Enrp_Ins_Pre_Pos function
14  |                         w.r.t. bug 3829270
15  | ptandon  7-OCT-2003     Added a new Function Enrp_Check_Usec_Core as
16  |                         part of Prevent Dropping Core Units build.
17  |                         Enh Bug#3052432.
18  | rvangala 012-Dec-2003   Added 2 new parameters to enrp_ins_sca_hist
19  | bdeviset  11-DEC-2004   Added extra parameters to Enrp_Ins_Sct_Trnsfr as
20  |                         UOOID_TO_TRANSFER,SUSA_TO_TRANSFER, TRANSFER_ADV_STAND_FLAG transfer table
21  | amuthu    05-JAN-2005   Added new method for deriving the core indicator value for the destinations
22  |                         program attempt in a transfer enrp_chk_dest_usec_core
23  | ckasu     29-SEP-2005   Modfied signature of enrp_chk_dest_usec_core inorder to include cooid as
24  |                         a part of bug #4278867
25  *=======================================================================*/
26 Procedure Enrp_Ins_Dflt_Effect(
27   p_person_id IN NUMBER ,
28   p_encumbrance_type IN VARCHAR2 ,
29   p_start_dt IN DATE ,
30   p_expiry_dt IN DATE ,
31   p_course_cd IN VARCHAR2 ,
32   p_message_name out NOCOPY Varchar2 ,
33   p_message_string IN OUT NOCOPY VARCHAR2 );
34 
35 
36 PROCEDURE enrp_ins_award_aim (
37   p_person_id       IN NUMBER,
38   p_course_cd       IN VARCHAR2,
39   p_version_number  IN NUMBER,
40   p_start_dt        IN DATE
41 );
42 
43 
44 Procedure Enrp_Ins_Merge_Log(
45   p_smir_id IN NUMBER );
46 
47 Function Enrp_Ins_Pre_Pos(
48   p_acad_cal_type               IN VARCHAR2 ,
49   p_acad_sequence_number        IN NUMBER ,
50   p_person_id                   IN NUMBER ,
51   p_course_cd                   IN VARCHAR2 ,
52   p_version_number              IN NUMBER ,
53   p_location_cd                 IN VARCHAR2 ,
54   p_attendance_mode             IN VARCHAR2 ,
55   p_attendance_type             IN VARCHAR2 ,
56   p_unit_set_cd                 IN VARCHAR2 ,
57   p_adm_cal_type                IN VARCHAR2 ,
58   p_admission_cat               IN VARCHAR2 ,
59   p_log_creation_dt             IN DATE ,
60   p_units_indicator             IN VARCHAR2 DEFAULT 'N', -- Added this paramter as part of Core Vs Optional DLD.
61   p_warn_level                  IN OUT NOCOPY VARCHAR2 ,
62   p_message_name                IN OUT NOCOPY VARCHAR2,
63   p_progress_stat               IN VARCHAR2 DEFAULT NULL,
64   p_progress_outcome_type       IN VARCHAR2 DEFAULT NULL,
65   p_enr_method                  IN VARCHAR2 DEFAULT NULL,
66   p_load_cal_type               IN VARCHAR2 DEFAULT NULL,
67   p_load_ci_seq_num             IN NUMBER DEFAULT NULL)
68 RETURN boolean;
69 
70 
71 Function Enrp_Ins_Scae_Trnsfr(
72   p_person_id IN NUMBER ,
73   p_course_cd IN VARCHAR2 ,
74   p_cal_type IN VARCHAR2 ,
75   p_ci_sequence_number IN NUMBER ,
76   p_enrolment_cat IN VARCHAR2 ,
77   p_message_name out NOCOPY Varchar2 )
78 RETURN BOOLEAN;
79 
80 
81 Function Enrp_Ins_Sca_Cah(
82   p_person_id IN NUMBER ,
83   p_course_cd IN VARCHAR2 ,
84   p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
85   p_commencement_dt IN DATE ,
86   p_old_attendance_type IN VARCHAR2 ,
87   p_message_name out NOCOPY Varchar2 )
88 RETURN BOOLEAN;
89 
90 -- Modified by : jbegum
91 -- Added 4 new parameters p_new_last_date_of_attendance , p_old_last_date_of_attendance , p_new_dropped_by , p_old_dropped_by
92 -- as part of Enhancement Bug # 1832130
93 
94 -- Modified by : kkillams
95 -- Added 8 new parameters p_new_primary_program_type,p_old_primary_program_type,p_new_primary_prog_type_source,p_old_primary_prog_type_source,
96 -- p_new_catalog_cal_type,p_old_catalog_cal_type,p_new_catalog_seq_num,p_old_catalog_seq_num,p_new_key_program,p_old_key_program
97 -- as part of Enhancement Bug # 2027984
98 
99 Procedure Enrp_Ins_Sca_Hist(
100   p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
101   p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
102   p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103   p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104   p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105   p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106   p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107   p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108   p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109   p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110   p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111   p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112   p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113   p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114   p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115   p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
116   p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
117   p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
118   p_new_progression_status IN VARCHAR2 ,
119   p_old_progression_status IN VARCHAR2 ,
120   p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
121   p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
122   p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123   p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124   p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125   p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126   p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127   p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
128   p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
129   p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
130   p_new_lapsed_dt IN DATE ,
131   p_old_lapsed_dt IN DATE ,
132   p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
133   p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
134   p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135   p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136   p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137   p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138   p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139   p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140   p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141   p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142   p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143   p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144   p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145   p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146   p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147   p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148   p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149   p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150   p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151   p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
152   p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
153   p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
154   p_new_crs_rqrmnts_complete_dt IN DATE ,
155   p_old_crs_rqrmnts_complete_dt IN DATE ,
156   p_new_s_completed_source_type IN VARCHAR2 ,
157   p_old_s_completed_source_type IN VARCHAR2 ,
158   p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
159   p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
160   p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
161   p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
162   p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
163   p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
164   p_new_self_help_group_ind IN VARCHAR2 ,
165   p_old_self_help_group_ind IN VARCHAR2 ,
166   p_new_correspondence_cat IN VARCHAR2 ,
167   p_old_correspondence_cat IN IGS_EN_STDNT_PS_ATT_ALL.CORRESPONDENCE_CAT%TYPE ,
168   p_new_adm_adm_appl_number IN NUMBER ,
169   p_old_adm_adm_appl_number IN NUMBER ,
170   p_new_adm_nominated_course_cd IN VARCHAR2 ,
171   p_old_adm_nominated_course_cd IN VARCHAR2 ,
172   p_new_adm_sequence_number IN NUMBER ,
173   p_old_adm_sequence_number IN NUMBER ,
174   p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
175   p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
176   p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177   p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178   p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179   p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180   p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181   p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182   p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183   p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184   p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185   p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186   p_new_catalog_cal_type IN  IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187   p_old_catalog_cal_type IN  IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188   p_new_catalog_seq_num IN  IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189   p_old_catalog_seq_num IN  IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190   p_new_key_program IN  IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191   p_old_key_program IN  IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192   p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193   p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194   p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195   p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196   p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197   p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
198   p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,
199   p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL
200 );
201 
202 Function Enrp_Ins_Scho_Dflt(
203   p_person_id IN NUMBER ,
204   p_course_cd IN VARCHAR2 ,
205   p_hecs_payment_option IN VARCHAR2 ,
206   p_acad_cal_type IN VARCHAR2 ,
207   p_acad_sequence_number IN NUMBER ,
208   p_message_name out NOCOPY Varchar2 )
209 RETURN boolean;
210 
211 
212 Function Enrp_Ins_Sct_Trnsfr(
213   p_person_id IN NUMBER ,
214   p_course_cd IN VARCHAR2 ,
215   p_transfer_course_cd IN VARCHAR2 ,
216   p_transfer_dt IN DATE ,
217   p_message_name OUT NOCOPY VARCHAR2,
218   p_trans_approved_dt    IN DATE,
219   p_term_cal_type        IN VARCHAR2,
220   p_term_seq_num         IN NUMBER,
221   p_discontinue_src_flag IN VARCHAR2,
222   p_uooids_to_transfer IN VARCHAR2,
223   p_susa_to_transfer IN VARCHAR2,
224   p_transfer_adv_stand_flag IN VARCHAR2,
225   p_status_date IN DATE,
226   p_status_flag IN VARCHAR2)
227 RETURN BOOLEAN;
228 
229 --
230 -- Added as Part of EN213 Build
231 -- This Function checks whether the given unit section is a core unit or not in the
232 -- current pattern of study for the given student program attempt.
233 --
234 
235 FUNCTION enrp_check_usec_core(
236   p_person_id IN NUMBER ,
237   p_program_cd IN VARCHAR2 ,
238   p_uoo_id IN NUMBER )
239 RETURN VARCHAR2;
240 
241 FUNCTION enrp_chk_dest_usec_core(
242   p_person_id IN NUMBER ,
243   p_src_program_cd IN VARCHAR2 ,
244   p_dest_program_cd IN VARCHAR2 ,
245   p_unit_set_cd IN VARCHAR2,
246   p_uoo_id IN NUMBER,
247   p_coo_id IN NUMBER)
248 RETURN VARCHAR2;
249 
250 
251 END IGS_EN_GEN_009;