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_AD_INTERFACE

Line 58: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,

54: p_d_interface_id IN NUMBER,
55: p_d_batch_id IN NUMBER,
56: p_c_addr_type IN VARCHAR2,
57: p_c_person_id_type IN VARCHAR2,
58: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
59: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)
60: AS
61: /*
62: || Created By : prabhat.patel

Line 59: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)

55: p_d_batch_id IN NUMBER,
56: p_c_addr_type IN VARCHAR2,
57: p_c_person_id_type IN VARCHAR2,
58: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
59: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)
60: AS
61: /*
62: || Created By : prabhat.patel
63: || Created On : 09-OCT-2002

Line 190: igs_ad_interface_table */

186: END LOOP;
187: dbms_sql.close_cursor(l_cursor_id);
188:
189: /*If the dynamic Query returns only one row, then Update the
190: igs_ad_interface_table */
191:
192: IF x_match_cnt = 1 THEN /* Only One Match is Found Match_Ind 12 is - Match to a Single Person*/
193: UPDATE igs_ad_interface
194: SET match_ind = cst_mi_val_12,

Line 193: UPDATE igs_ad_interface

189: /*If the dynamic Query returns only one row, then Update the
190: igs_ad_interface_table */
191:
192: IF x_match_cnt = 1 THEN /* Only One Match is Found Match_Ind 12 is - Match to a Single Person*/
193: UPDATE igs_ad_interface
194: SET match_ind = cst_mi_val_12,
195: person_id = l_person_id
196: WHERE interface_id = imp_person_rec.interface_id;
197:

Line 203: UPDATE igs_ad_interface

199: p_match_ind := '12';
200: RETURN;
201: ELSIF x_match_cnt > 1 THEN -- if more than one duplicate is found then update match_ind to 13
202: -- 13 - Match to Multiple Persons
203: UPDATE igs_ad_interface
204: SET match_ind = cst_mi_val_13,
205: ERROR_CODE = cst_err_val_2,
206: STATUS = cst_stat_val_3
207: WHERE interface_id = imp_person_rec.interface_id;

Line 279: UPDATE igs_ad_interface

275: END LOOP;
276:
277: dbms_sql.close_cursor(l_cursor_id1);
278: IF x_match_cnt = 0 THEN /* Partial match not found */
279: UPDATE igs_ad_interface
280: SET match_ind = cst_mi_val_11
281: WHERE interface_id = imp_person_rec.interface_id;
282: p_match_ind := '11';
283: RETURN;

Line 285: UPDATE igs_ad_interface

281: WHERE interface_id = imp_person_rec.interface_id;
282: p_match_ind := '11';
283: RETURN;
284: ELSE
285: UPDATE igs_ad_interface
286: SET match_ind = cst_mi_val_14,
287: ERROR_CODE = cst_err_val_3,
288: STATUS = cst_stat_val_3
289: WHERE interface_id = imp_person_rec.interface_id;

Line 302: UPDATE igs_ad_interface

298: END IF;
299: END IF;
300: END LOOP;
301: IF i = 0 THEN
302: UPDATE igs_ad_interface
303: SET status = cst_stat_val_3,
304: match_ind = cst_mi_val_24,
305: ERROR_CODE = cst_err_val_1
306: WHERE interface_id = p_d_interface_id;

Line 322: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,

318: p_d_interface_id IN NUMBER,
319: p_d_batch_id IN NUMBER,
320: p_c_addr_type IN VARCHAR2,
321: p_c_person_id_type IN VARCHAR2,
322: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
323: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)
324: AS
325: /*
326: || Created By : prabhat.patel

Line 323: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)

319: p_d_batch_id IN NUMBER,
320: p_c_addr_type IN VARCHAR2,
321: p_c_person_id_type IN VARCHAR2,
322: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
323: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)
324: AS
325: /*
326: || Created By : prabhat.patel
327: || Created On : 09-OCT-2002

Line 456: /If the dynamic Query returns only one row, then Update the igs_ad_interface_table /

452: EXIT;
453: END IF;
454: END LOOP; /* End Loop for dup_matches_cur */
455: dbms_sql.close_cursor(l_cursor_id);
456: /*If the dynamic Query returns only one row, then Update the igs_ad_interface_table */
457: IF x_match_cnt = 1 THEN /* Only One Match is Found */
458: UPDATE igs_ad_interface
459: SET match_ind = cst_mi_val_12,
460: person_id = l_person_id

Line 458: UPDATE igs_ad_interface

454: END LOOP; /* End Loop for dup_matches_cur */
455: dbms_sql.close_cursor(l_cursor_id);
456: /*If the dynamic Query returns only one row, then Update the igs_ad_interface_table */
457: IF x_match_cnt = 1 THEN /* Only One Match is Found */
458: UPDATE igs_ad_interface
459: SET match_ind = cst_mi_val_12,
460: person_id = l_person_id
461: WHERE interface_id = imp_person_rec.interface_id;
462: p_person_id := l_person_id;

Line 466: UPDATE igs_ad_interface

462: p_person_id := l_person_id;
463: p_match_ind := '12';
464: RETURN;
465: ELSIF x_match_cnt > 1 THEN
466: UPDATE igs_ad_interface
467: SET match_ind = cst_mi_val_13,
468: error_code = cst_err_val_2,
469: STATUS = cst_stat_val_3
470: WHERE interface_id = imp_person_rec.interface_id;

Line 550: UPDATE igs_ad_interface

546:
547: dbms_sql.close_cursor(l_cursor_id1);
548:
549: IF x_match_cnt = 0 THEN /* No Partial match not found */
550: UPDATE igs_ad_interface
551: SET match_ind = cst_mi_val_11
552: WHERE interface_id = imp_person_rec.interface_id;
553:
554: p_match_ind := '11';

Line 558: UPDATE igs_ad_interface

554: p_match_ind := '11';
555:
556: RETURN;
557: ELSE
558: UPDATE igs_ad_interface
559: SET match_ind = cst_mi_val_14,
560: ERROR_CODE = cst_err_val_3,
561: STATUS = cst_stat_val_3
562: WHERE interface_id = imp_person_rec.interface_id;

Line 577: UPDATE igs_ad_interface

573: END IF;
574: END IF;
575: END LOOP;
576: IF i = 0 THEN
577: UPDATE igs_ad_interface
578: SET status = cst_stat_val_3,
579: match_ind = cst_mi_val_24,
580: error_code = cst_err_val_1
581: WHERE interface_id = p_d_interface_id;

Line 597: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,

593: p_d_interface_id IN NUMBER,
594: p_d_batch_id IN NUMBER,
595: p_c_addr_type IN VARCHAR2,
596: p_c_person_id_type IN VARCHAR2,
597: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
598: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE) AS
599:
600: /*
601: || Created By : pkpatel

Line 598: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE) AS

594: p_d_batch_id IN NUMBER,
595: p_c_addr_type IN VARCHAR2,
596: p_c_person_id_type IN VARCHAR2,
597: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
598: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE) AS
599:
600: /*
601: || Created By : pkpatel
602: || Created On : 10-DEC-2001

Line 781: /If the dynamic Query returns only one row, then Update the igs_ad_interface_table /

777: END IF;
778: END LOOP; /* End Loop for dup_matches_cur */
779: dbms_sql.close_cursor(l_cursor_id);
780:
781: /*If the dynamic Query returns only one row, then Update the igs_ad_interface_table */
782: IF x_match_cnt = 1 THEN /* Only One Match is Found */
783: UPDATE igs_ad_interface
784: SET match_ind = cst_mi_val_12,
785: person_id = l_person_id

Line 783: UPDATE igs_ad_interface

779: dbms_sql.close_cursor(l_cursor_id);
780:
781: /*If the dynamic Query returns only one row, then Update the igs_ad_interface_table */
782: IF x_match_cnt = 1 THEN /* Only One Match is Found */
783: UPDATE igs_ad_interface
784: SET match_ind = cst_mi_val_12,
785: person_id = l_person_id
786: WHERE interface_id = imp_person_rec.interface_id;
787:

Line 793: UPDATE igs_ad_interface

789: p_match_ind := '12';
790: RETURN;
791:
792: ELSIF x_match_cnt > 1 THEN
793: UPDATE igs_ad_interface
794: SET match_ind = cst_mi_val_13,
795: error_code = cst_err_val_2,
796: STATUS = cst_stat_val_3
797: WHERE interface_id = imp_person_rec.interface_id;

Line 898: UPDATE igs_ad_interface

894:
895: dbms_sql.close_cursor(l_cursor_id1);
896:
897: IF x_match_cnt = 0 THEN /* No Partial match not found */
898: UPDATE igs_ad_interface
899: SET match_ind = cst_mi_val_11
900: WHERE interface_id = imp_person_rec.interface_id;
901:
902: p_match_ind := '11';

Line 906: UPDATE igs_ad_interface

902: p_match_ind := '11';
903:
904: RETURN;
905: ELSE
906: UPDATE igs_ad_interface
907: SET match_ind = '14',
908: ERROR_CODE = 'E003',
909: STATUS = '3'
910: WHERE interface_id = imp_person_rec.interface_id;

Line 926: UPDATE igs_ad_interface

922: END IF;
923: END LOOP;
924:
925: IF i = 0 THEN
926: UPDATE igs_ad_interface
927: SET status = '3',
928: match_ind = '24',
929: error_code = 'E001'
930: WHERE interface_id = p_d_interface_id;

Line 950: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,

946: p_d_interface_id IN NUMBER,
947: p_d_batch_id IN NUMBER,
948: p_c_addr_type IN VARCHAR2,
949: p_c_person_id_type IN VARCHAR2,
950: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
951: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)
952: AS
953: /*
954: || Created By : pkpatel

Line 951: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)

947: p_d_batch_id IN NUMBER,
948: p_c_addr_type IN VARCHAR2,
949: p_c_person_id_type IN VARCHAR2,
950: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
951: p_match_ind OUT NOCOPY igs_ad_interface.match_ind%TYPE)
952: AS
953: /*
954: || Created By : pkpatel
955: || Created On : 10-DEC-2001

Line 1143: /If the dynamic Query returns only one row, then Update the igs_ad_interface_table /

1139: END IF;
1140: END LOOP; /* End Loop for dup_matches_cur */
1141: dbms_sql.close_cursor(l_cursor_id);
1142:
1143: /*If the dynamic Query returns only one row, then Update the igs_ad_interface_table */
1144: IF x_match_cnt = 1 THEN /* Only One Match is Found */
1145:
1146: UPDATE igs_ad_interface
1147: SET match_ind = cst_mi_val_12,

Line 1146: UPDATE igs_ad_interface

1142:
1143: /*If the dynamic Query returns only one row, then Update the igs_ad_interface_table */
1144: IF x_match_cnt = 1 THEN /* Only One Match is Found */
1145:
1146: UPDATE igs_ad_interface
1147: SET match_ind = cst_mi_val_12,
1148: person_id = l_person_id
1149: WHERE interface_id = imp_person_rec.interface_id;
1150:

Line 1156: UPDATE igs_ad_interface

1152: p_match_ind := '12';
1153:
1154: RETURN;
1155: ELSIF x_match_cnt > 1 THEN
1156: UPDATE igs_ad_interface
1157: SET match_ind = '13',
1158: ERROR_CODE = 'E002',
1159: STATUS = '3'
1160: WHERE interface_id = imp_person_rec.interface_id;

Line 1259: UPDATE igs_ad_interface

1255:
1256: dbms_sql.close_cursor(l_cursor_id1);
1257:
1258: IF x_match_cnt = 0 THEN /* No Partial match not found */
1259: UPDATE igs_ad_interface
1260: SET match_ind = cst_mi_val_11
1261: WHERE interface_id = imp_person_rec.interface_id;
1262:
1263: p_match_ind := '11';

Line 1267: UPDATE igs_ad_interface

1263: p_match_ind := '11';
1264:
1265: RETURN;
1266: ELSE
1267: UPDATE igs_ad_interface
1268: SET match_ind = cst_mi_val_14,
1269: ERROR_CODE = cst_err_val_3,
1270: STATUS = cst_stat_val_3
1271: WHERE interface_id = imp_person_rec.interface_id;

Line 1286: UPDATE igs_ad_interface

1282: END IF;
1283: END IF;
1284: END LOOP;
1285: IF i = 0 THEN
1286: UPDATE igs_ad_interface
1287: SET status = cst_stat_val_3,
1288: match_ind = cst_mi_val_24,
1289: error_code = cst_err_val_1
1290: WHERE interface_id = p_d_interface_id;

Line 1307: p_interface_id IN igs_ad_interface.interface_id%TYPE,

1303: PROCEDURE igs_ad_imp_find_dup_persons
1304: (p_d_batch_id IN NUMBER,
1305: p_d_source_type_id IN NUMBER,
1306: p_d_match_set_id IN NUMBER,
1307: p_interface_id IN igs_ad_interface.interface_id%TYPE,
1308: p_match_ind IN OUT NOCOPY igs_ad_interface.match_ind%TYPE,
1309: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
1310: p_addr_type IN igs_pe_mtch_set_data.VALUE%TYPE,
1311: p_person_id_type IN igs_pe_mtch_set_data.VALUE%TYPE) AS

Line 1308: p_match_ind IN OUT NOCOPY igs_ad_interface.match_ind%TYPE,

1304: (p_d_batch_id IN NUMBER,
1305: p_d_source_type_id IN NUMBER,
1306: p_d_match_set_id IN NUMBER,
1307: p_interface_id IN igs_ad_interface.interface_id%TYPE,
1308: p_match_ind IN OUT NOCOPY igs_ad_interface.match_ind%TYPE,
1309: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
1310: p_addr_type IN igs_pe_mtch_set_data.VALUE%TYPE,
1311: p_person_id_type IN igs_pe_mtch_set_data.VALUE%TYPE) AS
1312: /*

Line 1309: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,

1305: p_d_source_type_id IN NUMBER,
1306: p_d_match_set_id IN NUMBER,
1307: p_interface_id IN igs_ad_interface.interface_id%TYPE,
1308: p_match_ind IN OUT NOCOPY igs_ad_interface.match_ind%TYPE,
1309: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
1310: p_addr_type IN igs_pe_mtch_set_data.VALUE%TYPE,
1311: p_person_id_type IN igs_pe_mtch_set_data.VALUE%TYPE) AS
1312: /*
1313: || Created By : pkpatel

Line 1350: CURSOR c_stat_data_exists (cp_interface_id IGS_AD_INTERFACE.INTERFACE_ID%TYPE,

1346: WHERE md.match_set_id = cp_d_match_set_id
1347: AND md.data_element = cp_lookup_code
1348: AND md.drop_if_null = cp_din;
1349:
1350: CURSOR c_stat_data_exists (cp_interface_id IGS_AD_INTERFACE.INTERFACE_ID%TYPE,
1351: cp_status IGS_AD_INTERFACE.STATUS%TYPE) IS
1352: SELECT 'X'
1353: FROM igs_ad_stat_int
1354: WHERE interface_id = cp_interface_id AND

Line 1351: cp_status IGS_AD_INTERFACE.STATUS%TYPE) IS

1347: AND md.data_element = cp_lookup_code
1348: AND md.drop_if_null = cp_din;
1349:
1350: CURSOR c_stat_data_exists (cp_interface_id IGS_AD_INTERFACE.INTERFACE_ID%TYPE,
1351: cp_status IGS_AD_INTERFACE.STATUS%TYPE) IS
1352: SELECT 'X'
1353: FROM igs_ad_stat_int
1354: WHERE interface_id = cp_interface_id AND
1355: status = cp_status;

Line 1450: UPDATE igs_ad_interface

1446: END IF;
1447: IF c_stat_data_element%ISOPEN THEN
1448: CLOSE c_stat_data_element;
1449: END IF;
1450: UPDATE igs_ad_interface
1451: SET status='3', ERROR_CODE='E177'
1452: WHERE interface_id = p_interface_id;
1453:
1454: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN