DBA Data[Home] [Help]

APPS.OKL_STM_PVT dependencies on OKL_K_HEADERS_V

Line 711: FROM okl_k_headers_v

707: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
708:
709: CURSOR l_khrid_csr IS
710: SELECT '1'
711: FROM okl_k_headers_v
712: WHERE id=p_stmv_rec.khr_id;
713:
714: l_dummy_khr_id VARCHAR2(1);
715: l_row_notfound BOOLEAN :=TRUE;

Line 737: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KHR_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_HEADERS_V');

733: l_row_notfound :=l_khrid_csr%NOTFOUND;
734: CLOSE l_khrid_csr;
735:
736: IF(l_row_notfound ) THEN
737: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KHR_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_HEADERS_V');
738:
739: x_return_status := Okc_Api.G_RET_STS_ERROR;
740: -- raise the exception as there's no matching foreign key value
741: