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.

[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_OFR_PAT

Line 2697: CURSOR cur_rowid ( cp_c_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,

2693:
2694: -- Procedure to validate Database constraints for Unit Offering Pattern Records.
2695: PROCEDURE validate_uop_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2696:
2697: CURSOR cur_rowid ( cp_c_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,
2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
2700: cp_n_ci_seq_num IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE) IS
2701: SELECT delete_flag

Line 2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,

2694: -- Procedure to validate Database constraints for Unit Offering Pattern Records.
2695: PROCEDURE validate_uop_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2696:
2697: CURSOR cur_rowid ( cp_c_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,
2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
2700: cp_n_ci_seq_num IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE) IS
2701: SELECT delete_flag
2702: FROM igs_ps_unit_ofr_pat_all

Line 2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,

2695: PROCEDURE validate_uop_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2696:
2697: CURSOR cur_rowid ( cp_c_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,
2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
2700: cp_n_ci_seq_num IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE) IS
2701: SELECT delete_flag
2702: FROM igs_ps_unit_ofr_pat_all
2703: WHERE unit_cd = cp_c_unit_cd AND

Line 2700: cp_n_ci_seq_num IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE) IS

2696:
2697: CURSOR cur_rowid ( cp_c_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,
2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
2700: cp_n_ci_seq_num IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE) IS
2701: SELECT delete_flag
2702: FROM igs_ps_unit_ofr_pat_all
2703: WHERE unit_cd = cp_c_unit_cd AND
2704: version_number = cp_n_ver_num AND

Line 2702: FROM igs_ps_unit_ofr_pat_all

2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,
2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
2700: cp_n_ci_seq_num IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE) IS
2701: SELECT delete_flag
2702: FROM igs_ps_unit_ofr_pat_all
2703: WHERE unit_cd = cp_c_unit_cd AND
2704: version_number = cp_n_ver_num AND
2705: cal_type = cp_c_cal_type AND
2706: ci_sequence_number = cp_n_ci_seq_num;

Line 2711: /* Pk validation for IGS_PS_UNIT_OFR_PAT , having delete_flag implementation*/

2707: rec_rowid cur_rowid%ROWTYPE;
2708:
2709: BEGIN
2710:
2711: /* Pk validation for IGS_PS_UNIT_OFR_PAT , having delete_flag implementation*/
2712: l_b_uop_deleted := FALSE;
2713: OPEN cur_rowid( p_usec_rec.unit_cd,p_usec_rec.version_number,l_c_cal_type,l_n_seq_num);
2714: FETCH cur_rowid INTO rec_rowid;
2715: IF cur_rowid%FOUND THEN

Line 2748: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'WAITLIST_ALLOWED', p_usec_rec.waitlist_allowed);

2744:
2745: -- Check Constraints checking.
2746: IF p_usec_rec.waitlist_allowed IS NOT NULL THEN
2747: BEGIN
2748: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'WAITLIST_ALLOWED', p_usec_rec.waitlist_allowed);
2749: EXCEPTION
2750: WHEN OTHERS THEN
2751: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'WAITLIST_ALLOWED', 'LEGACY_TOKENS', TRUE);
2752: p_usec_rec.status := 'E';

Line 2758: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'MAX_STUDENTS_PER_WAITLIST', p_usec_rec.max_students_per_waitlist);

2754: END IF;
2755:
2756: IF p_usec_rec.max_students_per_waitlist IS NOT NULL THEN
2757: BEGIN
2758: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'MAX_STUDENTS_PER_WAITLIST', p_usec_rec.max_students_per_waitlist);
2759: EXCEPTION
2760: WHEN OTHERS THEN
2761: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999', 'MAX_STUDENTS_PER_WAITLIST', 'LEGACY_TOKENS', TRUE);
2762: p_usec_rec.status := 'E';

Line 2841: UPDATE igs_ps_unit_ofr_pat_all

2837: END IF;
2838:
2839: IF ( p_usec_rec.status = 'S' ) THEN
2840: IF l_b_uop_deleted THEN
2841: UPDATE igs_ps_unit_ofr_pat_all
2842: SET
2843: waitlist_allowed = p_usec_rec.waitlist_allowed,
2844: max_students_per_waitlist = p_usec_rec.max_students_per_waitlist,
2845: delete_flag = 'N',

Line 2861: INSERT INTO igs_ps_unit_ofr_pat_all

2857: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2858: ||p_usec_rec.teach_cal_alternate_code);
2859: END IF;
2860: ELSE
2861: INSERT INTO igs_ps_unit_ofr_pat_all
2862: (unit_cd,
2863: version_number,
2864: cal_type,
2865: ci_sequence_number,

Line 3164: IF NOT igs_ps_unit_ofr_pat_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,

3160:
3161: /* Check for Foreign Key Validations */
3162:
3163: -- Check for existence of Unit Offering Pattern
3164: IF NOT igs_ps_unit_ofr_pat_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,
3165: x_version_number => p_usec_rec.version_number,
3166: x_cal_type => l_c_cal_type,
3167: x_ci_sequence_number => l_n_seq_num ) THEN
3168: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_OFR_PAT', 'LEGACY_TOKENS', FALSE);

Line 5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,

5137: END check_insert_update;
5138:
5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist

Line 5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,

5138:
5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all

Line 5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,

5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all
5147: WHERE unit_cd = cp_c_unit_cd

Line 5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS

5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all
5147: WHERE unit_cd = cp_c_unit_cd
5148: AND version_number = cp_n_ver_num

Line 5146: FROM igs_ps_unit_ofr_pat_all

5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all
5147: WHERE unit_cd = cp_c_unit_cd
5148: AND version_number = cp_n_ver_num
5149: AND cal_type = cp_c_cal_type
5150: AND ci_sequence_number = cp_n_seq_num ;

Line 5303: igs_ps_unit_ofr_pat_pkg.check_constraints ('WAITLIST_ALLOWED', p_usec_rec.usec_waitlist_allowed);

5299: END IF;
5300:
5301: IF p_usec_rec.usec_waitlist_allowed IS NOT NULL THEN
5302: BEGIN
5303: igs_ps_unit_ofr_pat_pkg.check_constraints ('WAITLIST_ALLOWED', p_usec_rec.usec_waitlist_allowed);
5304: EXCEPTION
5305: WHEN OTHERS THEN
5306: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','WAITLIST_ALLOWED', 'LEGACY_TOKENS', TRUE);
5307: p_usec_rec.status := 'E';

Line 5313: igs_ps_unit_ofr_pat_pkg.check_constraints('MAX_STUDENTS_PER_WAITLIST',p_usec_rec.usec_max_students_per_waitlist);

5309: END IF;
5310:
5311: IF p_usec_rec.usec_max_students_per_waitlist IS NOT NULL THEN
5312: BEGIN
5313: igs_ps_unit_ofr_pat_pkg.check_constraints('MAX_STUDENTS_PER_WAITLIST',p_usec_rec.usec_max_students_per_waitlist);
5314: EXCEPTION
5315: WHEN OTHERS THEN
5316: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','MAX_STUDENTS_PER_WAITLIST','LEGACY_TOKENS',TRUE);
5317: p_usec_rec.status :='E';