APPS.IGS_PS_VAL_POSU dependencies on IGS_PS_PAT_STUDY_UNT

Line 19: -- Validate IGS_PS_PAT_STUDY_UNT records.

15: p_location_cd IN VARCHAR2,
16: p_unit_class IN VARCHAR2 )
17: RETURN BOOLEAN AS
18: BEGIN -- crsp_val_posu_iu
19: -- Validate IGS_PS_PAT_STUDY_UNT records.
20: -- Multiple records cannot exist with the same unit_cd for a parent
21: -- IGS_PS_PAT_OF_STUDY record.
22: -------------------------------------------------------------------
23: --Change History:

Line 35: FROM igs_ps_pat_study_unt psu,

31: l_n_count NUMBER;
32:
33: CURSOR cur_multiple_section IS
34: SELECT 'X'
35: FROM igs_ps_pat_study_unt psu,
36: igs_ps_unit_ver_all a,
37: igs_ps_unit_stat b
38: WHERE
39: psu.course_cd = p_course_cd AND

Line 53: FROM igs_ps_pat_study_unt psu

49: (p_sequence_number IS NULL OR psu.sequence_number <> p_sequence_number); --leave this record
50:
51: CURSOR cur_check_multi_section IS
52: SELECT COUNT(*)
53: FROM igs_ps_pat_study_unt psu
54: WHERE
55: psu.course_cd = p_course_cd AND
56: psu.version_number = p_version_number AND
57: psu.cal_type = p_cal_type AND

Line 65: FROM IGS_PS_PAT_STUDY_UNT

61:
62:
63: CURSOR c_pfsu1 IS
64: SELECT 'X'
65: FROM IGS_PS_PAT_STUDY_UNT
66: WHERE
67: course_cd = p_course_cd AND
68: version_number = p_version_number AND
69: cal_type = p_cal_type AND

Line 81: FROM IGS_PS_PAT_STUDY_UNT

77: l_c_var VARCHAR2(1);
78:
79: CURSOR c_pfsu IS
80: SELECT posp_sequence_number
81: FROM IGS_PS_PAT_STUDY_UNT
82: WHERE
83: course_cd = p_course_cd AND
84: version_number = p_version_number AND
85: cal_type = p_cal_type AND

Line 180: -- Validate IGS_PS_PAT_STUDY_UNT records, either unit_cd or

176: p_description IN VARCHAR2 ,
177: p_message_name OUT NOCOPY VARCHAR2 )
178: RETURN BOOLEAN AS
179: BEGIN -- crsp_val_posu_rqrd
180: -- Validate IGS_PS_PAT_STUDY_UNT records, either unit_cd or
181: -- description must be specified. The unit_location_cd and
182: -- IGS_AS_UNIT_CLASS can only be specified if the unit_cd is set.
183: DECLARE
184: BEGIN

Line 261: -- supplied for the IGS_PS_PAT_STUDY_UNT.unit_cd, location_cd, IGS_AS_UNIT_CLASS

257: p_message_name := NULL;
258: RETURN TRUE;
259: END IF;
260: -- 2. Check for future IGS_PS_UNIT_OFR_OPT records for the IGS_PS_COURSE offering
261: -- supplied for the IGS_PS_PAT_STUDY_UNT.unit_cd, location_cd, IGS_AS_UNIT_CLASS
262: -- and IGS_PS_PAT_STUDY_PRD.teach_cal_type
263: OPEN c_posp_uoo_ci;
264: FETCH c_posp_uoo_ci INTO v_dummy;
265: IF (c_posp_uoo_ci%NOTFOUND) THEN