APPS.HZ_PURGE_GEN dependencies on PON_BID_HEADERS

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

1924:
1925: or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1926: )
1927:
1928: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1929: )
1930:
1931: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1932: );

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

1927:
1928: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1929: )
1930:
1931: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1932: );
1933: else
1934: delete from hz_purge_gt temp where
1935:

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

1963:
1964: or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1965: )
1966:
1967: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1968: )
1969:
1970: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1971: );

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

1966:
1967: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1968: )
1969:
1970: or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID = temp.party_id
1971: );
1972: end if;
1973:
1974:

Line 4204: --PON_BID_HEADERS;SURROG_BID_CREATED_TP_ID

4200: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4201: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx
4202: );
4203: end if;
4204: --PON_BID_HEADERS;SURROG_BID_CREATED_TP_ID
4205: appid:=396;
4206: if(regid_proc = true) then
4207: 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
4208:

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

4205: appid:=396;
4206: if(regid_proc = true) then
4207: 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
4208:
4209: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4210: );
4211: else
4212: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4213: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx

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

4209: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4210: );
4211: else
4212: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4213: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4214: );
4215: end if;
4216: --PON_CONTRACTS;AUTHORING_PARTY_CONTACT_ID
4217: appid:=396;

Line 4480: --PON_BID_HEADERS;SURROG_BID_CREATED_CONTACT_ID

4476: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4477: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4478: );
4479: end if;
4480: --PON_BID_HEADERS;SURROG_BID_CREATED_CONTACT_ID
4481: appid:=396;
4482: if(regid_proc = true) then
4483: 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
4484:

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

4481: appid:=396;
4482: if(regid_proc = true) then
4483: 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
4484:
4485: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4486: );
4487: else
4488: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4489: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx

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

4485: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4486: );
4487: else
4488: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4489: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4490: );
4491: end if;
4492: --PON_BID_HEADERS;SCORE_OVERRIDE_TP_CONTACT_ID
4493: appid:=396;

Line 4492: --PON_BID_HEADERS;SCORE_OVERRIDE_TP_CONTACT_ID

4488: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4489: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx
4490: );
4491: end if;
4492: --PON_BID_HEADERS;SCORE_OVERRIDE_TP_CONTACT_ID
4493: appid:=396;
4494: if(regid_proc = true) then
4495: 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
4496:

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

4493: appid:=396;
4494: if(regid_proc = true) then
4495: 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
4496:
4497: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4498: );
4499: else
4500: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4501: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx

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

4497: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4498: );
4499: else
4500: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4501: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4502: );
4503: end if;
4504: --PON_BID_HEADERS;SHORTLIST_TPC_ID
4505: appid:=396;

Line 4504: --PON_BID_HEADERS;SHORTLIST_TPC_ID

4500: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4501: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx
4502: );
4503: end if;
4504: --PON_BID_HEADERS;SHORTLIST_TPC_ID
4505: appid:=396;
4506: if(regid_proc = true) then
4507: 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
4508:

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

4505: appid:=396;
4506: if(regid_proc = true) then
4507: 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
4508:
4509: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4510: );
4511: else
4512: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4513: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx

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

4509: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4510: );
4511: else
4512: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4513: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4514: );
4515: end if;
4516: --PON_BID_HEADERS;DRAFT_UNLOCKED_BY_CONTACT_ID
4517: appid:=396;

Line 4516: --PON_BID_HEADERS;DRAFT_UNLOCKED_BY_CONTACT_ID

4512: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4513: temp.party_id in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx
4514: );
4515: end if;
4516: --PON_BID_HEADERS;DRAFT_UNLOCKED_BY_CONTACT_ID
4517: appid:=396;
4518: if(regid_proc = true) then
4519: 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
4520:

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

4517: appid:=396;
4518: if(regid_proc = true) then
4519: 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
4520:
4521: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4522: );
4523: else
4524: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4525: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

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

4521: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4522: );
4523: else
4524: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4525: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4526: );
4527: end if;
4528: --PON_BID_HEADERS;DRAFT_LOCKED_BY_CONTACT_ID
4529: appid:=396;

Line 4528: --PON_BID_HEADERS;DRAFT_LOCKED_BY_CONTACT_ID

4524: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4525: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4526: );
4527: end if;
4528: --PON_BID_HEADERS;DRAFT_LOCKED_BY_CONTACT_ID
4529: appid:=396;
4530: if(regid_proc = true) then
4531: 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
4532:

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

4529: appid:=396;
4530: if(regid_proc = true) then
4531: 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
4532:
4533: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4534: );
4535: else
4536: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4537: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx

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

4533: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4534: );
4535: else
4536: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4537: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4538: );
4539: end if;
4540: --OKL_INS_POLICIES_B;INT_ID
4541: appid:=540;