APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_K_HEADERS_V

Line 267: -- FUNCTION get_rec for: OKL_K_HEADERS_V

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

Line 273: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS

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

Line 336: FROM OKL_K_HEADERS_V

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

Line 337: WHERE OKL_K_HEADERS_V.id = p_id;

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

Line 338: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;

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

Line 344: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);

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

Line 345: FETCH okl_k_headers_v_pk_csr INTO

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

Line 408: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;

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

Line 409: CLOSE okl_k_headers_v_pk_csr;

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