DBA Data[Home] [Help]

APPS.OKL_CFP_PVT dependencies on OKL_CASH_FLOW_OBJECTS_V

Line 431: FROM Okl_Cash_Flow_Objects_V

427: l_dummy_var VARCHAR2(1) := '?';
428:
429: CURSOR okl_cfpv_cfov_fk_csr (p_id IN NUMBER) IS
430: SELECT 'x'
431: FROM Okl_Cash_Flow_Objects_V
432: WHERE okl_cash_flow_objects_v.id = p_id;
433: BEGIN
434:
435: IF (p_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM OR p_cfpv_rec.cfo_id IS NULL)

Line 432: WHERE okl_cash_flow_objects_v.id = p_id;

428:
429: CURSOR okl_cfpv_cfov_fk_csr (p_id IN NUMBER) IS
430: SELECT 'x'
431: FROM Okl_Cash_Flow_Objects_V
432: WHERE okl_cash_flow_objects_v.id = p_id;
433: BEGIN
434:
435: IF (p_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM OR p_cfpv_rec.cfo_id IS NULL)
436: THEN

Line 453: 'OKL_CASH_FLOW_OBJECTS_V');

449: 'cfo_id',
450: g_child_table_token ,
451: 'OKL_CF_OBJECT_PERIODS_V',
452: g_parent_table_token ,
453: 'OKL_CASH_FLOW_OBJECTS_V');
454: l_return_status := OKC_API.G_RET_STS_ERROR;
455:
456: END IF;
457: END IF;

Line 654: FROM Okl_Cash_Flow_Objects_V

650: ) RETURN VARCHAR2 IS
651: item_not_found_error EXCEPTION;
652: CURSOR okl_cfpv_cfov_fk_csr (p_id IN NUMBER) IS
653: SELECT 'x'
654: FROM Okl_Cash_Flow_Objects_V
655: WHERE okl_cash_flow_objects_v.id = p_id;
656: l_okl_cfpv_cfov_fk okl_cfpv_cfov_fk_csr%ROWTYPE;
657:
658: CURSOR okl_cfpv_ptp_fk_csr (p_lookup_code IN VARCHAR2) IS

Line 655: WHERE okl_cash_flow_objects_v.id = p_id;

651: item_not_found_error EXCEPTION;
652: CURSOR okl_cfpv_cfov_fk_csr (p_id IN NUMBER) IS
653: SELECT 'x'
654: FROM Okl_Cash_Flow_Objects_V
655: WHERE okl_cash_flow_objects_v.id = p_id;
656: l_okl_cfpv_cfov_fk okl_cfpv_cfov_fk_csr%ROWTYPE;
657:
658: CURSOR okl_cfpv_ptp_fk_csr (p_lookup_code IN VARCHAR2) IS
659: SELECT 'x'