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_PURGE dependencies on HZ_PURGE_GT

Line 34: stmt1 varchar2(31000):= 'delete from hz_purge_gt temp where ';

30: and entity_name in('HZ_CUST_ACCOUNTS','HZ_CUST_ACCT_SITES_ALL','HZ_CUSTOMER_PROFILES') OR
31: (entity_name ='HZ_PARTY_RELATIONSHIPS' and fk_column_name<>'PARTY_ID') OR
32: (entity_name ='HZ_ORGANIZATION_PROFILES' and fk_column_name ='DISPLAYED_DUNS_PARTY_ID');
33:
34: stmt1 varchar2(31000):= 'delete from hz_purge_gt temp where ';
35: stmt2 varchar2(31000):= 'delete /*+ parallel(temp) */ from hz_purge_gt temp where ';
36: stmt3 varchar2(31000):= '';
37: stmt4 varchar2(31000):= '';
38: stmt5 varchar2(31000):= '';

Line 35: stmt2 varchar2(31000):= 'delete /+ parallel(temp) / from hz_purge_gt temp where ';

31: (entity_name ='HZ_PARTY_RELATIONSHIPS' and fk_column_name<>'PARTY_ID') OR
32: (entity_name ='HZ_ORGANIZATION_PROFILES' and fk_column_name ='DISPLAYED_DUNS_PARTY_ID');
33:
34: stmt1 varchar2(31000):= 'delete from hz_purge_gt temp where ';
35: stmt2 varchar2(31000):= 'delete /*+ parallel(temp) */ from hz_purge_gt temp where ';
36: stmt3 varchar2(31000):= '';
37: stmt4 varchar2(31000):= '';
38: stmt5 varchar2(31000):= '';
39: appid number(15);

Line 83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');

79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');
86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');

Line 150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');

146: end if;
147:
148: if (s1 is not null) then
149: stmt1:= stmt1||fnd_global.local_chr(10)||s1;
150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');
151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');

Line 152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';

148: if (s1 is not null) then
149: stmt1:= stmt1||fnd_global.local_chr(10)||s1;
150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');
151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');
155: HZ_GEN_PLSQL.ADD_LINE(' else ');
156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');

Line 164: stmt1 := 'delete from hz_purge_gt temp where ';

160: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
161: end if;
162: id := 1;
163: s1 := null;
164: stmt1 := 'delete from hz_purge_gt temp where ';
165: stmt3 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
166: END LOOP;
167: CLOSE app_id;
168:

Line 165: stmt3 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';

161: end if;
162: id := 1;
163: s1 := null;
164: stmt1 := 'delete from hz_purge_gt temp where ';
165: stmt3 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
166: END LOOP;
167: CLOSE app_id;
168:
169: OPEN app_id;

Line 187: stmt4 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp ';

183: cnt :=1;
184: delete_template(e1, fk1, pk1, j1, pe1, fk_data_typ1,'FALSE', s2,cnt);
185: if(s2 is not NULL) then
186: HZ_GEN_PLSQL.add_line('--'||e1||';'||fk1);
187: stmt4 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp ';
188: stmt5 := ' where not exists(select ''Y'' from hz_application_trans_gt appl where appl.app_id = '||appid||' and appl.party_id=temp.party_id) and ';
189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');

Line 205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');

201: end if;
202: END LOOP;
203: CLOSE app_id;
204: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');
206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');

Line 277: insert_stmt varchar2(5000):= 'insert into hz_purge_gt(party_id) select party_id from hz_parties where party_type<>''NULL'' ';

273: x_msg_count number;
274: x_msg_data varchar2(100);
275: request_id number;
276: where_clause varchar2(5000);
277: insert_stmt varchar2(5000):= 'insert into hz_purge_gt(party_id) select party_id from hz_parties where party_type<>''NULL'' ';
278: delete_stmt varchar2(5000):= 'delete from hz_purge_gt ';
279: time_stamp date;
280: mergedict_update_date date;
281: phone_number varchar2(100);

Line 278: delete_stmt varchar2(5000):= 'delete from hz_purge_gt ';

274: x_msg_data varchar2(100);
275: request_id number;
276: where_clause varchar2(5000);
277: insert_stmt varchar2(5000):= 'insert into hz_purge_gt(party_id) select party_id from hz_parties where party_type<>''NULL'' ';
278: delete_stmt varchar2(5000):= 'delete from hz_purge_gt ';
279: time_stamp date;
280: mergedict_update_date date;
281: phone_number varchar2(100);
282: candpartyid number;

Line 301: select h.party_id, p.party_name from hz_purge_gt h, hz_parties p where h.party_id=p.party_id;

297: l_schema VARCHAR2(255);
298: l_tmp VARCHAR2(2000);*/
299:
300: cursor printparties is
301: select h.party_id, p.party_name from hz_purge_gt h, hz_parties p where h.party_id=p.party_id;
302:
303: cursor time_stmp is
304: select to_date(timestamp,'YYYY-MM-DD:HH24:MI:SS') from sys.user_objects
305: where object_type='PACKAGE BODY' and status='VALID'and object_name='HZ_PURGE_GEN';

Line 314: select count(*) from hz_purge_gt;

310: cursor b1 is
311: select subset_sql, attributes_flag from hz_purge_batches where batch_id = to_number(batchid);
312:
313: cursor numparties is
314: select count(*) from hz_purge_gt;
315:
316: cursor appl_trans is
317: select distinct(app_id), party_id from hz_application_trans_gt;
318:

Line 320: select distinct(party_id) from hz_purge_gt;

316: cursor appl_trans is
317: select distinct(app_id), party_id from hz_application_trans_gt;
318:
319: cursor purge_parties is
320: select distinct(party_id) from hz_purge_gt;
321:
322: BEGIN
323: retcode:=0;
324:

Line 379: from hz_parties a , hz_purge_gt temp, hz_contact_points cp where

375: select to_number(batchid), a.party_id, substr(a.party_name,1,250), a.party_number,
376: a.address1||','||a.city||','||a.state||','||a.country||' '||a.postal_code,
377: cp.PHONE_AREA_CODE||'-'||cp.PHONE_COUNTRY_CODE||'-'||cp.PHONE_NUMBER, a.country, 'IDENTIFIED',
378: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id
379: from hz_parties a , hz_purge_gt temp, hz_contact_points cp where
380: temp.party_id = a.party_id and
381: cp.owner_table_id(+)=temp.party_id and
382: cp.contact_point_type(+)='PHONE' and
383: cp.owner_table_name(+)='HZ_PARTIES' and

Line 487: delete from hz_purge_gt;

483:
484: -- initialize API return status to success.
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487: delete from hz_purge_gt;
488: insert into hz_purge_gt(party_id) select party_id from hz_parties where party_id=partyid;
489: hz_purge_gen.identify_candidates(p_init_msg_list, x_return_status, x_msg_count, x_msg_data, true, false);
490: open party;
491: fetch party into party_count;

Line 488: insert into hz_purge_gt(party_id) select party_id from hz_parties where party_id=partyid;

484: -- initialize API return status to success.
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487: delete from hz_purge_gt;
488: insert into hz_purge_gt(party_id) select party_id from hz_parties where party_id=partyid;
489: hz_purge_gen.identify_candidates(p_init_msg_list, x_return_status, x_msg_count, x_msg_data, true, false);
490: open party;
491: fetch party into party_count;
492: if party_count>0 then

Line 1170: insert into hz_purge_gt(party_id) values(single_party);

1166: if parties_count1>0 then
1167: insert into hz_application_trans_gt(app_id) values(appid);
1168: if check_flag=true then
1169: --dbms_output.put_line('insert single party into table'||appid);
1170: insert into hz_purge_gt(party_id) values(single_party);
1171: end if;
1172: end if;
1173: end if;
1174:

Line 1486: l_sql := 'delete from hz_purge_gt temp where ';

1482: p3:=' ';
1483: end if;
1484:
1485: if(first = 'TRUE' AND cnt=1) then
1486: l_sql := 'delete from hz_purge_gt temp where ';
1487: p1:= ' exists (select ''Y'' from '||e1;
1488: p2:= ' xx where xx.'||fk1||' = '||partyid;
1489: if j1 is not null then
1490: p3:= ' and '||'('||p3||')';

Line 1493: l_sql := 'delete from hz_purge_gt temp where 1<>1 ';

1489: if j1 is not null then
1490: p3:= ' and '||'('||p3||')';
1491: end if;
1492: elsif (first = 'TRUE' AND cnt>1) then
1493: l_sql := 'delete from hz_purge_gt temp where 1<>1 ';
1494: p1:= ' or exists (select ''Y'' from '||e1;
1495: p2:= ' xx where xx.'||fk1||' = '||partyid;
1496: if j1 is not null then
1497: p3:= ' and '||'('||p3||')';

Line 1500: l_sql := 'delete from hz_purge_gt temp where ';

1496: if j1 is not null then
1497: p3:= ' and '||'('||p3||')';
1498: end if;
1499: elsif(first = 'FALSE' AND cnt=1) then
1500: l_sql := 'delete from hz_purge_gt temp where ';
1501: p1:= partyid||' in (select /*+ parallel(xx)*/ xx.'||fk1||' from '||e1;
1502: p2:= ' xx ';
1503: if j1 is not null then
1504: p3:= ' where '||'('||p3||')';

Line 1534: l_sql := 'delete from hz_purge_gt temp where ';

1530: p3:=' ';
1531: end if;
1532:
1533: if(first = 'TRUE' AND cnt=1) then
1534: l_sql := 'delete from hz_purge_gt temp where ';
1535: if(cnt2=1) then
1536: p1:= ' exists (select ''Y'' from '||e2;
1537: else
1538: p1:= ' or exists (select ''Y'' from '||e2;

Line 1546: l_sql := 'delete from hz_purge_gt temp where 1<>1 ';

1542: p3 := ' and '||'('||p3||')';
1543: end if;
1544: p4:= ' and exists' ;
1545: elsif (first = 'TRUE' AND cnt>1) then
1546: l_sql := 'delete from hz_purge_gt temp where 1<>1 ';
1547: p1:= ' or exists (select ''Y'' from '||e2;
1548: p2:= ' xx where xx.'||fk2||' = '||partyid;
1549: if j2 is not null then
1550: p3 := ' and '||'('||p3||')';

Line 1554: l_sql := 'delete from hz_purge_gt temp where ';

1550: p3 := ' and '||'('||p3||')';
1551: end if;
1552: p4:= ' and exists' ;
1553: elsif(first = 'FALSE' AND cnt=1) then
1554: l_sql := 'delete from hz_purge_gt temp where ';
1555: if(cnt2=1) then
1556: p1:= partyid||' in (select /*+ parallel (xx)*/ xx.'||fk2||' from '||e2;
1557: else
1558: p1:= ' or '||partyid||' in (select /*+ parallel (xx)*/ xx.'||fk2||' from '||e2;

Line 1634: l_sql := 'delete from hz_purge_gt temp where ';

1630: p3:='';
1631: end if;
1632:
1633: if(first = 'TRUE' AND cnt=1) then
1634: l_sql := 'delete from hz_purge_gt temp where ';
1635: if(cnt3=1) then
1636: p1:= ' exists (select ''Y'' from '||e3;
1637: else
1638: p1:= ' or exists (select ''Y'' from '||e3;

Line 1646: l_sql := 'delete from hz_purge_gt temp where 1<>1 ';

1642: p3:=' and '||'('||p3||')';
1643: end if;
1644: p4:= ' and exists ';
1645: elsif (first = 'TRUE' AND cnt>1) then
1646: l_sql := 'delete from hz_purge_gt temp where 1<>1 ';
1647: p1:= ' or exists (select ''Y'' from '||e3;
1648: p2:= ' xx where xx.'||fk3||' = '||partyid ;
1649: if j3 is not null then
1650: p3:=' and '||'('||p3||')';

Line 1655: l_sql := 'delete from hz_purge_gt temp where ';

1651: end if;
1652: p4:= ' and exists ';
1653: elsif(first = 'FALSE' AND cnt=1) then
1654: if(cnt3=1) then
1655: l_sql := 'delete from hz_purge_gt temp where ';
1656: p1:= partyid||' in (select /*+ parallel(xx)*/ ''Y'' from '||e3;
1657: else
1658: p1:= ' or '||partyid||' in (select /*+ parallel(xx)*/ ''Y'' from '||e3;
1659: end if;