APPS.OKL_LAV_PVT dependencies on OKL_LEASEAPP_TEMPL_VERSIONS_B

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

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

Line 465: INSERT INTO okl_leaseapp_templ_versions_b (

461: BEGIN
462:
463: l_prog_name := G_PKG_NAME||'.insert_row (B)';
464:
465: INSERT INTO okl_leaseapp_templ_versions_b (
466: id
467: ,object_version_number
468: ,attribute_category
469: ,attribute1

Line 861: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B

857: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
858:
859: CURSOR lock_csr IS
860: SELECT OBJECT_VERSION_NUMBER
861: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B
862: WHERE ID = p_lav_rec.id
863: AND OBJECT_VERSION_NUMBER = p_lav_rec.object_version_number
864: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
865:

Line 868: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B

864: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
865:
866: CURSOR lchk_csr IS
867: SELECT OBJECT_VERSION_NUMBER
868: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B
869: WHERE ID = p_lav_rec.id;
870:
871: l_object_version_number NUMBER;
872: lc_object_version_number NUMBER;

Line 971: UPDATE okl_leaseapp_templ_versions_b

967: ELSIF l_return_status = G_RET_STS_ERROR THEN
968: RAISE OKL_API.G_EXCEPTION_ERROR;
969: END IF;
970:
971: UPDATE okl_leaseapp_templ_versions_b
972: SET
973: object_version_number = p_lav_rec.object_version_number+1
974: ,attribute_category = p_lav_rec.attribute_category
975: ,attribute1 = p_lav_rec.attribute1

Line 1436: DELETE FROM OKL_LEASEAPP_TEMPL_VERSIONS_B WHERE id = p_id;

1432: BEGIN
1433:
1434: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1435:
1436: DELETE FROM OKL_LEASEAPP_TEMPL_VERSIONS_B WHERE id = p_id;
1437: DELETE FROM OKL_LEASEAPP_TEMPL_VERSIONS_TL WHERE id = p_id;
1438:
1439: x_return_status := G_RET_STS_SUCCESS;
1440: