[Home] [Help]
2356: SELECT 'X' a
2357: FROM Igs_Ad_Relacad_Int_all a
2358: WHERE Interface_Relacad_Id = cp_Interface_Relacad_Id
2359: AND NVL(p_start_date,p_end_date) IS NOT NULL
2360: AND EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2
2361: WHERE h1.party_id = P_Rel_Person_ID
2362: AND h2.party_number = p_institution_code
2363: AND h2.party_id = h1.school_party_id
2364: AND h1.start_date_attended IS NULL
2363: AND h2.party_id = h1.school_party_id
2364: AND h1.start_date_attended IS NULL
2365: AND h1.last_date_attended IS NULL
2366: )
2367: AND NOT EXISTS ( SELECT 1 FROM hz_Education h1, hz_parties h2
2368: WHERE h1.party_id = p_rel_person_id
2369: AND h2.party_number = p_institution_code
2370: AND h2.party_id = h1.school_party_id
2371: AND NVL(h1.start_date_attended,
2380: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2381: ) IS
2382:
2383: SELECT 1 a
2384: FROM hz_Education h1, hz_parties h2
2385: WHERE h1.party_id = P_Rel_Person_ID
2386: AND h2.party_number = p_institution_code
2387: AND h2.party_id = h1.school_party_id
2388: AND NVL(h1.start_date_attended,
2408: l_Academic_His_Rec Academic_His_C%ROWTYPE;
2409:
2410: l_row_id IGS_AD_ACAD_HISTORY_V.ROW_ID%TYPE;--VARCHAR2(30);
2411: l_education_id NUMBER;
2412: l_object_version_number HZ_EDUCATION.OBJECT_VERSION_NUMBER%TYPE;
2413: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2414: l_msg_count NUMBER;
2415: l_msg_data VARCHAR2(2000);
2416: l_peron_interest_id NUMBER;
2437:
2438: l_Institution_Rec Institution_C%ROWTYPE;
2439:
2440: -- Validate the DEGREE_CODE
2441: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS
2442: SELECT dg.degree_cd
2443: FROM igs_ps_degrees dg,
2444: igs_ps_type_all ps
2445: WHERE dg.degree_cd = p_degree