APPS.OKL_VLR_PVT dependencies on OKL_VALIDATION_RESULTS_B

Line 12: WHERE NOT EXISTS (SELECT NULL FROM OKL_VALIDATION_RESULTS_B B WHERE B.ID =T.ID);

8:
9: BEGIN
10:
11: DELETE FROM OKL_VALIDATION_RESULTS_TL T
12: WHERE NOT EXISTS (SELECT NULL FROM OKL_VALIDATION_RESULTS_B B WHERE B.ID =T.ID);
13:
14: UPDATE OKL_VALIDATION_RESULTS_TL T
15: SET (VALIDATION_TEXT) =
16: (SELECT

Line 431: INSERT INTO okl_validation_results_b (

427: BEGIN
428:
429: l_prog_name := G_PKG_NAME||'.insert_row (B)';
430:
431: INSERT INTO okl_validation_results_b (
432: id
433: ,object_version_number
434: ,attribute_category
435: ,attribute1

Line 826: FROM OKL_VALIDATION_RESULTS_B

822: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
823:
824: CURSOR lock_csr IS
825: SELECT OBJECT_VERSION_NUMBER
826: FROM OKL_VALIDATION_RESULTS_B
827: WHERE ID = p_vlr_rec.id
828: AND OBJECT_VERSION_NUMBER = p_vlr_rec.object_version_number
829: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
830:

Line 833: FROM OKL_VALIDATION_RESULTS_B

829: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
830:
831: CURSOR lchk_csr IS
832: SELECT OBJECT_VERSION_NUMBER
833: FROM OKL_VALIDATION_RESULTS_B
834: WHERE ID = p_vlr_rec.id;
835:
836: l_object_version_number NUMBER;
837: lc_object_version_number NUMBER;

Line 937: UPDATE okl_validation_results_b

933: ELSIF l_return_status = G_RET_STS_ERROR THEN
934: RAISE OKL_API.G_EXCEPTION_ERROR;
935: END IF;
936:
937: UPDATE okl_validation_results_b
938: SET
939: object_version_number = p_vlr_rec.object_version_number+1
940: ,attribute_category = p_vlr_rec.attribute_category
941: ,attribute1 = p_vlr_rec.attribute1

Line 1395: DELETE FROM OKL_VALIDATION_RESULTS_B WHERE id = p_id;

1391: BEGIN
1392:
1393: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1394:
1395: DELETE FROM OKL_VALIDATION_RESULTS_B WHERE id = p_id;
1396: DELETE FROM OKL_VALIDATION_RESULTS_TL WHERE id = p_id;
1397:
1398: x_return_status := G_RET_STS_SUCCESS;
1399: