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_APPLICATION_TRANS_GT

Line 96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');

92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');
97: HZ_GEN_PLSQL.add_line('open repopulate;');
98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');
99: HZ_GEN_PLSQL.add_line('close repopulate;');
100: populate_fk_datatype;

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 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 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 ';

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 ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');

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 317: select distinct(app_id), party_id from hz_application_trans_gt;

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:
319: cursor purge_parties is
320: select distinct(party_id) from hz_purge_gt;
321:

Line 472: select count(*) from hz_application_trans_gt;

468: party_count number;
469: phone_number varchar2(75);
470:
471: cursor party is
472: select count(*) from hz_application_trans_gt;
473:
474: begin
475: null;
476: /*

Line 1157: select count(*) from hz_application_trans_gt where app_id=appid;

1153: parties_count1 NUMBER;
1154: appid_cnt NUMBER;
1155:
1156: cursor appid_count(appid NUMBER) IS
1157: select count(*) from hz_application_trans_gt where app_id=appid;
1158:
1159: BEGIN
1160:
1161: OPEN appid_count(appid);

Line 1167: insert into hz_application_trans_gt(app_id) values(appid);

1163: CLOSE appid_count;
1164: If(appid_cnt=0) then
1165: parties_count1:=SQL%ROWCOUNT;
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;