APPS.IGS_EN_PLAN_UNITS_PKG dependencies on IGS_EN_SPA_TERMS

Line 140: ELSIF NOT igs_en_spa_terms_pkg.get_uk_for_validation (

136: (new_references.course_cd IS NULL) OR
137: (new_references.term_cal_type IS NULL) OR
138: (new_references.term_ci_sequence_number IS NULL))) THEN
139: NULL;
140: ELSIF NOT igs_en_spa_terms_pkg.get_uk_for_validation (
141: new_references.person_id,
142: new_references.course_cd,
143: new_references.term_cal_type,
144: new_references.term_ci_sequence_number

Line 233: PROCEDURE get_fk_igs_en_spa_terms (

229:
230: END get_fk_igs_en_stdnt_ps_att;
231:
232:
233: PROCEDURE get_fk_igs_en_spa_terms (
234: x_person_id IN NUMBER,
235: x_program_cd IN VARCHAR2,
236: x_term_cal_type IN VARCHAR2,
237: x_term_sequence_number IN NUMBER

Line 271: END get_fk_igs_en_spa_terms;

267: RETURN;
268: END IF;
269: CLOSE cur_rowid;
270:
271: END get_fk_igs_en_spa_terms;
272:
273: PROCEDURE before_insert_update(p_action IN VARCHAR2) IS
274:
275: CURSOR c_spa_exists (cp_person_id IN NUMBER, cp_program_cd IN VARCHAR2, cp_term_cal IN VARCHAR2, cp_term_seq IN NUMBER) IS

Line 277: FROM IGS_EN_SPA_TERMS

273: PROCEDURE before_insert_update(p_action IN VARCHAR2) IS
274:
275: CURSOR c_spa_exists (cp_person_id IN NUMBER, cp_program_cd IN VARCHAR2, cp_term_cal IN VARCHAR2, cp_term_seq IN NUMBER) IS
276: SELECT PLAN_SHT_STATUS
277: FROM IGS_EN_SPA_TERMS
278: WHERE person_id = cp_person_id
279: AND program_cd = cp_program_cd
280: AND term_cal_type = cp_term_cal
281: AND term_sequence_number = cp_term_seq;

Line 285: l_plan_sht_status igs_en_spa_terms.plan_sht_status%TYPE;

281: AND term_sequence_number = cp_term_seq;
282:
283:
284: l_message_name VARCHAR2(2000);
285: l_plan_sht_status igs_en_spa_terms.plan_sht_status%TYPE;
286:
287: BEGIN
288: IF p_action NOT IN ('INSERT','UPDATE') or new_references.cart_error_flag = 'Y' THEN
289: RETURN;

Line 305: igs_en_spa_terms_api.create_update_term_rec(p_person_id => new_references.person_id,

301: END IF;
302:
303:
304: -- Call the API to Create/Update the term record.
305: igs_en_spa_terms_api.create_update_term_rec(p_person_id => new_references.person_id,
306: p_program_cd => new_references.course_cd,
307: p_term_cal_type =>new_references.term_cal_type,
308: p_term_sequence_number => new_references.term_ci_sequence_number,
309: p_plan_sht_status => 'PLAN',

Line 344: igs_en_spa_terms_api.create_update_term_rec(p_person_id => old_references.person_id,

340: old_references.term_cal_type,old_references.term_ci_sequence_number) ;
341: FETCH c_plan_rec_exists INTO l_dummy;
342: IF c_plan_rec_exists%NOTFOUND THEN
343: -- Call the API to Create/Update the term record.
344: igs_en_spa_terms_api.create_update_term_rec(p_person_id => old_references.person_id,
345: p_program_cd => old_references.course_cd,
346: p_term_cal_type =>old_references.term_cal_type,
347: p_term_sequence_number => old_references.term_ci_sequence_number,
348: p_plan_sht_status => 'NONE',