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_VALIDATE_LGCY_PKG dependencies on IGS_PS_UNIT_VER_ALL

Line 41: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1);

37: smvk 26-Dec-2002 Added a generic procedure (get_party_id) and a function (validate_staff_person)
38: As a part of Bug # 2721495
39: ********************************************************************************************** */
40:
41: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1);
42: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1);
43:
44: -- for doing certain validation at unit section level while importing unit section occurrence of instructors
45: TYPE usec_tr_rectype IS RECORD( uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

Line 42: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1);

38: As a part of Bug # 2721495
39: ********************************************************************************************** */
40:
41: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1);
42: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1);
43:
44: -- for doing certain validation at unit section level while importing unit section occurrence of instructors
45: TYPE usec_tr_rectype IS RECORD( uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
46: instr_index NUMBER);

Line 144: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,

140: END LOOP;
141:
142: END upd_usec_occurs_schd_status;
143:
144: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
145: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
146: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
147: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
148: p_c_rec_status IN OUT NOCOPY VARCHAR2) ;

Line 145: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,

141:
142: END upd_usec_occurs_schd_status;
143:
144: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
145: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
146: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
147: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
148: p_c_rec_status IN OUT NOCOPY VARCHAR2) ;
149:

Line 146: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,

142: END upd_usec_occurs_schd_status;
143:
144: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
145: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
146: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
147: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
148: p_c_rec_status IN OUT NOCOPY VARCHAR2) ;
149:
150: PROCEDURE unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,

Line 147: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,

143:
144: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
145: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
146: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
147: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
148: p_c_rec_status IN OUT NOCOPY VARCHAR2) ;
149:
150: PROCEDURE unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
151: p_coord_person_id IN igs_ps_unit_ver_all.coord_person_id%TYPE) AS

Line 151: p_coord_person_id IN igs_ps_unit_ver_all.coord_person_id%TYPE) AS

147: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
148: p_c_rec_status IN OUT NOCOPY VARCHAR2) ;
149:
150: PROCEDURE unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
151: p_coord_person_id IN igs_ps_unit_ver_all.coord_person_id%TYPE) AS
152: /***********************************************************************************************
153:
154: Created By: sarakshi
155: Date Created By: 13-Nov-2002

Line 580: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

576: Change History (in reverse chronological order)
577: Who When What
578: ********************************************************************************************** */
579: CURSOR c_unit_gs_count (
580: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
581: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE
582: ) IS
583: SELECT COUNT(*) cnt
584: FROM igs_ps_unit_grd_schm

Line 581: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE

577: Who When What
578: ********************************************************************************************** */
579: CURSOR c_unit_gs_count (
580: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
581: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE
582: ) IS
583: SELECT COUNT(*) cnt
584: FROM igs_ps_unit_grd_schm
585: WHERE

Line 664: CURSOR c_anon_unit_grading ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

660: AND b.s_location_type = 'CAMPUS'
661: AND a.location_cd = cp_location_cd;
662: rec_location_type c_location_type%ROWTYPE;
663:
664: CURSOR c_anon_unit_grading ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
665: cp_version_number igs_ps_unit_ver_all.version_number%TYPE ) IS
666: SELECT 1
667: FROM igs_ps_unit_ver
668: WHERE unit_cd = cp_unit_cd

Line 665: cp_version_number igs_ps_unit_ver_all.version_number%TYPE ) IS

661: AND a.location_cd = cp_location_cd;
662: rec_location_type c_location_type%ROWTYPE;
663:
664: CURSOR c_anon_unit_grading ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
665: cp_version_number igs_ps_unit_ver_all.version_number%TYPE ) IS
666: SELECT 1
667: FROM igs_ps_unit_ver
668: WHERE unit_cd = cp_unit_cd
669: AND version_number = cp_version_number

Line 694: CURSOR c_anon_assess_grading ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

690: AND c.teach_ci_sequence_number = cp_ci_seq_num ;
691:
692: l_load_start_dt igs_ca_inst_all.start_dt%TYPE;
693:
694: CURSOR c_anon_assess_grading ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
695: cp_version_number igs_ps_unit_ver_all.version_number%TYPE ) IS
696: SELECT 1
697: FROM igs_ps_unit_ver
698: WHERE unit_cd = cp_unit_cd

Line 695: cp_version_number igs_ps_unit_ver_all.version_number%TYPE ) IS

691:
692: l_load_start_dt igs_ca_inst_all.start_dt%TYPE;
693:
694: CURSOR c_anon_assess_grading ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
695: cp_version_number igs_ps_unit_ver_all.version_number%TYPE ) IS
696: SELECT 1
697: FROM igs_ps_unit_ver
698: WHERE unit_cd = cp_unit_cd
699: AND version_number = cp_version_number

Line 715: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

711: AND A.cal_status = B.cal_status;
712:
713: rec_cal_status c_cal_status%ROWTYPE;
714:
715: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
716: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
717: SELECT same_teaching_period
718: FROM igs_ps_unit_ver_all
719: WHERE unit_cd = cp_unit_cd

Line 716: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS

712:
713: rec_cal_status c_cal_status%ROWTYPE;
714:
715: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
716: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
717: SELECT same_teaching_period
718: FROM igs_ps_unit_ver_all
719: WHERE unit_cd = cp_unit_cd
720: AND version_number = cp_version_number;

Line 718: FROM igs_ps_unit_ver_all

714:
715: CURSOR c_muiltiple_section_flag ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
716: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
717: SELECT same_teaching_period
718: FROM igs_ps_unit_ver_all
719: WHERE unit_cd = cp_unit_cd
720: AND version_number = cp_version_number;
721:
722: l_same_teaching_period igs_ps_unit_ver_all.same_teaching_period%TYPE;

Line 722: l_same_teaching_period igs_ps_unit_ver_all.same_teaching_period%TYPE;

718: FROM igs_ps_unit_ver_all
719: WHERE unit_cd = cp_unit_cd
720: AND version_number = cp_version_number;
721:
722: l_same_teaching_period igs_ps_unit_ver_all.same_teaching_period%TYPE;
723:
724: CURSOR c_crosslist ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
725: SELECT 'X'
726: FROM igs_ps_usec_x_grpmem

Line 1309: CURSOR c_credit (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

1305: sarakshi 10-Nov-2003 Enh#3116171, added business logic related to the newly introduced field BILLING_CREDIT_POINTS
1306: sarakshi 28-Jun-2003 Enh#2930935,modified cursor c_credits such that it no longer selects
1307: enrolled and achievable credit points
1308: ********************************************************************************************** */
1309: CURSOR c_credit (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1310: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1311: SELECT points_override_ind
1312: FROM igs_ps_unit_ver_all
1313: WHERE unit_cd = cp_unit_cd

Line 1310: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS

1306: sarakshi 28-Jun-2003 Enh#2930935,modified cursor c_credits such that it no longer selects
1307: enrolled and achievable credit points
1308: ********************************************************************************************** */
1309: CURSOR c_credit (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1310: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1311: SELECT points_override_ind
1312: FROM igs_ps_unit_ver_all
1313: WHERE unit_cd = cp_unit_cd
1314: AND version_number = cp_ver_num;

Line 1312: FROM igs_ps_unit_ver_all

1308: ********************************************************************************************** */
1309: CURSOR c_credit (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1310: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1311: SELECT points_override_ind
1312: FROM igs_ps_unit_ver_all
1313: WHERE unit_cd = cp_unit_cd
1314: AND version_number = cp_ver_num;
1315:
1316: CURSOR c_teach_resp(p_uoo_id NUMBER) IS

Line 1336: l_c_override_ind igs_ps_unit_ver_all.points_override_ind%TYPE;

1332: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;
1333: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;
1334: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;
1335:
1336: l_c_override_ind igs_ps_unit_ver_all.points_override_ind%TYPE;
1337: l_c_message VARCHAR2(30);
1338:
1339: BEGIN
1340: OPEN c_credit ( p_usec_rec.unit_cd, p_usec_rec.version_number );

Line 1417: CURSOR c_subtitle ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

1413: Known limitations,enhancements,remarks:
1414: Change History (in reverse chronological order)
1415: Who When What
1416: ********************************************************************************************** */
1417: CURSOR c_subtitle ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1418: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1419: SELECT 1
1420: FROM igs_ps_unit_subtitle
1421: WHERE closed_ind = 'N'

Line 1418: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS

1414: Change History (in reverse chronological order)
1415: Who When What
1416: ********************************************************************************************** */
1417: CURSOR c_subtitle ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1418: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1419: SELECT 1
1420: FROM igs_ps_unit_subtitle
1421: WHERE closed_ind = 'N'
1422: AND approved_ind = 'Y'

Line 1428: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

1424: AND version_number = cp_ver_num;
1425: rec_subtitle c_subtitle%ROWTYPE;
1426:
1427: CURSOR c_subtitle_id (
1428: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1429: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,
1430: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE,
1431: cp_approved_ind igs_ps_unit_subtitle.approved_ind%TYPE) IS
1432: SELECT subtitle_id

Line 1429: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,

1425: rec_subtitle c_subtitle%ROWTYPE;
1426:
1427: CURSOR c_subtitle_id (
1428: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1429: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,
1430: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE,
1431: cp_approved_ind igs_ps_unit_subtitle.approved_ind%TYPE) IS
1432: SELECT subtitle_id
1433: FROM igs_ps_unit_subtitle

Line 1441: CURSOR c_unit_ver(cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

1437: AND version_number = cp_ver_num
1438: AND subtitle = cp_subtitle ;
1439: rec_subtitle_id c_subtitle_id%ROWTYPE;
1440:
1441: CURSOR c_unit_ver(cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1442: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1443: SELECT uv.title_override_ind,
1444: uv.subtitle_modifiable_flag
1445: FROM igs_ps_unit_ver uv

Line 1442: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS

1438: AND subtitle = cp_subtitle ;
1439: rec_subtitle_id c_subtitle_id%ROWTYPE;
1440:
1441: CURSOR c_unit_ver(cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1442: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1443: SELECT uv.title_override_ind,
1444: uv.subtitle_modifiable_flag
1445: FROM igs_ps_unit_ver uv
1446: WHERE uv.unit_cd = cp_unit_cd

Line 1458: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

1454:
1455: c_usec_ref_rec c_usec_ref%ROWTYPE;
1456:
1457: CURSOR c_subtitle_closed (
1458: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1459: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,
1460: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE ) IS
1461: SELECT 'X'
1462: FROM igs_ps_unit_subtitle

Line 1459: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,

1455: c_usec_ref_rec c_usec_ref%ROWTYPE;
1456:
1457: CURSOR c_subtitle_closed (
1458: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1459: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,
1460: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE ) IS
1461: SELECT 'X'
1462: FROM igs_ps_unit_subtitle
1463: WHERE closed_ind = 'Y'

Line 2853: FUNCTION validate_org_unit_cd ( p_c_org_unit_cd IN igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,

2849:
2850: END validate_cal_cat;
2851:
2852: -- Validate Orgaization Unit Code
2853: FUNCTION validate_org_unit_cd ( p_c_org_unit_cd IN igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
2854: p_c_object_name IN VARCHAR2 ) RETURN BOOLEAN
2855: AS
2856: /***********************************************************************************************
2857: Created By : shtatiko

Line 2922: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,

2918: END get_party_id;
2919:
2920: -- Removed the function validate_staff_person
2921:
2922: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
2923: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
2924: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
2925: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
2926: p_c_rec_status IN OUT NOCOPY VARCHAR2) IS

Line 2923: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,

2919:
2920: -- Removed the function validate_staff_person
2921:
2922: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
2923: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
2924: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
2925: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
2926: p_c_rec_status IN OUT NOCOPY VARCHAR2) IS
2927: /***********************************************************************************************

Line 2924: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,

2920: -- Removed the function validate_staff_person
2921:
2922: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
2923: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
2924: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
2925: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
2926: p_c_rec_status IN OUT NOCOPY VARCHAR2) IS
2927: /***********************************************************************************************
2928: Created By : jbegum

Line 2925: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,

2921:
2922: PROCEDURE validate_enr_lmts( p_n_ern_min igs_ps_unit_ver_all.enrollment_minimum%TYPE,
2923: p_n_enr_max igs_ps_unit_ver_all.enrollment_maximum%TYPE,
2924: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
2925: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
2926: p_c_rec_status IN OUT NOCOPY VARCHAR2) IS
2927: /***********************************************************************************************
2928: Created By : jbegum
2929: Date Created By: 02-June-2003

Line 3026: CURSOR c_usec_st(cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,

3022: WHERE uoo_id = cp_n_uoo_id;
3023:
3024: c_usec_wlst_pri_rec c_usec_wlst_pri%ROWTYPE;
3025:
3026: CURSOR c_usec_st(cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3027: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
3028: SELECT b.s_unit_status unit_status
3029: FROM igs_ps_unit_ver_all a,igs_ps_unit_stat b
3030: WHERE a.UNIT_STATUS=b.UNIT_STATUS

Line 3027: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

3023:
3024: c_usec_wlst_pri_rec c_usec_wlst_pri%ROWTYPE;
3025:
3026: CURSOR c_usec_st(cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3027: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
3028: SELECT b.s_unit_status unit_status
3029: FROM igs_ps_unit_ver_all a,igs_ps_unit_stat b
3030: WHERE a.UNIT_STATUS=b.UNIT_STATUS
3031: AND a.unit_cd=cp_unit_cd

Line 3029: FROM igs_ps_unit_ver_all a,igs_ps_unit_stat b

3025:
3026: CURSOR c_usec_st(cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3027: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
3028: SELECT b.s_unit_status unit_status
3029: FROM igs_ps_unit_ver_all a,igs_ps_unit_stat b
3030: WHERE a.UNIT_STATUS=b.UNIT_STATUS
3031: AND a.unit_cd=cp_unit_cd
3032: AND a.version_number=cp_version_number;
3033: c_usec_st_rec c_usec_st%ROWTYPE;

Line 3226: FROM igs_ps_unit_ver_all uv,

3222: p_insert_update VARCHAR2) AS
3223:
3224: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3225: SELECT enrollment_maximum,enrollment_expected,override_enrollment_max
3226: FROM igs_ps_unit_ver_all uv,
3227: igs_ps_unit_ofr_opt_all uoo
3228: WHERE uv.unit_cd=uoo.unit_cd
3229: AND uv.version_number=uoo.version_number
3230: AND uoo.uoo_id=cp_uoo_id;

Line 3636: l_c_validation_type igs_ps_unit_ver_all.workload_val_code%TYPE;

3632: l_n_tot_lec NUMBER;
3633: l_n_tot_lab NUMBER;
3634: l_n_tot_oth NUMBER;
3635: rec_unit_dtls c_unit_dtls%ROWTYPE;
3636: l_c_validation_type igs_ps_unit_ver_all.workload_val_code%TYPE;
3637:
3638: BEGIN
3639: l_b_validation := TRUE;
3640: l_b_status :=TRUE;

Line 4020: cp_version_number igs_ps_unit_ver_all.version_number%type,

4016: c_usec_chk_rec c_usec_chk%ROWTYPE;
4017:
4018: CURSOR c_pattern_chk(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
4019: cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
4020: cp_version_number igs_ps_unit_ver_all.version_number%type,
4021: cp_unit_cd igs_ps_unit_ver_all.unit_cd%type
4022: ) IS
4023: SELECT 'X'
4024: FROM igs_ps_unit_ofr_pat_all

Line 4021: cp_unit_cd igs_ps_unit_ver_all.unit_cd%type

4017:
4018: CURSOR c_pattern_chk(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
4019: cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
4020: cp_version_number igs_ps_unit_ver_all.version_number%type,
4021: cp_unit_cd igs_ps_unit_ver_all.unit_cd%type
4022: ) IS
4023: SELECT 'X'
4024: FROM igs_ps_unit_ofr_pat_all
4025: WHERE cal_type= cp_cal_type