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_VER_PKG dependencies on IGS_PS_VER

Line 1: PACKAGE BODY igs_ps_ver_pkg AS

1: PACKAGE BODY igs_ps_ver_pkg AS
2: /* $Header: IGSPI42B.pls 120.2 2005/08/11 03:35:57 appldev ship $ */
3: /************************************************************************
4: Created By :
5: Date Created By :

Line 17: old_references igs_ps_ver_all%ROWTYPE;

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

Line 18: new_references igs_ps_ver_all%ROWTYPE;

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

Line 34: CURSOR cur_delete (cp_course_cd igs_ps_ver_all.course_cd%TYPE,

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,

Line 35: cp_version_number igs_ps_ver_all.version_number%TYPE)

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

Line 38: FROM igs_ps_ver_all uv,

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

Line 81: CURSOR cur_check_update (cp_course_cd igs_ps_ver_all.course_cd%TYPE,

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,

Line 82: cp_version_number igs_ps_ver_all.version_number%TYPE)

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

Line 85: FROM igs_ps_ver_all uv,

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

Line 209: FROM igs_ps_ver_all

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:

Line 398: v_start_dt igs_ps_ver_all.start_dt%TYPE;

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;

Line 399: v_review_dt igs_ps_ver_all.review_dt%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;

Line 400: v_expiry_dt igs_ps_ver_all.expiry_dt%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;

Line 401: v_end_dt igs_ps_ver_all.end_dt%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;

Line 402: v_course_status igs_ps_ver_all.course_status%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;

Line 403: v_title igs_ps_ver_all.title%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;

Line 404: v_short_title igs_ps_ver_all.short_title%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;

Line 405: v_abbreviation igs_ps_ver_all.abbreviation%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;

Line 406: v_supp_exam_permitted_ind igs_ps_ver_all.supp_exam_permitted_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;

Line 407: v_generic_course_ind igs_ps_ver_all.generic_course_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;

Line 408: v_graduate_students_ind igs_ps_ver_all.graduate_students_ind%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;

Line 409: v_count_intrmsn_in_time_ind igs_ps_ver_all.count_intrmsn_in_time_ind%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;

Line 410: v_intrmsn_allowed_ind igs_ps_ver_all.intrmsn_allowed_ind%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;

Line 411: v_course_type igs_ps_ver_all.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;

Line 412: v_responsible_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%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;

Line 413: v_responsible_ou_start_dt igs_ps_ver_all.responsible_ou_start_dt%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;

Line 414: v_govt_special_course_type igs_ps_ver_all.govt_special_course_type%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;

Line 415: v_qualification_recency igs_ps_ver_all.qualification_recency%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;

Line 416: v_external_adv_stnd_limit igs_ps_ver_all.external_adv_stnd_limit%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;

Line 417: v_internal_adv_stnd_limit igs_ps_ver_all.internal_adv_stnd_limit%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;

Line 418: v_contact_hours igs_ps_ver_all.contact_hours%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;

Line 419: v_credit_points_required igs_ps_ver_all.credit_points_required%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;

Line 420: v_govt_course_load igs_ps_ver_all.govt_course_load%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;

Line 421: v_std_annual_load igs_ps_ver_all.std_annual_load%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;

Line 422: v_course_total_eftsu igs_ps_ver_all.course_total_eftsu%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;

Line 423: v_max_intrmsn_duration igs_ps_ver_all.max_intrmsn_duration%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;

Line 424: v_num_of_units_before_intrmsn igs_ps_ver_all.num_of_units_before_intrmsn%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;

Line 425: v_min_sbmsn_percentage igs_ps_ver_all.min_sbmsn_percentage%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;

Line 426: v_min_cp_per_calendar igs_ps_ver_all.min_cp_per_calendar%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;

Line 427: v_approval_date igs_ps_ver_all.approval_date%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;

Line 428: v_external_approval_date igs_ps_ver_all.external_approval_date%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;

Line 429: v_federal_financial_aid igs_ps_ver_all.federal_financial_aid%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;

Line 430: v_institutional_financial_aid igs_ps_ver_all.institutional_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;

Line 431: v_max_cp_per_teaching_period igs_ps_ver_all.max_cp_per_teaching_period%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;

Line 432: v_residency_cp_required igs_ps_ver_all.residency_cp_required%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;

Line 433: v_state_financial_aid igs_ps_ver_all.state_financial_aid%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;

Line 435: l_primary_program_rank igs_ps_ver_all.primary_program_rank%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';

Line 436: l_n_max_wlst_per_stud igs_ps_ver_all.max_wlst_per_stud%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';
440: cst_inactive VARCHAR2 (8) := 'INACTIVE';

Line 437: l_n_annual_instruction_time igs_ps_ver_all.annual_instruction_time%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';
441: cst_error VARCHAR2 (1) := 'E';

Line 451: FROM igs_ps_ver_hist

447: WHERE course_status = new_references.course_status;
448:
449: CURSOR spvh_cur IS
450: SELECT ROWID
451: FROM igs_ps_ver_hist
452: WHERE course_cd = old_references.course_cd AND
453: version_number = old_references.version_number;
454:
455: BEGIN

Line 889: igs_ps_ver_hist_pkg.delete_row(x_rowid => spvh_rec.rowid);

885:
886: BEGIN
887: FOR spvh_rec IN spvh_cur
888: LOOP
889: igs_ps_ver_hist_pkg.delete_row(x_rowid => spvh_rec.rowid);
890: END LOOP;
891: END;
892:
893: END IF;

Line 1430: Added igf_gr_pell_setup_pkg.get_fk_igs_ps_ver for child existance.

1426: Change History :
1427: Who When What
1428: sarakshi 02-Apr-2004 Bug#3345205, added child existance for IGS_EN_PSV_TERM_IT
1429: ugummall 27-NOV-2003 Bug 3252832. FA 131 - COD Updates.
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.

Line 1432: vvutukur 09-Jun-2003 Enh#2831572.Financial Accounting Build.Added call to igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver.

1428: sarakshi 02-Apr-2004 Bug#3345205, added child existance for IGS_EN_PSV_TERM_IT
1429: ugummall 27-NOV-2003 Bug 3252832. FA 131 - COD Updates.
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.

Line 1434: pmarada 15-feb-2002 Added IGS_HE_ST_PROG_ALL_PKG.GET_FK_IGS_PS_VER_ALL for hesa requirment.

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

Line 1435: smadathi 01-Feb-2002 Added igf_sp_prg_pkg.get_fk_igs_ps_ver and

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
1439: (reverse chronological order - newest change first)

Line 1436: igf_sp_std_prg_pkg.get_fk_igs_ps_ver calls.

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
1439: (reverse chronological order - newest change first)
1440: *************************************************************************/

Line 1451: IGS_PS_UNIT_LVL_PKG.get_fk_igs_ps_ver(

1447: l_hesa VARCHAR2(1);
1448:
1449: BEGIN
1450:
1451: IGS_PS_UNIT_LVL_PKG.get_fk_igs_ps_ver(
1452: old_references.course_cd,
1453: old_references.version_number
1454: );
1455:

Line 1456: igs_pr_ul_mark_cnfg_pkg.get_fk_igs_ps_ver(

1452: old_references.course_cd,
1453: old_references.version_number
1454: );
1455:
1456: igs_pr_ul_mark_cnfg_pkg.get_fk_igs_ps_ver(
1457: old_references.course_cd,
1458: old_references.version_number
1459: );
1460:

Line 1461: igs_ad_ps_appl_inst_pkg.get_fk_igs_ps_ver (

1457: old_references.course_cd,
1458: old_references.version_number
1459: );
1460:
1461: igs_ad_ps_appl_inst_pkg.get_fk_igs_ps_ver (
1462: old_references.course_cd,
1463: old_references.version_number
1464: );
1465:

Line 1466: igs_av_adv_standing_pkg.get_fk_igs_ps_ver (

1462: old_references.course_cd,
1463: old_references.version_number
1464: );
1465:
1466: igs_av_adv_standing_pkg.get_fk_igs_ps_ver (
1467: old_references.course_cd,
1468: old_references.version_number
1469: );
1470:

Line 1471: igs_pe_alternatv_ext_pkg.get_fk_igs_ps_ver (

1467: old_references.course_cd,
1468: old_references.version_number
1469: );
1470:
1471: igs_pe_alternatv_ext_pkg.get_fk_igs_ps_ver (
1472: old_references.course_cd,
1473: old_references.version_number
1474: );
1475:

Line 1476: igs_co_itm_pkg.get_fk_igs_ps_ver (

1472: old_references.course_cd,
1473: old_references.version_number
1474: );
1475:
1476: igs_co_itm_pkg.get_fk_igs_ps_ver (
1477: old_references.course_cd,
1478: old_references.version_number
1479: );
1480:

Line 1481: igs_ps_anl_load_pkg.get_fk_igs_ps_ver (

1477: old_references.course_cd,
1478: old_references.version_number
1479: );
1480:
1481: igs_ps_anl_load_pkg.get_fk_igs_ps_ver (
1482: old_references.course_cd,
1483: old_references.version_number
1484: );
1485:

Line 1486: igs_ps_award_pkg.get_fk_igs_ps_ver (

1482: old_references.course_cd,
1483: old_references.version_number
1484: );
1485:
1486: igs_ps_award_pkg.get_fk_igs_ps_ver (
1487: old_references.course_cd,
1488: old_references.version_number
1489: );
1490:

Line 1491: igs_ps_categorise_pkg.get_fk_igs_ps_ver (

1487: old_references.course_cd,
1488: old_references.version_number
1489: );
1490:
1491: igs_ps_categorise_pkg.get_fk_igs_ps_ver (
1492: old_references.course_cd,
1493: old_references.version_number
1494: );
1495:

Line 1496: igs_ps_field_study_pkg.get_fk_igs_ps_ver (

1492: old_references.course_cd,
1493: old_references.version_number
1494: );
1495:
1496: igs_ps_field_study_pkg.get_fk_igs_ps_ver (
1497: old_references.course_cd,
1498: old_references.version_number
1499: );
1500:

Line 1501: igs_ps_fld_std_hist_pkg.get_fk_igs_ps_ver (

1497: old_references.course_cd,
1498: old_references.version_number
1499: );
1500:
1501: igs_ps_fld_std_hist_pkg.get_fk_igs_ps_ver (
1502: old_references.course_cd,
1503: old_references.version_number
1504: );
1505:

Line 1506: igs_ps_grp_mbr_pkg.get_fk_igs_ps_ver (

1502: old_references.course_cd,
1503: old_references.version_number
1504: );
1505:
1506: igs_ps_grp_mbr_pkg.get_fk_igs_ps_ver (
1507: old_references.course_cd,
1508: old_references.version_number
1509: );
1510:

Line 1511: igs_ps_ofr_pkg.get_fk_igs_ps_ver (

1507: old_references.course_cd,
1508: old_references.version_number
1509: );
1510:
1511: igs_ps_ofr_pkg.get_fk_igs_ps_ver (
1512: old_references.course_cd,
1513: old_references.version_number
1514: );
1515:

Line 1516: igs_ps_own_pkg.get_fk_igs_ps_ver (

1512: old_references.course_cd,
1513: old_references.version_number
1514: );
1515:
1516: igs_ps_own_pkg.get_fk_igs_ps_ver (
1517: old_references.course_cd,
1518: old_references.version_number
1519: );
1520:

Line 1521: igs_ps_own_hist_pkg.get_fk_igs_ps_ver (

1517: old_references.course_cd,
1518: old_references.version_number
1519: );
1520:
1521: igs_ps_own_hist_pkg.get_fk_igs_ps_ver (
1522: old_references.course_cd,
1523: old_references.version_number
1524: );
1525: igs_ps_occup_titles_pkg.get_fk_igs_ps_ver (

Line 1525: igs_ps_occup_titles_pkg.get_fk_igs_ps_ver (

1521: igs_ps_own_hist_pkg.get_fk_igs_ps_ver (
1522: old_references.course_cd,
1523: old_references.version_number
1524: );
1525: igs_ps_occup_titles_pkg.get_fk_igs_ps_ver (
1526: old_references.course_cd
1527: );
1528:
1529: igs_ps_ref_cd_pkg.get_fk_igs_ps_ver (

Line 1529: igs_ps_ref_cd_pkg.get_fk_igs_ps_ver (

1525: igs_ps_occup_titles_pkg.get_fk_igs_ps_ver (
1526: old_references.course_cd
1527: );
1528:
1529: igs_ps_ref_cd_pkg.get_fk_igs_ps_ver (
1530: old_references.course_cd,
1531: old_references.version_number
1532: );
1533:

Line 1534: igs_ps_ref_cd_hist_pkg.get_fk_igs_ps_ver (

1530: old_references.course_cd,
1531: old_references.version_number
1532: );
1533:
1534: igs_ps_ref_cd_hist_pkg.get_fk_igs_ps_ver (
1535: old_references.course_cd,
1536: old_references.version_number
1537: );
1538:

Line 1539: igs_ps_stage_pkg.get_fk_igs_ps_ver (

1535: old_references.course_cd,
1536: old_references.version_number
1537: );
1538:
1539: igs_ps_stage_pkg.get_fk_igs_ps_ver (
1540: old_references.course_cd,
1541: old_references.version_number
1542: );
1543:

Line 1544: igs_ps_ver_note_pkg.get_fk_igs_ps_ver (

1540: old_references.course_cd,
1541: old_references.version_number
1542: );
1543:
1544: igs_ps_ver_note_pkg.get_fk_igs_ps_ver (
1545: old_references.course_cd,
1546: old_references.version_number
1547: );
1548:

Line 1549: igs_ps_ver_ru_pkg.get_fk_igs_ps_ver (

1545: old_references.course_cd,
1546: old_references.version_number
1547: );
1548:
1549: igs_ps_ver_ru_pkg.get_fk_igs_ps_ver (
1550: old_references.course_cd,
1551: old_references.version_number
1552: );
1553:

Line 1554: igs_re_dflt_ms_set_pkg.get_fk_igs_ps_ver (

1550: old_references.course_cd,
1551: old_references.version_number
1552: );
1553:
1554: igs_re_dflt_ms_set_pkg.get_fk_igs_ps_ver (
1555: old_references.course_cd,
1556: old_references.version_number
1557: );
1558:

Line 1560: igs_fi_fnd_src_rstn_pkg.get_fk_igs_ps_ver (

1556: old_references.version_number
1557: );
1558:
1559:
1560: igs_fi_fnd_src_rstn_pkg.get_fk_igs_ps_ver (
1561: old_references.course_cd,
1562: old_references.version_number
1563: );
1564:

Line 1565: igs_fi_fd_src_rstn_h_pkg.get_fk_igs_ps_ver (

1561: old_references.course_cd,
1562: old_references.version_number
1563: );
1564:
1565: igs_fi_fd_src_rstn_h_pkg.get_fk_igs_ps_ver (
1566: old_references.course_cd,
1567: old_references.version_number
1568: );
1569:

Line 1570: igs_co_ou_co_ref_pkg.get_fk_igs_ps_ver (

1566: old_references.course_cd,
1567: old_references.version_number
1568: );
1569:
1570: igs_co_ou_co_ref_pkg.get_fk_igs_ps_ver (
1571: old_references.course_cd,
1572: old_references.version_number
1573: );
1574:

Line 1575: igs_pr_ru_appl_pkg.get_fk_igs_ps_ver (

1571: old_references.course_cd,
1572: old_references.version_number
1573: );
1574:
1575: igs_pr_ru_appl_pkg.get_fk_igs_ps_ver (
1576: old_references.course_cd,
1577: old_references.version_number
1578: );
1579:

Line 1580: igs_ad_sbm_ps_fntrgt_pkg.get_fk_igs_ps_ver (

1576: old_references.course_cd,
1577: old_references.version_number
1578: );
1579:
1580: igs_ad_sbm_ps_fntrgt_pkg.get_fk_igs_ps_ver (
1581: old_references.course_cd,
1582: old_references.version_number
1583: );
1584:

Line 1585: igs_en_stdnt_ps_att_pkg.get_fk_igs_ps_ver (

1581: old_references.course_cd,
1582: old_references.version_number
1583: );
1584:
1585: igs_en_stdnt_ps_att_pkg.get_fk_igs_ps_ver (
1586: old_references.course_cd,
1587: old_references.version_number
1588: );
1589:

Line 1590: igs_ps_stdnt_apv_alt_pkg.get_fk_igs_ps_ver (

1586: old_references.course_cd,
1587: old_references.version_number
1588: );
1589:
1590: igs_ps_stdnt_apv_alt_pkg.get_fk_igs_ps_ver (
1591: old_references.course_cd,
1592: old_references.version_number
1593: );
1594:

Line 1596: igs_pr_s_crv_prg_con_pkg.get_fk_igs_ps_ver (

1592: old_references.version_number
1593: );
1594:
1595:
1596: igs_pr_s_crv_prg_con_pkg.get_fk_igs_ps_ver (
1597: old_references.course_cd,
1598: old_references.version_number
1599: );
1600:

Line 1601: igs_ps_rsv_orgun_prf_pkg.get_fk_igs_ps_ver_all(

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,

Line 1604: igs_ps_rsv_uop_prf_pkg.get_fk_igs_ps_ver_all(

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,

Line 1607: igs_ps_rsv_usec_prf_pkg.get_fk_igs_ps_ver_all(

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

Line 1613: igs_fi_fee_as_rate_pkg.get_fk_igs_ps_ver(

1609: old_references.version_number);
1610: -- msrinivi : 1882122 Commented due to leap frog
1611: -- msrinivi : 1882122 Uncommented the following lines after leapfrog
1612: -- Added by Nishikant for enhancement bug#1851586
1613: igs_fi_fee_as_rate_pkg.get_fk_igs_ps_ver(
1614: old_references.course_cd,
1615: old_references.version_number);
1616:
1617: igs_ps_accts_pkg.get_fk_igs_ps_ver(

Line 1617: igs_ps_accts_pkg.get_fk_igs_ps_ver(

1613: igs_fi_fee_as_rate_pkg.get_fk_igs_ps_ver(
1614: old_references.course_cd,
1615: old_references.version_number);
1616:
1617: igs_ps_accts_pkg.get_fk_igs_ps_ver(
1618: old_references.course_cd,
1619: old_references.version_number);
1620:
1621: igf_sp_prg_pkg.get_fk_igs_ps_ver (

Line 1621: igf_sp_prg_pkg.get_fk_igs_ps_ver (

1617: igs_ps_accts_pkg.get_fk_igs_ps_ver(
1618: old_references.course_cd,
1619: old_references.version_number);
1620:
1621: igf_sp_prg_pkg.get_fk_igs_ps_ver (
1622: old_references.course_cd,
1623: old_references.version_number
1624: );
1625:

Line 1626: igf_sp_std_prg_pkg.get_fk_igs_ps_ver(

1622: old_references.course_cd,
1623: old_references.version_number
1624: );
1625:
1626: igf_sp_std_prg_pkg.get_fk_igs_ps_ver(
1627: old_references.course_cd,
1628: old_references.version_number
1629: );
1630:

Line 1631: igs_en_config_enr_cp_pkg.get_fk_igs_ps_ver(

1627: old_references.course_cd,
1628: old_references.version_number
1629: );
1630:
1631: igs_en_config_enr_cp_pkg.get_fk_igs_ps_ver(
1632: old_references.course_cd,
1633: old_references.version_number
1634: );
1635: -- added by rghosh for bug# 2602077

Line 1636: igs_ad_deplvl_prg_pkg.get_fk_igs_ps_ver(

1632: old_references.course_cd,
1633: old_references.version_number
1634: );
1635: -- added by rghosh for bug# 2602077
1636: igs_ad_deplvl_prg_pkg.get_fk_igs_ps_ver(
1637: old_references.course_cd,
1638: old_references.version_number
1639: );
1640:

Line 1642: igf_gr_pell_setup_pkg.get_fk_igs_ps_ver(

1638: old_references.version_number
1639: );
1640:
1641: -- added by ugummall for build FA 131 COD Updates. Bug 3252832.
1642: igf_gr_pell_setup_pkg.get_fk_igs_ps_ver(
1643: old_references.course_cd,
1644: old_references.version_number
1645: );
1646:

Line 1652: 'BEGIN IGS_HE_ST_PROG_ALL_PKG.GET_FK_IGS_PS_VER_ALL(:1,:2); END;'

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;

Line 1661: igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver(

1657: ELSE
1658: CLOSE c_hesa;
1659: END IF;
1660:
1661: igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver(
1662: old_references.course_cd,
1663: old_references.version_number);
1664:
1665: igs_en_psv_term_it_pkg.get_fk_igs_ps_ver(

Line 1665: igs_en_psv_term_it_pkg.get_fk_igs_ps_ver(

1661: igs_fi_ftci_accts_pkg.get_fk_igs_ps_ver(
1662: old_references.course_cd,
1663: old_references.version_number);
1664:
1665: igs_en_psv_term_it_pkg.get_fk_igs_ps_ver(
1666: old_references.course_cd,
1667: old_references.version_number);
1668:
1669:

Line 1694: FROM igs_ps_ver_all v ,

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;

Line 1703: FROM igs_ps_ver_all

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:

Line 1710: FROM igs_ps_ver_all

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;

Line 1765: FROM igs_ps_ver_all

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:

Line 1801: FROM igs_ps_ver_all

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:

Line 1838: FROM igs_ps_ver_all

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;

Line 1875: FROM igs_ps_ver_all

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:

Line 2107: Procedure dflt_prgm_ref_code ( p_course_cd IGS_PS_VER_ALL.COURSE_CD%TYPE,

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

Line 2108: p_version_number IGS_PS_VER_ALL.VERSION_NUMBER%TYPE

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

Line 2202: igs_ps_ver pv

2198: SELECT
2199: course_cd,
2200: version_number
2201: FROM
2202: igs_ps_ver pv
2203: WHERE
2204: row_id = x_rowid;
2205:
2206: cur_fetch_cou_ver c_fetch_cou_ver%rowtype;

Line 2314: CURSOR c IS SELECT ROWID FROM igs_ps_ver_all

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;

Line 2413: INSERT INTO igs_ps_ver_all (

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,

Line 2710: FROM igs_ps_ver_all

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

Line 3063: UPDATE igs_ps_ver_all SET

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,

Line 3221: CURSOR c1 IS SELECT ROWID FROM igs_ps_ver_all

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;

Line 3385: DELETE FROM igs_ps_ver_all

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;

Line 3395: END igs_ps_ver_pkg;

3391: p_action => 'DELETE',
3392: x_rowid => x_rowid
3393: );
3394: END delete_row;
3395: END igs_ps_ver_pkg;