[Home] [Help]
13: sbeerell 10-MAY-2000 Changed for new DLD version 2
14: (reverse chronological order - newest change first)
15: *************************************************************************/
16: l_rowid VARCHAR2(25);
17: old_references igs_ps_ver_all%ROWTYPE;
18: new_references igs_ps_ver_all%ROWTYPE;
19:
20:
21: PROCEDURE beforerowdelete AS
14: (reverse chronological order - newest change first)
15: *************************************************************************/
16: l_rowid VARCHAR2(25);
17: old_references igs_ps_ver_all%ROWTYPE;
18: new_references igs_ps_ver_all%ROWTYPE;
19:
20:
21: PROCEDURE beforerowdelete AS
22: ------------------------------------------------------------------
30: --
31: --Change History:
32: --Who When What
33: -------------------------------------------------------------------
34: CURSOR cur_delete (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
35: cp_version_number igs_ps_ver_all.version_number%TYPE)
36: IS
37: SELECT 'x'
38: FROM igs_ps_ver_all uv,
31: --Change History:
32: --Who When What
33: -------------------------------------------------------------------
34: CURSOR cur_delete (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
35: cp_version_number igs_ps_ver_all.version_number%TYPE)
36: IS
37: SELECT 'x'
38: FROM igs_ps_ver_all uv,
39: igs_ps_stat us
34: CURSOR cur_delete (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
35: cp_version_number igs_ps_ver_all.version_number%TYPE)
36: IS
37: SELECT 'x'
38: FROM igs_ps_ver_all uv,
39: igs_ps_stat us
40: WHERE uv.course_status=us.course_status
41: AND us.s_course_status='PLANNED'
42: AND uv.course_cd = cp_course_cd
77: FROM igs_ps_stat
78: WHERE course_status = cp_course_status;
79: l_s_course_status igs_ps_stat.s_course_status%TYPE;
80:
81: CURSOR cur_check_update (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
82: cp_version_number igs_ps_ver_all.version_number%TYPE)
83: IS
84: SELECT 'x'
85: FROM igs_ps_ver_all uv,
78: WHERE course_status = cp_course_status;
79: l_s_course_status igs_ps_stat.s_course_status%TYPE;
80:
81: CURSOR cur_check_update (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
82: cp_version_number igs_ps_ver_all.version_number%TYPE)
83: IS
84: SELECT 'x'
85: FROM igs_ps_ver_all uv,
86: igs_ps_stat us
81: CURSOR cur_check_update (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
82: cp_version_number igs_ps_ver_all.version_number%TYPE)
83: IS
84: SELECT 'x'
85: FROM igs_ps_ver_all uv,
86: igs_ps_stat us
87: WHERE uv.course_status=us.course_status
88: AND us.s_course_status <> 'PLANNED'
89: AND uv.course_cd = cp_course_cd
205: *************************************************************************/
206:
207: CURSOR cur_old_ref_values IS
208: SELECT *
209: FROM igs_ps_ver_all
210: WHERE ROWID = x_rowid;
211:
212: BEGIN
213:
394: (reverse chronological order - newest change first)
395: *************************************************************************/
396: v_message_name VARCHAR2(30);
397: v_return_type VARCHAR2(1);
398: v_start_dt igs_ps_ver_all.start_dt%TYPE;
399: v_review_dt igs_ps_ver_all.review_dt%TYPE;
400: v_expiry_dt igs_ps_ver_all.expiry_dt%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
395: *************************************************************************/
396: v_message_name VARCHAR2(30);
397: v_return_type VARCHAR2(1);
398: v_start_dt igs_ps_ver_all.start_dt%TYPE;
399: v_review_dt igs_ps_ver_all.review_dt%TYPE;
400: v_expiry_dt igs_ps_ver_all.expiry_dt%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
396: v_message_name VARCHAR2(30);
397: v_return_type VARCHAR2(1);
398: v_start_dt igs_ps_ver_all.start_dt%TYPE;
399: v_review_dt igs_ps_ver_all.review_dt%TYPE;
400: v_expiry_dt igs_ps_ver_all.expiry_dt%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
397: v_return_type VARCHAR2(1);
398: v_start_dt igs_ps_ver_all.start_dt%TYPE;
399: v_review_dt igs_ps_ver_all.review_dt%TYPE;
400: v_expiry_dt igs_ps_ver_all.expiry_dt%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
398: v_start_dt igs_ps_ver_all.start_dt%TYPE;
399: v_review_dt igs_ps_ver_all.review_dt%TYPE;
400: v_expiry_dt igs_ps_ver_all.expiry_dt%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
399: v_review_dt igs_ps_ver_all.review_dt%TYPE;
400: v_expiry_dt igs_ps_ver_all.expiry_dt%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
400: v_expiry_dt igs_ps_ver_all.expiry_dt%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
401: v_end_dt igs_ps_ver_all.end_dt%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
402: v_course_status igs_ps_ver_all.course_status%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
403: v_title igs_ps_ver_all.title%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
404: v_short_title igs_ps_ver_all.short_title%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
405: v_abbreviation igs_ps_ver_all.abbreviation%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_ind%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
407: v_generic_course_ind igs_ps_ver_all.generic_course_ind%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
411: v_course_type igs_ps_ver_all.course_type%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
415: v_qualification_recency igs_ps_ver_all.qualification_recency%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
418: v_contact_hours igs_ps_ver_all.contact_hours%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
419: v_credit_points_required igs_ps_ver_all.credit_points_required%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
420: v_govt_course_load igs_ps_ver_all.govt_course_load%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
421: v_std_annual_load igs_ps_ver_all.std_annual_load%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
434: l_rev_account_cd igs_ps_unit_ver_all.rev_account_cd%TYPE;
427: v_approval_date igs_ps_ver_all.approval_date%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
434: l_rev_account_cd igs_ps_unit_ver_all.rev_account_cd%TYPE;
435: l_primary_program_rank igs_ps_ver_all.primary_program_rank%TYPE;
428: v_external_approval_date igs_ps_ver_all.external_approval_date%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
434: l_rev_account_cd igs_ps_unit_ver_all.rev_account_cd%TYPE;
435: l_primary_program_rank igs_ps_ver_all.primary_program_rank%TYPE;
436: l_n_max_wlst_per_stud igs_ps_ver_all.max_wlst_per_stud%TYPE;
429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%TYPE;
430: v_institutional_financial_aid igs_ps_ver_all.institutional_financial_aid%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
434: l_rev_account_cd igs_ps_unit_ver_all.rev_account_cd%TYPE;
435: l_primary_program_rank igs_ps_ver_all.primary_program_rank%TYPE;
436: l_n_max_wlst_per_stud igs_ps_ver_all.max_wlst_per_stud%TYPE;
437: l_n_annual_instruction_time igs_ps_ver_all.annual_instruction_time%TYPE;
431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%TYPE;
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
434: l_rev_account_cd igs_ps_unit_ver_all.rev_account_cd%TYPE;
435: l_primary_program_rank igs_ps_ver_all.primary_program_rank%TYPE;
436: l_n_max_wlst_per_stud igs_ps_ver_all.max_wlst_per_stud%TYPE;
437: l_n_annual_instruction_time igs_ps_ver_all.annual_instruction_time%TYPE;
438:
439: cst_active VARCHAR2 (6) := 'ACTIVE';
432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%TYPE;
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
434: l_rev_account_cd igs_ps_unit_ver_all.rev_account_cd%TYPE;
435: l_primary_program_rank igs_ps_ver_all.primary_program_rank%TYPE;
436: l_n_max_wlst_per_stud igs_ps_ver_all.max_wlst_per_stud%TYPE;
437: l_n_annual_instruction_time igs_ps_ver_all.annual_instruction_time%TYPE;
438:
439: cst_active VARCHAR2 (6) := 'ACTIVE';
440: cst_inactive VARCHAR2 (8) := 'INACTIVE';
433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%TYPE;
434: l_rev_account_cd igs_ps_unit_ver_all.rev_account_cd%TYPE;
435: l_primary_program_rank igs_ps_ver_all.primary_program_rank%TYPE;
436: l_n_max_wlst_per_stud igs_ps_ver_all.max_wlst_per_stud%TYPE;
437: l_n_annual_instruction_time igs_ps_ver_all.annual_instruction_time%TYPE;
438:
439: cst_active VARCHAR2 (6) := 'ACTIVE';
440: cst_inactive VARCHAR2 (8) := 'INACTIVE';
441: cst_error VARCHAR2 (1) := 'E';
1430: Added igf_gr_pell_setup_pkg.get_fk_igs_ps_ver for child existance.
1431: ijeddy 05-nov-2003 Bug# 3181938; Modified this object as per Summary Measurement Of Attainment FD.
1432: vvutukur 09-Jun-2003 Enh#2831572.Financial Accounting Build.Added call to igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver.
1433: rghosh 28-oct-2002 Added the get fk call to the table igs_ad_deplvl_prg for bug#2602077
1434: pmarada 15-feb-2002 Added IGS_HE_ST_PROG_ALL_PKG.GET_FK_IGS_PS_VER_ALL for hesa requirment.
1435: smadathi 01-Feb-2002 Added igf_sp_prg_pkg.get_fk_igs_ps_ver and
1436: igf_sp_std_prg_pkg.get_fk_igs_ps_ver calls.
1437: Bug 2154941
1438: sbeerell 10-MAY-2000 Changed for new DLD version 2
1597: old_references.course_cd,
1598: old_references.version_number
1599: );
1600:
1601: igs_ps_rsv_orgun_prf_pkg.get_fk_igs_ps_ver_all(
1602: old_references.course_cd,
1603: old_references.version_number);
1604: igs_ps_rsv_uop_prf_pkg.get_fk_igs_ps_ver_all(
1605: old_references.course_cd,
1600:
1601: igs_ps_rsv_orgun_prf_pkg.get_fk_igs_ps_ver_all(
1602: old_references.course_cd,
1603: old_references.version_number);
1604: igs_ps_rsv_uop_prf_pkg.get_fk_igs_ps_ver_all(
1605: old_references.course_cd,
1606: old_references.version_number);
1607: igs_ps_rsv_usec_prf_pkg.get_fk_igs_ps_ver_all(
1608: old_references.course_cd,
1603: old_references.version_number);
1604: igs_ps_rsv_uop_prf_pkg.get_fk_igs_ps_ver_all(
1605: old_references.course_cd,
1606: old_references.version_number);
1607: igs_ps_rsv_usec_prf_pkg.get_fk_igs_ps_ver_all(
1608: old_references.course_cd,
1609: old_references.version_number);
1610: -- msrinivi : 1882122 Commented due to leap frog
1611: -- msrinivi : 1882122 Uncommented the following lines after leapfrog
1648: OPEN c_hesa;
1649: FETCH c_hesa INTO l_hesa;
1650: IF c_hesa%FOUND THEN
1651: EXECUTE IMMEDIATE
1652: 'BEGIN IGS_HE_ST_PROG_ALL_PKG.GET_FK_IGS_PS_VER_ALL(:1,:2); END;'
1653: USING
1654: old_references.course_cd,
1655: old_references.version_number;
1656: CLOSE c_hesa;
1690: -- lock is not required when the course status is non planned so an explicit lock is not required
1691: -- opening different cursors depending on the course status
1692: CURSOR cur_get_status IS
1693: SELECT st.s_course_status
1694: FROM igs_ps_ver_all v ,
1695: igs_ps_stat st
1696: WHERE v.course_status=st.course_status
1697: AND v.course_cd = x_course_cd
1698: AND v.version_number = x_version_number;
1699: l_course_status igs_ps_stat.s_course_status%TYPE;
1700:
1701: CURSOR cur_rowid_planned IS
1702: SELECT ROWID
1703: FROM igs_ps_ver_all
1704: WHERE course_cd = x_course_cd
1705: AND version_number = x_version_number
1706: FOR UPDATE NOWAIT;
1707:
1706: FOR UPDATE NOWAIT;
1707:
1708: CURSOR cur_rowid_non_planned IS
1709: SELECT ROWID
1710: FROM igs_ps_ver_all
1711: WHERE course_cd = x_course_cd
1712: AND version_number = x_version_number;
1713:
1714: lv_rowid cur_rowid_planned%ROWTYPE;
1761: (reverse chronological order - newest change first)
1762: *************************************************************************/
1763: CURSOR cur_rowid IS
1764: SELECT ROWID
1765: FROM igs_ps_ver_all
1766: WHERE course_cd = x_course_cd ;
1767:
1768: lv_rowid cur_rowid%ROWTYPE;
1769:
1797: (reverse chronological order - newest change first)
1798: ************************************************************************/
1799: CURSOR cur_rowid IS
1800: SELECT ROWID
1801: FROM igs_ps_ver_all
1802: WHERE govt_special_course_type = x_govt_special_course_type ;
1803:
1804: lv_rowid cur_rowid%ROWTYPE;
1805:
1834: *************************************************************************/
1835:
1836: CURSOR cur_rowid IS
1837: SELECT ROWID
1838: FROM igs_ps_ver_all
1839: WHERE responsible_org_unit_cd = x_org_unit_cd
1840: AND responsible_ou_start_dt = x_start_dt ;
1841:
1842: lv_rowid cur_rowid%ROWTYPE;
1871: *************************************************************************/
1872:
1873: CURSOR cur_rowid IS
1874: SELECT ROWID
1875: FROM igs_ps_ver_all
1876: WHERE course_status = x_course_status ;
1877:
1878: lv_rowid cur_rowid%ROWTYPE;
1879:
2103: check_child_existance;
2104: END IF;
2105: END before_dml;
2106:
2107: Procedure dflt_prgm_ref_code ( p_course_cd IGS_PS_VER_ALL.COURSE_CD%TYPE,
2108: p_version_number IGS_PS_VER_ALL.VERSION_NUMBER%TYPE
2109: )AS
2110:
2111: /************************************************************************
2104: END IF;
2105: END before_dml;
2106:
2107: Procedure dflt_prgm_ref_code ( p_course_cd IGS_PS_VER_ALL.COURSE_CD%TYPE,
2108: p_version_number IGS_PS_VER_ALL.VERSION_NUMBER%TYPE
2109: )AS
2110:
2111: /************************************************************************
2112: Created By : Aiyer
2310: sbeerell 10-MAY-2000 Modifiaction for DLD Version 2
2311: (reverse chronological order - newest change first)
2312: *************************************************************************/
2313:
2314: CURSOR c IS SELECT ROWID FROM igs_ps_ver_all
2315: WHERE course_cd = x_course_cd
2316: AND version_number = x_version_number;
2317: x_last_update_date DATE;
2318: x_last_updated_by NUMBER;
2409: x_max_wlst_per_stud => x_max_wlst_per_stud,
2410: x_annual_instruction_time => x_annual_instruction_time
2411: );
2412:
2413: INSERT INTO igs_ps_ver_all (
2414: graduate_students_ind,
2415: count_intrmsn_in_time_ind,
2416: intrmsn_allowed_ind,
2417: course_type,
2706: rev_account_cd,
2707: primary_program_rank,
2708: max_wlst_per_stud,
2709: annual_instruction_time
2710: FROM igs_ps_ver_all
2711: WHERE ROWID = x_rowid FOR UPDATE NOWAIT;
2712: tlinfo c1%ROWTYPE;
2713:
2714: BEGIN
3059: x_primary_program_rank => x_primary_program_rank,
3060: x_max_wlst_per_stud => x_max_wlst_per_stud,
3061: x_annual_instruction_time => x_annual_instruction_time
3062: );
3063: UPDATE igs_ps_ver_all SET
3064: graduate_students_ind = new_references.graduate_students_ind,
3065: count_intrmsn_in_time_ind = new_references.count_intrmsn_in_time_ind,
3066: intrmsn_allowed_ind = new_references.intrmsn_allowed_ind,
3067: course_type = new_references.course_type,
3217: smadathi 10-MAY-2001 Changed for New DLD Version
3218: sbeerell 10-MAY-2000 Changed for new DLD version 2
3219: (reverse chronological order - newest change first)
3220: *************************************************************************/
3221: CURSOR c1 IS SELECT ROWID FROM igs_ps_ver_all
3222: WHERE course_cd = x_course_cd
3223: AND version_number = x_version_number ;
3224: BEGIN
3225: OPEN c1;
3381: BEGIN
3382: before_dml( p_action => 'DELETE',
3383: x_rowid => x_rowid
3384: );
3385: DELETE FROM igs_ps_ver_all
3386: WHERE ROWID = x_rowid;
3387: IF (SQL%NOTFOUND) THEN
3388: RAISE NO_DATA_FOUND;
3389: END IF;