DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_UTIL

Line 970: l_refno_unq_chk := okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',l_lease_qte_rec.reference_number);

966: RAISE OKL_API.G_EXCEPTION_ERROR;
967: END IF;
968:
969: --Bug 7022258-Added by kkorrapo
970: l_refno_unq_chk := okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',l_lease_qte_rec.reference_number);
971:
972: IF (l_refno_unq_chk = 'N') THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;

Line 1982: --l_lease_qte_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');

1978: END IF;
1979: --Bug # 5021937 ssdeshpa end
1980:
1981: --Bug 7022258-Added by kkorrapo
1982: --l_lease_qte_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
1983: --Bug 7022258--Addition end
1984:
1985: create_lease_qte (p_api_version => p_api_version,
1986: p_init_msg_list => p_init_msg_list,

Line 2148: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');

2144: -- Generate reference number
2145:
2146: --Bug 7022258-Modified by kkorrapo
2147: -- SELECT OKL_LSQ_SEQ.nextval INTO l_quote_rec.reference_number FROM dual;
2148: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
2149: --Bug 7022258--Modification end
2150:
2151: l_quote_rec.status := 'PR-INCOMPLETE';
2152:

Line 2700: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');

2696: -- Generate reference number
2697:
2698: --Bug 7022258-Changed by kkorrapo
2699: -- SELECT OKL_LSQ_SEQ.nextval INTO l_quote_rec.reference_number FROM dual;
2700: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
2701: --Bug 7022258--Change end
2702:
2703: l_quote_rec.parent_object_id := p_target_leaseopp_id;
2704: l_quote_rec.status := 'PR-INCOMPLETE';