APPS.IGS_AD_VAL_SCFT dependencies on IGS_AD_SBM_PS_FNTRGT

Line 27: -- IGS_AD_SBM_PS_FNTRGT is unique within submission, course and funding source.

23: p_message_name OUT NOCOPY VARCHAR2 )
24: RETURN BOOLEAN AS
25: BEGIN -- admp_val_scft_uniq
26: -- This module checks the combination of optional components of
27: -- IGS_AD_SBM_PS_FNTRGT is unique within submission, course and funding source.
28: DECLARE
29: v_scft_count NUMBER;
30: CURSOR c_scft IS
31: SELECT count(*)

Line 32: FROM IGS_AD_SBM_PS_FNTRGT

28: DECLARE
29: v_scft_count NUMBER;
30: CURSOR c_scft IS
31: SELECT count(*)
32: FROM IGS_AD_SBM_PS_FNTRGT
33: WHERE submission_yr = p_submission_yr AND
34: submission_number = p_submission_number AND
35: course_cd = p_course_cd AND
36: crv_version_number = p_crv_version_number AND

Line 80: -- This module validates the IGS_PS_VER component of IGS_AD_SBM_PS_FNTRGT

76: p_crv_version_number IN NUMBER ,
77: p_message_name OUT NOCOPY VARCHAR2 )
78: RETURN BOOLEAN AS
79: BEGIN -- admp_val_scft_cop
80: -- This module validates the IGS_PS_VER component of IGS_AD_SBM_PS_FNTRGT
81: -- exists and is offered within a IGS_PS_OFR_PAT that is in the
82: -- academic period of the submission period.
83: DECLARE
84: v_cop VARCHAR2(1);

Line 135: -- This module validates that the funding_source for the IGS_AD_SBM_PS_FNTRGT

131: p_funding_source IN VARCHAR2 ,
132: p_message_name OUT NOCOPY VARCHAR2 )
133: RETURN BOOLEAN AS
134: BEGIN -- admp_val_scft_fs
135: -- This module validates that the funding_source for the IGS_AD_SBM_PS_FNTRGT
136: -- complies with any IGS_FI_FND_SRC_RSTN.
137: DECLARE
138: v_fsr VARCHAR2(1);
139: CURSOR c_fsr (

Line 140: cp_funding_source IGS_AD_SBM_PS_FNTRGT.funding_source%TYPE) IS

136: -- complies with any IGS_FI_FND_SRC_RSTN.
137: DECLARE
138: v_fsr VARCHAR2(1);
139: CURSOR c_fsr (
140: cp_funding_source IGS_AD_SBM_PS_FNTRGT.funding_source%TYPE) IS
141: SELECT 'x'
142: FROM IGS_FI_FND_SRC_RSTN
143: WHERE course_cd = p_course_cd AND
144: version_number = p_crv_version_number AND

Line 197: -- This module validates the IGS_EN_UNIT_SET component of IGS_AD_SBM_PS_FNTRGT

193: p_attendance_type IN VARCHAR2 ,
194: p_message_name OUT NOCOPY VARCHAR2 )
195: RETURN BOOLEAN AS
196: BEGIN -- admp_val_scft_cous
197: -- This module validates the IGS_EN_UNIT_SET component of IGS_AD_SBM_PS_FNTRGT
198: -- does not have a system status of 'INACTIVE' and maps to at least one
199: -- course_offering_unot_set or IGS_PS_OF_OPT_UNT_ST.
200: DECLARE
201: v_coousv VARCHAR2(1);