APPS.IGS_HE_IMPORT_DATA dependencies on IGS_HE_ST_SPA_UT_ALL_PKG

Line 2484: igs_he_st_spa_ut_all_pkg.delete_row( X_ROWID => c_del_tariff_rec.rowid );

2480: FOR c_spa_rec IN c_spa( c_pe_det_rec.person_id , c_interface_rec.course_cd) LOOP
2481: -- delete existing tariff records for the student program attempt record
2482:
2483: FOR c_del_tariff_rec IN c_del_tariff(c_spa_rec.person_id, c_spa_rec.course_cd) LOOP
2484: igs_he_st_spa_ut_all_pkg.delete_row( X_ROWID => c_del_tariff_rec.rowid );
2485: END LOOP ;
2486:
2487: -- smaddali modified the igs_he_st_spa_yt_all_pkg insert row calls for bug 2671022
2488: -- to pass the OSS award code instead of the HESA UT code

Line 2494: igs_he_st_spa_ut_all_pkg.insert_row (

2490: -- If qualification GCSEAS details are given then create a ucas tariff record
2491: IF c_interface_rec.gceasn IS NOT NULL THEN
2492: l_rowid := NULL ;
2493: l_hesa_st_spau_id := NULL ;
2494: igs_he_st_spa_ut_all_pkg.insert_row (
2495: X_ROWID => l_rowid ,
2496: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2497: X_ORG_ID => l_org_id ,
2498: X_PERSON_ID => c_spa_rec.person_id ,

Line 2512: igs_he_st_spa_ut_all_pkg.insert_row (

2508: -- If qualification VCSEAS details are given then create a ucas tariff record
2509: IF c_interface_rec.vceasn IS NOT NULL THEN
2510: l_rowid := NULL ;
2511: l_hesa_st_spau_id := NULL ;
2512: igs_he_st_spa_ut_all_pkg.insert_row (
2513: X_ROWID => l_rowid ,
2514: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2515: X_ORG_ID => l_org_id ,
2516: X_PERSON_ID => c_spa_rec.person_id ,

Line 2530: igs_he_st_spa_ut_all_pkg.insert_row (

2526: -- If qualification GCSEA details are given then create a ucas tariff record
2527: IF c_interface_rec.gcean IS NOT NULL THEN
2528: l_rowid := NULL ;
2529: l_hesa_st_spau_id := NULL ;
2530: igs_he_st_spa_ut_all_pkg.insert_row (
2531: X_ROWID => l_rowid ,
2532: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2533: X_ORG_ID => l_org_id ,
2534: X_PERSON_ID => c_spa_rec.person_id ,

Line 2548: igs_he_st_spa_ut_all_pkg.insert_row (

2544: -- If qualification VCSEA details are given then create a ucas tariff record
2545: IF c_interface_rec.vcean IS NOT NULL THEN
2546: l_rowid := NULL ;
2547: l_hesa_st_spau_id := NULL ;
2548: igs_he_st_spa_ut_all_pkg.insert_row (
2549: X_ROWID => l_rowid ,
2550: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2551: X_ORG_ID => l_org_id ,
2552: X_PERSON_ID => c_spa_rec.person_id ,

Line 2566: igs_he_st_spa_ut_all_pkg.insert_row (

2562: -- If qualification KEYSKL details are given then create a ucas tariff record
2563: IF c_interface_rec.ksqn IS NOT NULL THEN
2564: l_rowid := NULL ;
2565: l_hesa_st_spau_id := NULL ;
2566: igs_he_st_spa_ut_all_pkg.insert_row (
2567: X_ROWID => l_rowid ,
2568: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2569: X_ORG_ID => l_org_id,
2570: X_PERSON_ID => c_spa_rec.person_id ,

Line 2584: igs_he_st_spa_ut_all_pkg.insert_row (

2580: -- If qualification 1UNKEYSKL details are given then create a ucas tariff record
2581: IF c_interface_rec.uksan IS NOT NULL THEN
2582: l_rowid := NULL ;
2583: l_hesa_st_spau_id := NULL ;
2584: igs_he_st_spa_ut_all_pkg.insert_row (
2585: X_ROWID => l_rowid ,
2586: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2587: X_ORG_ID => l_org_id ,
2588: X_PERSON_ID => c_spa_rec.person_id ,

Line 2602: igs_he_st_spa_ut_all_pkg.insert_row (

2598: -- If qualification SCOTADH details are given then create a ucas tariff record
2599: IF c_interface_rec.sahn IS NOT NULL THEN
2600: l_rowid := NULL ;
2601: l_hesa_st_spau_id := NULL ;
2602: igs_he_st_spa_ut_all_pkg.insert_row (
2603: X_ROWID => l_rowid ,
2604: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2605: X_ORG_ID => l_org_id ,
2606: X_PERSON_ID => c_spa_rec.person_id ,

Line 2620: igs_he_st_spa_ut_all_pkg.insert_row (

2616: -- If qualification SCOTH details are given then create a ucas tariff record
2617: IF c_interface_rec.shn IS NOT NULL THEN
2618: l_rowid := NULL ;
2619: l_hesa_st_spau_id := NULL ;
2620: igs_he_st_spa_ut_all_pkg.insert_row (
2621: X_ROWID => l_rowid ,
2622: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2623: X_ORG_ID => l_org_id,
2624: X_PERSON_ID => c_spa_rec.person_id ,

Line 2638: igs_he_st_spa_ut_all_pkg.insert_row (

2634: -- If qualification SCOTST details are given then create a ucas tariff record
2635: IF c_interface_rec.ssgcn IS NOT NULL THEN
2636: l_rowid := NULL ;
2637: l_hesa_st_spau_id := NULL ;
2638: igs_he_st_spa_ut_all_pkg.insert_row (
2639: X_ROWID => l_rowid ,
2640: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2641: X_ORG_ID => l_org_id ,
2642: X_PERSON_ID => c_spa_rec.person_id ,

Line 2656: igs_he_st_spa_ut_all_pkg.insert_row (

2652: -- If qualification SCOTI2 details are given then create a ucas tariff record
2653: IF c_interface_rec.si2n IS NOT NULL THEN
2654: l_rowid := NULL ;
2655: l_hesa_st_spau_id := NULL ;
2656: igs_he_st_spa_ut_all_pkg.insert_row (
2657: X_ROWID => l_rowid ,
2658: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2659: X_ORG_ID => l_org_id ,
2660: X_PERSON_ID => c_spa_rec.person_id ,

Line 2674: igs_he_st_spa_ut_all_pkg.insert_row (

2670: -- If qualification SCOTCO details are given then create a ucas tariff record
2671: IF c_interface_rec.scsn IS NOT NULL THEN
2672: l_rowid := NULL ;
2673: l_hesa_st_spau_id := NULL ;
2674: igs_he_st_spa_ut_all_pkg.insert_row (
2675: X_ROWID => l_rowid ,
2676: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2677: X_ORG_ID => l_org_id,
2678: X_PERSON_ID => c_spa_rec.person_id ,

Line 2692: igs_he_st_spa_ut_all_pkg.insert_row (

2688: -- If qualification ADVEXT details are given then create a ucas tariff record
2689: IF c_interface_rec.aean IS NOT NULL OR c_interface_rec.aeats IS NOT NULL THEN
2690: l_rowid := NULL ;
2691: l_hesa_st_spau_id := NULL ;
2692: igs_he_st_spa_ut_all_pkg.insert_row (
2693: X_ROWID => l_rowid ,
2694: X_HESA_ST_SPAU_ID => l_hesa_st_spau_id ,
2695: X_ORG_ID => l_org_id ,
2696: X_PERSON_ID => c_spa_rec.person_id ,