APPS.IGS_PS_GEN_003 dependencies on IGS_CA_TYPE

Line 88: -- IGS_CA_TYPE, location_cd, attendance_mode, attendance_type

84: IF p_coo_id IS NOT NULL THEN
85: OPEN gc_coo_id_passed;
86: FETCH gc_coo_id_passed INTO gv_coo_id_passed;
87: -- return the coo_id, course_cd, version_number,
88: -- IGS_CA_TYPE, location_cd, attendance_mode, attendance_type
89: IF(gc_coo_id_passed%ROWCOUNT <> 0) THEN
90: CLOSE gc_coo_id_passed;
91: p_course_cd := gv_coo_id_passed.course_cd;
92: p_version_number := gv_coo_id_passed.version_number;

Line 167: -- IGS_CA_TYPE, ci_sequence_numberlocation_cd,

163: IF p_cop_id IS NOT NULL THEN
164: OPEN gc_cop_id_passed;
165: FETCH gc_cop_id_passed INTO gv_cop_id_passed;
166: -- return the cop_id, course_cd, version_number,
167: -- IGS_CA_TYPE, ci_sequence_numberlocation_cd,
168: -- attendance_mode, attendance_type
169: IF(gc_cop_id_passed%ROWCOUNT <> 0) THEN
170: CLOSE gc_cop_id_passed;
171: p_course_cd := gv_cop_id_passed.course_cd;

Line 548: FROM IGS_CA_TYPE

544: cst_all_coi_rec_inserted BOOLEAN := FALSE;
545:
546: CURSOR c_check_cal_type_exist IS
547: SELECT 'x'
548: FROM IGS_CA_TYPE
549: WHERE cal_type = p_source_cal_type;
550: CURSOR c_check_cal_instance_exist(
551: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,
552: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS

Line 647: -- Can only transfer within the same IGS_CA_TYPE

643: fnd_file.put_line ( fnd_file.LOG, ' ' );
644:
645: v_message := NULL;
646:
647: -- Can only transfer within the same IGS_CA_TYPE
648: IF (p_source_cal_type <> p_dest_cal_type) THEN
649: v_message :='IGS_PS_ROLLOVER_CALINSTANCES';
650: RAISE invalid;
651: END IF;