DBA Data[Home] [Help]

APPS.OKL_STM_PVT dependencies on OKL_K_LINES_V

Line 784: FROM OKL_K_LINES_V

780: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
781:
782: CURSOR l_kleid_csr IS
783: SELECT '1'
784: FROM OKL_K_LINES_V
785: WHERE id=p_stmv_rec.kle_id;
786:
787: l_dummy_kle_id VARCHAR2(1);
788: l_row_notfound BOOLEAN :=TRUE;

Line 813: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KLE_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_LINES_V');

809: CLOSE l_kleid_csr;
810:
811: IF(l_row_notfound ) THEN
812:
813: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KLE_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_LINES_V');
814:
815: x_return_status := Okc_Api.G_RET_STS_ERROR;
816: -- raise the exception as there's no matching foreign key value
817: