APPS.OKL_VLD_PVT dependencies on OKL_VALIDATIONS_B

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

8:
9: BEGIN
10:
11: DELETE FROM OKL_VALIDATIONS_TL T
12: WHERE NOT EXISTS (SELECT NULL FROM OKL_VALIDATIONS_B B WHERE B.ID =T.ID);
13:
14: UPDATE OKL_VALIDATIONS_TL T
15: SET (SHORT_DESCRIPTION,
16: DESCRIPTION,

Line 392: INSERT INTO okl_validations_b (

388: BEGIN
389:
390: l_prog_name := G_PKG_NAME||'.insert_row (B)';
391:
392: INSERT INTO okl_validations_b (
393: id
394: ,object_version_number
395: ,attribute_category
396: ,attribute1

Line 789: FROM OKL_VALIDATIONS_B

785: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
786:
787: CURSOR lock_csr IS
788: SELECT OBJECT_VERSION_NUMBER
789: FROM OKL_VALIDATIONS_B
790: WHERE ID = p_vld_rec.id
791: AND OBJECT_VERSION_NUMBER = p_vld_rec.object_version_number
792: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
793:

Line 796: FROM OKL_VALIDATIONS_B

792: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
793:
794: CURSOR lchk_csr IS
795: SELECT OBJECT_VERSION_NUMBER
796: FROM OKL_VALIDATIONS_B
797: WHERE ID = p_vld_rec.id;
798:
799: l_object_version_number NUMBER;
800: lc_object_version_number NUMBER;

Line 900: UPDATE okl_validations_b

896: ELSIF l_return_status = G_RET_STS_ERROR THEN
897: RAISE OKL_API.G_EXCEPTION_ERROR;
898: END IF;
899:
900: UPDATE okl_validations_b
901: SET
902: object_version_number = p_vld_rec.object_version_number+1
903: ,attribute_category = p_vld_rec.attribute_category
904: ,attribute1 = p_vld_rec.attribute1

Line 1362: DELETE FROM OKL_VALIDATIONS_B WHERE id = p_id;

1358: BEGIN
1359:
1360: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1361:
1362: DELETE FROM OKL_VALIDATIONS_B WHERE id = p_id;
1363: DELETE FROM OKL_VALIDATIONS_TL WHERE id = p_id;
1364:
1365: x_return_status := G_RET_STS_SUCCESS;
1366: