APPS.IGS_HE_PROG_TRANSFER_PKG dependencies on IGS_HE_ST_SPA_CC

Line 876: CURSOR old_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,

872: c_prg_grp_rec c_prg_grp%ROWTYPE ;
873: l_cont_progs BOOLEAN;
874:
875: -- Fetch the Cost Centers of the Old Program Attempt
876: CURSOR old_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
877: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS
878: SELECT spa.*
879: FROM IGS_HE_ST_SPA_CC spa
880: WHERE spa.person_id = cp_person_id

Line 877: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS

873: l_cont_progs BOOLEAN;
874:
875: -- Fetch the Cost Centers of the Old Program Attempt
876: CURSOR old_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
877: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS
878: SELECT spa.*
879: FROM IGS_HE_ST_SPA_CC spa
880: WHERE spa.person_id = cp_person_id
881: AND spa.course_cd = cp_course_cd ;

Line 879: FROM IGS_HE_ST_SPA_CC spa

875: -- Fetch the Cost Centers of the Old Program Attempt
876: CURSOR old_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
877: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS
878: SELECT spa.*
879: FROM IGS_HE_ST_SPA_CC spa
880: WHERE spa.person_id = cp_person_id
881: AND spa.course_cd = cp_course_cd ;
882:
883: -- Check whether the Cost Center record already exist in the new program attempt

Line 884: CURSOR new_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,

880: WHERE spa.person_id = cp_person_id
881: AND spa.course_cd = cp_course_cd ;
882:
883: -- Check whether the Cost Center record already exist in the new program attempt
884: CURSOR new_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
885: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE,
886: cp_cost_centre IGS_HE_ST_SPA_CC.cost_centre%TYPE,
887: cp_subject IGS_HE_ST_SPA_CC.subject%TYPE) IS
888: SELECT 'X'

Line 885: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE,

881: AND spa.course_cd = cp_course_cd ;
882:
883: -- Check whether the Cost Center record already exist in the new program attempt
884: CURSOR new_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
885: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE,
886: cp_cost_centre IGS_HE_ST_SPA_CC.cost_centre%TYPE,
887: cp_subject IGS_HE_ST_SPA_CC.subject%TYPE) IS
888: SELECT 'X'
889: FROM IGS_HE_ST_SPA_CC spa

Line 886: cp_cost_centre IGS_HE_ST_SPA_CC.cost_centre%TYPE,

882:
883: -- Check whether the Cost Center record already exist in the new program attempt
884: CURSOR new_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
885: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE,
886: cp_cost_centre IGS_HE_ST_SPA_CC.cost_centre%TYPE,
887: cp_subject IGS_HE_ST_SPA_CC.subject%TYPE) IS
888: SELECT 'X'
889: FROM IGS_HE_ST_SPA_CC spa
890: WHERE spa.person_id = cp_person_id

Line 887: cp_subject IGS_HE_ST_SPA_CC.subject%TYPE) IS

883: -- Check whether the Cost Center record already exist in the new program attempt
884: CURSOR new_spa_cc_dtls_cur( cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
885: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE,
886: cp_cost_centre IGS_HE_ST_SPA_CC.cost_centre%TYPE,
887: cp_subject IGS_HE_ST_SPA_CC.subject%TYPE) IS
888: SELECT 'X'
889: FROM IGS_HE_ST_SPA_CC spa
890: WHERE spa.person_id = cp_person_id
891: AND spa.course_cd = cp_course_cd

Line 889: FROM IGS_HE_ST_SPA_CC spa

885: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE,
886: cp_cost_centre IGS_HE_ST_SPA_CC.cost_centre%TYPE,
887: cp_subject IGS_HE_ST_SPA_CC.subject%TYPE) IS
888: SELECT 'X'
889: FROM IGS_HE_ST_SPA_CC spa
890: WHERE spa.person_id = cp_person_id
891: AND spa.course_cd = cp_course_cd
892: AND cost_centre = cp_cost_centre
893: AND subject = cp_subject;

Line 896: l_he_spa_cc_id igs_he_st_spa_cc.he_spa_cc_id%TYPE := NULL ;

892: AND cost_centre = cp_cost_centre
893: AND subject = cp_subject;
894:
895: l_rowid VARCHAR2(25) := NULL;
896: l_he_spa_cc_id igs_he_st_spa_cc.he_spa_cc_id%TYPE := NULL ;
897: l_dummy VARCHAR2(1);
898:
899: BEGIN
900:

Line 1278: -- Loop through all the records in IGS_HE_ST_SPA_CC table for the old program attempt

1274: END IF; -- if old UK statistics record found
1275:
1276: -- CREATE THE UK STATISTICS COST CENTRE - SPA RECORD
1277:
1278: -- Loop through all the records in IGS_HE_ST_SPA_CC table for the old program attempt
1279: -- and insert if the record does not exist for new Program Attempt
1280: FOR old_spa_cc_dtls_rec IN old_spa_cc_dtls_cur( p_person_id, p_old_course_cd ) LOOP
1281:
1282: OPEN new_spa_cc_dtls_cur( p_person_id, p_new_course_cd,

Line 1288: igs_he_st_spa_cc_pkg.insert_row (

1284: FETCH new_spa_cc_dtls_cur INTO l_dummy;
1285: IF new_spa_cc_dtls_cur%NOTFOUND THEN
1286:
1287: -- create the new student program attempt cost centre record
1288: igs_he_st_spa_cc_pkg.insert_row (
1289: x_rowid => l_rowid,
1290: x_he_spa_cc_id => l_he_spa_cc_id,
1291: x_person_id => p_person_id,
1292: x_course_cd => p_new_course_cd,