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_009 dependencies on IGS_PE_IDENTIFY_DUPS

Line 20: || pkpatel 30-MAY-2002 Bug 2377580, parameters were missing in the call to Igs_Pe_Identify_Dups.form_dup_whereclause

16: || As a part of BUG 2599109, SEVIS Build
17: ||
18: || ssawhney 21-may-2002 Bug 2381539, %imp_p% procedures, incorrect ref to variable x_lvcExactSelectClause in case of partial match
19: || because of which it was not going into match at all.
20: || pkpatel 30-MAY-2002 Bug 2377580, parameters were missing in the call to Igs_Pe_Identify_Dups.form_dup_whereclause
21: || npalanis 5-Jun-2002 Bug 2397849 , The function for match indicator 15 ,16 and 17 are handled.
22: || pkpatel 10-OCT-2002 Bug No: 2603065
23: || Increased the size of variable x_lvcExactSelectClause and x_lvcPartialSelectClause from 500 to 2000
24: || ssawhney 22-oct-2002 SWS104, Bug 2630860. Introduced validations from making STATISTICS not mandatory.

Line 131: Igs_Pe_Identify_Dups.form_dup_whereclause(

127:
128: -- First call the form_dup_whereclause with Exact match
129: -- for that pass x_match_category as 'E'
130:
131: Igs_Pe_Identify_Dups.form_dup_whereclause(
132: x_errbuf => l_errbuf,
133: x_retcode => l_retcode,
134: x_match_set_id =>p_d_match_set_id,
135: x_match_category =>'E',

Line 223: Igs_Pe_Identify_Dups.form_dup_whereclause(

219: -- form_dup_where cluase is 'PARTIAL_MATCH' then the control come here
220: IF x_match_cnt = 0 THEN
221:
222: /* If Exact Match is not found then go for Partial Match . pass the match_category as 'P'*/
223: Igs_Pe_Identify_Dups.form_dup_whereclause(
224: x_errbuf => l_errbuf,
225: x_retcode => l_retcode,
226: x_match_set_id =>p_d_match_set_id,
227: x_match_category =>'P',

Line 392: IF ((Igs_Pe_Identify_Dups.g_person_id_type_din = 'N') AND

388: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
389: END IF;
390:
391: FOR imp_person_rec IN imp_person_cur(p_d_interface_id,p_c_person_id_type) LOOP
392: IF ((Igs_Pe_Identify_Dups.g_person_id_type_din = 'N') AND
393: ((imp_person_rec.ALTERNATE_ID IS NULL) OR (imp_person_rec.PERSON_ID_TYPE IS NULL))) THEN
394: i:= 0;
395: ELSE
396: i := i+1;

Line 397: Igs_Pe_Identify_Dups.form_dup_whereclause(

393: ((imp_person_rec.ALTERNATE_ID IS NULL) OR (imp_person_rec.PERSON_ID_TYPE IS NULL))) THEN
394: i:= 0;
395: ELSE
396: i := i+1;
397: Igs_Pe_Identify_Dups.form_dup_whereclause(
398: x_errbuf => l_errbuf,
399: x_retcode => l_retcode,
400: x_match_set_id =>p_d_match_set_id,
401: x_match_category =>'E',

Line 483: Igs_Pe_Identify_Dups.form_dup_whereclause(

479: END IF;
480:
481: IF x_match_cnt = 0 THEN
482: /* If Exact Match is not found then go for Partial Match */
483: Igs_Pe_Identify_Dups.form_dup_whereclause(
484: x_errbuf => l_errbuf,
485: x_retcode => l_retcode,
486: x_match_set_id =>p_d_match_set_id,
487: x_match_category =>'P',

Line 612: || The parameter ethnic_origin was passed in the call to the procedure Igs_Pe_Identify_Dups.form_dup_whereclause

608: || pkpatel 14-MAY-2002 Bug No: 2373468
609: || Removed the CLOSE imp_person_cur inside the FOR LOOP.
610: || ssawhney 21 may Bug 2381539, incorrect variables usages with dup match check
611: || pkpatel 30-MAY-2002 Bug 2377580, The addr_type was added in the WHERE clause of CURSOR imp_person_cur
612: || The parameter ethnic_origin was passed in the call to the procedure Igs_Pe_Identify_Dups.form_dup_whereclause
613: || pkpatel 10-OCT-2002 Bug No: 2603065
614: || Increased the size of variable x_lvcExactSelectClause and x_lvcPartialSelectClause from 500 to 2000
615: || pkpatel 22-JUN-2001 Bug no.2702536
616: || Added the parameters p_match_ind, p_person_id

Line 634: ( addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y');

630: SELECT *
631: FROM igs_ad_imp_matches_pa_v
632: WHERE interface_id = cp_d_interface_id
633: AND
634: ( addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y');
635:
636:
637: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,
638: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS

Line 689: IF (Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N') THEN

685: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
686: END IF;
687:
688:
689: IF (Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N') THEN
690: l_view_passed := 'IGS_PE_DUP_MATCHES_PA_V';
691: ELSE
692: l_view_passed := 'IGS_PE_DUP_MATCHES_PRIM_PA_V';
693: END IF;

Line 697: IF ((Igs_Pe_Identify_Dups.g_addr_type_din = 'N' AND Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')

693: END IF;
694:
695: FOR imp_person_rec IN imp_person_cur(p_d_interface_id,p_c_addr_type) LOOP
696:
697: IF ((Igs_Pe_Identify_Dups.g_addr_type_din = 'N' AND Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')
698: AND((imp_person_rec.COUNTRY IS NULL) OR (imp_person_rec.ADDR_TYPE IS NULL)))-- new code
699: THEN
700: i:= 0;
701: ELSE

Line 703: Igs_Pe_Identify_Dups.form_dup_whereclause(

699: THEN
700: i:= 0;
701: ELSE
702: i := i+1;
703: Igs_Pe_Identify_Dups.form_dup_whereclause(
704: x_errbuf => l_errbuf,
705: x_retcode => l_retcode,
706: x_match_set_id =>p_d_match_set_id,
707: x_match_category =>'E',

Line 749: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

745: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN
746: x_match_cnt := x_match_cnt+1;
747: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
748:
749: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
750: FOR temp_cur IN Party_Site_Cur(l_person_ID,p_c_addr_type) LOOP
751: lnParty_Site_ID := temp_cur.Party_Site_ID;
752: END LOOP;
753: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

Line 753: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

749: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
750: FOR temp_cur IN Party_Site_Cur(l_person_ID,p_c_addr_type) LOOP
751: lnParty_Site_ID := temp_cur.Party_Site_ID;
752: END LOOP;
753: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN
754: FOR temp_cur IN prim_Party_Site_Cur(l_person_ID) LOOP
755: lnParty_Site_ID := temp_cur.Party_Site_ID;
756: END LOOP;
757: END IF;

Line 812: Igs_Pe_Identify_Dups.form_dup_whereclause(

808: END IF;
809:
810: IF x_match_cnt = 0 THEN
811: /* If Exact Match is not found then go for Partial Match */
812: Igs_Pe_Identify_Dups.form_dup_whereclause(
813: x_errbuf => l_errbuf,
814: x_retcode => l_retcode,
815: x_match_set_id =>p_d_match_set_id,
816: x_match_category =>'P', -- bug Bug 2381539, it was being passed as E

Line 864: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

860:
861: dbms_sql.column_value(l_cursor_id1, 1, l_person_id);
862:
863: --Get Party_Site_ID From the Cursor
864: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
865: FOR temp_cur IN Party_Site_Cur(l_person_id,p_c_addr_type) LOOP
866: lnParty_Site_ID := temp_cur.Party_Site_ID;
867: END LOOP;
868: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

Line 868: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

864: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
865: FOR temp_cur IN Party_Site_Cur(l_person_id,p_c_addr_type) LOOP
866: lnParty_Site_ID := temp_cur.Party_Site_ID;
867: END LOOP;
868: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN
869: FOR temp_cur IN prim_Party_Site_Cur(l_person_id) LOOP
870: lnParty_Site_ID := temp_cur.Party_Site_ID;
871: END LOOP;
872: END IF;

Line 962: || to the procedure Igs_Pe_Identify_Dups.form_dup_whereclause

958: || Change History :
959: || Who When What
960: || (reverse chronological order - newest change first)
961: || pkpatel 30-MAY-2002 Bug 2377580, The parameters x_person_id_type,x_api_person_id were passed in the call
962: || to the procedure Igs_Pe_Identify_Dups.form_dup_whereclause
963: || pkpatel 10-OCT-2002 Bug No: 2603065
964: || Increased the size of variable x_lvcExactSelectClause and x_lvcPartialSelectClause from 500 to 2000
965: || pkpatel 22-JUN-2001 Bug no.2702536
966: || Added the parameters p_match_ind, p_person_id

Line 968: || gmaheswa 24-March-2006 Bug 4218763 Modified imp_person_cur to condsider Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' condition.

964: || Increased the size of variable x_lvcExactSelectClause and x_lvcPartialSelectClause from 500 to 2000
965: || pkpatel 22-JUN-2001 Bug no.2702536
966: || Added the parameters p_match_ind, p_person_id
967: || pkpatel 4-MAY-2003 Bug 3004858 (PKM Issue to use bind variable)
968: || gmaheswa 24-March-2006 Bug 4218763 Modified imp_person_cur to condsider Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' condition.
969: */
970:
971:
972: l_prog_label VARCHAR2(100);

Line 984: AND (addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y')

980: cp_c_person_id_type igs_ad_imp_matches_ppa_v.person_id_type%TYPE )IS
981: SELECT *
982: FROM igs_ad_imp_matches_ppa_v
983: WHERE interface_id = cp_d_interface_id
984: AND (addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y')
985: AND (person_id_type = cp_c_person_id_type OR person_id_type IS NULL);
986:
987:
988: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,

Line 1040: IF (Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')THEN

1036: l_debug_str, NULL,
1037: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1038: END IF;
1039:
1040: IF (Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')THEN
1041: l_view_passed := 'IGS_PE_DUP_MATCHES_PPA_V';
1042: ELSE
1043: l_view_passed := 'IGS_PE_DUP_MATCHES_PRIM_PPA_V';
1044: END IF;

Line 1048: IF ((Igs_Pe_Identify_Dups.g_addr_type_din = 'N' AND

1044: END IF;
1045:
1046: FOR imp_person_rec IN imp_person_cur(p_d_interface_id,p_c_addr_type,p_c_person_id_type) LOOP
1047:
1048: IF ((Igs_Pe_Identify_Dups.g_addr_type_din = 'N' AND
1049: Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')AND
1050: ((imp_person_rec.COUNTRY IS NULL) OR
1051: (imp_person_rec.ADDR_TYPE IS NULL))) OR
1052: ((Igs_Pe_Identify_Dups.g_person_id_type_din = 'N') AND

Line 1049: Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')AND

1045:
1046: FOR imp_person_rec IN imp_person_cur(p_d_interface_id,p_c_addr_type,p_c_person_id_type) LOOP
1047:
1048: IF ((Igs_Pe_Identify_Dups.g_addr_type_din = 'N' AND
1049: Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')AND
1050: ((imp_person_rec.COUNTRY IS NULL) OR
1051: (imp_person_rec.ADDR_TYPE IS NULL))) OR
1052: ((Igs_Pe_Identify_Dups.g_person_id_type_din = 'N') AND
1053: ((imp_person_rec.ALTERNATE_ID IS NULL)

Line 1052: ((Igs_Pe_Identify_Dups.g_person_id_type_din = 'N') AND

1048: IF ((Igs_Pe_Identify_Dups.g_addr_type_din = 'N' AND
1049: Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N')AND
1050: ((imp_person_rec.COUNTRY IS NULL) OR
1051: (imp_person_rec.ADDR_TYPE IS NULL))) OR
1052: ((Igs_Pe_Identify_Dups.g_person_id_type_din = 'N') AND
1053: ((imp_person_rec.ALTERNATE_ID IS NULL)
1054: OR (imp_person_rec.PERSON_ID_TYPE IS NULL)))
1055:
1056: THEN

Line 1061: Igs_Pe_Identify_Dups.form_dup_whereclause(

1057: i:= 0;
1058: ELSE
1059:
1060: i := i+1;
1061: Igs_Pe_Identify_Dups.form_dup_whereclause(
1062: x_errbuf => l_errbuf,
1063: x_retcode => l_retcode,
1064: x_match_set_id =>p_d_match_set_id,
1065: x_match_category =>'E',

Line 1112: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

1108:
1109: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1110:
1111: --Get Party_Site_ID From the Cursor based on primary address indicator
1112: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
1113: FOR temp_cur IN Party_Site_Cur(l_person_ID,p_c_addr_type) LOOP
1114: lnParty_Site_ID := temp_cur.Party_Site_ID;
1115: END LOOP;
1116: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

Line 1116: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

1112: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
1113: FOR temp_cur IN Party_Site_Cur(l_person_ID,p_c_addr_type) LOOP
1114: lnParty_Site_ID := temp_cur.Party_Site_ID;
1115: END LOOP;
1116: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN
1117: FOR temp_cur IN prim_Party_Site_Cur(l_person_ID) LOOP
1118: lnParty_Site_ID := temp_cur.Party_Site_ID;
1119: END LOOP;
1120: END IF;

Line 1175: Igs_Pe_Identify_Dups.form_dup_whereclause(

1171: IF x_match_cnt = 0 THEN
1172: /* If Exact Match is not found then go for Partial Match */
1173:
1174: -- Bug 2377580, the parameters x_person_id_type and x_api_person_id were added
1175: Igs_Pe_Identify_Dups.form_dup_whereclause(
1176: x_errbuf => l_errbuf,
1177: x_retcode => l_retcode,
1178: x_match_set_id =>p_d_match_set_id,
1179: x_match_category =>'P', -- bug Bug 2381539, this was being passed as E.

Line 1228: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

1224:
1225: dbms_sql.column_value(l_cursor_id1, 1, l_person_id);
1226:
1227: --Get Party_Site_ID From the Cursor Based on primary address indicator
1228: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
1229: FOR temp_cur IN Party_Site_Cur(l_person_ID,p_c_addr_type) LOOP
1230: lnParty_Site_ID := temp_cur.Party_Site_ID;
1231: END LOOP;
1232: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

Line 1232: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN

1228: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
1229: FOR temp_cur IN Party_Site_Cur(l_person_ID,p_c_addr_type) LOOP
1230: lnParty_Site_ID := temp_cur.Party_Site_ID;
1231: END LOOP;
1232: ELSIF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y' THEN
1233: FOR temp_cur IN prim_Party_Site_Cur(l_person_ID) LOOP
1234: lnParty_Site_ID := temp_cur.Party_Site_ID;
1235: END LOOP;
1236: END IF;

Line 1321: || to the procedure Igs_Pe_Identify_Dups.form_dup_whereclause

1317: || Change History :
1318: || Who When What
1319: || (reverse chronological order - newest change first)
1320: || pkpatel 30-MAY-2002 Bug 2377580, The parameters x_person_id_type,x_api_person_id were passed in the call
1321: || to the procedure Igs_Pe_Identify_Dups.form_dup_whereclause
1322: || pkpatel 10-OCT-2002 Bug No: 2603065
1323: || Increased the size of variable x_lvcExactSelectClause and x_lvcPartialSelectClause from 500 to 2000
1324: || pkpatel 22-JUN-2001 Bug no.2702536
1325: || Added the parameters p_match_ind, p_person_id

Line 1405: IF p_addr_type IS NULL AND p_person_id_type IS NULL AND IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'N' THEN

1401: END IF;
1402: END IF;
1403: CLOSE c_stat_data_element;
1404:
1405: IF p_addr_type IS NULL AND p_person_id_type IS NULL AND IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'N' THEN
1406: igs_ad_find_duplicates_imp_p(p_d_match_set_id =>p_d_match_set_id,
1407: p_d_batch_id =>p_d_batch_id,
1408: p_d_interface_id =>p_interface_id,
1409: p_c_addr_type =>p_addr_type,

Line 1414: ELSIF (p_person_id_type IS NULL) AND ( p_addr_type IS NOT NULL OR IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'Y') THEN

1410: p_c_person_id_type =>p_person_id_type,
1411: p_person_id =>p_person_id,
1412: p_match_ind =>p_match_ind);
1413:
1414: ELSIF (p_person_id_type IS NULL) AND ( p_addr_type IS NOT NULL OR IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'Y') THEN
1415: igs_ad_find_duplicates_imp_pa(p_d_match_set_id =>p_d_match_set_id,
1416: p_d_batch_id =>p_d_batch_id,
1417: p_d_interface_id =>p_interface_id,
1418: p_c_addr_type =>p_addr_type,

Line 1422: ELSIF p_addr_type IS NULL AND p_person_id_type IS NOT NULL AND IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'N' THEN

1418: p_c_addr_type =>p_addr_type,
1419: p_c_person_id_type =>p_person_id_type,
1420: p_person_id =>p_person_id,
1421: p_match_ind =>p_match_ind);
1422: ELSIF p_addr_type IS NULL AND p_person_id_type IS NOT NULL AND IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'N' THEN
1423: igs_ad_find_duplicates_imp_pp(p_d_match_set_id =>p_d_match_set_id,
1424: p_d_batch_id =>p_d_batch_id,
1425: p_d_interface_id =>p_interface_id,
1426: p_c_addr_type =>p_addr_type,

Line 1430: ELSIF p_person_id_type IS NOT NULL AND (p_addr_type IS NOT NULL OR IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'Y') THEN

1426: p_c_addr_type =>p_addr_type,
1427: p_c_person_id_type =>p_person_id_type,
1428: p_person_id =>p_person_id,
1429: p_match_ind =>p_match_ind);
1430: ELSIF p_person_id_type IS NOT NULL AND (p_addr_type IS NOT NULL OR IGS_PE_IDENTIFY_DUPS.g_primary_addr_flag = 'Y') THEN
1431: igs_ad_find_duplicates_imp_ppa(p_d_match_set_id =>p_d_match_set_id,
1432: p_d_batch_id =>p_d_batch_id,
1433: p_d_interface_id =>p_interface_id,
1434: p_c_addr_type =>p_addr_type,