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_PARTIES

Line 11: where parent_entity_name='HZ_PARTIES'

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:
15: cursor x1(app_id number) is --4500011

Line 17: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''

13: --and entity_name in (select table_name from fnd_tables);
14:
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

Line 26: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''

22:
23: cursor x4(app_id number) is --4500011
24: select decode(entity_name,'HZ_PARTY_RELATIONSHIPS','HZ_RELATIONSHIPS',entity_name) entity_name, fk_column_name,
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

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

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<>''PARTY_RELATIONSHIP'' ';
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 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 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 383: cp.owner_table_name(+)='HZ_PARTIES' and

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
384: cp.primary_flag(+)='Y';
385:
386: num_parties:=SQL%ROWCOUNT;*/
387:

Line 399: from hz_parties a , hz_contact_points cp where

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
403: cp.owner_table_name(+)='HZ_PARTIES' and

Line 403: cp.owner_table_name(+)='HZ_PARTIES' and

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
403: cp.owner_table_name(+)='HZ_PARTIES' and
404: cp.primary_flag(+)='Y';
405: end loop;
406: close purge_parties;
407:

Line 425: from hz_parties a where

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;
429: end if;

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 670: and OWNER_TABLE_NAME=''HZ_PARTIES'') and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;

666:
667: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
668: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
669: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
670: and OWNER_TABLE_NAME=''HZ_PARTIES'') and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;
671: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
672:
673: begin
674: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in

Line 677: and OWNER_TABLE_NAME=''HZ_PARTIES'')' using batchid;

673: begin
674: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
675: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
676: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
677: and OWNER_TABLE_NAME=''HZ_PARTIES'')' using batchid;
678: log(' HZ_STAGED_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
679: exception
680: when others then
681: null;

Line 686: and OWNER_TABLE_NAME='HZ_PARTIES';

682: end;
683:
684: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in
685: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')
686: and OWNER_TABLE_NAME='HZ_PARTIES';
687: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
688:
689: DELETE from HZ_PERSON_PROFILES where PARTY_ID in
690: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');

Line 747: and OWNER_TABLE_NAME=''HZ_PARTIES''' using batchid;

743: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
744: log(' HZ_INDUSTRIAL_REFERENCE : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
745: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
746: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
747: and OWNER_TABLE_NAME=''HZ_PARTIES''' using batchid;
748: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
749: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
750: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
751: and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using batchid;

Line 751: and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using batchid;

747: and OWNER_TABLE_NAME=''HZ_PARTIES''' using batchid;
748: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
749: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
750: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
751: and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using batchid;
752: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
753: execute immediate 'DELETE from HZ_ORIG_SYS_REFERENCES where party_id in
754: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'') ' using batchid;
755: log(' HZ_ORIG_SYS_REFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 820: DELETE from HZ_PARTIES where party_id in

816: from hz_code_assignments HCA
817: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
818: AND HCA.OWNER_TABLE_ID = PTP.PARTY_TAX_PROFILE_ID);
819:
820: DELETE from HZ_PARTIES where party_id in
821: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
822: log(' HZ_PARTIES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
823: fnd_file.close;
824:

Line 822: log(' HZ_PARTIES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

818: AND HCA.OWNER_TABLE_ID = PTP.PARTY_TAX_PROFILE_ID);
819:
820: DELETE from HZ_PARTIES where party_id in
821: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
822: log(' HZ_PARTIES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
823: fnd_file.close;
824:
825: --if the purged party is of type 'RELATIONSHIP' then set the corresponding value in the hz_relationships to null
826:

Line 828: (select pur_cand.candidate_party_id from hz_purge_candidates pur_cand, hz_parties parties where pur_cand.batch_id=:1 and

824:
825: --if the purged party is of type 'RELATIONSHIP' then set the corresponding value in the hz_relationships to null
826:
827: execute immediate 'update hz_relationships set party_id=null where party_id in
828: (select pur_cand.candidate_party_id from hz_purge_candidates pur_cand, hz_parties parties where pur_cand.batch_id=:1 and
829: pur_cand.candidate_party_id = parties.party_id and parties.party_type=''PARTY_RELATIONSHIP'' )' using batchid;
830:
831: -- bug 4947069
832:

Line 917: from hz_parties a , hz_contact_points cp where a.party_id = p_party_id and

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:
921: hz_common_pub.disable_cont_source_security;

Line 919: cp.owner_table_name(+)='HZ_PARTIES';

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:
921: hz_common_pub.disable_cont_source_security;
922:
923: DELETE from HZ_ORGANIZATION_PROFILES where PARTY_ID = p_party_id;

Line 978: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')

974:
975: DELETE from HZ_PARTY_SITES where PARTY_ID = p_party_id;
976:
977: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
978: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')
979: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
980:
981: begin
982: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in

Line 983: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')' using p_party_id;

979: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
980:
981: begin
982: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
983: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')' using p_party_id;
984: exception
985: when others then
986: null;
987: end;

Line 989: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID = p_party_id and OWNER_TABLE_NAME='HZ_PARTIES';

985: when others then
986: null;
987: end;
988:
989: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID = p_party_id and OWNER_TABLE_NAME='HZ_PARTIES';
990:
991: DELETE from HZ_PERSON_PROFILES where PARTY_ID = p_party_id;
992:
993: DELETE from HZ_FINANCIAL_PROFILE where PARTY_ID = p_party_id;

Line 1025: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES''' using p_party_id;

1021: DELETE from HZ_EDUCATION where PARTY_ID = p_party_id;
1022:
1023: DELETE from HZ_INDUSTRIAL_REFERENCE where PARTY_ID = p_party_id;
1024:
1025: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES''' using p_party_id;
1026:
1027: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID = :1 and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using p_party_id;
1028:
1029: execute immediate 'DELETE from HZ_ORIG_SYS_REFERENCES where party_id = :1' using p_party_id;

Line 1027: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID = :1 and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using p_party_id;

1023: DELETE from HZ_INDUSTRIAL_REFERENCE where PARTY_ID = p_party_id;
1024:
1025: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES''' using p_party_id;
1026:
1027: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID = :1 and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using p_party_id;
1028:
1029: execute immediate 'DELETE from HZ_ORIG_SYS_REFERENCES where party_id = :1' using p_party_id;
1030:
1031: begin

Line 1072: DELETE from HZ_PARTIES where party_id = p_party_id;

1068: from hz_code_assignments HCA
1069: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
1070: AND HCA.OWNER_TABLE_ID = PTP.PARTY_TAX_PROFILE_ID);
1071:
1072: DELETE from HZ_PARTIES where party_id = p_party_id;
1073:
1074: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED','BO_EVENTS_ENABLED')) THEN
1075:
1076: HZ_BES_BO_UTIL_PKG.del_obj_hierarchy(p_party_id);

Line 1082: (select party_id from hz_parties where party_type = ''PARTY_RELATIONSHIP'')' using p_party_id;

1078: END IF;
1079:
1080: /* if the purged party is of type 'RELATIONSHIP' then set the corresponding value in the hz_relationships to null */
1081: execute immediate 'update hz_relationships set party_id=null where party_id=:1 and party_id in
1082: (select party_id from hz_parties where party_type = ''PARTY_RELATIONSHIP'')' using p_party_id;
1083:
1084: -- bug 4947069
1085:
1086: delete from hz_relationships where (subject_id = p_party_id or object_id = p_party_id) and status = 'M';

Line 1442: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''

1438:
1439: cursor x2(parent varchar2) is --4500011
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

Line 1449: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''

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,
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:

Line 1455: if pe1='HZ_PARTIES' then

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 ';
1457: if (fk_data_typ1<>'NUMBER' AND fk_data_typ1 IS NOT NULL) then
1458: partyid := ' to_char(temp.party_id) ';
1459: end if;

Line 1497: -- open cursor to get the second level tables, which have/not have HZ_PARTIES as parent_entity

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
1500: fetch x2 into e2, fk2, pk2, j2, pe2,fk_data_typ2;
1501: exit when x2%NOTFOUND;

Line 1503: if pe2 = 'HZ_PARTIES' then

1499: loop
1500: fetch x2 into e2, fk2, pk2, j2, pe2,fk_data_typ2;
1501: exit when x2%NOTFOUND;
1502: cnt2:=cnt2+1;
1503: if pe2 = 'HZ_PARTIES' then
1504: partyid :=' temp.party_id ';
1505: if (fk_data_typ2<>'NUMBER' AND fk_data_typ2 IS NOT NULL) then
1506: partyid := ' to_char(temp.party_id) ';
1507: end if;

Line 1596: -- open cursor to get the third level tables, which have HZ_PARTIES as parent_entity

1592: else
1593: cnt3:=0;
1594: end if;
1595:
1596: -- open cursor to get the third level tables, which have HZ_PARTIES as parent_entity
1597: open x3(pe2);
1598: loop
1599: fetch x3 into e3, fk3, pk3, j3, pe3,fk_data_typ3;
1600: exit when x3%NOTFOUND;

Line 1602: if pe3 = 'HZ_PARTIES' then

1598: loop
1599: fetch x3 into e3, fk3, pk3, j3, pe3,fk_data_typ3;
1600: exit when x3%NOTFOUND;
1601: cnt3:=cnt3+1;
1602: if pe3 = 'HZ_PARTIES' then
1603: partyid :=' temp.party_id ';
1604:
1605: if (fk_data_typ3<>'NUMBER' AND fk_data_typ3 IS NOT NULL) then
1606: partyid := ' to_char(temp.party_id) ';