APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_K_HEADERS_V

Line 266: -- FUNCTION get_rec for: OKL_K_HEADERS_V

262: RETURN(get_rec(p_chrv_rec, l_row_notfound));
263:
264: END get_rec;
265: ---------------------------------------------------------------------------
266: -- FUNCTION get_rec for: OKL_K_HEADERS_V
267: ---------------------------------------------------------------------------
268: FUNCTION get_rec (
269: p_khrv_rec IN khrv_rec_type,
270: x_no_data_found OUT NOCOPY BOOLEAN

Line 272: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS

268: FUNCTION get_rec (
269: p_khrv_rec IN khrv_rec_type,
270: x_no_data_found OUT NOCOPY BOOLEAN
271: ) RETURN khrv_rec_type IS
272: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS
273: SELECT
274: ID,
275: OBJECT_VERSION_NUMBER,
276: ISG_ID,

Line 335: FROM OKL_K_HEADERS_V

331: CURRENCY_CONVERSION_RATE,
332: CURRENCY_CONVERSION_DATE,
333: CURRENCY_CONVERSION_TYPE,
334: ASSIGNABLE_YN
335: FROM OKL_K_HEADERS_V
336: WHERE OKL_K_HEADERS_V.id = p_id;
337: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
338: l_khrv_rec khrv_rec_type;
339: BEGIN

Line 336: WHERE OKL_K_HEADERS_V.id = p_id;

332: CURRENCY_CONVERSION_DATE,
333: CURRENCY_CONVERSION_TYPE,
334: ASSIGNABLE_YN
335: FROM OKL_K_HEADERS_V
336: WHERE OKL_K_HEADERS_V.id = p_id;
337: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
338: l_khrv_rec khrv_rec_type;
339: BEGIN
340:

Line 337: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;

333: CURRENCY_CONVERSION_TYPE,
334: ASSIGNABLE_YN
335: FROM OKL_K_HEADERS_V
336: WHERE OKL_K_HEADERS_V.id = p_id;
337: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
338: l_khrv_rec khrv_rec_type;
339: BEGIN
340:
341: x_no_data_found := TRUE;

Line 343: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);

339: BEGIN
340:
341: x_no_data_found := TRUE;
342: -- Get current database values
343: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
344: FETCH okl_k_headers_v_pk_csr INTO
345: l_khrv_rec.ID,
346: l_khrv_rec.OBJECT_VERSION_NUMBER,
347: l_khrv_rec.ISG_ID,

Line 344: FETCH okl_k_headers_v_pk_csr INTO

340:
341: x_no_data_found := TRUE;
342: -- Get current database values
343: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
344: FETCH okl_k_headers_v_pk_csr INTO
345: l_khrv_rec.ID,
346: l_khrv_rec.OBJECT_VERSION_NUMBER,
347: l_khrv_rec.ISG_ID,
348: l_khrv_rec.KHR_ID,

Line 407: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;

403: l_khrv_rec.CURRENCY_CONVERSION_DATE,
404: l_khrv_rec.CURRENCY_CONVERSION_TYPE,
405: l_khrv_rec.ASSIGNABLE_YN
406: ;
407: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
408: CLOSE okl_k_headers_v_pk_csr;
409: RETURN(l_khrv_rec);
410: END get_rec;
411:

Line 408: CLOSE okl_k_headers_v_pk_csr;

404: l_khrv_rec.CURRENCY_CONVERSION_TYPE,
405: l_khrv_rec.ASSIGNABLE_YN
406: ;
407: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
408: CLOSE okl_k_headers_v_pk_csr;
409: RETURN(l_khrv_rec);
410: END get_rec;
411:
412: FUNCTION get_rec (