APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USO_CM_GRP

Line 3080: l_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type;

3076: Change History (in reverse chronological order)
3077: Who When What
3078: ********************************************************************************************** */
3079:
3080: l_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type;
3081: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3082: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3083: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3084: l_insert_update VARCHAR2(1);

Line 3086: FUNCTION ifexists(p_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type,

3082: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3083: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3084: l_insert_update VARCHAR2(1);
3085:
3086: FUNCTION ifexists(p_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type,
3087: p_old_max_enr_group igs_ps_uso_cm_grp.max_enr_group%TYPE
3088: ) RETURN BOOLEAN AS
3089: BEGIN
3090: FOR I in 1..class_meet_tab.count LOOP

Line 3087: p_old_max_enr_group igs_ps_uso_cm_grp.max_enr_group%TYPE

3083: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3084: l_insert_update VARCHAR2(1);
3085:
3086: FUNCTION ifexists(p_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type,
3087: p_old_max_enr_group igs_ps_uso_cm_grp.max_enr_group%TYPE
3088: ) RETURN BOOLEAN AS
3089: BEGIN
3090: FOR I in 1..class_meet_tab.count LOOP
3091: IF p_n_class_meet_group_id = class_meet_tab(i).class_meet_group_id THEN

Line 3139: FROM igs_ps_uso_cm_grp

3135: -- Check for Update
3136: FUNCTION check_insert_update ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) RETURN VARCHAR2 IS
3137: CURSOR c_uso_cm_grp(cp_cm_grp_name VARCHAR2) IS
3138: SELECT 'X'
3139: FROM igs_ps_uso_cm_grp
3140: WHERE class_meet_group_name =cp_cm_grp_name
3141: AND Cal_type=l_c_cal_type
3142: AND ci_sequence_number=l_n_seq_num;
3143:

Line 3188: FROM igs_ps_uso_cm_grp

3184: PROCEDURE Assign_default( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS
3185:
3186: CURSOR c_uso_cm_grp(cp_cm_grp_name VARCHAR2) IS
3187: SELECT *
3188: FROM igs_ps_uso_cm_grp
3189: WHERE class_meet_group_name =cp_cm_grp_name
3190: AND cal_type=l_c_cal_type
3191: AND ci_sequence_number=l_n_seq_num;
3192:

Line 3224: IF igs_ps_uso_cm_grp_pkg.get_uk_for_validation (x_class_meet_group_name=>p_uso_cm_grp_rec.class_meet_group_name,

3220: PROCEDURE validate_db_cons ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS
3221: BEGIN
3222: IF (p_insert_update = 'I') THEN
3223: /* Unique Key Validation */
3224: IF igs_ps_uso_cm_grp_pkg.get_uk_for_validation (x_class_meet_group_name=>p_uso_cm_grp_rec.class_meet_group_name,
3225: x_cal_type=>l_c_cal_type,
3226: x_ci_sequence_number=>l_n_seq_num) THEN
3227: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_MEET_WITH_CLASS_GROUP', 'LEGACY_TOKENS', FALSE);
3228: p_uso_cm_grp_rec.status := 'W';

Line 3386: INSERT INTO igs_ps_uso_cm_grp

3382:
3383: IF p_uso_cm_grp_rec.status = 'S' THEN
3384: IF l_insert_update = 'I' THEN
3385: /* Insert Record */
3386: INSERT INTO igs_ps_uso_cm_grp
3387: (class_meet_group_id,
3388: class_meet_group_name,
3389: cal_type,
3390: ci_sequence_number ,

Line 3400: (igs_ps_uso_cm_grp_s.NEXTVAL,

3396: max_enr_group,
3397: max_ovr_group
3398: )
3399: VALUES
3400: (igs_ps_uso_cm_grp_s.NEXTVAL,
3401: p_uso_cm_grp_rec.class_meet_group_name,
3402: l_c_cal_type,
3403: l_n_seq_num,
3404: g_n_user_id,

Line 3422: UPDATE igs_ps_uso_cm_grp

3418: p_uso_cm_grp_rec.unit_class||' '||'Class meet group name:'||p_uso_cm_grp_rec.class_meet_group_name);
3419: END IF;
3420:
3421: ELSE --update
3422: UPDATE igs_ps_uso_cm_grp
3423: SET max_enr_group=p_uso_cm_grp_rec.max_enr_group,
3424: max_ovr_group=p_uso_cm_grp_rec.max_ovr_group,
3425: last_updated_by = g_n_user_id,
3426: last_update_date = SYSDATE,

Line 3565: IF NOT igs_ps_uso_cm_grp_pkg.get_pk_for_validation ( l_n_class_meet_group_id ) THEN

3561: p_uso_clas_meet_rec.status := 'E';
3562: END IF;
3563:
3564: /* Validate FK Constraints */
3565: IF NOT igs_ps_uso_cm_grp_pkg.get_pk_for_validation ( l_n_class_meet_group_id ) THEN
3566: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_MEET_WITH_CLASS_GROUP', 'LEGACY_TOKENS', FALSE);
3567: p_uso_clas_meet_rec.status := 'E';
3568: END IF;
3569: