APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_USO_CM_GRP

Line 872: FROM igs_ps_uso_cm_grp

868: c_host_rec c_host%ROWTYPE;
869:
870: CURSOR c_cm_grp(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
871: SELECT *
872: FROM igs_ps_uso_cm_grp
873: WHERE class_meet_group_id = cp_class_meet_group_id;
874:
875: c_cm_grp_rec c_cm_grp%ROWTYPE;
876:

Line 903: FROM igs_ps_uso_cm_grp a, igs_ca_inst_all b

899: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
900:
901: CURSOR cur_group_id (cp_group_name VARCHAR2, cp_alternate_cd VARCHAR2) IS
902: SELECT a.class_meet_group_id
903: FROM igs_ps_uso_cm_grp a, igs_ca_inst_all b
904: WHERE a.class_meet_group_name = cp_group_name
905: AND a.cal_type = b.cal_type
906: AND a.ci_sequence_number =b.sequence_number
907: AND b.alternate_code=cp_alternate_cd;

Line 914: max_enr_group_temp igs_ps_uso_cm_grp.max_enr_group%TYPE;

910:
911: l_new_sum NUMBER;
912: l_execute_next_logic BOOLEAN;
913: l_n_count_msg NUMBER;
914: max_enr_group_temp igs_ps_uso_cm_grp.max_enr_group%TYPE;
915: max_ovr_group_temp igs_ps_uso_cm_grp.max_ovr_group%TYPE;
916: l_b_status BOOLEAN;
917: l_b_error BOOLEAN;
918: BEGIN

Line 915: max_ovr_group_temp igs_ps_uso_cm_grp.max_ovr_group%TYPE;

911: l_new_sum NUMBER;
912: l_execute_next_logic BOOLEAN;
913: l_n_count_msg NUMBER;
914: max_enr_group_temp igs_ps_uso_cm_grp.max_enr_group%TYPE;
915: max_ovr_group_temp igs_ps_uso_cm_grp.max_ovr_group%TYPE;
916: l_b_status BOOLEAN;
917: l_b_error BOOLEAN;
918: BEGIN
919:

Line 1011: UPDATE igs_ps_uso_cm_grp

1007: max_ovr_group_temp:=l_new_sum;
1008: END IF;
1009:
1010: --Update the maximum enrollment/ovrride group
1011: UPDATE igs_ps_uso_cm_grp
1012: SET max_enr_group=max_enr_group_temp,
1013: max_ovr_group=max_ovr_group_temp,
1014: last_updated_by = g_n_user_id,
1015: last_update_date = SYSDATE,

Line 1109: SELECT 'X' FROM igs_ps_uso_cm_grp

1105: Change History (in reverse chronological order)
1106: Who When What
1107: ********************************************************************************************** */
1108: CURSOR c_uso_cm_grp(cp_cmg_name VARCHAR2) IS
1109: SELECT 'X' FROM igs_ps_uso_cm_grp
1110: WHERE class_meet_group_name =cp_cmg_name;
1111:
1112: c_uso_cm_grp_rec c_uso_cm_grp%ROWTYPE;
1113:

Line 1116: FROM igs_ps_uso_cm_grp

1112: c_uso_cm_grp_rec c_uso_cm_grp%ROWTYPE;
1113:
1114: CURSOR c_val_enr(cp_cmg_name VARCHAR2,cp_cal_type VARCHAR2,cp_sequence_number NUMBER) IS
1115: SELECT *
1116: FROM igs_ps_uso_cm_grp
1117: WHERE class_meet_group_name =cp_cmg_name
1118: AND Cal_type=cp_cal_type
1119: AND ci_sequence_number=cp_sequence_number;
1120:

Line 1124: SELECT * FROM igs_ps_uso_cm_grp

1120:
1121: c_val_enr_rec c_val_enr%ROWTYPE;
1122:
1123: CURSOR c_old_cmgrp(cp_cmg_name VARCHAR2,cp_cal_type VARCHAR2,cp_seq_no NUMBER) IS
1124: SELECT * FROM igs_ps_uso_cm_grp
1125: WHERE class_meet_group_name =cp_cmg_name
1126: AND cal_type=cp_cal_type
1127: AND ci_sequence_number=cp_seq_no;
1128: