DBA Data[Home] [Help]

APPS.IGS_PS_GEN_003 dependencies on IGS_PS_VAL_CO

Line 11: --smadathi 28-AUG-2001 Bug No. 1956374 .The call to igs_ps_val_cop.genp_val_staff_prsn

7: --sarakshi 25-Feb-2003 Bug#2797116,modified curosr gc_cd_and_vn_passed and gc_coo_id_passed
8: -- in crsp_get_coo_key procedure,added delete_flag check in the where clause
9: --shtatiko 05-FEB-2003 Bug# 2550392, Modified crsp_ins_ci_cop procedure and added
10: -- log_parameters procedures.
11: --smadathi 28-AUG-2001 Bug No. 1956374 .The call to igs_ps_val_cop.genp_val_staff_prsn
12: -- is changed to igs_ad_val_acai.genp_val_staff_prsn
13: -------------------------------------------------------------------------------------------
14: -- Bug # 1956374 Procedure assp_val_gs_cur_fut reference is changed
15:

Line 385: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_COO.crsp_val_loc_cd

381: -- Check for closed IGS_AD_LOCATION code,
382: -- closed attendance mode,
383: -- and closed attendance type
384:
385: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_COO.crsp_val_loc_cd
386: IF (IGS_PS_VAL_UOO.crsp_val_loc_cd (
387: v_cop_rec.location_cd,
388: p_message_name) = TRUE) AND
389: (IGS_PS_VAL_COo.crsp_val_coo_am (

Line 389: (IGS_PS_VAL_COo.crsp_val_coo_am (

385: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_COO.crsp_val_loc_cd
386: IF (IGS_PS_VAL_UOO.crsp_val_loc_cd (
387: v_cop_rec.location_cd,
388: p_message_name) = TRUE) AND
389: (IGS_PS_VAL_COo.crsp_val_coo_am (
390: v_cop_rec.attendance_mode,
391: p_message_name) = TRUE) AND
392: (IGS_PS_VAL_COo.crsp_val_coo_att (
393: v_cop_rec.attendance_type,

Line 392: (IGS_PS_VAL_COo.crsp_val_coo_att (

388: p_message_name) = TRUE) AND
389: (IGS_PS_VAL_COo.crsp_val_coo_am (
390: v_cop_rec.attendance_mode,
391: p_message_name) = TRUE) AND
392: (IGS_PS_VAL_COo.crsp_val_coo_att (
393: v_cop_rec.attendance_type,
394: p_message_name) = TRUE) THEN
395: OPEN c_check_cop_exist;
396: FETCH c_check_cop_exist INTO v_check;

Line 665: IF (IGS_PS_VAL_CO.crsp_val_co_cal_type (

661:
662: END IF;
663: CLOSE c_check_cal_type_exist;
664: -- validate the calendar type of IGS_PS_COURSE offering
665: IF (IGS_PS_VAL_CO.crsp_val_co_cal_type (
666: p_source_cal_type,
667: v_message) = FALSE) THEN
668: RAISE invalid;
669: END IF;