APPS.OKL_VLS_PVT dependencies on OKL_VALIDATION_SETS_B

Line 436: INSERT INTO okl_validation_sets_b (

432: BEGIN
433:
434: l_prog_name := G_PKG_NAME||'.insert_row (B)';
435:
436: INSERT INTO okl_validation_sets_b (
437: id
438: ,object_version_number
439: ,attribute_category
440: ,attribute1

Line 835: FROM OKL_VALIDATION_SETS_B

831: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
832:
833: CURSOR lock_csr IS
834: SELECT OBJECT_VERSION_NUMBER
835: FROM OKL_VALIDATION_SETS_B
836: WHERE ID = p_vls_rec.id
837: AND OBJECT_VERSION_NUMBER = p_vls_rec.object_version_number
838: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
839:

Line 842: FROM OKL_VALIDATION_SETS_B

838: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
839:
840: CURSOR lchk_csr IS
841: SELECT OBJECT_VERSION_NUMBER
842: FROM OKL_VALIDATION_SETS_B
843: WHERE ID = p_vls_rec.id;
844:
845: l_object_version_number NUMBER;
846: lc_object_version_number NUMBER;

Line 946: UPDATE okl_validation_sets_b

942: ELSIF l_return_status = G_RET_STS_ERROR THEN
943: RAISE OKL_API.G_EXCEPTION_ERROR;
944: END IF;
945:
946: UPDATE okl_validation_sets_b
947: SET
948: object_version_number = p_vls_rec.object_version_number+1
949: ,attribute_category = p_vls_rec.attribute_category
950: ,attribute1 = p_vls_rec.attribute1

Line 1412: DELETE FROM OKL_VALIDATION_SETS_B WHERE id = p_id;

1408: BEGIN
1409:
1410: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1411:
1412: DELETE FROM OKL_VALIDATION_SETS_B WHERE id = p_id;
1413: DELETE FROM OKL_VALIDATION_SETS_TL WHERE id = p_id;
1414:
1415: x_return_status := G_RET_STS_SUCCESS;
1416: