208:
209: -- bug 15935804 begin...
210: begin
211: select party_id,party_name into l_party_id,l_party_name from hz_parties
212: where party_id = (select party_id from iex_litigations where litigation_id = p_litigation_id);
213:
214: select account_number into l_account_number from hz_cust_accounts
215: where cust_account_id = (select cust_account_id from iex_litigations where litigation_id = p_litigation_id);
216: exception
211: select party_id,party_name into l_party_id,l_party_name from hz_parties
212: where party_id = (select party_id from iex_litigations where litigation_id = p_litigation_id);
213:
214: select account_number into l_account_number from hz_cust_accounts
215: where cust_account_id = (select cust_account_id from iex_litigations where litigation_id = p_litigation_id);
216: exception
217: when others then null;
218: end;
219:
529: update IEX_REPOSSESSIONS
530: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
531: where repossession_id = l_repossession_id;
532: ELSIF l_del_type = 'Litigation' THEN
533: update IEX_LITIGATIONS
534: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
535: where litigation_id = l_litigation_id;
536: ELSIF l_del_type = 'Writeoff' THEN
537: update IEX_WRITEOFFS
673: update IEX_REPOSSESSIONS
674: set CREDIT_HOLD_APPROVED_FLAG = 'N'
675: where repossession_id = l_repossession_id;
676: ELSIF l_del_type = 'Litigation' THEN
677: update IEX_LITIGATIONS
678: set CREDIT_HOLD_APPROVED_FLAG = 'N'
679: where litigation_id = l_litigation_id;
680: ELSIF l_del_type = 'Writeoff' THEN
681: update IEX_WRITEOFFS