APPS.HZ_IMP_DQM_STAGE dependencies on HZ_SRCH_PSITES

Line 237: update HZ_SRCH_PSITES c set party_site_id = ( select b.party_site_id

233: ELSE
234: -- - Update IDs on PARTY SITES
235: log( ' Update party_sites since address validation was not run');
236:
237: update HZ_SRCH_PSITES c set party_site_id = ( select b.party_site_id
238: from hz_imp_addresses_int a, HZ_IMP_ADDRESSES_SG b
239: where a.rowid = b.int_row_id
240: and c.int_row_id = a.rowid
241: and a.batch_id = p_batch_id

Line 412: chk_table('HZ_SRCH_PSITES', p_batch_id);

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
416: RAISE FND_API.G_EXC_ERROR;

Line 515: delete from hz_srch_psites a

511: ) IS
512:
513: BEGIN
514: IF (p_et_name = 'PSITES') THEN
515: delete from hz_srch_psites a
516: where a.party_os || a.party_osr in (
517: select a.party_os || a.party_osr
518: from HZ_IMP_ADDRESSES_SG b
519: where a.party_os = b.party_orig_system

Line 584: where object_name = 'HZ_SRCH_PSITES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1 ;*/

580: IF ((l_a = 'Y') AND (l_c = l_d) ) THEN
581: IF (l_e = 'Y') THEN
582: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
583: /*select owner into l_owner from sys.all_objects
584: where object_name = 'HZ_SRCH_PSITES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1 ;*/
585: --Bug:4956084
586: l_sqlstr := 'select owner from sys.all_tables
587: where table_name = ''HZ_SRCH_PSITES'' and owner = :p_owner ';
588: execute immediate l_sqlstr into l_owner USING l_owner1 ;

Line 587: where table_name = ''HZ_SRCH_PSITES'' and owner = :p_owner ';

583: /*select owner into l_owner from sys.all_objects
584: where object_name = 'HZ_SRCH_PSITES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1 ;*/
585: --Bug:4956084
586: l_sqlstr := 'select owner from sys.all_tables
587: where table_name = ''HZ_SRCH_PSITES'' and owner = :p_owner ';
588: execute immediate l_sqlstr into l_owner USING l_owner1 ;
589: l_table_name := l_owner || '.HZ_SRCH_PSITES';
590: chk_table(l_table_name, p_batch_id);
591: END IF;

Line 589: l_table_name := l_owner || '.HZ_SRCH_PSITES';

585: --Bug:4956084
586: l_sqlstr := 'select owner from sys.all_tables
587: where table_name = ''HZ_SRCH_PSITES'' and owner = :p_owner ';
588: execute immediate l_sqlstr into l_owner USING l_owner1 ;
589: l_table_name := l_owner || '.HZ_SRCH_PSITES';
590: chk_table(l_table_name, p_batch_id);
591: END IF;
592: END IF;
593: ELSIF (l_a = 'Y') THEN

Line 2354: l(' INSERT INTO HZ_SRCH_PSITES ( ');

2350: l(' END LOOP; ');
2351: l(' SAVEPOINT pop_party_sites; ');
2352: l(' BEGIN ');
2353: l(' FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST ');
2354: l(' INSERT INTO HZ_SRCH_PSITES ( ');
2355: get_insert_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_INT');
2356: l( l_sel_str);
2357: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);
2358: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2504: l(' INSERT INTO HZ_SRCH_PSITES ( ');

2500: l(' END LOOP; ');
2501: l(' SAVEPOINT pop_party_sites_int; ');
2502: l(' BEGIN ');
2503: l(' FORALL I in H_P_PS_OSR.FIRST..H_P_PS_OSR.LAST ');
2504: l(' INSERT INTO HZ_SRCH_PSITES ( ');
2505: get_insert_str('HZ_STAGED_PARTY_SITES', p_rule_id, l_sel_str, 'INT_TCA');
2506: l_sel_str := l_sel_str || ' , PARTY_ID ';-- bug 5393826
2507: l( l_sel_str);
2508: -- dbms_output.put_line('l_sel_str get_insert_str ' || l_sel_str);