APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_HE_AD_DTL_ALL

Line 2311: FROM igs_he_ad_dtl_all

2307: WHERE person_id = p_per_id;
2308:
2309: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS
2310: SELECT COUNT(*)
2311: FROM igs_he_ad_dtl_all
2312: WHERE person_id = p_per_id;
2313:
2314: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS
2315: SELECT had.ROWID ,had.*

Line 2316: FROM igs_he_ad_dtl_all had

2312: WHERE person_id = p_per_id;
2313:
2314: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS
2315: SELECT had.ROWID ,had.*
2316: FROM igs_he_ad_dtl_all had
2317: WHERE person_id = l_per_id;
2318:
2319: -- UCAS Association mapping
2320: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,

Line 2327: l_dom_cd igs_he_ad_dtl_all.domicile_cd%TYPE;

2323: FROM IGS_HE_CODE_MAP_VAL
2324: WHERE association_code = cp_assoc
2325: AND map1 = cp_map1;
2326:
2327: l_dom_cd igs_he_ad_dtl_all.domicile_cd%TYPE;
2328: l_count NUMBER;
2329: l_rowid VARCHAR2(250);
2330:
2331: BEGIN

Line 2482: /**** Import domicile code into igs_he_ad_dtl_all table ******/

2478: END IF ;
2479: CLOSE c_appl_int ;
2480:
2481: -----------------------------------------------------------------------------------------------------------------
2482: /**** Import domicile code into igs_he_ad_dtl_all table ******/
2483: -----------------------------------------------------------------------------------------------------------------
2484: --If sent to oss succesfull we can create igs_he_ad_dtl record to import domicile code
2485: IF l_export_to_oss_status = 'AC' THEN
2486:

Line 2512: igs_he_ad_dtl_all_pkg.insert_row(

2508:
2509: FOR lv_ad_appl_inst IN cur_ad_appl_inst(l_app_dtls.oss_person_id) LOOP
2510:
2511: l_rowid := NULL ;
2512: igs_he_ad_dtl_all_pkg.insert_row(
2513: x_rowid => l_rowid,
2514: x_org_id => NULL,
2515: x_hesa_ad_dtl_id => l_count,
2516: x_person_id => l_app_dtls.oss_person_id,

Line 2531: igs_he_ad_dtl_all_pkg.update_row (

2527:
2528: ELSE
2529:
2530: FOR had_rec IN get_had_details(l_app_dtls.oss_person_id) LOOP
2531: igs_he_ad_dtl_all_pkg.update_row (
2532: x_mode => 'R',
2533: x_rowid => had_rec.ROWID,
2534: x_org_id => had_rec.org_id,
2535: x_hesa_ad_dtl_id => had_rec.hesa_ad_dtl_id,