eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_STAGE dependencies on HZ_STAGED_PARTIES

Line 372: where object_name = 'HZ_STAGED_PARTIES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1;

368: l_temp VARCHAR2(255);
369: BEGIN
370: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
371: select owner into l_owner from sys.all_objects
372: where object_name = 'HZ_STAGED_PARTIES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1;
373: END IF;
374: log('Deleting existing staged data');
375: log('Truncating HZ_STAGED_PARTIES .. ', FALSE);
376: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_STAGED_PARTIES';

Line 375: log('Truncating HZ_STAGED_PARTIES .. ', FALSE);

371: select owner into l_owner from sys.all_objects
372: where object_name = 'HZ_STAGED_PARTIES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1;
373: END IF;
374: log('Deleting existing staged data');
375: log('Truncating HZ_STAGED_PARTIES .. ', FALSE);
376: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_STAGED_PARTIES';
377: log('Done');
378:
379: log('Truncating HZ_STAGED_PARTY_SITES .. ', FALSE);

Line 376: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_STAGED_PARTIES';

372: where object_name = 'HZ_STAGED_PARTIES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1;
373: END IF;
374: log('Deleting existing staged data');
375: log('Truncating HZ_STAGED_PARTIES .. ', FALSE);
376: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_STAGED_PARTIES';
377: log('Done');
378:
379: log('Truncating HZ_STAGED_PARTY_SITES .. ', FALSE);
380: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_STAGED_PARTY_SITES';

Line 1051: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

1047: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1048: WHERE f.attribute_id = a.attribute_id
1049: AND i.owner = l_owner1
1050: AND f.index_required_flag in ('Y','T')
1051: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',
1052: 'PARTY_SITES','HZ_STAGED_PARTY_SITES','CONTACTS','HZ_STAGED_CONTACTS',
1053: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS')||'_N'||f.function_id) LOOP
1054: EXECUTE IMMEDIATE 'DROP INDEX '||IDX.idx_name;
1055: END LOOP;

Line 1222: SELECT decode(p_entity,'PARTY','HZ_STAGED_PARTIES',

1218: WHEN NO_DATA_FOUND THEN
1219: l_next_misc_section := l_num_primary;
1220: END;
1221:
1222: SELECT decode(p_entity,'PARTY','HZ_STAGED_PARTIES',
1223: 'PARTY_SITES','HZ_STAGED_PARTIES',
1224: 'CONTACTS','HZ_STAGED_CONTACTS',
1225: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS','DUMMY')
1226: INTO l_table_name

Line 1223: 'PARTY_SITES','HZ_STAGED_PARTIES',

1219: l_next_misc_section := l_num_primary;
1220: END;
1221:
1222: SELECT decode(p_entity,'PARTY','HZ_STAGED_PARTIES',
1223: 'PARTY_SITES','HZ_STAGED_PARTIES',
1224: 'CONTACTS','HZ_STAGED_CONTACTS',
1225: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS','DUMMY')
1226: INTO l_table_name
1227: from DUAL;

Line 1377: outandlog('The estimated disk space required for HZ_STAGED_PARTIES = ' || reco_staging_parties || 'MB' );

1373: reco_staging_contact_points := ceil(get_size('HZ_CONTACT_POINTS') * 2.0 * safety_factor);
1374: reco_index_size := 0.85 * (reco_staging_parties + reco_staging_party_sites + reco_staging_contacts + reco_staging_contact_points);
1375: reco_staging_size := reco_staging_parties + reco_staging_party_sites + reco_staging_contacts + reco_staging_contact_points + reco_index_size;
1376:
1377: outandlog('The estimated disk space required for HZ_STAGED_PARTIES = ' || reco_staging_parties || 'MB' );
1378: outandlog('The estimated disk space required for HZ_STAGED_PARTY_SITES = ' ||reco_staging_party_sites || 'MB' );
1379: outandlog('The estimated disk space required for HZ_STAGED_CONTACTS = ' ||reco_staging_contacts || 'MB' );
1380: outandlog('The estimated disk space required for HZ_STAGED_CONTACT_POINTS = ' || reco_staging_contact_points || 'MB' );
1381: outandlog('The estimated disk space required by text indexes = ' ||reco_index_size || 'MB' );

Line 1387: gather_stats(l_index_owner, 'HZ_STAGED_PARTIES');

1383: outandlog('The estimated total disk space required for staging = ' ||reco_staging_size || 'MB' );
1384: outandlog('NEWLINE');
1385: ELSIF l_command = 'ANALYZE_STAGED_TABLES' THEN
1386: outandlog('Staged tables being analyzed');
1387: gather_stats(l_index_owner, 'HZ_STAGED_PARTIES');
1388: gather_stats(l_index_owner, 'HZ_STAGED_PARTY_SITES');
1389: gather_stats(l_index_owner, 'HZ_STAGED_CONTACTS');
1390: gather_stats(l_index_owner, 'HZ_STAGED_CONTACT_POINTS');
1391: outandlog('Staged tables analyzed, End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));

Line 2147: SELECT 1 INTO T FROM HZ_STAGED_PARTIES

2143: END LOOP;
2144:
2145: l_req_id := 1;
2146: BEGIN
2147: SELECT 1 INTO T FROM HZ_STAGED_PARTIES
2148: WHERE ROWNUM=1
2149: AND CONTAINS (concat_col, 'dummy_string')>0;
2150: EXCEPTION
2151: WHEN NO_DATA_FOUND THEN

Line 3290: from hz_staged_parties;

3286: create_btree_indexes ('PARTY');
3287: BEGIN
3288: select min(party_id), max(party_id)
3289: into l_min_id, l_max_id
3290: from hz_staged_parties;
3291: WHILE (l_min_id <= l_max_id )
3292: LOOP
3293: select party_id into tmp
3294: from (

Line 3297: from hz_staged_parties

3293: select party_id into tmp
3294: from (
3295: select party_id, rownum rnum
3296: from ( SELECT party_id
3297: from hz_staged_parties
3298: where party_id>l_min_id
3299: and rownum<1001 ) a )
3300: where rnum = 1000;
3301: update hz_staged_parties set d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC', concat_col = concat_col

Line 3301: update hz_staged_parties set d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC', concat_col = concat_col

3297: from hz_staged_parties
3298: where party_id>l_min_id
3299: and rownum<1001 ) a )
3300: where rnum = 1000;
3301: update hz_staged_parties set d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC', concat_col = concat_col
3302: where party_id between l_min_id and tmp;
3303: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3304: FND_Concurrent.af_commit;
3305: l_min_id:=tmp+1;

Line 3309: update hz_staged_parties set concat_col = concat_col,

3305: l_min_id:=tmp+1;
3306: END LOOP;
3307: EXCEPTION
3308: WHEN NO_DATA_FOUND THEN
3309: update hz_staged_parties set concat_col = concat_col,
3310: d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC'
3311: where party_id between l_min_id and l_max_id ;
3312: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3313: FND_Concurrent.af_commit;

Line 3328: from hz_staged_parties;

3324: IF (new_primary_trans('PARTY')) THEN
3325: BEGIN
3326: select min(party_id), max(party_id)
3327: into l_min_id, l_max_id
3328: from hz_staged_parties;
3329: WHILE (l_min_id <= l_max_id )
3330: LOOP
3331: select party_id into tmp
3332: from (

Line 3335: from hz_staged_parties

3331: select party_id into tmp
3332: from (
3333: select party_id, rownum rnum
3334: from ( SELECT party_id
3335: from hz_staged_parties
3336: where party_id>l_min_id
3337: and rownum<1001 ) a )
3338: where rnum = 1000;
3339: update hz_staged_parties set concat_col = concat_col

Line 3339: update hz_staged_parties set concat_col = concat_col

3335: from hz_staged_parties
3336: where party_id>l_min_id
3337: and rownum<1001 ) a )
3338: where rnum = 1000;
3339: update hz_staged_parties set concat_col = concat_col
3340: where party_id between l_min_id and tmp;
3341: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3342: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3343: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');

Line 3349: update hz_staged_parties set concat_col = concat_col

3345: l_min_id:=tmp+1;
3346: END LOOP;
3347: EXCEPTION
3348: WHEN NO_DATA_FOUND THEN
3349: update hz_staged_parties set concat_col = concat_col
3350: where party_id between l_min_id and l_max_id ;
3351: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3352: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3353: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');

Line 3591: log(' Creating hz_stage_parties_t1 on hz_staged_parties.');

3587:
3588: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';
3589:
3590: IF l_command <> 'STAGE_NEW_TRANSFORMATIONS' THEN
3591: log(' Creating hz_stage_parties_t1 on hz_staged_parties.');
3592: log(' Index Memory ' || p_idx_mem);
3593: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS') );
3594:
3595: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_stage_parties_t1 ON ' ||

Line 3596: 'hz_staged_parties(concat_col) indextype is ctxsys.context ' ||

3592: log(' Index Memory ' || p_idx_mem);
3593: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS') );
3594:
3595: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_stage_parties_t1 ON ' ||
3596: 'hz_staged_parties(concat_col) indextype is ctxsys.context ' ||
3597: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_party_ds ' ||
3598: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' || p_idx_mem || ''')';
3599: ELSE
3600: log(' Attempting to drop and create hz_stage_parties_t1 on hz_staged_parties with new transformations.');

Line 3600: log(' Attempting to drop and create hz_stage_parties_t1 on hz_staged_parties with new transformations.');

3596: 'hz_staged_parties(concat_col) indextype is ctxsys.context ' ||
3597: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_party_ds ' ||
3598: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' || p_idx_mem || ''')';
3599: ELSE
3600: log(' Attempting to drop and create hz_stage_parties_t1 on hz_staged_parties with new transformations.');
3601: log(' Index Memory ' || p_idx_mem);
3602: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS') );
3603:
3604: BEGIN

Line 3614: 'hz_staged_parties(concat_col) indextype is ctxsys.context ' ||

3610: NULL;
3611:
3612: END ;
3613: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_stage_parties_t1 ON ' ||
3614: 'hz_staged_parties(concat_col) indextype is ctxsys.context ' ||
3615: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_party_ds ' ||
3616: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' || p_idx_mem || ''')';
3617: log('Done creating hz_stage_parties_t1');
3618: END IF;

Line 4052: l(' UPDATE HZ_STAGED_PARTIES SET ');

4048: END LOOP;
4049:
4050: IF l_update_str IS NOT NULL THEN
4051: IF p_entity = 'PARTY' THEN
4052: l(' UPDATE HZ_STAGED_PARTIES SET ');
4053: l(' ' || l_update_str);
4054: l(' WHERE party_id = p_record_id;');
4055: ELSIF p_entity = 'PARTY_SITES' THEN
4056: l(' UPDATE HZ_STAGED_PARTY_SITES SET ');

Line 4429: l(' SELECT '||proc_cols||' FROM '||uname||'.HZ_STAGED_PARTIES WHERE ROWID=rid;');

4425: l(' RETURN NULL;');
4426: l(' END;');
4427: ELSE
4428: l(' CURSOR P IS');
4429: l(' SELECT '||proc_cols||' FROM '||uname||'.HZ_STAGED_PARTIES WHERE ROWID=rid;');
4430: l(' val CLOB;');
4431: l(' BEGIN');
4432: l(' val:=null;');
4433: l(' FOR rec in P LOOP');

Line 5207: l(' log (''Inserting Data into HZ_STAGED_PARTIES...'',FALSE); ');

5203: l(' l_en := H_P_PARTY_ID.COUNT; ');
5204: l('');
5205: l(' IF p_operation = ''C'' THEN ');
5206: l(' BEGIN ');
5207: l(' log (''Inserting Data into HZ_STAGED_PARTIES...'',FALSE); ');
5208: l(' FORALL I in l_st..l_en SAVE EXCEPTIONS ');
5209: l(' INSERT INTO HZ_STAGED_PARTIES (');
5210: l(' PARTY_ID');
5211: l(' ,STATUS');

Line 5209: l(' INSERT INTO HZ_STAGED_PARTIES (');

5205: l(' IF p_operation = ''C'' THEN ');
5206: l(' BEGIN ');
5207: l(' log (''Inserting Data into HZ_STAGED_PARTIES...'',FALSE); ');
5208: l(' FORALL I in l_st..l_en SAVE EXCEPTIONS ');
5209: l(' INSERT INTO HZ_STAGED_PARTIES (');
5210: l(' PARTY_ID');
5211: l(' ,STATUS');
5212: l(' ,D_PS');
5213: l(' ,D_CT');

Line 5262: l(' log (''Updating Data in HZ_STAGED_PARTIES...'',FALSE); ');

5258: l(' END LOOP; ');
5259: l(' END; ');
5260: l(' ELSIF p_operation = ''U'' THEN ');
5261: l(' BEGIN ');
5262: l(' log (''Updating Data in HZ_STAGED_PARTIES...'',FALSE); ');
5263: l(' FORALL I in l_st..l_en SAVE EXCEPTIONS ');
5264: l(' UPDATE HZ_STAGED_PARTIES SET ');
5265: l(' status =H_STATUS(I) ');
5266: l(' ,concat_col = concat_col ');

Line 5264: l(' UPDATE HZ_STAGED_PARTIES SET ');

5260: l(' ELSIF p_operation = ''U'' THEN ');
5261: l(' BEGIN ');
5262: l(' log (''Updating Data in HZ_STAGED_PARTIES...'',FALSE); ');
5263: l(' FORALL I in l_st..l_en SAVE EXCEPTIONS ');
5264: l(' UPDATE HZ_STAGED_PARTIES SET ');
5265: l(' status =H_STATUS(I) ');
5266: l(' ,concat_col = concat_col ');
5267:
5268: FOR I IN 1..255 LOOP

Line 5594: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');

5590: END LOOP;
5591:
5592: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
5593: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5594: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5595: l(' WHERE sp.party_id = p.party_id) ' );
5596: l(' AND p.party_id = op.party_id ');
5597: l(' AND op.effective_end_date is NULL ');
5598: l(' AND p.PARTY_TYPE =''ORGANIZATION''; ');

Line 5609: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');

5605: END IF;
5606: END LOOP;
5607: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
5608: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5609: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5610: l(' WHERE sp.party_id = p.party_id) ' );
5611: l(' AND p.party_id = pe.party_id ');
5612: l(' AND pe.effective_end_date is NULL ');
5613: l(' AND p.PARTY_TYPE =''PERSON''; ');

Line 5624: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');

5620: END IF;
5621: END LOOP;
5622: l(' FROM HZ_PARTIES p ');
5623: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5624: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5625: l(' WHERE sp.party_id = p.party_id) ' );
5626: l(' AND p.party_type <> ''PERSON'' ');
5627: l(' AND p.party_type <> ''ORGANIZATION'' ');
5628: l(' AND p.party_type <> ''PARTY_RELATIONSHIP''; ');

Line 5740: l(' INSERT INTO HZ_STAGED_PARTIES (');

5736: l(' l_en := H_P_PARTY_ID.COUNT; ');
5737: l(' LOOP ');
5738: l(' BEGIN ');
5739: l(' FORALL I in l_st..l_en');
5740: l(' INSERT INTO HZ_STAGED_PARTIES (');
5741: l(' PARTY_ID');
5742: l(' ,STATUS');
5743: FOR I IN 1..255 LOOP
5744: IF l_forall_list(I) <> 'N' THEN

Line 5770: l(' UPDATE HZ_STAGED_PARTIES SET ');

5766: l(' insert_stage_contacts;');
5767: l(' insert_stage_party_sites;');
5768: l(' insert_stage_contact_pts;');
5769: l(' FORALL I in H_P_PARTY_ID.FIRST..H_P_PARTY_ID.LAST');
5770: l(' UPDATE HZ_STAGED_PARTIES SET ');
5771: l(' D_PS = H_PS_DEN(I),');
5772: l(' D_CT = H_CT_DEN(I),');
5773: l(' D_CPT = H_CPT_DEN(I)');
5774: l(' WHERE PARTY_ID = H_P_PARTY_ID(I);');

Line 5902: l(' INSERT INTO HZ_STAGED_PARTIES (');

5898: l(' WHILE (l_tryins OR l_tryupd) LOOP');
5899: l(' IF l_tryins THEN');
5900: l(' BEGIN');
5901: l(' l_tryins:=FALSE;');
5902: l(' INSERT INTO HZ_STAGED_PARTIES (');
5903: l(' PARTY_ID');
5904: l(' ,STATUS');
5905: l(' ,D_PS');
5906: l(' ,D_CT');

Line 5935: l(' UPDATE HZ_STAGED_PARTIES SET ');

5931: l(' END IF;');
5932: l(' IF l_tryupd THEN');
5933: l(' BEGIN');
5934: l(' l_tryupd:=FALSE;');
5935: l(' UPDATE HZ_STAGED_PARTIES SET ');
5936: l(' status =H_STATUS(1) ');
5937: l(' ,concat_col = concat_col ');
5938: FOR I IN 1..255 LOOP
5939: IF l_forall_list(I) <> 'N' THEN

Line 6119: l(' INSERT INTO HZ_STAGED_PARTIES (');

6115: l(' WHILE (l_tryins OR l_tryupd) LOOP');
6116: l(' IF l_tryins THEN');
6117: l(' BEGIN');
6118: l(' l_tryins:=FALSE;');
6119: l(' INSERT INTO HZ_STAGED_PARTIES (');
6120: l(' PARTY_ID');
6121: l(' ,STATUS');
6122: l(' ,D_PS');
6123: l(' ,D_CT');

Line 6153: l(' UPDATE HZ_STAGED_PARTIES SET ');

6149: l('');
6150: l(' IF l_tryupd THEN');
6151: l(' BEGIN');
6152: l(' l_tryupd:=FALSE;');
6153: l(' UPDATE HZ_STAGED_PARTIES SET ');
6154: l(' concat_col = concat_col ');
6155: l(' ,status =H_STATUS(1) ');
6156: FOR I IN 1..255 LOOP
6157: IF l_forall_list(I) <> 'N' THEN

Line 6696: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');

6692: l(' END; ');
6693: l(' END IF;');
6694: l('');
6695: l(' IF l_last_fetch THEN');
6696: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');
6697: l(' -- PARTY_SITES (in this case), have been inserted/updated ');
6698: l('');
6699: l(' log (''Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
6700: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');

Line 6699: l(' log (''Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');

6695: l(' IF l_last_fetch THEN');
6696: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');
6697: l(' -- PARTY_SITES (in this case), have been inserted/updated ');
6698: l('');
6699: l(' log (''Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
6700: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
6701: l(' FORALL I IN H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST ');
6702: l(' UPDATE HZ_STAGED_PARTIES set ');
6703: l(' D_PS = ''SYNC'' ');

Line 6702: l(' UPDATE HZ_STAGED_PARTIES set ');

6698: l('');
6699: l(' log (''Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
6700: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
6701: l(' FORALL I IN H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST ');
6702: l(' UPDATE HZ_STAGED_PARTIES set ');
6703: l(' D_PS = ''SYNC'' ');
6704: l(' ,CONCAT_COL = CONCAT_COL ');
6705: l(' WHERE PARTY_ID = H_PS_PARTY_ID(I); ');
6706: l(' log (''Done''); ');

Line 7232: l(' UPDATE HZ_STAGED_PARTIES set ');

7228: l(' END;');
7229: l(' END IF;');
7230: l(' END LOOP;');
7231: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
7232: l(' UPDATE HZ_STAGED_PARTIES set ');
7233: l(' D_PS = ''SYNC'' ');
7234: l(' ,CONCAT_COL = CONCAT_COL ');
7235: l(' WHERE PARTY_ID = H_PARTY_ID(1); ');
7236: l(' END;');

Line 7425: l(' UPDATE HZ_STAGED_PARTIES set');

7421: l(' END IF;');
7422: l(' END LOOP;');
7423: l('');
7424: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
7425: l(' UPDATE HZ_STAGED_PARTIES set');
7426: l(' D_PS = ''SYNC''');
7427: l(' ,CONCAT_COL = CONCAT_COL ');
7428: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
7429: l('');

Line 8005: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');

8001: l(' END; ');
8002: l(' END IF;');
8003: l('');
8004: l(' IF l_last_fetch THEN');
8005: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');
8006: l(' -- CONTACTS (in this case), have been inserted/updated ');
8007: l('');
8008: l(' log (''Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
8009: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');

Line 8008: l(' log (''Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');

8004: l(' IF l_last_fetch THEN');
8005: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');
8006: l(' -- CONTACTS (in this case), have been inserted/updated ');
8007: l('');
8008: l(' log (''Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
8009: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
8010: l(' FORALL I IN H_ORG_CONTACT_ID.FIRST..H_ORG_CONTACT_ID.LAST ');
8011: l(' UPDATE HZ_STAGED_PARTIES set ');
8012: l(' D_CT = ''SYNC'' ');

Line 8011: l(' UPDATE HZ_STAGED_PARTIES set ');

8007: l('');
8008: l(' log (''Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
8009: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
8010: l(' FORALL I IN H_ORG_CONTACT_ID.FIRST..H_ORG_CONTACT_ID.LAST ');
8011: l(' UPDATE HZ_STAGED_PARTIES set ');
8012: l(' D_CT = ''SYNC'' ');
8013: l(' ,CONCAT_COL = CONCAT_COL ');
8014: l(' WHERE PARTY_ID = H_C_PARTY_ID(I); ');
8015: l(' log (''Done''); ');

Line 8545: l(' UPDATE HZ_STAGED_PARTIES set');

8541: l(' END;');
8542: l(' END IF;');
8543: l(' END LOOP;');
8544: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
8545: l(' UPDATE HZ_STAGED_PARTIES set');
8546: l(' D_CT = ''SYNC''');
8547: l(' ,CONCAT_COL = CONCAT_COL ');
8548: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
8549: l(' END;');

Line 8717: l(' UPDATE HZ_STAGED_PARTIES set');

8713: l(' END IF;');
8714: l(' END LOOP;');
8715: l('');
8716: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
8717: l(' UPDATE HZ_STAGED_PARTIES set');
8718: l(' D_CT = ''SYNC''');
8719: l(' ,CONCAT_COL = CONCAT_COL ');
8720: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
8721: l('');

Line 9278: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');

9274: l(' END; ');
9275: l(' END IF;');
9276: l('');
9277: l(' IF l_last_fetch THEN');
9278: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');
9279: l(' -- CONTACT_POINTS (in this case), have been inserted/updated ');
9280: l('');
9281: l(' log (''Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
9282: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');

Line 9281: l(' log (''Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');

9277: l(' IF l_last_fetch THEN');
9278: l(' -- Update HZ_STAGED_PARTIES, if corresponding child entity records ');
9279: l(' -- CONTACT_POINTS (in this case), have been inserted/updated ');
9280: l('');
9281: l(' log (''Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
9282: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
9283: l(' FORALL I IN H_CONTACT_POINT_ID.FIRST..H_CONTACT_POINT_ID.LAST ');
9284: l(' UPDATE HZ_STAGED_PARTIES set ');
9285: l(' D_CPT = ''SYNC'' ');

Line 9284: l(' UPDATE HZ_STAGED_PARTIES set ');

9280: l('');
9281: l(' log (''Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...'',FALSE); ');
9282: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
9283: l(' FORALL I IN H_CONTACT_POINT_ID.FIRST..H_CONTACT_POINT_ID.LAST ');
9284: l(' UPDATE HZ_STAGED_PARTIES set ');
9285: l(' D_CPT = ''SYNC'' ');
9286: l(' ,CONCAT_COL = CONCAT_COL ');
9287: l(' WHERE PARTY_ID = H_CPT_PARTY_ID(I); ');
9288: l(' log (''Done''); ');

Line 9820: l(' UPDATE HZ_STAGED_PARTIES set');

9816: l(' END;');
9817: l(' END IF;');
9818: l(' END LOOP;');
9819: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
9820: l(' UPDATE HZ_STAGED_PARTIES set');
9821: l(' D_CPT = ''SYNC''');
9822: l(' ,CONCAT_COL = CONCAT_COL ');
9823: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
9824: l(' END;');

Line 10043: l(' UPDATE HZ_STAGED_PARTIES set');

10039: l(' END IF;');
10040: l(' END LOOP;');
10041: l('');
10042: l(' --Fix for bug 5048604, to update concat_col during update of denorm column ');
10043: l(' UPDATE HZ_STAGED_PARTIES set');
10044: l(' D_CPT = ''SYNC''');
10045: l(' ,CONCAT_COL = CONCAT_COL ');
10046: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
10047: l('');

Line 10204: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');

10200: FOR I in 1..l_org_select.COUNT LOOP
10201: l(' ,' || l_org_select(I));
10202: END LOOP;
10203:
10204: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
10205: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10206: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10207: l(' AND p.party_id = op.party_id ');
10208: l(' AND op.effective_end_date is NULL; ');

Line 10215: l(' FROM HZ_STAGED_PARTIES s,HZ_PARTIES p, HZ_PERSON_PROFILES pe ');

10211: l(' SELECT p.PARTY_ID ');
10212: FOR I in 1..l_per_select.COUNT LOOP
10213: l(' ,' || l_per_select(I));
10214: END LOOP;
10215: l(' FROM HZ_STAGED_PARTIES s,HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
10216: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10217: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10218: l(' AND p.party_id = pe.party_id ');
10219: l(' AND pe.effective_end_date is NULL; ');

Line 10226: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p ');

10222: l(' SELECT p.PARTY_ID ');
10223: FOR I in 1..l_oth_select.COUNT LOOP
10224: l(' ,' || l_oth_select(I));
10225: END LOOP;
10226: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p ');
10227: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10228: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10229: l(' AND p.party_type <> ''PERSON'' ');
10230: l(' AND p.party_type <> ''ORGANIZATION'' ');

Line 10305: l(' UPDATE HZ_STAGED_PARTIES SET ');

10301: END LOOP;
10302: l(' END LOOP;');
10303:
10304: l(' FORALL I in H_PARTY_ID.FIRST..H_PARTY_ID.LAST');
10305: l(' UPDATE HZ_STAGED_PARTIES SET ');
10306: FIRST:=TRUE;
10307: FOR I IN 1..255 LOOP
10308: IF l_forall_list(I) <> 'N' THEN
10309: IF (FIRST) THEN

Line 10555: -- ADD CODE FOR UPDATING HZ_STAGED_PARTIES IF THERE ARE ANY NEW CONTACT DENORM ATTRIBUTES

10551: END IF;
10552: END LOOP;
10553:
10554: l(' WHERE ORG_CONTACT_ID = H_ORG_CONTACT_ID(I)');
10555: -- ADD CODE FOR UPDATING HZ_STAGED_PARTIES IF THERE ARE ANY NEW CONTACT DENORM ATTRIBUTES
10556: IF get_missing_denorm_attrib_cols('CONTACTS') IS NOT NULL
10557: THEN
10558: l('RETURNING PARTY_ID, ');
10559: l(get_missing_denorm_attrib_cols('CONTACTS'));

Line 10561: -- AND UPDATE THESE PARTY IDS IN HZ_STAGED_PARTIES, BY APPENDING TO THE D_CT COLUMNS

10557: THEN
10558: l('RETURNING PARTY_ID, ');
10559: l(get_missing_denorm_attrib_cols('CONTACTS'));
10560: -- THIS BULK COLLECT WILL CHOSE THE PARTY ID COLUMNS OF THE ROWS THAT ARE UPDATED
10561: -- AND UPDATE THESE PARTY IDS IN HZ_STAGED_PARTIES, BY APPENDING TO THE D_CT COLUMNS
10562: -- VALUES FROM THE NEW DENORM ATTRIBUTE COLUMNS
10563: l('BULK COLLECT INTO H_DENORM_PARTY_ID, H_DENORM_VALUE ;');
10564: l('LOOP');
10565: l('BEGIN');

Line 10567: l(' UPDATE HZ_STAGED_PARTIES');

10563: l('BULK COLLECT INTO H_DENORM_PARTY_ID, H_DENORM_VALUE ;');
10564: l('LOOP');
10565: l('BEGIN');
10566: l(' FORALL I IN H_ROW_OFFSET..H_DENORM_PARTY_ID.COUNT');
10567: l(' UPDATE HZ_STAGED_PARTIES');
10568: l(' SET D_CT = D_CT||'' ''||H_DENORM_VALUE(I)');
10569: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(I) AND D_CT <> ''SYNC'' ;');
10570: l('EXIT ;');
10571: l('EXCEPTION');

Line 10574: l(' UPDATE HZ_STAGED_PARTIES');

10570: l('EXIT ;');
10571: l('EXCEPTION');
10572: l('WHEN OTHERS THEN');
10573: l(' H_ROW_OFFSET := H_ROW_OFFSET+SQL%ROWCOUNT;');
10574: l(' UPDATE HZ_STAGED_PARTIES');
10575: l(' SET D_CT = ''SYNC'' ');
10576: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(H_ROW_OFFSET) ;');
10577: l(' H_ROW_OFFSET := H_ROW_OFFSET+1 ;');
10578: l('END ;');

Line 10635: l(' UPDATE HZ_STAGED_PARTIES');

10631:
10632: l('LOOP');
10633: l('BEGIN');
10634: l(' FORALL I IN H_ROW_OFFSET..H_DENORM_PARTY_ID.COUNT');
10635: l(' UPDATE HZ_STAGED_PARTIES');
10636: l(' SET D_CT = D_CT||'' ''||H_DENORM_VALUE(I)');
10637: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(I) AND D_CT <> ''SYNC'' ;');
10638: l('EXIT ;');
10639: l('EXCEPTION');

Line 10642: l(' UPDATE HZ_STAGED_PARTIES');

10638: l('EXIT ;');
10639: l('EXCEPTION');
10640: l('WHEN OTHERS THEN');
10641: l(' H_ROW_OFFSET := H_ROW_OFFSET+SQL%ROWCOUNT;');
10642: l(' UPDATE HZ_STAGED_PARTIES');
10643: l(' SET D_CT = ''SYNC'' ');
10644: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(H_ROW_OFFSET) ;');
10645: l(' H_ROW_OFFSET := H_ROW_OFFSET+1 ;');
10646: l('END ;');

Line 10882: -- ADD CODE FOR UPDATING HZ_STAGED_PARTIES IF THERE ARE ANY NEW PARTY SITE DENORM ATTRIBUTES

10878: END IF;
10879: END LOOP;
10880: l(' WHERE PARTY_SITE_ID=H_PARTY_SITE_ID(I)');
10881:
10882: -- ADD CODE FOR UPDATING HZ_STAGED_PARTIES IF THERE ARE ANY NEW PARTY SITE DENORM ATTRIBUTES
10883: IF get_missing_denorm_attrib_cols('PARTY_SITES') IS NOT NULL
10884: THEN
10885: l('RETURNING PARTY_ID, ');
10886: l(get_missing_denorm_attrib_cols('PARTY_SITES'));

Line 10888: -- AND UPDATE THESE PARTY IDS IN HZ_STAGED_PARTIES, BY APPENDING TO THE D_PS COLUMNS

10884: THEN
10885: l('RETURNING PARTY_ID, ');
10886: l(get_missing_denorm_attrib_cols('PARTY_SITES'));
10887: -- THIS BULK COLLECT WILL CHOSE THE PARTY ID COLUMNS OF THE ROWS THAT ARE UPDATED
10888: -- AND UPDATE THESE PARTY IDS IN HZ_STAGED_PARTIES, BY APPENDING TO THE D_PS COLUMNS
10889: -- VALUES FROM THE NEW DENORM ATTRIBUTE COLUMNS
10890: l('BULK COLLECT INTO H_DENORM_PARTY_ID, H_DENORM_VALUE ;');
10891: l('LOOP');
10892: l('BEGIN');

Line 10894: l(' UPDATE HZ_STAGED_PARTIES');

10890: l('BULK COLLECT INTO H_DENORM_PARTY_ID, H_DENORM_VALUE ;');
10891: l('LOOP');
10892: l('BEGIN');
10893: l(' FORALL I IN H_ROW_OFFSET..H_DENORM_PARTY_ID.COUNT');
10894: l(' UPDATE HZ_STAGED_PARTIES');
10895: l(' SET D_PS = D_PS||'' ''||H_DENORM_VALUE(I)');
10896: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(I) AND D_PS <> ''SYNC'' ;');
10897: l('EXIT ;');
10898: l('EXCEPTION');

Line 10901: l(' UPDATE HZ_STAGED_PARTIES');

10897: l('EXIT ;');
10898: l('EXCEPTION');
10899: l('WHEN OTHERS THEN');
10900: l(' H_ROW_OFFSET := H_ROW_OFFSET+SQL%ROWCOUNT;');
10901: l(' UPDATE HZ_STAGED_PARTIES');
10902: l(' SET D_PS = ''SYNC'' ');
10903: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(H_ROW_OFFSET) ;');
10904: l(' H_ROW_OFFSET := H_ROW_OFFSET+1;');
10905: l('END ; ');

Line 10960: l(' UPDATE HZ_STAGED_PARTIES');

10956:
10957: l('LOOP');
10958: l('BEGIN');
10959: l(' FORALL I IN H_ROW_OFFSET..H_DENORM_PARTY_ID.COUNT');
10960: l(' UPDATE HZ_STAGED_PARTIES');
10961: l(' SET D_PS = D_PS||'' ''||H_DENORM_VALUE(I)');
10962: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(I) AND D_PS <> ''SYNC'' ;');
10963: l('EXIT ;');
10964: l('EXCEPTION');

Line 10967: l(' UPDATE HZ_STAGED_PARTIES');

10963: l('EXIT ;');
10964: l('EXCEPTION');
10965: l('WHEN OTHERS THEN');
10966: l(' H_ROW_OFFSET := H_ROW_OFFSET+SQL%ROWCOUNT;');
10967: l(' UPDATE HZ_STAGED_PARTIES');
10968: l(' SET D_PS = ''SYNC'' ');
10969: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(H_ROW_OFFSET) ;');
10970: l(' H_ROW_OFFSET := H_ROW_OFFSET+1 ;');
10971: l('END ;');

Line 11198: -- ADD CODE FOR UPDATING HZ_STAGED_PARTIES IF THERE ARE ANY NEW CONTACT POINT DENORM ATTRIBUTES

11194: END IF;
11195: END LOOP;
11196: l(' WHERE CONTACT_POINT_ID = H_CONTACT_POINT_ID(I)');
11197:
11198: -- ADD CODE FOR UPDATING HZ_STAGED_PARTIES IF THERE ARE ANY NEW CONTACT POINT DENORM ATTRIBUTES
11199: IF get_missing_denorm_attrib_cols('CONTACT_POINTS') IS NOT NULL
11200: THEN
11201: l('RETURNING PARTY_ID, ');
11202: l(get_missing_denorm_attrib_cols('CONTACT_POINTS'));

Line 11204: -- AND UPDATE THESE PARTY IDS IN HZ_STAGED_PARTIES, BY APPENDING TO THE D_CPT COLUMNS

11200: THEN
11201: l('RETURNING PARTY_ID, ');
11202: l(get_missing_denorm_attrib_cols('CONTACT_POINTS'));
11203: -- THIS BULK COLLECT WILL CHOSE THE PARTY ID COLUMNS OF THE ROWS THAT ARE UPDATED
11204: -- AND UPDATE THESE PARTY IDS IN HZ_STAGED_PARTIES, BY APPENDING TO THE D_CPT COLUMNS
11205: -- VALUES FROM THE NEW DENORM ATTRIBUTE COLUMNS
11206: l('BULK COLLECT INTO H_DENORM_PARTY_ID, H_DENORM_VALUE ;');
11207: l('LOOP');
11208: l('BEGIN');

Line 11210: l(' UPDATE HZ_STAGED_PARTIES');

11206: l('BULK COLLECT INTO H_DENORM_PARTY_ID, H_DENORM_VALUE ;');
11207: l('LOOP');
11208: l('BEGIN');
11209: l(' FORALL I IN H_ROW_OFFSET..H_DENORM_PARTY_ID.COUNT');
11210: l(' UPDATE HZ_STAGED_PARTIES');
11211: l(' SET D_CPT = D_CPT||'' ''||H_DENORM_VALUE(I)');
11212: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(I) AND D_CPT <> ''SYNC'' ;');
11213: l('EXIT ;');
11214: l('EXCEPTION');

Line 11217: l(' UPDATE HZ_STAGED_PARTIES');

11213: l('EXIT ;');
11214: l('EXCEPTION');
11215: l('WHEN OTHERS THEN');
11216: l(' H_ROW_OFFSET := H_ROW_OFFSET+SQL%ROWCOUNT;');
11217: l(' UPDATE HZ_STAGED_PARTIES');
11218: l(' SET D_CPT = ''SYNC'' ');
11219: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(H_ROW_OFFSET) ;');
11220: l(' H_ROW_OFFSET := H_ROW_OFFSET+1 ;');
11221: l('END ;');

Line 11275: l(' UPDATE HZ_STAGED_PARTIES');

11271:
11272: l('LOOP');
11273: l('BEGIN');
11274: l(' FORALL I IN H_ROW_OFFSET..H_DENORM_PARTY_ID.COUNT');
11275: l(' UPDATE HZ_STAGED_PARTIES');
11276: l(' SET D_CPT = D_CPT||'' ''||H_DENORM_VALUE(I)');
11277: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(I) AND D_CPT <> ''SYNC'' ;');
11278: l('EXIT ;');
11279: l('EXCEPTION');

Line 11282: l(' UPDATE HZ_STAGED_PARTIES');

11278: l('EXIT ;');
11279: l('EXCEPTION');
11280: l('WHEN OTHERS THEN');
11281: l(' H_ROW_OFFSET := H_ROW_OFFSET+SQL%ROWCOUNT;');
11282: l(' UPDATE HZ_STAGED_PARTIES');
11283: l(' SET D_CPT = ''SYNC'' ');
11284: l(' WHERE PARTY_ID = H_DENORM_PARTY_ID(H_ROW_OFFSET) ;');
11285: l(' H_ROW_OFFSET := H_ROW_OFFSET+1 ;');
11286: l('END ;');

Line 11310: SELECT decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

11306: IS
11307: l_index_owner VARCHAR2(255);
11308:
11309: CURSOR indexes_reqd IS
11310: SELECT decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',
11311: 'PARTY_SITES','HZ_STAGED_PARTY_SITES','CONTACTS','HZ_STAGED_CONTACTS',
11312: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS')||'_N0'||substrb(staged_attribute_column,3) index_name,
11313: decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',
11314: 'PARTY_SITES','HZ_STAGED_PARTY_SITES','CONTACTS','HZ_STAGED_CONTACTS',

Line 11313: decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

11309: CURSOR indexes_reqd IS
11310: SELECT decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',
11311: 'PARTY_SITES','HZ_STAGED_PARTY_SITES','CONTACTS','HZ_STAGED_CONTACTS',
11312: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS')||'_N0'||substrb(staged_attribute_column,3) index_name,
11313: decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',
11314: 'PARTY_SITES','HZ_STAGED_PARTY_SITES','CONTACTS','HZ_STAGED_CONTACTS',
11315: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS') table_name,
11316: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',
11317: 'PARTY_SITES','HZ_SRCH_PSITES','CONTACTS','HZ_SRCH_CONTACTS',