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.

APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_PS_UNIT_VER_ALL

Line 34: -- SMADATHI 13-JUN-2001 Modified set column values procedure . Subtitle column in igs_ps_unit_ver_all was obsoleted and irrespective

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*/

Line 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

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;

Line 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

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;

Line 50: old_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

Line 51: new_references IGS_PS_UNIT_VER_ALL%RowType;

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: ------------------------------------------------------------------

Line 67: CURSOR cur_delete (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

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,

Line 68: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)

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

Line 71: FROM igs_ps_unit_ver_all uv,

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

Line 115: CURSOR cur_check_update (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

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,

Line 116: cp_version_number igs_ps_unit_ver_all.version_number%TYPE)

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

Line 119: FROM igs_ps_unit_ver_all uv,

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

Line 128: CURSOR c_enrollment_status (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

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

Line 129: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

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

Line 299: -- igs_ps_unit_ver_all is obsoleted . Irrespective of the value passed

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:

Line 312: FROM IGS_PS_UNIT_VER_ALL

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:

Line 465: v_start_dt IGS_PS_UNIT_VER_ALL.start_dt%TYPE;

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;

Line 466: v_expiry_dt IGS_PS_UNIT_VER_ALL.expiry_dt%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;

Line 467: v_review_dt IGS_PS_UNIT_VER_ALL.review_dt%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;

Line 468: v_end_dt IGS_PS_UNIT_VER_ALL.end_dt%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;

Line 469: v_unit_status IGS_PS_UNIT_VER_ALL.unit_status%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;

Line 470: v_title IGS_PS_UNIT_VER_ALL.title%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;

Line 471: v_short_title IGS_PS_UNIT_VER_ALL.short_title%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;

Line 472: v_title_override_ind IGS_PS_UNIT_VER_ALL.title_override_ind%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;

Line 473: v_abbreviation IGS_PS_UNIT_VER_ALL.abbreviation%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;

Line 474: v_unit_level IGS_PS_UNIT_VER_ALL.unit_level%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;

Line 475: v_credit_point_descriptor IGS_PS_UNIT_VER_ALL.credit_point_descriptor%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;

Line 476: v_achievable_credit_points IGS_PS_UNIT_VER_ALL.achievable_credit_points%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;

Line 477: v_enrolled_credit_points IGS_PS_UNIT_VER_ALL.enrolled_credit_points%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;

Line 478: v_supp_exam_permitted_ind IGS_PS_UNIT_VER_ALL.supp_exam_permitted_ind%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;

Line 479: v_points_increment IGS_PS_UNIT_VER_ALL.points_increment%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;

Line 480: v_points_min IGS_PS_UNIT_VER_ALL.points_min%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;

Line 481: v_points_max IGS_PS_UNIT_VER_ALL.points_max%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;

Line 482: v_points_override_ind IGS_PS_UNIT_VER_ALL.points_override_ind%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;

Line 483: v_coord_person_id IGS_PS_UNIT_VER_ALL.coord_person_id%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;

Line 484: v_owner_org_unit_cd IGS_PS_UNIT_VER_ALL.owner_org_unit_cd%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;

Line 485: v_owner_ou_start_dt IGS_PS_UNIT_VER_ALL.owner_ou_start_dt%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;

Line 486: v_award_course_only_ind IGS_PS_UNIT_VER_ALL.award_course_only_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;

Line 487: v_research_unit_ind IGS_PS_UNIT_VER_ALL.research_unit_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;

Line 488: v_industrial_ind IGS_PS_UNIT_VER_ALL.industrial_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;

Line 489: v_practical_ind IGS_PS_UNIT_VER_ALL.practical_ind%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);

Line 490: v_repeatable_ind IGS_PS_UNIT_VER_ALL.repeatable_ind%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);
494: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

Line 491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_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;
495: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;

Line 492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%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;

Line 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:

Line 497: v_ivr_enrol_ind IGS_PS_UNIT_VER_ALL.ivr_enrol_ind%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:
501: v_advance_maximum IGS_PS_UNIT_VER_ALL.advance_maximum%TYPE;

Line 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;

Line 502: v_approval_date IGS_PS_UNIT_VER_ALL.approval_date%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;

Line 503: v_cal_type_enrol_load_cal IGS_PS_UNIT_VER_ALL.cal_type_enrol_load_cal%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;

Line 504: v_cal_type_offer_load_cal IGS_PS_UNIT_VER_ALL.cal_type_offer_load_cal%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;

Line 505: v_clock_hours IGS_PS_UNIT_VER_ALL.clock_hours%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;

Line 506: v_contact_hrs_lab IGS_PS_UNIT_VER_ALL.contact_hrs_lab%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;

Line 507: v_contact_hrs_lecture IGS_PS_UNIT_VER_ALL.contact_hrs_lecture%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;

Line 508: v_contact_hrs_other IGS_PS_UNIT_VER_ALL.contact_hrs_other%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;

Line 509: v_continuing_education_units IGS_PS_UNIT_VER_ALL.continuing_education_units%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;

Line 510: v_curriculum_id IGS_PS_UNIT_VER_ALL.curriculum_id%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;

Line 511: v_enrollment_expected IGS_PS_UNIT_VER_ALL.enrollment_expected%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;

Line 512: v_enrollment_maximum IGS_PS_UNIT_VER_ALL.enrollment_maximum%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;

Line 513: v_enrollment_minimum IGS_PS_UNIT_VER_ALL.enrollment_minimum%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;

Line 514: v_exclude_from_max_cp_limit IGS_PS_UNIT_VER_ALL.exclude_from_max_cp_limit%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;

Line 515: v_federal_financial_aid IGS_PS_UNIT_VER_ALL.federal_financial_aid%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;

Line 516: v_institutional_financial_aid IGS_PS_UNIT_VER_ALL.institutional_financial_aid%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;

Line 517: v_lab_credit_points IGS_PS_UNIT_VER_ALL.lab_credit_points%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;

Line 518: v_lecture_credit_points IGS_PS_UNIT_VER_ALL.lecture_credit_points%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;

Line 519: v_max_repeat_credit_points IGS_PS_UNIT_VER_ALL.max_repeat_credit_points%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;

Line 520: v_max_repeats_for_credit IGS_PS_UNIT_VER_ALL.max_repeats_for_credit%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;

Line 521: v_max_repeats_for_funding IGS_PS_UNIT_VER_ALL.max_repeats_for_funding%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;

Line 522: v_non_schd_required_hrs IGS_PS_UNIT_VER_ALL.non_schd_required_hrs%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;

Line 523: v_other_credit_points IGS_PS_UNIT_VER_ALL.other_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;
527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%TYPE;

Line 524: v_override_enrollment_max IGS_PS_UNIT_VER_ALL.override_enrollment_max%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;

Line 525: v_record_exclusion_flag IGS_PS_UNIT_VER_ALL.record_exclusion_flag%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;

Line 526: v_ss_display_ind IGS_PS_UNIT_VER_ALL.ss_display_ind%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;

Line 527: v_rpt_fmly_id IGS_PS_UNIT_VER_ALL.rpt_fmly_id%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;

Line 528: v_same_teach_period_repeats IGS_PS_UNIT_VER_ALL.same_teach_period_repeats%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;

Line 529: v_same_teach_period_repeats_cp IGS_PS_UNIT_VER_ALL.same_teach_period_repeats_cp%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;

Line 530: v_same_teaching_period IGS_PS_UNIT_VER_ALL.same_teaching_period%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;

Line 531: v_sequence_num_enrol_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_enrol_load_cal%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;

Line 532: v_sequence_num_offer_load_cal IGS_PS_UNIT_VER_ALL.sequence_num_offer_load_cal%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;

Line 533: v_special_permission_ind IGS_PS_UNIT_VER_ALL.special_permission_ind%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;

Line 534: v_state_financial_aid IGS_PS_UNIT_VER_ALL.state_financial_aid%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;

Line 535: v_subtitle_id IGS_PS_UNIT_VER_ALL.subtitle_id%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;

Line 536: v_subtitle_modifiable_flag IGS_PS_UNIT_VER_ALL.subtitle_modifiable_flag%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;

Line 537: v_unit_type_id IGS_PS_UNIT_VER_ALL.unit_type_id%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

Line 538: v_work_load_cp_lab IGS_PS_UNIT_VER_ALL.work_load_cp_lab%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
542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%TYPE;

Line 539: v_work_load_cp_lecture IGS_PS_UNIT_VER_ALL.work_load_cp_lecture%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;

Line 540: v_work_load_other IGS_PS_UNIT_VER_ALL.work_load_other%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;

Line 542: v_rev_account_cd IGS_PS_UNIT_VER_ALL.rev_account_cd%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;

Line 543: v_claimable_hours IGS_PS_UNIT_VER_ALL.claimable_hours%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;

Line 544: v_anon_unit_grading_ind IGS_PS_UNIT_VER_ALL.anon_unit_grading_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;

Line 545: v_anon_assess_grading_ind IGS_PS_UNIT_VER_ALL.anon_assess_grading_ind%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;

Line 546: v_auditable_ind IGS_PS_UNIT_VER_ALL.auditable_ind%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;

Line 547: v_audit_permission_ind IGS_PS_UNIT_VER_ALL.audit_permission_ind%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;

Line 548: v_max_auditors_allowed IGS_PS_UNIT_VER_ALL.max_auditors_allowed%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;

Line 549: v_billing_credit_points IGS_PS_UNIT_VER_ALL.billing_credit_points%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:

Line 550: v_ovrd_wkld_val_flag IGS_PS_UNIT_VER_ALL.ovrd_wkld_val_flag%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:
554: CURSOR c_get_s_unit_status IS

Line 551: v_workload_val_code IGS_PS_UNIT_VER_ALL.workload_val_code%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
555: SELECT s_unit_status

Line 552: v_billing_hrs IGS_PS_UNIT_VER_ALL.billing_hrs%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
556: FROM IGS_PS_UNIT_STAT

Line 567: CURSOR c_igs_ps_unit_ver_all is

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

Line 578: l_c_igs_ps_unit_ver_all c_igs_ps_unit_ver_all%ROWTYPE ; -- cursor variable

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:

Line 593: OPEN c_igs_ps_unit_ver_all ;

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');

Line 594: FETCH c_igs_ps_unit_ver_all INTO l_c_igs_ps_unit_ver_all ;

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;

Line 595: IF c_igs_ps_unit_ver_all%FOUND THEN

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 ;

Line 596: CLOSE c_igs_ps_unit_ver_all ;

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;

Line 601: 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;
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;

Line 2589: igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all(x_unit_cd => old_references.unit_cd,

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: --------------------------------------------------------------

Line 2606: FROM igs_ps_unit_ver_all uv,

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;

Line 2615: FROM igs_ps_unit_ver_all

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:

Line 2622: FROM igs_ps_unit_ver_all

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;

Line 2668: FROM IGS_PS_UNIT_VER_ALL

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:

Line 2695: FROM IGS_PS_UNIT_VER_ALL

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;

Line 2722: FROM IGS_PS_UNIT_VER_ALL

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:

Line 2748: FROM IGS_PS_UNIT_VER_ALL

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:

Line 2774: FROM IGS_PS_UNIT_VER_ALL

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:

Line 2800: FROM IGS_PS_UNIT_VER_ALL

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:

Line 2834: FROM igs_ps_unit_ver_all

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:

Line 2868: FROM igs_ps_unit_ver_all

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:

Line 2902: FROM igs_ps_unit_ver_all

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:

Line 2938: FROM igs_ps_unit_ver_all

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;

Line 2975: FROM igs_ps_unit_ver_all

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;

Line 3599: cursor C is select ROWID from IGS_PS_UNIT_VER_ALL

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;

Line 3742: INSERT INTO IGS_PS_UNIT_VER_ALL (

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,

Line 4090: -- igs_ps_unit_ver_all is obsoleted . The reference to it was

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:

Line 4204: FROM IGS_PS_UNIT_VER_ALL

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

Line 4743: update IGS_PS_UNIT_VER_ALL set

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,

Line 4970: cursor c1 is select rowid from IGS_PS_UNIT_VER_ALL

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;

Line 5212: delete from IGS_PS_UNIT_VER_ALL

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;

Line 5228: UPDATE IGS_PS_UNIT_VER_ALL set

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;