[Home] [Help]
259: and a.batch_id = p_batch_id
260: and a.batch_id = c.batch_id
261: and b.action_flag = 'I' );
262: log( ' Update contacts as same match rule being used');
263: update HZ_SRCH_CONTACTS c set party_id = ( select b.sub_id
264: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b
265: where a.rowid = b.int_row_id
266: and c.int_row_id = a.rowid
267: and a.batch_id = p_batch_id
409: l_sql_stmt VARCHAR2(255);
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;
520: and a.party_osr = b.party_orig_system_reference
521: and b.action_flag = 'U'
522: and a.batch_id = p_batch_id);
523: ELSIF (p_et_name = 'CONTACTS') THEN
524: delete from HZ_SRCH_CONTACTS c where c.contact_os ||c.contact_osr || c.batch_id in(
525: select b.contact_orig_system || b.contact_orig_system_reference || b.batch_id
526: from HZ_IMP_CONTACTS_SG a, HZ_IMP_CONTACTS_INT b
527: where a.int_row_id = b.rowid
528: and a.action_flag = 'U'
2973: l(' END LOOP; ');
2974: l(' SAVEPOINT pop_contacts; ');
2975: l(' BEGIN ');
2976: l(' FORALL I in H_P_CONTACT_OSR.FIRST..H_P_CONTACT_OSR.LAST ');
2977: l(' INSERT INTO HZ_SRCH_CONTACTS ( ');
2978: get_insert_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_INT');
2979: l( l_sel_str);
2980: -- dbms_output.put_line(' get_insert_str (CONTACTS)' || l_sel_str);
2981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3094: l(' END LOOP; ');
3095: l(' SAVEPOINT pop_contacts_int; ');
3096: l(' BEGIN ');
3097: l(' FORALL I in H_P_CONTACT_OS.FIRST..H_P_CONTACT_OS.LAST ');
3098: l(' INSERT INTO HZ_SRCH_CONTACTS ( ');
3099: get_insert_str('HZ_STAGED_CONTACTS', p_rule_id, l_sel_str, 'INT_TCA');
3100: l( l_sel_str);
3101: -- dbms_output.put_line(' get_insert_str (CONTACTS int_tca)' || l_sel_str);
3102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN