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_MERGE_DICTIONARY

Line 10: CURSOR app_id IS select distinct(dict_application_id) from hz_merge_dictionary

6: x_msg_count OUT NOCOPY NUMBER,
7: x_msg_data OUT NOCOPY VARCHAR2)
8: IS
9:
10: CURSOR app_id IS select distinct(dict_application_id) from hz_merge_dictionary
11: where parent_entity_name='HZ_PARTIES'
12: and nvl(validate_purge_flag,'Y') <> 'N'; --5125968
13: --and entity_name in (select table_name from fnd_tables);
14:

Line 19: from hz_merge_dictionary where parent_entity_name like 'HZ_%' and dict_application_id = app_id

15: cursor x1(app_id number) is --4500011
16: select decode(entity_name,'HZ_PARTY_RELATIONSHIPS','HZ_RELATIONSHIPS',entity_name) entity_name, fk_column_name, decode(entity_name,'HZ_PARTY_RELATIONSHIPS','RELATIONSHIP_ID',pk_column_name) pk_column_name,
17: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''
18: AND directional_flag = ''F''', join_clause) join_clause, parent_entity_name,fk_data_type
19: from hz_merge_dictionary where parent_entity_name like 'HZ_%' and dict_application_id = app_id
20: and fk_column_name IS NOT NULL and entity_name not in ('AS_CHANGED_ACCOUNTS_ALL','POS_PARTIES_V','POS_PARTY_SITES_V','WSH_LOCATION_OWNERS','ZX_PARTY_TAX_PROFILE','CE_BANKS_MERGE_V','CE_BANK_BRANCHES_MERGE_V','WSH_SUPPLIER_SF_SITES_V')
21: and nvl(validate_purge_flag,'Y') <> 'N'; --5125968
22:
23: cursor x4(app_id number) is --4500011

Line 29: from hz_merge_dictionary where parent_entity_name like 'HZ_%' and dict_application_id = app_id

25: decode(entity_name,'HZ_PARTY_RELATIONSHIPS','RELATIONSHIP_ID',pk_column_name) pk_column_name,
26: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''
27: AND directional_flag = ''F''', join_clause) join_clause,
28: parent_entity_name, fk_data_type
29: from hz_merge_dictionary where parent_entity_name like 'HZ_%' and dict_application_id = app_id
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:

Line 308: select max(last_update_date) from hz_merge_dictionary;

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

Line 342: /* Generate the body of the Package HZ_PURGE_GEN if last_update_date of hz_merge_dictionary

338: open dict_update_date;
339: fetch dict_update_date into mergedict_update_date;
340: close dict_update_date;
341:
342: /* Generate the body of the Package HZ_PURGE_GEN if last_update_date of hz_merge_dictionary
343: is greater than the package generation date*/
344:
345:
346: if (mergedict_update_date is null or time_stamp is null or mergedict_update_date>time_stamp) then

Line 1252: from hz_merge_dictionary

1248:
1249: PROCEDURE populate_fk_datatype IS
1250: cursor c_dict_no_fktype is
1251: select entity_name, fk_column_name, merge_dict_id, dict_application_id
1252: from hz_merge_dictionary
1253: where fk_data_type is null;
1254:
1255: l_sub_entity_name VARCHAR2(150);
1256: l_sub_fk_column_name VARCHAR2(150);

Line 1271: update hz_merge_dictionary

1267: EXIT WHEN c_dict_no_fktype%NOTFOUND;
1268: l_app_name := get_app_name(l_app_id);
1269: l_data_type:=hz_party_merge.get_col_type(l_sub_entity_name,l_sub_fk_column_name,l_app_name);
1270:
1271: update hz_merge_dictionary
1272: set fk_data_type = l_data_type
1273: where merge_dict_id = l_merge_dict_id;
1274:
1275: end loop;

Line 1444: from hz_merge_dictionary where entity_name = parent;

1440: select decode(entity_name,'HZ_PARTY_RELATIONSHIPS','HZ_RELATIONSHIPS',entity_name) entity_name, fk_column_name,
1441: decode(entity_name,'HZ_PARTY_RELATIONSHIPS','RELATIONSHIP_ID',pk_column_name) pk_column_name,
1442: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''
1443: AND directional_flag = ''F''', join_clause) join_clause, parent_entity_name,fk_data_type
1444: from hz_merge_dictionary where entity_name = parent;
1445:
1446: cursor x3(parent2 varchar2) is --4500011
1447: select decode(entity_name,'HZ_PARTY_RELATIONSHIPS','HZ_RELATIONSHIPS',entity_name) entity_name, fk_column_name,
1448: decode(entity_name,'HZ_PARTY_RELATIONSHIPS','RELATIONSHIP_ID',pk_column_name) pk_column_name,

Line 1452: from hz_merge_dictionary where entity_name = parent2;

1448: decode(entity_name,'HZ_PARTY_RELATIONSHIPS','RELATIONSHIP_ID',pk_column_name) pk_column_name,
1449: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''
1450: AND directional_flag = ''F''', join_clause) join_clause,
1451: parent_entity_name,fk_data_type
1452: from hz_merge_dictionary where entity_name = parent2;
1453:
1454: BEGIN
1455: if pe1='HZ_PARTIES' then
1456: partyid :=' temp.party_id ';