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_AD_IMP_008 dependencies on IGS_AD_RELACAD_INT

Line 2327: --1. Pick up all the records from the table IGS_AD_RELACAD_INT WHERE STATUS = '2' AND INTERFACE_RELATIONS_ID = P_INTERFACE_RELATIONS_ID

2323: l_enable_log VARCHAR2(1);
2324: l_request_id NUMBER;
2325: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
2326:
2327: --1. Pick up all the records from the table IGS_AD_RELACAD_INT WHERE STATUS = '2' AND INTERFACE_RELATIONS_ID = P_INTERFACE_RELATIONS_ID
2328: CURSOR Relacad_Rec_C(cp_interface_relations_id NUMBER) IS
2329: SELECT *
2330: FROM Igs_Ad_Relacad_Int_all
2331: WHERE Status = '2'

Line 2330: FROM Igs_Ad_Relacad_Int_all

2326:
2327: --1. Pick up all the records from the table IGS_AD_RELACAD_INT WHERE STATUS = '2' AND INTERFACE_RELATIONS_ID = P_INTERFACE_RELATIONS_ID
2328: CURSOR Relacad_Rec_C(cp_interface_relations_id NUMBER) IS
2329: SELECT *
2330: FROM Igs_Ad_Relacad_Int_all
2331: WHERE Status = '2'
2332: AND Interface_Relations_Id = cP_Interface_Relations_Id;
2333:
2334: -- Check to see if an academic history record already exists for this person

Line 2336: CURSOR Academic_His_C(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,

2332: AND Interface_Relations_Id = cP_Interface_Relations_Id;
2333:
2334: -- Check to see if an academic history record already exists for this person
2335: -- Duplicate check changed to ( person_id, institution_code , start_Date, end_date ) Import Process enahancements
2336: CURSOR Academic_His_C(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2337: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2338: P_Rel_Person_ID NUMBER,
2339: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2340: ) IS

Line 2337: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,

2333:
2334: -- Check to see if an academic history record already exists for this person
2335: -- Duplicate check changed to ( person_id, institution_code , start_Date, end_date ) Import Process enahancements
2336: CURSOR Academic_His_C(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2337: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2338: P_Rel_Person_ID NUMBER,
2339: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2340: ) IS
2341: SELECT *

Line 2339: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE

2335: -- Duplicate check changed to ( person_id, institution_code , start_Date, end_date ) Import Process enahancements
2336: CURSOR Academic_His_C(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2337: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2338: P_Rel_Person_ID NUMBER,
2339: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2340: ) IS
2341: SELECT *
2342: FROM IGS_AD_ACAD_HISTORY_V a
2343: WHERE a.institution_code = P_Institution_Code

Line 2349: cp_Interface_Relacad_Id Igs_Ad_Relacad_Int_all.Interface_Relacad_Id%TYPE,

2345: AND ((TRUNC(a.end_Date) = TRUNC(p_end_date)) OR (a.end_date IS NULL AND p_end_date IS NULL))
2346: AND a.person_id = P_Rel_Person_ID;
2347: --Cursor to select the records that are for first record updates.
2348: CURSOR c_Academic_His_first(
2349: cp_Interface_Relacad_Id Igs_Ad_Relacad_Int_all.Interface_Relacad_Id%TYPE,
2350: P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2351: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2352: P_Rel_Person_ID NUMBER,
2353: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE

Line 2350: P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,

2346: AND a.person_id = P_Rel_Person_ID;
2347: --Cursor to select the records that are for first record updates.
2348: CURSOR c_Academic_His_first(
2349: cp_Interface_Relacad_Id Igs_Ad_Relacad_Int_all.Interface_Relacad_Id%TYPE,
2350: P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2351: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2352: P_Rel_Person_ID NUMBER,
2353: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2354: ) IS

Line 2351: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,

2347: --Cursor to select the records that are for first record updates.
2348: CURSOR c_Academic_His_first(
2349: cp_Interface_Relacad_Id Igs_Ad_Relacad_Int_all.Interface_Relacad_Id%TYPE,
2350: P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2351: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2352: P_Rel_Person_ID NUMBER,
2353: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2354: ) IS
2355:

Line 2353: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE

2349: cp_Interface_Relacad_Id Igs_Ad_Relacad_Int_all.Interface_Relacad_Id%TYPE,
2350: P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2351: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2352: P_Rel_Person_ID NUMBER,
2353: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2354: ) IS
2355:
2356: SELECT 'X' a
2357: FROM Igs_Ad_Relacad_Int_all a

Line 2357: FROM Igs_Ad_Relacad_Int_all a

2353: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2354: ) IS
2355:
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

Line 2377: CURSOR c_Academic_His_partial(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,

2373: );
2374: l_Academic_His_first_Rec c_Academic_His_first%ROWTYPE;
2375:
2376: -- This cursor will be opened only if it is not exact match OR this record is not a candidate for first record udpate.
2377: CURSOR c_Academic_His_partial(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2378: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2379: P_Rel_Person_ID NUMBER,
2380: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2381: ) IS

Line 2378: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,

2374: l_Academic_His_first_Rec c_Academic_His_first%ROWTYPE;
2375:
2376: -- This cursor will be opened only if it is not exact match OR this record is not a candidate for first record udpate.
2377: CURSOR c_Academic_His_partial(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2378: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2379: P_Rel_Person_ID NUMBER,
2380: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2381: ) IS
2382:

Line 2380: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE

2376: -- This cursor will be opened only if it is not exact match OR this record is not a candidate for first record udpate.
2377: CURSOR c_Academic_His_partial(P_Institution_Code Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2378: P_Start_Date Igs_Ad_Relacad_Int.Start_Date%TYPE,
2379: P_Rel_Person_ID NUMBER,
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

Line 2428: CURSOR Institution_C(cp_Institution_Cd Igs_Ad_Relacad_Int.Institution_Code%TYPE,

2424: --Start of local procedure Validate_Acad_Hist
2425: PROCEDURE Validate_Acad_Hist( Relacad_Rec Relacad_Rec_C%ROWTYPE ,l_check OUT NOCOPY VARCHAR2 ) AS
2426:
2427: -- Validate the INSTITUTION_CD.
2428: CURSOR Institution_C(cp_Institution_Cd Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2429: cp_inst_status Igs_Or_Inst_Stat.S_Institution_Status%TYPE) IS
2430: SELECT 1
2431: FROM igs_pe_hz_parties pzp, hz_parties hp, Igs_Or_Inst_Stat stat
2432: WHERE pzp.party_id = hp.party_id AND

Line 2475: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E396','IGS_AD_RELACAD_INT_ALL');

2471: OR Relacad_Rec.degree_earned IS NOT NULL
2472: OR Relacad_Rec.program_code IS NOT NULL) THEN
2473:
2474: IF l_enable_log = 'Y' THEN
2475: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E396','IGS_AD_RELACAD_INT_ALL');
2476: END IF;
2477:
2478: UPDATE Igs_Ad_Relacad_Int_all
2479: SET Error_Code = 'E396',

Line 2478: UPDATE Igs_Ad_Relacad_Int_all

2474: IF l_enable_log = 'Y' THEN
2475: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E396','IGS_AD_RELACAD_INT_ALL');
2476: END IF;
2477:
2478: UPDATE Igs_Ad_Relacad_Int_all
2479: SET Error_Code = 'E396',
2480: Status = l_Status
2481: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2482: l_check := 'TRUE';

Line 2493: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E401','IGS_AD_RELACAD_INT_ALL');

2489: FETCH Institution_C INTO l_Institution_Rec;
2490: IF (Institution_C%NOTFOUND) THEN
2491:
2492: IF l_enable_log = 'Y' THEN
2493: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E401','IGS_AD_RELACAD_INT_ALL');
2494: END IF;
2495:
2496: UPDATE Igs_Ad_Relacad_Int_all
2497: SET Error_Code = 'E401',

Line 2496: UPDATE Igs_Ad_Relacad_Int_all

2492: IF l_enable_log = 'Y' THEN
2493: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E401','IGS_AD_RELACAD_INT_ALL');
2494: END IF;
2495:
2496: UPDATE Igs_Ad_Relacad_Int_all
2497: SET Error_Code = 'E401',
2498: Status = l_Status
2499: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2500: CLOSE Institution_C;

Line 2513: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E402','IGS_AD_RELACAD_INT_ALL');

2509: FETCH c_degree_code INTO l_Course_Rec;
2510: IF (c_degree_code%NOTFOUND) THEN
2511:
2512: IF l_enable_log = 'Y' THEN
2513: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E402','IGS_AD_RELACAD_INT_ALL');
2514: END IF;
2515:
2516: UPDATE Igs_Ad_Relacad_Int_all
2517: SET Error_Code = 'E402',

Line 2516: UPDATE Igs_Ad_Relacad_Int_all

2512: IF l_enable_log = 'Y' THEN
2513: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E402','IGS_AD_RELACAD_INT_ALL');
2514: END IF;
2515:
2516: UPDATE Igs_Ad_Relacad_Int_all
2517: SET Error_Code = 'E402',
2518: Status = l_Status
2519: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2520: CLOSE c_degree_code;

Line 2535: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E403','IGS_AD_RELACAD_INT_ALL');

2531: FETCH c_degree_code INTO l_Course_Rec;
2532: IF (c_degree_code%NOTFOUND) THEN
2533:
2534: IF l_enable_log = 'Y' THEN
2535: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E403','IGS_AD_RELACAD_INT_ALL');
2536: END IF;
2537:
2538: UPDATE Igs_Ad_Relacad_Int_all
2539: SET Error_Code = 'E403',

Line 2538: UPDATE Igs_Ad_Relacad_Int_all

2534: IF l_enable_log = 'Y' THEN
2535: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E403','IGS_AD_RELACAD_INT_ALL');
2536: END IF;
2537:
2538: UPDATE Igs_Ad_Relacad_Int_all
2539: SET Error_Code = 'E403',
2540: Status = l_Status
2541: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2542: CLOSE c_degree_code;

Line 2553: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E453','IGS_AD_RELACAD_INT_ALL');

2549:
2550: IF RELACAD_REC.CURRENT_INST NOT IN('Y','N') THEN
2551:
2552: IF l_enable_log = 'Y' THEN
2553: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E453','IGS_AD_RELACAD_INT_ALL');
2554: END IF;
2555:
2556: UPDATE Igs_Ad_Relacad_Int_all
2557: SET Error_Code = 'E453',

Line 2556: UPDATE Igs_Ad_Relacad_Int_all

2552: IF l_enable_log = 'Y' THEN
2553: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E453','IGS_AD_RELACAD_INT_ALL');
2554: END IF;
2555:
2556: UPDATE Igs_Ad_Relacad_Int_all
2557: SET Error_Code = 'E453',
2558: Status = l_Status
2559: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2560: l_check := 'TRUE';

Line 2568: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E448','IGS_AD_RELACAD_INT_ALL');

2564: -- IF RELACAD_REC.CURRENT_INST = 'Y' THEN THE END DATE MUST BE NULL.
2565: IF RELACAD_REC.CURRENT_INST = 'Y' AND RELACAD_REC.END_DATE IS NOT NULL THEN
2566:
2567: IF l_enable_log = 'Y' THEN
2568: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E448','IGS_AD_RELACAD_INT_ALL');
2569: END IF;
2570:
2571:
2572: UPDATE Igs_Ad_Relacad_Int_all

Line 2572: UPDATE Igs_Ad_Relacad_Int_all

2568: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E448','IGS_AD_RELACAD_INT_ALL');
2569: END IF;
2570:
2571:
2572: UPDATE Igs_Ad_Relacad_Int_all
2573: SET Error_Code = 'E448',
2574: Status = l_Status
2575: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2576: l_check := 'TRUE';

Line 2583: UPDATE Igs_Ad_Relacad_Int_all

2579:
2580: --6. START_DATE
2581: IF RELACAD_REC.START_DATE IS NOT NULL THEN
2582: IF NOT RELACAD_REC.START_DATE < SYSDATE THEN
2583: UPDATE Igs_Ad_Relacad_Int_all
2584: SET Error_Code = 'E405',
2585: Status = l_Status
2586: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2587: l_check := 'TRUE';

Line 2596: UPDATE Igs_Ad_Relacad_Int_all

2592: --7. END_DATE
2593: IF RELACAD_REC.END_DATE IS NOT NULL
2594: AND RELACAD_REC.START_DATE IS NOT NULL THEN
2595: IF NOT RELACAD_REC.END_DATE >= RELACAD_REC.START_DATE THEN
2596: UPDATE Igs_Ad_Relacad_Int_all
2597: SET Error_Code = 'E406',
2598: Status = l_Status
2599: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2600: l_check := 'TRUE';

Line 2605: UPDATE Igs_Ad_Relacad_Int_all

2601: RETURN;
2602: END IF;
2603: ELSIF RELACAD_REC.END_DATE IS NOT NULL
2604: AND RELACAD_REC.START_DATE IS NULL THEN
2605: UPDATE Igs_Ad_Relacad_Int_all
2606: SET Error_Code = 'E407',
2607: Status = l_Status
2608: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2609: l_check := 'TRUE';

Line 2617: UPDATE Igs_Ad_Relacad_Int_all

2613:
2614: --8. PLANNED_COMPLETION_DATE
2615: IF RELACAD_REC.PLAN_COMPLETION_DATE IS NOT NULL AND RELACAD_REC.START_DATE IS NOT NULL THEN
2616: IF NOT RELACAD_REC.PLAN_COMPLETION_DATE >= RELACAD_REC.START_DATE THEN
2617: UPDATE Igs_Ad_Relacad_Int_all
2618: SET Error_Code = 'E408',
2619: Status = l_Status
2620: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2621: l_check := 'TRUE';

Line 2633: UPDATE Igs_Ad_Relacad_Int_all

2629: CLOSE birth_date_cur;
2630:
2631: IF birth_date_rec.birth_date IS NOT NULL AND relacad_rec.start_date IS NOT NULL THEN
2632: IF relacad_rec.start_date < birth_date_rec.birth_date THEN
2633: UPDATE Igs_Ad_Relacad_Int_all
2634: SET Error_Code = 'E222',
2635: Status = l_Status
2636: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2637: l_check := 'TRUE';

Line 2675: UPDATE Igs_Ad_Relacad_Int_all

2671: l_rule := Igs_Ad_Imp_001.Find_Source_Cat_Rule(p_source_type_id,'RELATIONS_ACAD_HISTORY');
2672:
2673: --1 If rule is E or I, then if the match_ind is not null, the combination is invalid
2674: IF l_rule IN ('E','I') THEN
2675: UPDATE Igs_Ad_Relacad_Int_all
2676: SET status = '3',
2677: ERROR_CODE = 'E695' -- Error code depicting incorrect combination
2678: WHERE match_ind IS NOT NULL
2679: AND status = '2'

Line 2685: UPDATE Igs_Ad_Relacad_Int_all mi

2681: END IF;
2682:
2683: --2 If rule is E and duplicate exists, update match_ind to 19 and status to 1
2684: IF l_rule = 'E' THEN
2685: UPDATE Igs_Ad_Relacad_Int_all mi
2686: SET status = '1',
2687: match_ind = '19'
2688: WHERE mi.Interface_Relations_Id = P_Interface_Relations_Id
2689: AND mi.status = '2'

Line 2701: UPDATE Igs_Ad_Relacad_Int_all

2697:
2698: --3 If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
2699: -- processed in prior runs and didn't get updated .. update to status 1
2700: IF l_rule = 'R' THEN
2701: UPDATE Igs_Ad_Relacad_Int_all
2702: SET status = '1'
2703: WHERE Interface_Relations_Id = P_Interface_Relations_Id
2704: AND match_ind IN ('18','19','22','23')
2705: AND status = '2';

Line 2710: UPDATE Igs_Ad_Relacad_Int_all

2706: END IF;
2707:
2708: --4 If rule is R and match_ind is neither 21 nor 25 then error
2709: IF l_rule = 'R' THEN
2710: UPDATE Igs_Ad_Relacad_Int_all
2711: SET status = '3',
2712: ERROR_CODE = 'E695'
2713: WHERE Interface_Relations_Id = P_Interface_Relations_Id
2714: AND status = '2'

Line 2720: UPDATE Igs_Ad_Relacad_Int_all mi

2716: END IF;
2717:
2718: --5 If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
2719: IF l_rule = 'R' THEN
2720: UPDATE Igs_Ad_Relacad_Int_all mi
2721: SET status = '1',
2722: match_ind = '23'
2723: WHERE mi.Interface_Relations_Id = P_Interface_Relations_Id
2724: AND mi.match_ind IS NULL

Line 2742: UPDATE Igs_Ad_Relacad_Int_all mi

2738: END IF;
2739:
2740: --6 If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
2741: IF l_rule = 'R' THEN
2742: UPDATE Igs_Ad_Relacad_Int_all mi
2743: SET status = '3',
2744: match_ind = '20'
2745: WHERE mi.Interface_Relations_Id = P_Interface_Relations_Id
2746: AND mi.match_ind IS NULL

Line 2756: --1. Pick up all the records from the table IGS_AD_RELACAD_INT

2752: AND ((TRUNC(pe.end_Date) = TRUNC(mi.end_date)) OR (pe.end_date IS NULL AND mi.end_date IS NULL))
2753: AND pe.person_id = P_Rel_Person_ID);
2754: END IF;
2755:
2756: --1. Pick up all the records from the table IGS_AD_RELACAD_INT
2757: FOR Relacad_Rec IN Relacad_Rec_C(P_Interface_Relations_Id) LOOP
2758: Relacad_Rec.CURRENT_INST := UPPER(Relacad_Rec.CURRENT_INST);
2759: Relacad_Rec.start_date := TRUNC(Relacad_Rec.start_date);
2760: l_check:= 'FALSE';

Line 2856: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');

2852: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2853: END IF;
2854:
2855: IF l_enable_log = 'Y' THEN
2856: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');
2857: END IF;
2858:
2859: UPDATE Igs_Ad_Relacad_Int_all
2860: SET Error_Code = 'E014',

Line 2859: UPDATE Igs_Ad_Relacad_Int_all

2855: IF l_enable_log = 'Y' THEN
2856: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');
2857: END IF;
2858:
2859: UPDATE Igs_Ad_Relacad_Int_all
2860: SET Error_Code = 'E014',
2861: Status = '3'
2862: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2863: ELSE

Line 2864: UPDATE Igs_Ad_Relacad_Int_all

2860: SET Error_Code = 'E014',
2861: Status = '3'
2862: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2863: ELSE
2864: UPDATE Igs_Ad_Relacad_Int_all
2865: SET Error_Code = NULL,
2866: Status = '1', Match_Ind = '18'
2867: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2868: END IF;

Line 2959: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');

2955: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2956: END IF;
2957:
2958: IF l_enable_log = 'Y' THEN
2959: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');
2960: END IF;
2961:
2962: UPDATE Igs_Ad_Relacad_Int_all
2963: SET Error_Code = 'E014',

Line 2962: UPDATE Igs_Ad_Relacad_Int_all

2958: IF l_enable_log = 'Y' THEN
2959: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');
2960: END IF;
2961:
2962: UPDATE Igs_Ad_Relacad_Int_all
2963: SET Error_Code = 'E014',
2964: Status = '3'
2965: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2966: ELSE

Line 2967: UPDATE Igs_Ad_Relacad_Int_all

2963: SET Error_Code = 'E014',
2964: Status = '3'
2965: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
2966: ELSE
2967: UPDATE Igs_Ad_Relacad_Int_all
2968: SET Error_Code = NULL,
2969: Status = '1',
2970: match_ind = '18'
2971: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;

Line 3073: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');

3069: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3070: END IF;
3071:
3072: IF l_enable_log = 'Y' THEN
3073: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');
3074: END IF;
3075:
3076: UPDATE Igs_Ad_Relacad_Int_all
3077: SET Error_Code = 'E014',

Line 3076: UPDATE Igs_Ad_Relacad_Int_all

3072: IF l_enable_log = 'Y' THEN
3073: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E014','IGS_AD_RELACAD_INT_ALL');
3074: END IF;
3075:
3076: UPDATE Igs_Ad_Relacad_Int_all
3077: SET Error_Code = 'E014',
3078: Status = '3'
3079: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3080: ELSE

Line 3081: UPDATE Igs_Ad_Relacad_Int_all

3077: SET Error_Code = 'E014',
3078: Status = '3'
3079: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3080: ELSE
3081: UPDATE Igs_Ad_Relacad_Int_all
3082: SET Error_Code = NULL,
3083: Status = '1',
3084: match_ind = '18'
3085: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;

Line 3099: UPDATE Igs_Ad_Relacad_Int_all

3095: FROM IGS_AD_ACAD_HISTORY_V acad
3096: WHERE acad.person_id = p_rel_person_id
3097: AND acad.institution_code = RELACAD_REC.INSTITUTION_CODE;
3098: IF l_count >1 THEN
3099: UPDATE Igs_Ad_Relacad_Int_all
3100: SET Status = '3', match_ind = '14'
3101: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3102: ELSE
3103: UPDATE Igs_Ad_Relacad_Int_all

Line 3103: UPDATE Igs_Ad_Relacad_Int_all

3099: UPDATE Igs_Ad_Relacad_Int_all
3100: SET Status = '3', match_ind = '14'
3101: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3102: ELSE
3103: UPDATE Igs_Ad_Relacad_Int_all
3104: SET Status = '3', match_ind = '13'
3105: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3106: END IF;
3107:

Line 3192: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E322','IGS_AD_RELACAD_INT_ALL');

3188: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3189: END IF;
3190:
3191: IF l_enable_log = 'Y' THEN
3192: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E322','IGS_AD_RELACAD_INT_ALL');
3193: END IF;
3194:
3195: UPDATE Igs_Ad_Relacad_Int_all
3196: SET Error_Code = 'E322',

Line 3195: UPDATE Igs_Ad_Relacad_Int_all

3191: IF l_enable_log = 'Y' THEN
3192: igs_ad_imp_001.logerrormessage(relacad_rec.interface_relacad_id,'E322','IGS_AD_RELACAD_INT_ALL');
3193: END IF;
3194:
3195: UPDATE Igs_Ad_Relacad_Int_all
3196: SET Error_Code = 'E322',
3197: Status = '3'
3198: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3199: ELSE

Line 3200: UPDATE Igs_Ad_Relacad_Int_all

3196: SET Error_Code = 'E322',
3197: Status = '3'
3198: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3199: ELSE
3200: UPDATE Igs_Ad_Relacad_Int_all
3201: SET Error_Code = NULL,
3202: Status = '1'
3203: WHERE Interface_Relacad_Id = Relacad_Rec.Interface_Relacad_Id;
3204: END IF;