APPS.IGS_CA_VAL_QLITY dependencies on IGS_CA_INST_ALL

Line 32: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,

28: -- nsidana 7/30/2004 Bug : 3736551 : Added check to verify that load calenders do not overlap within a same academic calender.
29: ------------------------------------------------------------------
30:
31: -- forward declaration of the procedure
32: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
34: p_c_s_log_type IN VARCHAR2 ,
35: p_d_log_creation_dt IN DATE
36: );

Line 33: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

29: ------------------------------------------------------------------
30:
31: -- forward declaration of the procedure
32: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
34: p_c_s_log_type IN VARCHAR2 ,
35: p_d_log_creation_dt IN DATE
36: );
37:

Line 988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,

984: -- Bug : 2694794
985: -- cursor to check that only one load calendar instance is attached
986: -- as a subordinate calendar under an admission calendar instance
987:
988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,

Line 989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS

985: -- cursor to check that only one load calendar instance is attached
986: -- as a subordinate calendar under an admission calendar instance
987:
988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,
993: igs_ca_type cat

Line 992: igs_ca_inst_all ca,

988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,
993: igs_ca_type cat
994: WHERE
995: car.SUP_CI_SEQUENCE_NUMBER= p_sequence_number AND
996: car.SUP_CAL_type = p_cal_type AND

Line 2833: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2829: IGS_GE_MSG_STACK.ADD;
2830: App_Exception.Raise_Exception;
2831: END calp_val_teach_ci;
2832:
2833: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2834: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2835: p_c_s_log_type IN VARCHAR2 ,
2836: p_d_log_creation_dt IN DATE
2837: ) IS

Line 2834: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

2830: App_Exception.Raise_Exception;
2831: END calp_val_teach_ci;
2832:
2833: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2834: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2835: p_c_s_log_type IN VARCHAR2 ,
2836: p_d_log_creation_dt IN DATE
2837: ) IS
2838: ------------------------------------------------------------------