APPS.IGS_AD_IMP_009 dependencies on IGS_AD_IMP_NEAR_MTCH_PKG

Line 169: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

165: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN
166: x_match_cnt := x_match_cnt+1;
167: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
168:
169: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
170: (x_rowid =>l_rowid,
171: x_org_id => lnOrg_ID,
172: x_near_mtch_id=>l_pk,
173: x_interface_id=>p_d_interface_id,

Line 259: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

255: IF dbms_sql.fetch_rows(l_cursor_id1) > 0 THEN
256: x_match_cnt := x_match_cnt+1;
257: dbms_sql.column_value(l_cursor_id1, 1, l_person_id);
258:
259: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
260: (x_rowid =>l_rowid,
261: x_org_id => lnOrg_ID,
262: x_near_mtch_id=>l_pk,
263: x_interface_id=>p_d_interface_id,

Line 437: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

433: x_match_cnt := x_match_cnt+1;
434: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
435:
436: /* Insert into igs_ad_imp_near_match, all the duplicate records */
437: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
438: (x_rowid =>l_rowid,
439: x_Org_ID => lnOrg_ID,
440: x_near_mtch_id=>l_pk,
441: x_interface_id=>p_d_interface_id,

Line 527: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

523:
524: dbms_sql.column_value(l_cursor_id1, 1, l_person_id);
525:
526: /* Insert into igs_ad_imp_near_match_int, all the duplicate records */
527: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
528: (x_rowid =>l_rowid,
529: x_Org_ID => lnOrg_ID,
530: x_near_mtch_id=>l_pk,
531: x_interface_id=>p_d_interface_id,

Line 761: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

757: END IF;
758:
759:
760: /* Insert into igs_ad_imp_near_match, all the duplicate records */
761: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
762: (x_rowid =>l_rowid,
763: x_Org_ID => lnOrg_ID,
764: x_near_mtch_id=>l_pk,
765: x_interface_id=>p_d_interface_id,

Line 875: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

871: END LOOP;
872: END IF;
873:
874: /* Insert into igs_ad_imp_near_match_int, all the duplicate records */
875: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
876: (x_rowid =>l_rowid,
877: x_Org_ID => lnOrg_ID,
878: x_near_mtch_id=>l_pk,
879: x_interface_id=>p_d_interface_id,

Line 1123: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

1119: END LOOP;
1120: END IF;
1121:
1122: /* Insert into igs_ad_imp_near_match, all the duplicate records */
1123: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
1124: (x_rowid =>l_rowid,
1125: x_Org_ID => lnOrg_ID,
1126: x_near_mtch_id=>l_pk,
1127: x_interface_id=>p_d_interface_id,

Line 1238: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row

1234: lnParty_Site_ID := temp_cur.Party_Site_ID;
1235: END LOOP;
1236: END IF;
1237:
1238: Igs_Ad_Imp_Near_Mtch_Pkg.insert_row
1239: (x_rowid =>l_rowid,
1240: x_Org_ID => lnOrg_ID,
1241: x_near_mtch_id=>l_pk,
1242: x_interface_id=>p_d_interface_id,