[Home] [Help]
1: package body IGS_PS_UNIT_VER_PKG as
2: /* $Header: IGSPI92B.pls 120.6 2006/05/15 00:37:51 sarakshi ship $ */
3: -- Change History
4: -- Who When What
5: --sommukhe 28-Nov-2005 Bug#4760997, created a new procedure update_row_subtitle_id.
30: -- jdeekoll 11-SEP-2001 Added one column claimable_hours
31: -- msrinivi 20-Jul-2001 Bug # 1882122 Added one column rev_account_cd
32: -- rgangara 09-Jul-2001 Added the Default 'N' to fields ss_enrol_ind and ivr_enrol_ind
33: -- SMADATHI 03-JUL-2001 Modified Check_Child_Existance Procedure . This is as per enhancement bug no. 1830175
34: -- SMADATHI 13-JUN-2001 Modified set column values procedure . Subtitle column in igs_ps_unit_ver_all was obsoleted and irrespective
35: -- of the values assigned to it , the column will be assigned value NULL . Also reference to this column
36: -- was removed from lock_row procedure .This is as per Enhancement Bug No. 1775394
37: /* SMADATHI 29-MAY-2001 removed foreign key references to IGS_PS_UNT_REPT_FMLY , IGS_PS_UNT_PRV_GRADE as per DLD. (Enhancement Bug No. 1775394)
38: SMADATHI 25-MAY-2001 removed foreign key references to IGS_PS_USEC_RPT_FMLY as per DLD (Enhancement Bug No. 1775394). Also added validation for Curriculum Id*/
42: -- smvk 16-Dec-2002 Function Call IGS_PS_VAL_US.crsp_val_ver_dt,IGS_PS_VAL_UV.crsp_val_uv_pnt_ovrd and IGS_PS_VAL_UV.crsp_val_uv_unit_sts
43: -- are modified with additional parameter value 'FALSE'. for Bug # 2696207
44: -- smvk 19-Dec-2002 Removed the OWNER_ORG_UNIT_CD checking for upper case
45: -- from check_constraints procedure. Bug # 2487149
46: -- smaddali 21-jan-04 Modified procedure Check_Child_Existance , to remove cursor c_hesa and call igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all
47: -- and igs_he_st_uv_cc_all_pkg.get_fk_igs_ps_unit_ver_all directly instead of thru execute immediate for bug#3306063
48:
49: l_rowid VARCHAR2(25);
50: old_references IGS_PS_UNIT_VER_ALL%RowType;
43: -- are modified with additional parameter value 'FALSE'. for Bug # 2696207
44: -- smvk 19-Dec-2002 Removed the OWNER_ORG_UNIT_CD checking for upper case
45: -- from check_constraints procedure. Bug # 2487149
46: -- smaddali 21-jan-04 Modified procedure Check_Child_Existance , to remove cursor c_hesa and call igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all
47: -- and igs_he_st_uv_cc_all_pkg.get_fk_igs_ps_unit_ver_all directly instead of thru execute immediate for bug#3306063
48:
49: l_rowid VARCHAR2(25);
50: old_references IGS_PS_UNIT_VER_ALL%RowType;
51: new_references IGS_PS_UNIT_VER_ALL%RowType;
46: -- smaddali 21-jan-04 Modified procedure Check_Child_Existance , to remove cursor c_hesa and call igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all
47: -- and igs_he_st_uv_cc_all_pkg.get_fk_igs_ps_unit_ver_all directly instead of thru execute immediate for bug#3306063
48:
49: l_rowid VARCHAR2(25);
50: old_references IGS_PS_UNIT_VER_ALL%RowType;
51: new_references IGS_PS_UNIT_VER_ALL%RowType;
52:
53:
54: PROCEDURE beforerowdelete AS
47: -- and igs_he_st_uv_cc_all_pkg.get_fk_igs_ps_unit_ver_all directly instead of thru execute immediate for bug#3306063
48:
49: l_rowid VARCHAR2(25);
50: old_references IGS_PS_UNIT_VER_ALL%RowType;
51: new_references IGS_PS_UNIT_VER_ALL%RowType;
52:
53:
54: PROCEDURE beforerowdelete AS
55: ------------------------------------------------------------------
63: --
64: --Change History:
65: --Who When What
66: -------------------------------------------------------------------
67: CURSOR cur_delete (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
68: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
69: IS
70: SELECT 'x'
71: FROM igs_ps_unit_ver_all uv,
64: --Change History:
65: --Who When What
66: -------------------------------------------------------------------
67: CURSOR cur_delete (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
68: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
69: IS
70: SELECT 'x'
71: FROM igs_ps_unit_ver_all uv,
72: igs_ps_unit_stat us
67: CURSOR cur_delete (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
68: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
69: IS
70: SELECT 'x'
71: FROM igs_ps_unit_ver_all uv,
72: igs_ps_unit_stat us
73: WHERE uv.unit_status=us.unit_status
74: AND us.s_unit_status='PLANNED'
75: AND uv.unit_cd = cp_unit_cd
111: FROM igs_ps_unit_stat
112: WHERE unit_status = cp_unit_status;
113: l_s_unit_status igs_ps_unit_stat.s_unit_status%TYPE;
114:
115: CURSOR cur_check_update (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
116: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
117: IS
118: SELECT 'x'
119: FROM igs_ps_unit_ver_all uv,
112: WHERE unit_status = cp_unit_status;
113: l_s_unit_status igs_ps_unit_stat.s_unit_status%TYPE;
114:
115: CURSOR cur_check_update (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
116: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
117: IS
118: SELECT 'x'
119: FROM igs_ps_unit_ver_all uv,
120: igs_ps_unit_stat us
115: CURSOR cur_check_update (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
116: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
117: IS
118: SELECT 'x'
119: FROM igs_ps_unit_ver_all uv,
120: igs_ps_unit_stat us
121: WHERE uv.unit_status=us.unit_status
122: AND us.s_unit_status <> 'PLANNED'
123: AND uv.unit_cd = cp_unit_cd
124: AND uv.version_number = cp_version_number;
125:
126: l_check VARCHAR2(1);
127:
128: CURSOR c_enrollment_status (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
129: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
130: SELECT 'X'
131: FROM igs_en_su_attempt_all a,
132: igs_ps_unit_ofr_opt_all b
125:
126: l_check VARCHAR2(1);
127:
128: CURSOR c_enrollment_status (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
129: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
130: SELECT 'X'
131: FROM igs_en_su_attempt_all a,
132: igs_ps_unit_ofr_opt_all b
133: WHERE a.uoo_id = b.uoo_id
295:
296: ) AS
297: ------------------------------------------------------------------
298: --Purpose: As per enhancement bug no.1775394 , the column subtitle in
299: -- igs_ps_unit_ver_all is obsoleted . Irrespective of the value passed
300: -- to this column , it will always be assigned NULL .
301: --
302: --
303: --Known limitations/enhancements and/or remarks:
308: --msrinivi 20-Jul-2001 Added new col : rev_account_Cd
309: -------------------------------------------------------------------
310: CURSOR cur_old_ref_values IS
311: SELECT *
312: FROM IGS_PS_UNIT_VER_ALL
313: WHERE rowid = x_rowid;
314:
315: BEGIN
316:
461: --modified rgangara as per DLD Unit Section Enrollment on 03-May-2001 added two nwe Columns SS_enrol_ind and IVr_enrol_ind
462: v_message_name Varchar2(30);
463: v_return_type VARCHAR2(1);
464: -- Variables for history routine
465: v_start_dt IGS_PS_UNIT_VER_ALL.start_dt%TYPE;
466: v_expiry_dt IGS_PS_UNIT_VER_ALL.expiry_dt%TYPE;
467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
462: v_message_name Varchar2(30);
463: v_return_type VARCHAR2(1);
464: -- Variables for history routine
465: v_start_dt IGS_PS_UNIT_VER_ALL.start_dt%TYPE;
466: v_expiry_dt IGS_PS_UNIT_VER_ALL.expiry_dt%TYPE;
467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
463: v_return_type VARCHAR2(1);
464: -- Variables for history routine
465: v_start_dt IGS_PS_UNIT_VER_ALL.start_dt%TYPE;
466: v_expiry_dt IGS_PS_UNIT_VER_ALL.expiry_dt%TYPE;
467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
464: -- Variables for history routine
465: v_start_dt IGS_PS_UNIT_VER_ALL.start_dt%TYPE;
466: v_expiry_dt IGS_PS_UNIT_VER_ALL.expiry_dt%TYPE;
467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
465: v_start_dt IGS_PS_UNIT_VER_ALL.start_dt%TYPE;
466: v_expiry_dt IGS_PS_UNIT_VER_ALL.expiry_dt%TYPE;
467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
466: v_expiry_dt IGS_PS_UNIT_VER_ALL.expiry_dt%TYPE;
467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
470: v_title IGS_PS_UNIT_VER_ALL.title%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%TYPE;
483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%TYPE;
491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_ind%TYPE;
484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%TYPE;
491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_ind%TYPE;
492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%TYPE;
485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%TYPE;
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%TYPE;
491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_ind%TYPE;
492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%TYPE;
493: cst_error VARCHAR2(1);
486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_ind%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%TYPE;
491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_ind%TYPE;
492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%TYPE;
493: cst_error VARCHAR2(1);
494: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_ind%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%TYPE;
491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_ind%TYPE;
492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%TYPE;
493: cst_error VARCHAR2(1);
494: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
495: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;
488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_ind%TYPE;
489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%TYPE;
490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%TYPE;
491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_ind%TYPE;
492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%TYPE;
493: cst_error VARCHAR2(1);
494: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
495: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;
496: v_ss_enrol_ind IGS_PS_UNIT_VER_ALL.ss_enrol_ind%TYPE;
492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%TYPE;
493: cst_error VARCHAR2(1);
494: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
495: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;
496: v_ss_enrol_ind IGS_PS_UNIT_VER_ALL.ss_enrol_ind%TYPE;
497: v_ivr_enrol_ind IGS_PS_UNIT_VER_ALL.ivr_enrol_ind%TYPE;
498:
499: -- Modified by rbezawad on 24-May-2001. Added following 47 fields as per PSP001-US DLD.
500:
493: cst_error VARCHAR2(1);
494: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
495: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;
496: v_ss_enrol_ind IGS_PS_UNIT_VER_ALL.ss_enrol_ind%TYPE;
497: v_ivr_enrol_ind IGS_PS_UNIT_VER_ALL.ivr_enrol_ind%TYPE;
498:
499: -- Modified by rbezawad on 24-May-2001. Added following 47 fields as per PSP001-US DLD.
500:
501: v_advance_maximum IGS_PS_UNIT_VER_ALL.advance_maximum%TYPE;
497: v_ivr_enrol_ind IGS_PS_UNIT_VER_ALL.ivr_enrol_ind%TYPE;
498:
499: -- Modified by rbezawad on 24-May-2001. Added following 47 fields as per PSP001-US DLD.
500:
501: v_advance_maximum IGS_PS_UNIT_VER_ALL.advance_maximum%TYPE;
502: v_approval_date IGS_PS_UNIT_VER_ALL.approval_date%TYPE;
503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
498:
499: -- Modified by rbezawad on 24-May-2001. Added following 47 fields as per PSP001-US DLD.
500:
501: v_advance_maximum IGS_PS_UNIT_VER_ALL.advance_maximum%TYPE;
502: v_approval_date IGS_PS_UNIT_VER_ALL.approval_date%TYPE;
503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
499: -- Modified by rbezawad on 24-May-2001. Added following 47 fields as per PSP001-US DLD.
500:
501: v_advance_maximum IGS_PS_UNIT_VER_ALL.advance_maximum%TYPE;
502: v_approval_date IGS_PS_UNIT_VER_ALL.approval_date%TYPE;
503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
500:
501: v_advance_maximum IGS_PS_UNIT_VER_ALL.advance_maximum%TYPE;
502: v_approval_date IGS_PS_UNIT_VER_ALL.approval_date%TYPE;
503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
501: v_advance_maximum IGS_PS_UNIT_VER_ALL.advance_maximum%TYPE;
502: v_approval_date IGS_PS_UNIT_VER_ALL.approval_date%TYPE;
503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
502: v_approval_date IGS_PS_UNIT_VER_ALL.approval_date%TYPE;
503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_credit_points%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%TYPE;
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
541: --msrinivi Added new column Bug :1882122
534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
541: --msrinivi Added new column Bug :1882122
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
541: --msrinivi Added new column Bug :1882122
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%TYPE;
537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
541: --msrinivi Added new column Bug :1882122
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
541: --msrinivi Added new column Bug :1882122
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
541: --msrinivi Added new column Bug :1882122
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%TYPE;
541: --msrinivi Added new column Bug :1882122
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
541: --msrinivi Added new column Bug :1882122
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%TYPE;
543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%TYPE;
551: v_workload_val_code IGS_PS_UNIT_VER_ALL.workload_val_code%TYPE;
544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_ind%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%TYPE;
551: v_workload_val_code IGS_PS_UNIT_VER_ALL.workload_val_code%TYPE;
552: v_billing_hrs IGS_PS_UNIT_VER_ALL.billing_hrs%TYPE;
545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%TYPE;
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%TYPE;
551: v_workload_val_code IGS_PS_UNIT_VER_ALL.workload_val_code%TYPE;
552: v_billing_hrs IGS_PS_UNIT_VER_ALL.billing_hrs%TYPE;
553:
546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%TYPE;
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%TYPE;
551: v_workload_val_code IGS_PS_UNIT_VER_ALL.workload_val_code%TYPE;
552: v_billing_hrs IGS_PS_UNIT_VER_ALL.billing_hrs%TYPE;
553:
554: CURSOR c_get_s_unit_status IS
547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%TYPE;
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%TYPE;
551: v_workload_val_code IGS_PS_UNIT_VER_ALL.workload_val_code%TYPE;
552: v_billing_hrs IGS_PS_UNIT_VER_ALL.billing_hrs%TYPE;
553:
554: CURSOR c_get_s_unit_status IS
555: SELECT s_unit_status
548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%TYPE;
549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%TYPE;
550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%TYPE;
551: v_workload_val_code IGS_PS_UNIT_VER_ALL.workload_val_code%TYPE;
552: v_billing_hrs IGS_PS_UNIT_VER_ALL.billing_hrs%TYPE;
553:
554: CURSOR c_get_s_unit_status IS
555: SELECT s_unit_status
556: FROM IGS_PS_UNIT_STAT
558: --AND unit_status = 'INACTIVE';
559:
560: CURSOR SPUVH_CUR IS
561: SELECT Rowid
562: FROM IGS_PS_UNIT_VER_HIST
563: WHERE unit_cd = old_references.unit_cd AND
564: version_number = old_references.version_number;
565: -- cursor which picks all the unit codes whose curriculum id is closed
566:
563: WHERE unit_cd = old_references.unit_cd AND
564: version_number = old_references.version_number;
565: -- cursor which picks all the unit codes whose curriculum id is closed
566:
567: CURSOR c_igs_ps_unit_ver_all is
568: SELECT '1'
569: FROM igs_ps_unit_ver_v uv
570: WHERE unit_cd = new_references.unit_cd
571: AND version_number = new_references.version_number
565: -- cursor which picks all the unit codes whose curriculum id is closed
566:
567: CURSOR c_igs_ps_unit_ver_all is
568: SELECT '1'
569: FROM igs_ps_unit_ver_v uv
570: WHERE unit_cd = new_references.unit_cd
571: AND version_number = new_references.version_number
572: AND curriculum_id = new_references.curriculum_id
573: AND EXISTS (SELECT '1'
574: FROM igs_ps_unt_crclm ucur
575: WHERE ucur.curriculum_id = uv.curriculum_id
576: AND ucur.closed_ind = 'Y' ) ;
577:
578: l_c_igs_ps_unit_ver_all c_igs_ps_unit_ver_all%ROWTYPE ; -- cursor variable
579:
580: BEGIN
581: cst_error := 'E';
582:
579:
580: BEGIN
581: cst_error := 'E';
582:
583: -- Validate the IGS_PS_UNIT version fields cannot be updated if the IGS_PS_UNIT
584: -- version has a system status of 'INACTIVE'. IGS_GE_EXCEPTIONS are : IGS_PS_UNIT_STAT,
585: -- expiry_dt and end_dt.
586: -- updated by ssawhney 10-Nov-2000. Incorrect validations for ref start date and review date
587:
589: IF old_references.curriculum_id <> new_references.curriculum_id THEN
590: -- checks if the curriculum attached to the unit is closed . If curriculum is closed , error out NOCOPY
591: -- Closed curriculum id should not allow any update to existing repeat fail of units .
592: -- added by smadathi on 25-MAY-2001 as per new DLD requirement
593: OPEN c_igs_ps_unit_ver_all ;
594: FETCH c_igs_ps_unit_ver_all INTO l_c_igs_ps_unit_ver_all ;
595: IF c_igs_ps_unit_ver_all%FOUND THEN
596: CLOSE c_igs_ps_unit_ver_all ;
597: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CURRICULUM_CLOSED');
590: -- checks if the curriculum attached to the unit is closed . If curriculum is closed , error out NOCOPY
591: -- Closed curriculum id should not allow any update to existing repeat fail of units .
592: -- added by smadathi on 25-MAY-2001 as per new DLD requirement
593: OPEN c_igs_ps_unit_ver_all ;
594: FETCH c_igs_ps_unit_ver_all INTO l_c_igs_ps_unit_ver_all ;
595: IF c_igs_ps_unit_ver_all%FOUND THEN
596: CLOSE c_igs_ps_unit_ver_all ;
597: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CURRICULUM_CLOSED');
598: IGS_GE_MSG_STACK.ADD;
591: -- Closed curriculum id should not allow any update to existing repeat fail of units .
592: -- added by smadathi on 25-MAY-2001 as per new DLD requirement
593: OPEN c_igs_ps_unit_ver_all ;
594: FETCH c_igs_ps_unit_ver_all INTO l_c_igs_ps_unit_ver_all ;
595: IF c_igs_ps_unit_ver_all%FOUND THEN
596: CLOSE c_igs_ps_unit_ver_all ;
597: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CURRICULUM_CLOSED');
598: IGS_GE_MSG_STACK.ADD;
599: APP_EXCEPTION.RAISE_EXCEPTION ;
592: -- added by smadathi on 25-MAY-2001 as per new DLD requirement
593: OPEN c_igs_ps_unit_ver_all ;
594: FETCH c_igs_ps_unit_ver_all INTO l_c_igs_ps_unit_ver_all ;
595: IF c_igs_ps_unit_ver_all%FOUND THEN
596: CLOSE c_igs_ps_unit_ver_all ;
597: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CURRICULUM_CLOSED');
598: IGS_GE_MSG_STACK.ADD;
599: APP_EXCEPTION.RAISE_EXCEPTION ;
600: END IF;
597: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CURRICULUM_CLOSED');
598: IGS_GE_MSG_STACK.ADD;
599: APP_EXCEPTION.RAISE_EXCEPTION ;
600: END IF;
601: CLOSE c_igs_ps_unit_ver_all ;
602: END IF;
603: OPEN c_get_s_unit_status;
604: FETCH c_get_s_unit_status
605: INTO v_s_unit_status;
1318:
1319: BEGIN
1320: FOR SPUVH_Rec IN SPUVH_CUR
1321: Loop
1322: IGS_PS_UNIT_VER_HIST_PKG.Delete_Row(X_ROWID=>SPUVH_Rec.Rowid);
1323: End Loop;
1324: END;
1325:
1326:
1407: OPEN c_get_s_unit_status (new_references.unit_status);
1408: FETCH c_get_s_unit_status INTO v_s_unit_status;
1409: CLOSE c_get_s_unit_status;
1410: -- Perform a quality check if updating to a system status of ACTIVE.
1411: -- IGS_GE_NOTE: A IGS_PS_UNIT version can only be created with a status of PLANNED.
1412: -- Hence, only need to perform the check if updating.
1413: IF p_updating AND
1414: (v_s_unit_status = cst_active) THEN
1415: IF IGS_PS_VAL_UV.crsp_val_uv_quality (
2413: PROCEDURE Check_Child_Existance AS
2414:
2415: -- Who When What
2416: --vvutukur 09-Jun-2003 Enh#2831572.Financial Accounting Build.Added call to igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver.
2417: -- smadathi 01-Feb-2002 Added igf_sp_unit.get_fk_igs_ps_unit_ver and
2418: -- igf_sp_std_unit.get_fk_igs_ps_unit_ver as per enhancement bug 2154941
2419: -- smadathi 03-JUL-2001 added igs_en_elgb_ovr_step_pkg.get_fk_igs_ps_unit_ver as per enhancement bug no. 1830175
2420: --svenkata 02-06-2003 Modified to remove references to TBH of pkg IGS_EN_ELGB_OVR_STEP_PKG. Instead , added
2421: -- references to package IGS_EN_ELGB_OVR_UOO.Bug #2829272
2414:
2415: -- Who When What
2416: --vvutukur 09-Jun-2003 Enh#2831572.Financial Accounting Build.Added call to igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver.
2417: -- smadathi 01-Feb-2002 Added igf_sp_unit.get_fk_igs_ps_unit_ver and
2418: -- igf_sp_std_unit.get_fk_igs_ps_unit_ver as per enhancement bug 2154941
2419: -- smadathi 03-JUL-2001 added igs_en_elgb_ovr_step_pkg.get_fk_igs_ps_unit_ver as per enhancement bug no. 1830175
2420: --svenkata 02-06-2003 Modified to remove references to TBH of pkg IGS_EN_ELGB_OVR_STEP_PKG. Instead , added
2421: -- references to package IGS_EN_ELGB_OVR_UOO.Bug #2829272
2422: -- SMADATHI 29-MAY-2001 removed foreign key references to IGS_PS_UNT_REPT_FMLY , IGS_PS_UNT_PRV_GRADE as per DLD
2415: -- Who When What
2416: --vvutukur 09-Jun-2003 Enh#2831572.Financial Accounting Build.Added call to igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver.
2417: -- smadathi 01-Feb-2002 Added igf_sp_unit.get_fk_igs_ps_unit_ver and
2418: -- igf_sp_std_unit.get_fk_igs_ps_unit_ver as per enhancement bug 2154941
2419: -- smadathi 03-JUL-2001 added igs_en_elgb_ovr_step_pkg.get_fk_igs_ps_unit_ver as per enhancement bug no. 1830175
2420: --svenkata 02-06-2003 Modified to remove references to TBH of pkg IGS_EN_ELGB_OVR_STEP_PKG. Instead , added
2421: -- references to package IGS_EN_ELGB_OVR_UOO.Bug #2829272
2422: -- SMADATHI 29-MAY-2001 removed foreign key references to IGS_PS_UNT_REPT_FMLY , IGS_PS_UNT_PRV_GRADE as per DLD
2423: -- SMADATHI 25-MAY-2001 removed foreign key references to IGS_PS_USEC_RPT_FMLY as per DLD
2424: -- pmarada 15-feb-2002 Addedcheckchaild exist for the HESA requirment .
2425:
2426: BEGIN
2427:
2428: igs_fi_ftci_accts_pkg.get_fk_igs_ps_unit_ver(
2429: old_references.unit_cd,
2430: old_references.version_number);
2431:
2432: IGS_AD_PS_APLINSTUNT_PKG.GET_FK_IGS_PS_UNIT_VER (
2428: igs_fi_ftci_accts_pkg.get_fk_igs_ps_unit_ver(
2429: old_references.unit_cd,
2430: old_references.version_number);
2431:
2432: IGS_AD_PS_APLINSTUNT_PKG.GET_FK_IGS_PS_UNIT_VER (
2433: old_references.unit_cd,
2434: old_references.version_number
2435: );
2436:
2433: old_references.unit_cd,
2434: old_references.version_number
2435: );
2436:
2437: IGS_AV_STND_ALT_UNIT_PKG.GET_FK_IGS_PS_UNIT_VER (
2438: old_references.unit_cd,
2439: old_references.version_number
2440: );
2441:
2438: old_references.unit_cd,
2439: old_references.version_number
2440: );
2441:
2442: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_PS_UNIT_VER (
2443: old_references.unit_cd,
2444: old_references.version_number
2445: );
2446:
2443: old_references.unit_cd,
2444: old_references.version_number
2445: );
2446:
2447: IGS_CO_ITM_PKG.GET_FK_IGS_PS_UNIT_VER (
2448: old_references.unit_cd,
2449: old_references.version_number
2450: );
2451:
2448: old_references.unit_cd,
2449: old_references.version_number
2450: );
2451:
2452: IGS_PS_ANL_LOAD_U_LN_PKG.GET_FK_IGS_PS_UNIT_VER (
2453: old_references.unit_cd,
2454: old_references.version_number
2455: );
2456:
2453: old_references.unit_cd,
2454: old_references.version_number
2455: );
2456:
2457: IGS_PS_UNIT_LVL_PKG.GET_FK_IGS_PS_UNIT_VER (
2458: old_references.unit_cd,
2459: old_references.version_number
2460: );
2461:
2458: old_references.unit_cd,
2459: old_references.version_number
2460: );
2461:
2462: IGS_PS_UNIT_LVL_HIST_PKG.GET_FK_IGS_PS_UNIT_VER (
2463: old_references.unit_cd,
2464: old_references.version_number
2465: );
2466:
2463: old_references.unit_cd,
2464: old_references.version_number
2465: );
2466:
2467: IGS_CO_OU_CO_REF_PKG.GET_FK_IGS_PS_UNIT_VER (
2468: old_references.unit_cd,
2469: old_references.version_number
2470: );
2471:
2468: old_references.unit_cd,
2469: old_references.version_number
2470: );
2471:
2472: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_PS_UNIT_VER (
2473: old_references.unit_cd,
2474: old_references.version_number
2475: );
2476:
2473: old_references.unit_cd,
2474: old_references.version_number
2475: );
2476:
2477: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_PS_UNIT_VER (
2478: old_references.unit_cd,
2479: old_references.version_number
2480: );
2481:
2478: old_references.unit_cd,
2479: old_references.version_number
2480: );
2481:
2482: IGS_EN_ELGB_OVR_UOO_PKG.GET_FK_IGS_PS_UNIT_VER (
2483: old_references.unit_cd,
2484: old_references.version_number
2485: );
2486:
2483: old_references.unit_cd,
2484: old_references.version_number
2485: );
2486:
2487: IGS_PS_TCH_RESP_PKG.GET_FK_IGS_PS_UNIT_VER (
2488: old_references.unit_cd,
2489: old_references.version_number
2490: );
2491:
2488: old_references.unit_cd,
2489: old_references.version_number
2490: );
2491:
2492: IGS_PS_TCH_RESP_HIST_PKG.GET_FK_IGS_PS_UNIT_VER (
2493: old_references.unit_cd,
2494: old_references.version_number
2495: );
2496:
2493: old_references.unit_cd,
2494: old_references.version_number
2495: );
2496:
2497: IGS_PS_UNIT_CATEGORY_PKG.GET_FK_IGS_PS_UNIT_VER (
2498: old_references.unit_cd,
2499: old_references.version_number
2500: );
2501:
2498: old_references.unit_cd,
2499: old_references.version_number
2500: );
2501:
2502: IGS_PS_UNIT_DSCP_PKG.GET_FK_IGS_PS_UNIT_VER (
2503: old_references.unit_cd,
2504: old_references.version_number
2505: );
2506:
2503: old_references.unit_cd,
2504: old_references.version_number
2505: );
2506:
2507: IGS_PS_UNT_DSCP_HIST_PKG.GET_FK_IGS_PS_UNIT_VER (
2508: old_references.unit_cd,
2509: old_references.version_number
2510: );
2511:
2508: old_references.unit_cd,
2509: old_references.version_number
2510: );
2511:
2512: IGS_FI_UNIT_FEE_TRG_PKG.GET_FK_IGS_PS_UNIT_VER (
2513: old_references.unit_cd,
2514: old_references.version_number
2515: );
2516:
2513: old_references.unit_cd,
2514: old_references.version_number
2515: );
2516:
2517: IGS_PS_UNIT_OFR_PKG.GET_FK_IGS_PS_UNIT_VER (
2518: old_references.unit_cd,
2519: old_references.version_number
2520: );
2521:
2518: old_references.unit_cd,
2519: old_references.version_number
2520: );
2521:
2522: IGS_PS_UNIT_REF_CD_PKG.GET_FK_IGS_PS_UNIT_VER (
2523: old_references.unit_cd,
2524: old_references.version_number
2525: );
2526:
2523: old_references.unit_cd,
2524: old_references.version_number
2525: );
2526:
2527: IGS_PS_UNIT_REF_HIST_PKG.GET_FK_IGS_PS_UNIT_VER (
2528: old_references.unit_cd,
2529: old_references.version_number
2530: );
2531:
2528: old_references.unit_cd,
2529: old_references.version_number
2530: );
2531:
2532: IGS_PS_UNIT_VER_NOTE_PKG.GET_FK_IGS_PS_UNIT_VER (
2533: old_references.unit_cd,
2534: old_references.version_number
2535: );
2536:
2533: old_references.unit_cd,
2534: old_references.version_number
2535: );
2536:
2537: IGS_PS_UNIT_VER_RU_PKG.GET_FK_IGS_PS_UNIT_VER (
2538: old_references.unit_cd,
2539: old_references.version_number
2540: );
2541:
2538: old_references.unit_cd,
2539: old_references.version_number
2540: );
2541:
2542: IGS_PS_UNIT_GRD_SCHM_PKG.get_fk_igs_ps_unit_ver(
2543: old_references.unit_cd,
2544: old_references.version_number
2545: );
2546:
2543: old_references.unit_cd,
2544: old_references.version_number
2545: );
2546:
2547: IGS_PS_UNIT_OFR_MODE_PKG.get_fk_igs_ps_unit_ver(
2548: old_references.unit_cd,
2549: old_references.version_number);
2550:
2551: IGS_PS_UNIT_FLD_STDY_PKG.get_fk_igs_ps_unit_ver(
2547: IGS_PS_UNIT_OFR_MODE_PKG.get_fk_igs_ps_unit_ver(
2548: old_references.unit_cd,
2549: old_references.version_number);
2550:
2551: IGS_PS_UNIT_FLD_STDY_PKG.get_fk_igs_ps_unit_ver(
2552: old_references.unit_cd,
2553: old_references.version_number);
2554:
2555: IGS_PS_UNIT_LOCATION_PKG.get_fk_igs_ps_unit_ver(
2551: IGS_PS_UNIT_FLD_STDY_PKG.get_fk_igs_ps_unit_ver(
2552: old_references.unit_cd,
2553: old_references.version_number);
2554:
2555: IGS_PS_UNIT_LOCATION_PKG.get_fk_igs_ps_unit_ver(
2556: old_references.unit_cd,
2557: old_references.version_number);
2558:
2559: IGS_PS_UNIT_FACILITY_PKG.get_fk_igs_ps_unit_ver(
2555: IGS_PS_UNIT_LOCATION_PKG.get_fk_igs_ps_unit_ver(
2556: old_references.unit_cd,
2557: old_references.version_number);
2558:
2559: IGS_PS_UNIT_FACILITY_PKG.get_fk_igs_ps_unit_ver(
2560: old_references.unit_cd,
2561: old_references.version_number);
2562:
2563: IGS_PS_FACLTY_DISP_PKG.get_fk_igs_ps_unit_ver(
2559: IGS_PS_UNIT_FACILITY_PKG.get_fk_igs_ps_unit_ver(
2560: old_references.unit_cd,
2561: old_references.version_number);
2562:
2563: IGS_PS_FACLTY_DISP_PKG.get_fk_igs_ps_unit_ver(
2564: old_references.unit_cd);
2565:
2566: IGS_PS_UNIT_SUBTITLE_PKG.get_fk_igs_ps_unit_ver(
2567: old_references.unit_cd,
2562:
2563: IGS_PS_FACLTY_DISP_PKG.get_fk_igs_ps_unit_ver(
2564: old_references.unit_cd);
2565:
2566: IGS_PS_UNIT_SUBTITLE_PKG.get_fk_igs_ps_unit_ver(
2567: old_references.unit_cd,
2568: old_references.version_number);
2569:
2570: igs_ps_unit_x_grpmem_pkg.get_fk_igs_ps_unit_ver(
2566: IGS_PS_UNIT_SUBTITLE_PKG.get_fk_igs_ps_unit_ver(
2567: old_references.unit_cd,
2568: old_references.version_number);
2569:
2570: igs_ps_unit_x_grpmem_pkg.get_fk_igs_ps_unit_ver(
2571: old_references.unit_cd,
2572: old_references.version_number);
2573:
2574: igs_ps_unit_accts_pkg.get_fk_igs_ps_unit_ver(
2570: igs_ps_unit_x_grpmem_pkg.get_fk_igs_ps_unit_ver(
2571: old_references.unit_cd,
2572: old_references.version_number);
2573:
2574: igs_ps_unit_accts_pkg.get_fk_igs_ps_unit_ver(
2575: old_references.unit_cd,
2576: old_references.version_number);
2577:
2578:
2575: old_references.unit_cd,
2576: old_references.version_number);
2577:
2578:
2579: igf_sp_unit_pkg.get_fk_igs_ps_unit_ver(
2580: old_references.unit_cd,
2581: old_references.version_number);
2582:
2583: igf_sp_std_unit_pkg.get_fk_igs_ps_unit_ver(
2579: igf_sp_unit_pkg.get_fk_igs_ps_unit_ver(
2580: old_references.unit_cd,
2581: old_references.version_number);
2582:
2583: igf_sp_std_unit_pkg.get_fk_igs_ps_unit_ver(
2584: old_references.unit_cd,
2585: old_references.version_number);
2586:
2587: -- Added the following check chaild existance for the HESA requirment, pmarada
2585: old_references.version_number);
2586:
2587: -- Added the following check chaild existance for the HESA requirment, pmarada
2588: -- smaddali removed the Execute immediate statement and calling packages directly, bug#3306063
2589: igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all(x_unit_cd => old_references.unit_cd,
2590: x_version_number => old_references.version_number);
2591:
2592: END Check_Child_Existance;
2593: --------------------------------------------------------------
2602: -- opening different cursors depending on the unit status
2603:
2604: CURSOR cur_get_status IS
2605: SELECT us.s_unit_status
2606: FROM igs_ps_unit_ver_all uv,
2607: igs_ps_unit_stat us
2608: WHERE uv.unit_status=us.unit_status
2609: AND uv.unit_cd = x_unit_cd
2610: AND uv.version_number = x_version_number;
2611: l_unit_status igs_ps_unit_stat.s_unit_status%TYPE;
2612:
2613: CURSOR cur_rowid_planned IS
2614: SELECT ROWID
2615: FROM igs_ps_unit_ver_all
2616: WHERE unit_cd = x_unit_cd
2617: AND version_number = x_version_number
2618: FOR UPDATE NOWAIT;
2619:
2618: FOR UPDATE NOWAIT;
2619:
2620: CURSOR cur_rowid_non_planned IS
2621: SELECT ROWID
2622: FROM igs_ps_unit_ver_all
2623: WHERE unit_cd = x_unit_cd
2624: AND version_number = x_version_number;
2625:
2626: lv_rowid cur_rowid_planned%ROWTYPE;
2664: ) AS
2665:
2666: CURSOR cur_rowid IS
2667: SELECT rowid
2668: FROM IGS_PS_UNIT_VER_ALL
2669: WHERE credit_point_descriptor = x_credit_point_descriptor ;
2670:
2671: lv_rowid cur_rowid%RowType;
2672:
2691: ) AS
2692:
2693: CURSOR cur_rowid IS
2694: SELECT rowid
2695: FROM IGS_PS_UNIT_VER_ALL
2696: WHERE owner_org_unit_cd = x_org_unit_cd
2697: AND owner_ou_start_dt = x_start_dt ;
2698:
2699: lv_rowid cur_rowid%RowType;
2718: ) AS
2719:
2720: CURSOR cur_rowid IS
2721: SELECT rowid
2722: FROM IGS_PS_UNIT_VER_ALL
2723: WHERE coord_person_id = x_person_id ;
2724:
2725: lv_rowid cur_rowid%RowType;
2726:
2744: ) AS
2745:
2746: CURSOR cur_rowid IS
2747: SELECT rowid
2748: FROM IGS_PS_UNIT_VER_ALL
2749: WHERE unit_int_course_level_cd = x_unit_int_course_level_cd ;
2750:
2751: lv_rowid cur_rowid%RowType;
2752:
2770: ) AS
2771:
2772: CURSOR cur_rowid IS
2773: SELECT rowid
2774: FROM IGS_PS_UNIT_VER_ALL
2775: WHERE unit_cd = x_unit_cd ;
2776:
2777: lv_rowid cur_rowid%RowType;
2778:
2796: ) AS
2797:
2798: CURSOR cur_rowid IS
2799: SELECT rowid
2800: FROM IGS_PS_UNIT_VER_ALL
2801: WHERE unit_status = x_unit_status ;
2802:
2803: lv_rowid cur_rowid%RowType;
2804:
2830: || (reverse chronological order - newest change first)
2831: */
2832: CURSOR cur_rowid IS
2833: SELECT rowid
2834: FROM igs_ps_unit_ver_all
2835: WHERE ((rpt_fmly_id = x_rpt_fmly_id));
2836:
2837: lv_rowid cur_rowid%RowType;
2838:
2864: || (reverse chronological order - newest change first)
2865: */
2866: CURSOR cur_rowid IS
2867: SELECT rowid
2868: FROM igs_ps_unit_ver_all
2869: WHERE ((subtitle_id = x_subtitle_id));
2870:
2871: lv_rowid cur_rowid%RowType;
2872:
2898: || (reverse chronological order - newest change first)
2899: */
2900: CURSOR cur_rowid IS
2901: SELECT rowid
2902: FROM igs_ps_unit_ver_all
2903: WHERE ((curriculum_id = x_curriculum_id));
2904:
2905: lv_rowid cur_rowid%RowType;
2906:
2934: || (reverse chronological order - newest change first)
2935: */
2936: CURSOR cur_rowid IS
2937: SELECT rowid
2938: FROM igs_ps_unit_ver_all
2939: WHERE (cal_type_enrol_load_cal = x_cal_type and
2940: sequence_num_enrol_load_cal = x_sequence_number);
2941:
2942: lv_rowid cur_rowid%RowType;
2971: || (reverse chronological order - newest change first)
2972: */
2973: CURSOR cur_rowid IS
2974: SELECT rowid
2975: FROM igs_ps_unit_ver_all
2976: WHERE (cal_type_offer_load_cal = x_cal_type and
2977: sequence_num_offer_load_cal = x_sequence_number);
2978:
2979: lv_rowid cur_rowid%RowType;
3271:
3272: END Before_DML;
3273: ----------------------------------------------------------------------------
3274: PROCEDURE dflt_unit_ref_code (
3275: p_c_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
3276: p_n_version_number igs_ps_unit_ver.version_number%TYPE,
3277: p_c_message_name OUT NOCOPY VARCHAR2
3278: ) AS
3279: CURSOR c_igs_ge_ref_cd_type IS
3272: END Before_DML;
3273: ----------------------------------------------------------------------------
3274: PROCEDURE dflt_unit_ref_code (
3275: p_c_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
3276: p_n_version_number igs_ps_unit_ver.version_number%TYPE,
3277: p_c_message_name OUT NOCOPY VARCHAR2
3278: ) AS
3279: CURSOR c_igs_ge_ref_cd_type IS
3280: SELECT reference_cd_type
3328: p_action IN VARCHAR2,
3329: x_rowid IN VARCHAR2
3330: ) AS
3331: l_message_name VARCHAR2(30) ;
3332: CURSOR c_uv(cp_rowid igs_ps_unit_ver.row_id%TYPE) IS
3333: SELECT unit_cd, version_number
3334: FROM igs_ps_unit_ver
3335: WHERE ROWID = cp_rowid;
3336: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
3330: ) AS
3331: l_message_name VARCHAR2(30) ;
3332: CURSOR c_uv(cp_rowid igs_ps_unit_ver.row_id%TYPE) IS
3333: SELECT unit_cd, version_number
3334: FROM igs_ps_unit_ver
3335: WHERE ROWID = cp_rowid;
3336: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
3337: l_version_number igs_ps_unit_ver.version_number%TYPE;
3338:
3332: CURSOR c_uv(cp_rowid igs_ps_unit_ver.row_id%TYPE) IS
3333: SELECT unit_cd, version_number
3334: FROM igs_ps_unit_ver
3335: WHERE ROWID = cp_rowid;
3336: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
3337: l_version_number igs_ps_unit_ver.version_number%TYPE;
3338:
3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
3340: SELECT uso.unit_section_occurrence_id
3333: SELECT unit_cd, version_number
3334: FROM igs_ps_unit_ver
3335: WHERE ROWID = cp_rowid;
3336: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
3337: l_version_number igs_ps_unit_ver.version_number%TYPE;
3338:
3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
3340: SELECT uso.unit_section_occurrence_id
3341: FROM Igs_ps_usec_occurs_all uso,
3335: WHERE ROWID = cp_rowid;
3336: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
3337: l_version_number igs_ps_unit_ver.version_number%TYPE;
3338:
3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
3340: SELECT uso.unit_section_occurrence_id
3341: FROM Igs_ps_usec_occurs_all uso,
3342: Igs_ps_unit_ofr_opt_all us,
3343: Igs_ca_inst_all ci
3595: sarakshi 14-oct-2003 Enh#3052452,removed the nvl clause from max_repeats_for_credits in the before_dml call.
3596: sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id in call to before_dml
3597: as part of SWCR006 build.
3598: **************************************************************************************************************/
3599: cursor C is select ROWID from IGS_PS_UNIT_VER_ALL
3600: where UNIT_CD = X_UNIT_CD
3601: and VERSION_NUMBER = X_VERSION_NUMBER;
3602: X_LAST_UPDATE_DATE DATE;
3603: X_LAST_UPDATED_BY NUMBER;
3738: x_billing_hrs => x_billing_hrs
3739: );
3740:
3741:
3742: INSERT INTO IGS_PS_UNIT_VER_ALL (
3743: UNIT_CD,
3744: VERSION_NUMBER,
3745: START_DT,
3746: REVIEW_DT,
4086: x_billing_hrs IN NUMBER
4087: ) AS
4088: ------------------------------------------------------------------
4089: --Purpose: As per enhancement bug no.1775394 , the column subtitle in
4090: -- igs_ps_unit_ver_all is obsoleted . The reference to it was
4091: -- removed .
4092: --
4093: --
4094: --Known limitations/enhancements and/or remarks:
4200: billing_credit_points,
4201: ovrd_wkld_val_flag,
4202: workload_val_code,
4203: billing_hrs
4204: FROM IGS_PS_UNIT_VER_ALL
4205: WHERE ROWID = X_ROWID for update nowait;
4206: tlinfo c1%rowtype;
4207:
4208: begin
4739: x_workload_val_code => x_workload_val_code,
4740: x_billing_hrs => x_billing_hrs
4741: );
4742:
4743: update IGS_PS_UNIT_VER_ALL set
4744: START_DT = NEW_REFERENCES.START_DT,
4745: REVIEW_DT = NEW_REFERENCES.REVIEW_DT,
4746: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
4747: END_DT = NEW_REFERENCES.END_DT,
4966: x_ovrd_wkld_val_flag IN VARCHAR2 ,
4967: x_workload_val_code IN VARCHAR2 ,
4968: x_billing_hrs IN NUMBER
4969: ) AS
4970: cursor c1 is select rowid from IGS_PS_UNIT_VER_ALL
4971: where UNIT_CD = X_UNIT_CD
4972: and VERSION_NUMBER = X_VERSION_NUMBER;
4973: BEGIN
4974: open c1;
5208: p_action => 'DELETE',
5209: x_rowid => X_ROWID
5210: );
5211:
5212: delete from IGS_PS_UNIT_VER_ALL
5213: where ROWID = X_ROWID
5214: ;
5215: if (sql%notfound) then
5216: raise no_data_found;
5224:
5225: PROCEDURE update_row_subtitle_id(X_RowId IN VARCHAR2,X_Subtitle_Id IN NUMBER) AS
5226: BEGIN
5227:
5228: UPDATE IGS_PS_UNIT_VER_ALL set
5229: subtitle_id = X_Subtitle_Id
5230: WHERE ROWID = X_ROWID;
5231:
5232: END update_row_subtitle_id;
5230: WHERE ROWID = X_ROWID;
5231:
5232: END update_row_subtitle_id;
5233:
5234: END igs_ps_unit_ver_pkg;