[Home] [Help]
273: and a.batch_id = p_batch_id
274: and a.batch_id = c.batch_id
275: and b.action_flag = 'I' );
276: log( ' Update contact_points as same match rule being used');
277: update HZ_SRCH_CPTS c set party_id = ( select b.party_id
278: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b
279: where a.rowid = b.int_row_id
280: and c.int_row_id = a.rowid
281: and a.batch_id = p_batch_id
410: BEGIN
411: chk_table('HZ_SRCH_PARTIES', p_batch_id);
412: chk_table('HZ_SRCH_PSITES', p_batch_id);
413: chk_table('HZ_SRCH_CONTACTS', p_batch_id);
414: chk_table('HZ_SRCH_CPTS', p_batch_id);
415: EXCEPTION WHEN OTHERS THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END chk_srch_tab;
418:
529: and b.contact_orig_system = c.contact_os
530: and b.contact_orig_system_reference = c.contact_osr
531: and b.batch_id = p_batch_id);
532: ELSIF (p_et_name = 'CP') THEN
533: delete from HZ_SRCH_CPTS a
534: where a.party_os || a.party_osr in (
535: select a.party_os || a.party_osr
536: from HZ_IMP_CONTACTPTS_SG b
537: where a.party_os = b.party_orig_system
3238: l(' END LOOP; ');
3239: l(' SAVEPOINT POP_CP; ');
3240: l(' BEGIN ');
3241: l(' FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST ');
3242: l(' INSERT INTO HZ_SRCH_CPTS ( ');
3243: get_insert_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_INT');
3244: l( l_sel_str);
3245: -- dbms_output.put_line(' get_insert_str (CONTACT_POINTS) ' || l_sel_str);
3246: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3386: l(' END LOOP; ');
3387: l(' SAVEPOINT pop_cp_int; ');
3388: l(' BEGIN ');
3389: l(' FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST ');
3390: l(' INSERT INTO HZ_SRCH_CPTS ( ');
3391: get_insert_str('HZ_STAGED_CONTACT_POINTS', p_rule_id, l_sel_str, 'INT_TCA');
3392: l_sel_str := l_sel_str || ' , PARTY_ID '; -- bug 5393826
3393: l( l_sel_str);
3394: -- dbms_output.put_line(' get_insert_str (CONTACT_POINTS) ' || l_sel_str);