APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_CA_INST_ALL

Line 47: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

43:
44: -- Validate Unit Offer Option Records before inserting them
45: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
46: p_c_cal_type IN igs_ca_type.cal_type%TYPE,
47: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
48: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,
49: p_insert_update VARCHAR2,
50: p_conc_flag OUT NOCOPY BOOLEAN);
51:

Line 74: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,

70:
71: -- This procedure validates before inserting records of Unit Section Occurrence.
72: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
73: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
74: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
75: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
76: p_n_building_code IN NUMBER,
77: p_n_room_code IN NUMBER,
78: p_n_dedicated_building_code IN NUMBER,

Line 75: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,

71: -- This procedure validates before inserting records of Unit Section Occurrence.
72: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
73: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
74: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
75: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
76: p_n_building_code IN NUMBER,
77: p_n_room_code IN NUMBER,
78: p_n_dedicated_building_code IN NUMBER,
79: p_n_dedicated_room_code IN NUMBER,

Line 121: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE ) RETURN BOOLEAN;

117: );
118:
119: -- This Function will validate whether waitlisting is allowed for given organization unit code.
120: FUNCTION validate_waitlist_allowed ( p_c_cal_type IN igs_ca_type.cal_type%TYPE,
121: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE ) RETURN BOOLEAN;
122:
123:
124: -- This function checks whether given Grading schema is of type p_c_gs_type or not.
125: FUNCTION validate_gs_type ( p_c_gs_cd IN VARCHAR2, p_n_gs_ver IN NUMBER, p_c_gs_type IN VARCHAR2 DEFAULT 'UNIT' ) RETURN BOOLEAN;

Line 128: FUNCTION validate_cal_cat ( p_c_cal_type IN igs_ca_inst_all.cal_type%TYPE,

124: -- This function checks whether given Grading schema is of type p_c_gs_type or not.
125: FUNCTION validate_gs_type ( p_c_gs_cd IN VARCHAR2, p_n_gs_ver IN NUMBER, p_c_gs_type IN VARCHAR2 DEFAULT 'UNIT' ) RETURN BOOLEAN;
126:
127: -- Validates calendar type whether its of give category or not
128: FUNCTION validate_cal_cat ( p_c_cal_type IN igs_ca_inst_all.cal_type%TYPE,
129: p_c_cal_cat IN igs_ca_type.s_cal_cat%TYPE DEFAULT 'TEACHING' ) RETURN BOOLEAN;
130:
131: -- Validate Orgaization Unit Code
132: FUNCTION validate_org_unit_cd ( p_c_org_unit_cd IN igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,