APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_EN_SPA_TERMS_API

Line 3141: l_spa_term_cal_type := igs_en_spa_terms_api.g_spa_term_cal_type;

3137: END IF;
3138:
3139: IF (p_action = 'UPDATE') THEN
3140:
3141: l_spa_term_cal_type := igs_en_spa_terms_api.g_spa_term_cal_type;
3142: l_spa_term_sequence_number := igs_en_spa_terms_api.g_spa_term_sequence_number;
3143:
3144: -- Invoke the procedure to check whether to create/update the term record.
3145: enrp_ins_upd_term_rec(p_action);

Line 3142: l_spa_term_sequence_number := igs_en_spa_terms_api.g_spa_term_sequence_number;

3138:
3139: IF (p_action = 'UPDATE') THEN
3140:
3141: l_spa_term_cal_type := igs_en_spa_terms_api.g_spa_term_cal_type;
3142: l_spa_term_sequence_number := igs_en_spa_terms_api.g_spa_term_sequence_number;
3143:
3144: -- Invoke the procedure to check whether to create/update the term record.
3145: enrp_ins_upd_term_rec(p_action);
3146:

Line 4760: -- to igs_en_spa_terms_api.create_update_term_rec.

4756: --
4757: --Change History:
4758: --Who When What
4759: --stutta 16-Mar-2004 Passing new parameter p_update_rec in call
4760: -- to igs_en_spa_terms_api.create_update_term_rec.
4761: -- Bug # 3421436
4762: --stutta 7-Jan-2005 Allow term record creation whether any attributes
4763: -- change or not if called from PROGRAM_TRANSFER
4764: --stutta 1-Dec-2005 Delete terms when Unconfirming program irrespective

Line 4813: igs_en_spa_terms_api.create_update_term_rec(

4809: new_references.course_rqrmnts_complete_dt);
4810: FETCH cur_get_effective_term INTO l_term_cal_type,l_term_ci_seq_num;
4811: CLOSE cur_get_effective_term;
4812: IF (l_term_cal_type IS NOT NULL AND l_term_ci_seq_num IS NOT NULL) THEN
4813: igs_en_spa_terms_api.create_update_term_rec(
4814: p_person_id => new_references.person_id,
4815: p_program_cd => new_references.course_cd,
4816: p_term_cal_type => l_term_cal_type,
4817: p_term_sequence_number => l_term_ci_seq_num,

Line 4832: igs_en_spa_terms_api.delete_terms_for_program(

4828: IF (new_references.course_attempt_status = 'UNCONFIRM' AND old_references.course_attempt_status IS NOT NULL
4829: AND old_references.course_attempt_status <> new_references.course_attempt_status ) THEN
4830: -- For a term which is moving from a confirmed status to an unconfirmed status
4831: -- Delete all future term records from the current term for an unconfirmed program.
4832: igs_en_spa_terms_api.delete_terms_for_program(
4833: p_person_id => new_references.person_id,
4834: p_program_cd => new_references.course_cd);
4835: END IF;
4836: