APPS.HZ_PURGE_GEN dependencies on PON_BID_HEADERS

Line 1840: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id

1836:
1837: or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1838: )
1839:
1840: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1841: )
1842:
1843: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1844: );

Line 1843: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id

1839:
1840: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1841: )
1842:
1843: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1844: );
1845: else
1846: delete from hz_purge_gt temp where
1847:

Line 1876: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id

1872:
1873: or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1874: )
1875:
1876: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1877: )
1878:
1879: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1880: );

Line 1879: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id

1875:
1876: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1877: )
1878:
1879: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1880: );
1881: end if;
1882:
1883:

Line 4104: --PON_BID_HEADERS;SURROG_BID_CREATED_TP_ID

4100: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4101: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx
4102: );
4103: end if;
4104: --PON_BID_HEADERS;SURROG_BID_CREATED_TP_ID
4105: appid:=396;
4106: if(regid_proc = true) then
4107: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4108:

Line 4109: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx

4105: appid:=396;
4106: if(regid_proc = true) then
4107: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4108:
4109: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4110: );
4111: else
4112: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4113: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx

Line 4113: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx

4109: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4110: );
4111: else
4112: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4113: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4114: );
4115: end if;
4116: --PON_CONTRACTS;AUTHORING_PARTY_CONTACT_ID
4117: appid:=396;

Line 4392: --PON_BID_HEADERS;SURROG_BID_CREATED_CONTACT_ID

4388: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4389: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4390: );
4391: end if;
4392: --PON_BID_HEADERS;SURROG_BID_CREATED_CONTACT_ID
4393: appid:=396;
4394: if(regid_proc = true) then
4395: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4396:

Line 4397: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx

4393: appid:=396;
4394: if(regid_proc = true) then
4395: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4396:
4397: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4398: );
4399: else
4400: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4401: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx

Line 4401: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx

4397: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4398: );
4399: else
4400: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4401: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4402: );
4403: end if;
4404: --PON_BID_HEADERS;SCORE_OVERRIDE_TP_CONTACT_ID
4405: appid:=396;

Line 4404: --PON_BID_HEADERS;SCORE_OVERRIDE_TP_CONTACT_ID

4400: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4401: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4402: );
4403: end if;
4404: --PON_BID_HEADERS;SCORE_OVERRIDE_TP_CONTACT_ID
4405: appid:=396;
4406: if(regid_proc = true) then
4407: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4408:

Line 4409: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx

4405: appid:=396;
4406: if(regid_proc = true) then
4407: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4408:
4409: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4410: );
4411: else
4412: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4413: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx

Line 4413: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx

4409: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4410: );
4411: else
4412: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4413: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4414: );
4415: end if;
4416: --PON_BID_HEADERS;SHORTLIST_TPC_ID
4417: appid:=396;

Line 4416: --PON_BID_HEADERS;SHORTLIST_TPC_ID

4412: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4413: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4414: );
4415: end if;
4416: --PON_BID_HEADERS;SHORTLIST_TPC_ID
4417: appid:=396;
4418: if(regid_proc = true) then
4419: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4420:

Line 4421: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx

4417: appid:=396;
4418: if(regid_proc = true) then
4419: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4420:
4421: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4422: );
4423: else
4424: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4425: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx

Line 4425: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx

4421: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4422: );
4423: else
4424: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4425: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4426: );
4427: end if;
4428: --PON_BID_HEADERS;DRAFT_UNLOCKED_BY_CONTACT_ID
4429: appid:=396;

Line 4428: --PON_BID_HEADERS;DRAFT_UNLOCKED_BY_CONTACT_ID

4424: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4425: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4426: );
4427: end if;
4428: --PON_BID_HEADERS;DRAFT_UNLOCKED_BY_CONTACT_ID
4429: appid:=396;
4430: if(regid_proc = true) then
4431: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4432:

Line 4433: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

4429: appid:=396;
4430: if(regid_proc = true) then
4431: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4432:
4433: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4434: );
4435: else
4436: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4437: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

Line 4437: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

4433: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4434: );
4435: else
4436: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4437: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4438: );
4439: end if;
4440: --PON_BID_HEADERS;DRAFT_LOCKED_BY_CONTACT_ID
4441: appid:=396;

Line 4440: --PON_BID_HEADERS;DRAFT_LOCKED_BY_CONTACT_ID

4436: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4437: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4438: );
4439: end if;
4440: --PON_BID_HEADERS;DRAFT_LOCKED_BY_CONTACT_ID
4441: appid:=396;
4442: if(regid_proc = true) then
4443: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4444:

Line 4445: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

4441: appid:=396;
4442: if(regid_proc = true) then
4443: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4444:
4445: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4446: );
4447: else
4448: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4449: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

Line 4449: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

4445: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4446: );
4447: else
4448: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4449: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4450: );
4451: end if;
4452: --OKL_INS_POLICIES_ALL_B;INT_ID
4453: appid:=540;