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 FND_GLOBAL

Line 81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
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');

Line 84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

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;');
88:

Line 86: 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;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');

Line 120: s1 := s1||fnd_global.local_chr(10)||s2;

116: column_indexed := has_index(e1,fk1,app_name,j1);
117: if(column_indexed = true) then
118: delete_template(e1, fk1, pk1, j1, pe1, fk_data_typ1, 'TRUE', s2, cnt);
119: if(s2 is not null) then
120: s1 := s1||fnd_global.local_chr(10)||s2;
121: cnt := cnt+1;
122: end if;
123: end if;
124: end loop;

Line 139: s1 := s1||fnd_global.local_chr(10)||s2;

135: column_indexed := has_index(e1,fk1,app_name,j1);
136: if(column_indexed = true) then
137: delete_template(e1, fk1, pk1, j1, pe1, fk_data_typ1,'TRUE', s2,cnt);
138: if(s2 is not null) then
139: s1 := s1||fnd_global.local_chr(10)||s2;
140: cnt := cnt+1;
141: end if;
142: end if;
143: end loop;

Line 149: stmt1:= stmt1||fnd_global.local_chr(10)||s1;

145: end if;
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 ');

Line 154: HZ_GEN_PLSQL.ADD_LINE(stmt3||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||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:

Line 160: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));

156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:
159: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
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 ';

Line 192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');

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||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');
194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');
195: HZ_GEN_PLSQL.ADD_LINE('end if;');
196:

Line 207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));

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');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

Line 378: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id

374: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY)
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

Line 398: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id

394: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY)
395: select to_number(batchid), pid, substr(a.party_name,1,250), a.party_number,
396: a.address1||','||a.city||','||a.state||','||a.country||' '||a.postal_code,
397: cp.PHONE_AREA_CODE||'-'||cp.PHONE_COUNTRY_CODE||'-'||cp.PHONE_NUMBER, a.country, 'IDENTIFIED',
398: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id
399: from hz_parties a , hz_contact_points cp where
400: a.party_id = pid and
401: cp.owner_table_id(+)= a.party_id and
402: cp.contact_point_type(+)='PHONE' and

Line 424: x_sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id

420: PARTY_NAME,PARTY_NUMBER,ADDRESSES,PHONE_NUMBERS,COUNTRY,CREATION_DATE,
421: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY)
422: select to_number(batchid), p_id, app_id, substr(a.party_name,1,250), a.party_number,
423: null, null, null,
424: x_sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id
425: from hz_parties a where
426: a.party_id = p_id;
427: end loop;
428: close appl_trans;

Line 916: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id

912: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY)
913: select to_number('-1'), a.party_id, substr(a.party_name,1,250), a.party_number,
914: a.address1||','||a.city||','||a.state||','||a.country||' '||a.postal_code,
915: cp.PHONE_AREA_CODE||'-'||cp.PHONE_COUNTRY_CODE||'-'||cp.PHONE_NUMBER, a.country, 'IDENTIFIED',
916: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id
917: from hz_parties a , hz_contact_points cp where a.party_id = p_party_id and
918: cp.owner_table_id(+)=a.party_id and cp.contact_point_type(+)='PHONE' and cp.primary_flag(+)='Y' and
919: cp.owner_table_name(+)='HZ_PARTIES';
920:

Line 1494: s1:= s1||fnd_global.local_chr(10)||p1||

1490:
1491:
1492: p4:= ')';
1493:
1494: s1:= s1||fnd_global.local_chr(10)||p1||
1495: p2||fnd_global.local_chr(10)||p3||p4;
1496: else
1497: -- open cursor to get the second level tables, which have/not have HZ_PARTIES as parent_entity
1498: open x2(pe1);

Line 1495: p2||fnd_global.local_chr(10)||p3||p4;

1491:
1492: p4:= ')';
1493:
1494: s1:= s1||fnd_global.local_chr(10)||p1||
1495: p2||fnd_global.local_chr(10)||p3||p4;
1496: else
1497: -- open cursor to get the second level tables, which have/not have HZ_PARTIES as parent_entity
1498: open x2(pe1);
1499: loop

Line 1585: s1:=s1||fnd_global.local_chr(10)||p1||fnd_global.local_chr(10)||p2||fnd_global.local_chr(10)||p3||fnd_global.local_chr(10)||p4||

1581: end if;
1582: end if;
1583:
1584: p8:= '))';
1585: s1:=s1||fnd_global.local_chr(10)||p1||fnd_global.local_chr(10)||p2||fnd_global.local_chr(10)||p3||fnd_global.local_chr(10)||p4||
1586: fnd_global.local_chr(10)||p5||fnd_global.local_chr(10)||p6||fnd_global.local_chr(10)||p7||p8;
1587:
1588: else
1589:

Line 1586: fnd_global.local_chr(10)||p5||fnd_global.local_chr(10)||p6||fnd_global.local_chr(10)||p7||p8;

1582: end if;
1583:
1584: p8:= '))';
1585: s1:=s1||fnd_global.local_chr(10)||p1||fnd_global.local_chr(10)||p2||fnd_global.local_chr(10)||p3||fnd_global.local_chr(10)||p4||
1586: fnd_global.local_chr(10)||p5||fnd_global.local_chr(10)||p6||fnd_global.local_chr(10)||p7||p8;
1587:
1588: else
1589:
1590: if(cnt2>1) then

Line 1720: s1:=s1||fnd_global.local_chr(10)||p1||fnd_global.local_chr(10)||p2||fnd_global.local_chr(10)||p3||fnd_global.local_chr(10)||p4||fnd_global.local_chr(10)||p5||

1716: end if;
1717: end if;
1718:
1719: p12:= ')))';
1720: s1:=s1||fnd_global.local_chr(10)||p1||fnd_global.local_chr(10)||p2||fnd_global.local_chr(10)||p3||fnd_global.local_chr(10)||p4||fnd_global.local_chr(10)||p5||
1721: fnd_global.local_chr(10)||p6||fnd_global.local_chr(10)||p7||fnd_global.local_chr(10)||p8||fnd_global.local_chr(10)||p9||p10||
1722: p11||p12;
1723: end if;
1724:

Line 1721: fnd_global.local_chr(10)||p6||fnd_global.local_chr(10)||p7||fnd_global.local_chr(10)||p8||fnd_global.local_chr(10)||p9||p10||

1717: end if;
1718:
1719: p12:= ')))';
1720: s1:=s1||fnd_global.local_chr(10)||p1||fnd_global.local_chr(10)||p2||fnd_global.local_chr(10)||p3||fnd_global.local_chr(10)||p4||fnd_global.local_chr(10)||p5||
1721: fnd_global.local_chr(10)||p6||fnd_global.local_chr(10)||p7||fnd_global.local_chr(10)||p8||fnd_global.local_chr(10)||p9||p10||
1722: p11||p12;
1723: end if;
1724:
1725: end loop;

Line 1733: l_sql := l_sql||fnd_global.local_chr(10)||s1;

1729: end loop;
1730: close x2;
1731:
1732: end if;
1733: l_sql := l_sql||fnd_global.local_chr(10)||s1;
1734: valid_stmt:= has_context(l_sql);
1735: --valid_stmt:=true;
1736: if (valid_stmt=true) then
1737: --dbms_output.put_line('cnt='||cnt||',e1='||e1);