APPS.IGS_EN_PLAN_UTILS dependencies on IGS_EN_SPA_TERMS

Line 171: --Purpose: update plan_sht_status column of igs_en_spa_terms.

167: ------------------------------------------------------------------
168: --Created by : ctyagi, Oracle IDC
169: --Date created: 18-JULY-2005
170: --
171: --Purpose: update plan_sht_status column of igs_en_spa_terms.
172: --
173: --Known limitations/enhancements and/or remarks:
174: --
175: --Change History:

Line 181: FROM igs_en_spa_terms spt

177: -------------------------------------------------------------------
178:
179: CURSOR select_rec IS
180: SELECT spt.rowid,spt.*
181: FROM igs_en_spa_terms spt
182: WHERE PERSON_ID=P_PERSON_ID
183: AND PROGRAM_CD=P_COURSE_CD
184: AND TERM_CAL_TYPE=P_TERM_CAL_TYPE
185: AND TERM_SEQUENCE_NUMBER=P_TERM_SEQUENCE_NUMBER;

Line 193: l_plan_sht_status igs_en_spa_terms.plan_sht_status%TYPE;

189:
190:
191:
192: l_message_name VARCHAR2(2000);
193: l_plan_sht_status igs_en_spa_terms.plan_sht_status%TYPE;
194:
195: BEGIN
196: OPEN select_rec ;
197: FETCH select_rec INTO old_references;

Line 204: igs_en_spa_terms_api.create_update_term_rec(p_person_id => P_PERSON_ID,

200: IF P_PLAN_SHT_FLAG = 'SKIP' THEN
201:
202: IF p_person_id IS NOT NULL THEN
203: -- Call the API to Create/Update the term record.
204: igs_en_spa_terms_api.create_update_term_rec(p_person_id => P_PERSON_ID,
205: p_program_cd => P_COURSE_CD,
206: p_term_cal_type => P_TERM_CAL_TYPE,
207: p_term_sequence_number => P_TERM_SEQUENCE_NUMBER,
208: p_plan_sht_status => 'PLAN',

Line 222: igs_en_spa_terms_pkg.update_row(x_rowid => old_references.rowid ,

218:
219: OPEN select_rec ;
220: FETCH select_rec INTO old_references;
221: IF select_rec%FOUND THEN
222: igs_en_spa_terms_pkg.update_row(x_rowid => old_references.rowid ,
223: x_term_record_id => old_references.term_record_id,
224: x_person_id => old_references.person_id,
225: x_program_cd => old_references.program_cd,
226: x_program_version => old_references.program_version,