APPS.OKL_LEASE_OPPORTUNITY_PVT dependencies on OKL_QUICK_QUOTES_B

Line 235: UPDATE okl_quick_quotes_b SET

231: END IF;
232:
233: IF p_quick_quote_id IS NOT NULL THEN
234:
235: UPDATE okl_quick_quotes_b SET
236: lease_opportunity_id = x_lease_opp_rec.id
237: ,currency_code = l_lease_opp_rec.currency_code
238: ,program_agreement_id = l_lease_opp_rec.program_agreement_id
239: WHERE id = p_quick_quote_id;

Line 436: FROM okl_quick_quotes_b qqh

432: AND lsq.parent_object_id = p_lease_opp_id;
433:
434: CURSOR c_qqh IS
435: SELECT qqh.id
436: FROM okl_quick_quotes_b qqh
437: WHERE lease_opportunity_id = p_lease_opp_id;
438:
439: BEGIN
440:

Line 445: DELETE FROM okl_quick_quotes_b WHERE id = l_qqh.id;

441: FOR l_qqh IN c_qqh LOOP
442:
443: DELETE FROM okl_quick_quote_lines_tl WHERE id IN (SELECT id FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id);
444: DELETE FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id;
445: DELETE FROM okl_quick_quotes_b WHERE id = l_qqh.id;
446: DELETE FROM okl_quick_quotes_tl WHERE id = l_qqh.id;
447:
448: END LOOP;
449: