APPS.HZ_IMP_DQM_STAGE dependencies on HZ_SRCH_PARTIES

Line 255: update hz_srch_parties c set party_id = ( select b.party_id

251: ) where batch_id = p_batch_id;
252: END IF;
253: -- - Update IDs on PARTY, CONTACTS, CONTACT_POINTS
254: log( ' Update party as same match rule being used');
255: update hz_srch_parties c set party_id = ( select b.party_id
256: from hz_imp_parties_int a, hz_imp_parties_sg b
257: where a.rowid = b.int_row_id
258: and c.int_row_id = a.rowid
259: and a.batch_id = p_batch_id

Line 411: chk_table('HZ_SRCH_PARTIES', p_batch_id);

407: l_owner VARCHAR2(255);
408: l_table_name VARCHAR2(30);
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

Line 2039: l(' INSERT INTO HZ_SRCH_PARTIES (');

2035: l(' END LOOP;');
2036: l(' SAVEPOINT pop_parties;');
2037: l(' BEGIN ');
2038: l(' FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST');
2039: l(' INSERT INTO HZ_SRCH_PARTIES (');
2040: get_insert_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_INT');
2041: l( l_sel_str);
2042: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2184: l(' INSERT INTO HZ_SRCH_PARTIES ( ');

2180: l(' END LOOP; ');
2181: l(' SAVEPOINT pop_parties_int; ');
2182: l(' BEGIN ');
2183: l(' FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST ');
2184: l(' INSERT INTO HZ_SRCH_PARTIES ( ');
2185: get_insert_str('HZ_STAGED_PARTIES', p_rule_id, l_sel_str, 'INT_TCA');
2186: l_sel_str := l_sel_str || ' , PARTY_ID '; -- bug 5393826
2187: l( l_sel_str);
2188: -- dbms_output.put_line('get_insert_str PARTY int tca ' || l_sel_str);