310:
311: -- call Matching of Other Entities
312:
313: -- matching of relationships
314: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_RELATIONSHIPS(
315: l_dml_record.BATCH_ID,
316: l_dml_record.OS,
317: l_dml_record.FROM_OSR,
318: l_dml_record.TO_OSR,
322: );
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_RELATIONSHIPS completed ');
324:
325: -- matching of org contacts
326: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CONTACTS(
327: l_dml_record.BATCH_ID,
328: l_dml_record.OS,
329: l_dml_record.FROM_OSR,
330: l_dml_record.TO_OSR,
334: );
335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACTS completed ');
336:
337: -- matching of addresses
338: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_ADDRESSES(
339: l_dml_record.BATCH_ID,
340: l_dml_record.OS,
341: l_dml_record.FROM_OSR,
342: l_dml_record.TO_OSR,
346: );
347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_ADDRESSES completed ');
348:
349: -- matching of contact points
350: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CONTACT_POINTS(
351: l_dml_record.BATCH_ID,
352: l_dml_record.OS,
353: l_dml_record.FROM_OSR,
354: l_dml_record.TO_OSR,
358: );
359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACT_POINTS completed ');
360:
361: -- matching of party site use
362: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_ADDRUSES(
363: l_dml_record.BATCH_ID,
364: l_dml_record.OS,
365: l_dml_record.FROM_OSR,
366: l_dml_record.TO_OSR,
370: );
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_ADDRUSES completed ');
372:
373: -- matching of contact role
374: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CONTACTROLES(
375: l_dml_record.BATCH_ID,
376: l_dml_record.OS,
377: l_dml_record.FROM_OSR,
378: l_dml_record.TO_OSR,
382: );
383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACTROLES completed ');
384:
385: -- matching of financial reports
386: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_FINANCIAL_REPORTS(
387: l_dml_record.BATCH_ID,
388: l_dml_record.OS,
389: l_dml_record.FROM_OSR,
390: l_dml_record.TO_OSR,
394: );
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_FINANCIAL_REPORTS completed ');
396:
397: -- matching of financial numbers
398: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_FINANCIAL_NUMBERS(
399: l_dml_record.BATCH_ID,
400: l_dml_record.OS,
401: l_dml_record.FROM_OSR,
402: l_dml_record.TO_OSR,
406: );
407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_FINANCIAL_NUMBERS completed ');
408:
409: -- matching of credit ratings
410: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CREDIT_RATINGS(
411: l_dml_record.BATCH_ID,
412: l_dml_record.OS,
413: l_dml_record.FROM_OSR,
414: l_dml_record.TO_OSR,
419: );
420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CREDIT_RATINGS completed ');
421:
422: -- matching of code assignments
423: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CODE_ASSIGNMENTS(
424: l_dml_record.BATCH_ID,
425: l_dml_record.OS,
426: l_dml_record.FROM_OSR,
427: l_dml_record.TO_OSR,
578: -- matching of parties
579: -- Bug 4925023 : handle cases when records passed stage 3 at previous run.
580: -- Change from l_hwm_stage = 2 to l_hwm_stage >= 2
581: IF l_hwm_stage >= 2 AND l_pp_status = 'U' THEN
582: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_PARTIES(
583: l_dml_record.BATCH_ID,
584: l_dml_record.OS,
585: l_dml_record.FROM_OSR,
586: l_dml_record.TO_OSR,