APPS.OKL_ASO_PVT dependencies on OKL_ASSET_COMPONENTS_B

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

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

Line 466: INSERT INTO okl_asset_components_b (

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

Line 875: FROM OKL_ASSET_COMPONENTS_B

871: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
872:
873: CURSOR lock_csr IS
874: SELECT OBJECT_VERSION_NUMBER
875: FROM OKL_ASSET_COMPONENTS_B
876: WHERE ID = p_aso_rec.id
877: AND OBJECT_VERSION_NUMBER = p_aso_rec.object_version_number
878: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
879:

Line 882: FROM OKL_ASSET_COMPONENTS_B

878: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
879:
880: CURSOR lchk_csr IS
881: SELECT OBJECT_VERSION_NUMBER
882: FROM OKL_ASSET_COMPONENTS_B
883: WHERE ID = p_aso_rec.id;
884:
885: l_object_version_number NUMBER;
886: lc_object_version_number NUMBER;

Line 986: UPDATE okl_asset_components_b

982: ELSIF l_return_status = G_RET_STS_ERROR THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;
985:
986: UPDATE okl_asset_components_b
987: SET
988: object_version_number = p_aso_rec.object_version_number+1
989: ,attribute_category = p_aso_rec.attribute_category
990: ,attribute1 = p_aso_rec.attribute1

Line 1474: DELETE FROM OKL_ASSET_COMPONENTS_B WHERE id = p_id;

1470: BEGIN
1471:
1472: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1473:
1474: DELETE FROM OKL_ASSET_COMPONENTS_B WHERE id = p_id;
1475: DELETE FROM OKL_ASSET_COMPONENTS_TL WHERE id = p_id;
1476:
1477: x_return_status := G_RET_STS_SUCCESS;
1478: