eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_PROG_TRANSFER_PKG dependencies on IGS_HE_EN_SUSA_CC

Line 271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,

267: c_prg_grp_rec c_prg_grp%ROWTYPE ;
268: l_cont_progs BOOLEAN;
269:
270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*

Line 272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,

268: l_cont_progs BOOLEAN;
269:
270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa

Line 273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,

269:
270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa
277: WHERE susa.person_id = cp_person_id

Line 274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS

270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa
277: WHERE susa.person_id = cp_person_id
278: AND susa.course_cd = cp_course_cd

Line 276: FROM igs_he_en_susa_cc susa

272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa
277: WHERE susa.person_id = cp_person_id
278: AND susa.course_cd = cp_course_cd
279: AND susa.unit_set_cd = cp_unit_set_cd
280: AND susa.sequence_number = cp_sequence_number;

Line 283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,

279: AND susa.unit_set_cd = cp_unit_set_cd
280: AND susa.sequence_number = cp_sequence_number;
281:
282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,

Line 284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,

280: AND susa.sequence_number = cp_sequence_number;
281:
282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS

Line 285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,

281:
282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'

Line 286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,

282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa

Line 287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,

283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa
291: WHERE susa.person_id = cp_person_id

Line 288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS

284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa
291: WHERE susa.person_id = cp_person_id
292: AND susa.course_cd = cp_course_cd

Line 290: FROM igs_he_en_susa_cc susa

286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa
291: WHERE susa.person_id = cp_person_id
292: AND susa.course_cd = cp_course_cd
293: AND susa.unit_set_cd = cp_unit_set_cd
294: AND susa.sequence_number = cp_sequence_number

Line 299: l_he_susa_cc_id igs_he_en_susa_cc.he_susa_cc_id%TYPE := NULL ;

295: AND susa.cost_centre = cp_cost_centre
296: AND susa.subject = cp_subject;
297:
298: l_rowid VARCHAR2(25) := NULL;
299: l_he_susa_cc_id igs_he_en_susa_cc.he_susa_cc_id%TYPE := NULL ;
300: l_dummy VARCHAR2(1);
301:
302: BEGIN
303:

Line 642: -- Loop through all the records in igs_he_en_susa_cc table for the old unit set attempt

638: END IF; -- if old susa hesa details record is not found
639:
640: -- CREATE THE STUDENT SET ATTEMPT COST CENTRE RECORD
641:
642: -- Loop through all the records in igs_he_en_susa_cc table for the old unit set attempt
643: -- and insert if the record does not exist for new Unit Set Attempt
644: FOR old_susa_cc_dtls_rec IN old_susa_cc_dtls_cur( p_person_id, p_old_course_cd,
645: p_old_unit_set_cd, v_u_old_sequence_number ) LOOP
646:

Line 653: igs_he_en_susa_cc_pkg.insert_row (

649: FETCH new_susa_cc_dtls_cur INTO l_dummy;
650: IF new_susa_cc_dtls_cur%NOTFOUND THEN
651:
652: -- create the new student unit set attempt cost centre record
653: igs_he_en_susa_cc_pkg.insert_row (
654: x_rowid => l_rowid,
655: x_he_susa_cc_id => l_he_susa_cc_id,
656: x_person_id => p_person_id,
657: x_course_cd => p_new_course_cd,