APPS.IGS_EN_SUSA_LGCY_PUB dependencies on IGS_AS_SU_SETATMPT_PKG

Line 40: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'COURSE_CD',

36: FND_MSG_PUB.ADD;
37: l_valid_params := FALSE;
38: ELSE
39: BEGIN
40: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'COURSE_CD',
41: column_value => p_susa_rec.program_cd);
42: EXCEPTION
43: WHEN OTHERS THEN
44: -- Pop and set excep

Line 61: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'UNIT_SET_CD',

57: FND_MSG_PUB.ADD;
58: l_valid_params := FALSE;
59: ELSE
60: BEGIN
61: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'UNIT_SET_CD',
62: column_value => p_susa_rec.unit_set_cd);
63: EXCEPTION
64: WHEN OTHERS THEN
65: -- Pop and set excep

Line 85: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'STUDENT_CONFIRMED_IND',

81:
82: -- Student confirmed ind
83: IF p_susa_rec.student_confirmed_ind IS NOT NULL THEN
84: BEGIN
85: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'STUDENT_CONFIRMED_IND',
86: column_value => p_susa_rec.student_confirmed_ind);
87: EXCEPTION
88: WHEN OTHERS THEN
89: -- Pop and set excep

Line 102: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PARENT_UNIT_SET_CD',

98:
99: -- Parent Unit set code
100: IF p_susa_rec.parent_unit_set_cd IS NOT NULL THEN
101: BEGIN
102: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PARENT_UNIT_SET_CD',
103: column_value => p_susa_rec.parent_unit_set_cd);
104: EXCEPTION
105: WHEN OTHERS THEN
106: -- Pop and set excep

Line 119: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PRIMARY_SET_IND',

115:
116: -- Primary set ind
117: IF p_susa_rec.primary_set_ind IS NOT NULL THEN
118: BEGIN
119: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'PRIMARY_SET_IND',
120: column_value => p_susa_rec.primary_set_ind);
121: EXCEPTION
122: WHEN OTHERS THEN
123: -- Pop and set excep

Line 136: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'VOLUNTARY_END_IND',

132:
133: -- Voluntary end ind
134: IF p_susa_rec.voluntary_end_ind IS NOT NULL THEN
135: BEGIN
136: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'VOLUNTARY_END_IND',
137: column_value => p_susa_rec.voluntary_end_ind);
138: EXCEPTION
139: WHEN OTHERS THEN
140: -- Pop and set excep

Line 153: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'OVERRIDE_TITLE',

149:
150: -- Override title
151: IF p_susa_rec.override_title IS NOT NULL THEN
152: BEGIN
153: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'OVERRIDE_TITLE',
154: column_value => p_susa_rec.override_title);
155: EXCEPTION
156: WHEN OTHERS THEN
157: -- Pop and set excep

Line 170: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'RQRMNTS_COMPLETE_IND',

166:
167: -- Requirements complete ind
168: IF p_susa_rec.rqrmnts_complete_ind IS NOT NULL THEN
169: BEGIN
170: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'RQRMNTS_COMPLETE_IND',
171: column_value => p_susa_rec.rqrmnts_complete_ind);
172: EXCEPTION
173: WHEN OTHERS THEN
174: -- Pop and set excep

Line 187: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'S_COMPLETED_SOURCE_TYPE',

183:
184: -- S Completed source type
185: IF p_susa_rec.s_completed_source_type IS NOT NULL THEN
186: BEGIN
187: igs_as_su_setatmpt_pkg.check_constraints (column_name => 'S_COMPLETED_SOURCE_TYPE',
188: column_value => p_susa_rec.s_completed_source_type);
189: EXCEPTION
190: WHEN OTHERS THEN
191: -- Pop and set excep

Line 290: IF NOT igs_as_su_setatmpt_pkg.get_pk_for_validation (x_person_id => p_person_id,

286:
287:
288: -- Parent Unit Set Attempt existence
289: IF p_susa_rec.parent_unit_set_cd IS NOT NULL THEN
290: IF NOT igs_as_su_setatmpt_pkg.get_pk_for_validation (x_person_id => p_person_id,
291: x_course_cd => p_susa_rec.program_cd,
292: x_unit_set_cd => p_susa_rec.parent_unit_set_cd,
293: x_sequence_number => p_parent_seq_number
294: ) THEN