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_012 dependencies on IGS_AD_CONTACTS_INT

Line 41: || igs_ad_contacts_int.interface_contacts_id it is changed to

37: || 'PHONE'.
38: || * The contact point type check and phone line type check in
39: || create and update contact point proc is removed.
40: || * Cursor C1 fetches records based on contact point ID =
41: || igs_ad_contacts_int.interface_contacts_id it is changed to
42: || contact point ID = l_contact_point_id from hz_contact_points.
43: || ssawhney 15 nov Bug no.2103692:Person Interface DLD
44: || prc_pe_citizenship code is removed from here and added to
45: || IGS_AD_IMP_007.

Line 106: FROM igs_ad_contacts_int_all ai, igs_ad_interface_all i

102: ai.program_update_date,
103: i.interface_id i_interface_id,
104: i.person_id i_person_id,
105: i.match_ind i_match_ind
106: FROM igs_ad_contacts_int_all ai, igs_ad_interface_all i
107: WHERE ai.interface_run_id = cp_interface_run_id
108: AND i.interface_id = ai.interface_id
109: AND i.interface_run_id = cp_interface_run_id
110: AND ai.status = '2';

Line 118: l_contact_point_id igs_ad_contacts_int.dup_contact_point_id%TYPE;

114: l_error_code VARCHAR2(25);
115: l_status VARCHAR2(25);
116: l_dup_var BOOLEAN;
117: l_check VARCHAR2(10);
118: l_contact_point_id igs_ad_contacts_int.dup_contact_point_id%TYPE;
119: rec_pc c_pc%ROWTYPE;
120: l_processed_records NUMBER(5) := 0 ;
121: -- local variable to store the value of global variable igs_ad_imp_001.g_interface_run_id
122: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

Line 228: UPDATE igs_ad_contacts_int_all

224: IF l_enable_log = 'Y' THEN
225: igs_ad_imp_001.logerrormessage(rec_pc.interface_contacts_id,'E322');
226: END IF;
227:
228: UPDATE igs_ad_contacts_int_all
229: SET error_code='E322',status='3'
230: WHERE interface_contacts_id=rec_pc.interface_contacts_id;
231:
232: ELSE

Line 235: UPDATE igs_ad_contacts_int_all

231:
232: ELSE
233:
234: l_status := '1';
235: UPDATE igs_ad_contacts_int_all
236: SET status='1'
237: WHERE interface_contacts_id=rec_pc.interface_contacts_id;
238:
239: END IF;

Line 270: UPDATE igs_ad_contacts_int_all

266: IF l_enable_log = 'Y' THEN
267: igs_ad_imp_001.logerrormessage(rec_pc.interface_contacts_id,'E322');
268: END IF;
269:
270: UPDATE igs_ad_contacts_int_all
271: SET error_code='E322',status='3'
272: WHERE interface_contacts_id=rec_pc.interface_contacts_id;
273:
274: END crt_prsn_contacts;

Line 313: UPDATE igs_ad_contacts_int_all

309: IF l_enable_log = 'Y' THEN
310: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E246');
311: END IF;
312:
313: UPDATE igs_ad_contacts_int_all
314: SET status = cst_stat_val_3,
315: error_code = cst_err_val_246,
316: match_ind = cst_mi_val_18
317: WHERE interface_contacts_id = c_pc_rec.interface_contacts_id;

Line 329: UPDATE igs_ad_contacts_int_all

325: IF l_enable_log = 'Y' THEN
326: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E450');
327: END IF;
328:
329: UPDATE igs_ad_contacts_int_all
330: SET error_code = 'E450',
331: status = '3'
332: WHERE interface_contacts_id = c_pc_rec.interface_contacts_id;
333: l_Check := 'TRUE';

Line 346: UPDATE igs_ad_contacts_int_all

342: IF l_enable_log = 'Y' THEN
343: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E250');
344: END IF;
345:
346: UPDATE igs_ad_contacts_int_all
347: SET error_code = 'E250',
348: status = '3'
349: WHERE interface_contacts_id = c_pc_rec.interface_contacts_id;
350: l_Check := 'TRUE';

Line 363: UPDATE igs_ad_contacts_int_all

359: IF l_enable_log = 'Y' THEN
360: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E247');
361: END IF;
362:
363: UPDATE igs_ad_contacts_int_all
364: SET status = '3',
365: error_code = 'E247'
366: WHERE interface_contacts_id = c_pc_rec.interface_contacts_id;
367: l_Check := 'TRUE';

Line 382: UPDATE igs_ad_contacts_int_all

378: IF l_enable_log = 'Y' THEN
379: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E173');
380: END IF;
381:
382: UPDATE igs_ad_contacts_int_all
383: SET status = '3',
384: error_code = 'E173'
385: WHERE interface_contacts_id = c_pc_rec.interface_contacts_id;
386: CLOSE c_ph_cntry_cd;

Line 403: UPDATE igs_ad_contacts_int_all

399: IF l_enable_log = 'Y' THEN
400: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E251');
401: END IF;
402:
403: UPDATE igs_ad_contacts_int_all
404: SET error_code = 'E251',
405: status = '3'
406: WHERE interface_contacts_id = c_pc_rec.interface_contacts_id;
407: l_Check := 'TRUE';

Line 419: UPDATE igs_ad_contacts_int_all

415: IF l_enable_log = 'Y' THEN
416: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E248');
417: END IF;
418:
419: UPDATE igs_ad_contacts_int_all
420: SET error_code = 'E248',
421: status = '3'
422: WHERE interface_contacts_id = c_pc_rec.interface_contacts_id;
423: l_Check := 'TRUE';

Line 459: UPDATE igs_ad_contacts_int_all

455: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_CONTACTS');
456:
457: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid
458: IF l_rule IN ('E','I') THEN
459: UPDATE igs_ad_contacts_int_all
460: SET status = cst_stat_val_3,
461: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
462: WHERE match_ind IS NOT NULL
463: AND interface_run_id = l_interface_run_id

Line 469: UPDATE igs_ad_contacts_int_all ai

465: END IF;
466:
467: --2. If rule is E and duplicate exists, update match_ind to 19 and status to 1
468: IF l_rule = 'E' THEN
469: UPDATE igs_ad_contacts_int_all ai
470: SET status = cst_stat_val_1,
471: match_ind = cst_mi_val_19
472: WHERE ai.interface_run_id = l_interface_run_id
473: AND ai.status = cst_stat_val_2

Line 495: UPDATE igs_ad_contacts_int_all

491:
492: -- 3.If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
493: -- processed in prior runs and didn't get updated .. update to status 1
494: IF l_rule = 'R' THEN
495: UPDATE igs_ad_contacts_int_all
496: SET status = cst_stat_val_1
497: WHERE interface_run_id = l_interface_run_id
498: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
499: AND status=cst_stat_val_2;

Line 504: UPDATE igs_ad_contacts_int_all

500: END IF;
501:
502: -- 4.If rule is R and match_ind is neither 21 nor 25 then error
503: IF l_rule = 'R' THEN
504: UPDATE igs_ad_contacts_int_all
505: SET status = cst_stat_val_3,
506: ERROR_CODE = cst_err_val_695
507: WHERE interface_run_id = l_interface_run_id
508: AND (match_ind IS NOT NULL AND match_ind NOT IN (cst_mi_val_21,cst_mi_val_25))

Line 514: UPDATE igs_ad_contacts_int_all ai

510: END IF;
511:
512: -- 5.If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
513: IF l_rule = 'R' THEN
514: UPDATE igs_ad_contacts_int_all ai
515: SET status = cst_stat_val_1,
516: match_ind = cst_mi_val_23
517: WHERE ai.interface_run_id = l_interface_run_id
518: AND ai.match_ind IS NULL

Line 544: UPDATE igs_ad_contacts_int_all ai

540: END IF;
541:
542: -- 6.If rule in R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
543: IF l_rule = 'R' THEN
544: UPDATE igs_ad_contacts_int_all ai
545: SET status = cst_stat_val_3,
546: match_ind = cst_mi_val_20,
547: dup_contact_point_id = (SELECT contact_point_id
548: FROM hz_contact_points pe, igs_ad_interface_all i

Line 718: UPDATE igs_ad_contacts_int_all

714: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
715: END IF;
716:
717:
718: UPDATE igs_ad_contacts_int_all
719: SET ERROR_CODE = 'E014',
720: status='3'
721: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
722: ELSE

Line 724: UPDATE igs_ad_contacts_int_all

720: status='3'
721: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
722: ELSE
723: l_status := '1';
724: UPDATE igs_ad_contacts_int_all
725: SET status=cst_stat_val_1,
726: match_ind =cst_mi_val_18
727: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
728: END IF; -- if l_return_status

Line 757: UPDATE igs_ad_contacts_int_all

753: IF l_enable_log = 'Y' THEN
754: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
755: END IF;
756:
757: UPDATE igs_ad_contacts_int_all
758: SET match_ind = cst_mi_val_18,
759: status = cst_stat_val_3
760: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
761: END; -- begin

Line 853: UPDATE igs_ad_contacts_int_all

849: IF l_enable_log = 'Y' THEN
850: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
851: END IF;
852:
853: UPDATE igs_ad_contacts_int_all
854: SET error_code = 'E014',
855: status='3'
856: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
857: ELSE

Line 858: UPDATE igs_ad_contacts_int_all

854: SET error_code = 'E014',
855: status='3'
856: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
857: ELSE
858: UPDATE igs_ad_contacts_int_all
859: SET status = cst_stat_val_1,
860: match_ind = cst_mi_val_18
861: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
862: END IF;

Line 890: UPDATE igs_ad_contacts_int_all

886: IF l_enable_log = 'Y' THEN
887: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
888: END IF;
889:
890: UPDATE igs_ad_contacts_int_all
891: SET status = '3'
892: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
893: END; -- begin
894: END IF; -- if match_ind

Line 926: UPDATE igs_ad_contacts_int_all

922: IF l_enable_log = 'Y' THEN
923: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E518');
924: END IF;
925:
926: UPDATE igs_ad_contacts_int_all
927: SET status = '3',error_code='E518'
928: WHERE interface_contacts_id = rec_pc1.interface_contacts_id;
929: END;
930: END IF; -- if chk_dup_contact