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_BATCHES

Line 311: select subset_sql, attributes_flag from hz_purge_batches where batch_id = to_number(batchid);

307: cursor dict_update_date is
308: select max(last_update_date) from hz_merge_dictionary;
309:
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:

Line 411: update hz_purge_batches set num_candidates=num_parties, num_marked=num_parties, status='IDENTIFICATION_COMPLETE' where batch_id=to_number(batchid);

407:
408: num_parties:= i;
409: --dbms_output.put_line('num_parties='||num_parties);
410:
411: update hz_purge_batches set num_candidates=num_parties, num_marked=num_parties, status='IDENTIFICATION_COMPLETE' where batch_id=to_number(batchid);
412: if(regid_flag=true) then
413: open appl_trans;
414: loop
415: FETCH appl_trans into app_id, p_id;

Line 445: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);

441: WHEN FND_API.G_EXC_ERROR THEN
442: retcode := 2;
443: errbuf := errbuf || logerror||SQLERRM;
444: FND_FILE.close;
445: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: retcode := 2;
448: errbuf := errbuf || logerror||SQLERRM;
449: FND_FILE.close;

Line 450: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);

446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: retcode := 2;
448: errbuf := errbuf || logerror||SQLERRM;
449: FND_FILE.close;
450: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);
451: WHEN OTHERS THEN
452: retcode := 2;
453: errbuf := errbuf || logerror||SQLERRM;
454: FND_FILE.close;

Line 455: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);

451: WHEN OTHERS THEN
452: retcode := 2;
453: errbuf := errbuf || logerror||SQLERRM;
454: FND_FILE.close;
455: update hz_purge_batches set status='IDENTIFICATION_ERROR' where batch_id=to_number(batchid);
456: END;
457:
458: /* To check if a single party has any transactions */
459:

Line 861: /* update the status of purged parties in table 'HZ_PURGE_BATCHES to 'PURGE_COMPLETED' */

857: update hz_purge_candidates set status='PURGED' where candidate_party_id in (
858: select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='PURGED')
859: and batch_id<>batchid;
860:
861: /* update the status of purged parties in table 'HZ_PURGE_BATCHES to 'PURGE_COMPLETED' */
862: update hz_purge_batches set status='PURGE_COMPLETE',purge_date=sysdate where batch_id=batchid;
863:
864: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
865:

Line 862: update hz_purge_batches set status='PURGE_COMPLETE',purge_date=sysdate where batch_id=batchid;

858: select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='PURGED')
859: and batch_id<>batchid;
860:
861: /* update the status of purged parties in table 'HZ_PURGE_BATCHES to 'PURGE_COMPLETED' */
862: update hz_purge_batches set status='PURGE_COMPLETE',purge_date=sysdate where batch_id=batchid;
863:
864: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
865:
866: begin

Line 882: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;

878: WHEN FND_API.G_EXC_ERROR THEN
879: retcode := 2;
880: errbuf := errbuf || logerror||SQLERRM;
881: FND_FILE.close;
882: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: retcode := 2;
885: errbuf := errbuf || logerror||SQLERRM;
886: FND_FILE.close;

Line 887: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;

883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: retcode := 2;
885: errbuf := errbuf || logerror||SQLERRM;
886: FND_FILE.close;
887: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;
888: WHEN OTHERS THEN
889: retcode := 2;
890: errbuf := errbuf || logerror||SQLERRM;
891: FND_FILE.close;

Line 892: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;

888: WHEN OTHERS THEN
889: retcode := 2;
890: errbuf := errbuf || logerror||SQLERRM;
891: FND_FILE.close;
892: update hz_purge_batches set status='PURGE_ERROR' where batch_id=batchid;
893:
894: END;
895:
896: /* Purge Single Party */