APPS.OKL_CDJ_PVT dependencies on OKL_COST_ADJUSTMENTS_B

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

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

Line 513: INSERT INTO okl_cost_adjustments_b (

509: BEGIN
510:
511: l_prog_name := G_PKG_NAME||'.insert_row (B)';
512:
513: INSERT INTO okl_cost_adjustments_b (
514: id
515: ,object_version_number
516: ,attribute_category
517: ,attribute1

Line 930: FROM OKL_COST_ADJUSTMENTS_B

926: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
927:
928: CURSOR lock_csr IS
929: SELECT OBJECT_VERSION_NUMBER
930: FROM OKL_COST_ADJUSTMENTS_B
931: WHERE ID = p_cdj_rec.id
932: AND OBJECT_VERSION_NUMBER = p_cdj_rec.object_version_number
933: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
934:

Line 937: FROM OKL_COST_ADJUSTMENTS_B

933: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
934:
935: CURSOR lchk_csr IS
936: SELECT OBJECT_VERSION_NUMBER
937: FROM OKL_COST_ADJUSTMENTS_B
938: WHERE ID = p_cdj_rec.id;
939:
940: l_object_version_number NUMBER;
941: lc_object_version_number NUMBER;

Line 1041: UPDATE okl_cost_adjustments_b

1037: ELSIF l_return_status = G_RET_STS_ERROR THEN
1038: RAISE OKL_API.G_EXCEPTION_ERROR;
1039: END IF;
1040:
1041: UPDATE okl_cost_adjustments_b
1042: SET
1043: object_version_number = p_cdj_rec.object_version_number+1
1044: ,attribute_category = p_cdj_rec.attribute_category
1045: ,attribute1 = p_cdj_rec.attribute1

Line 1541: DELETE FROM OKL_COST_ADJUSTMENTS_B WHERE id = p_id;

1537: BEGIN
1538:
1539: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1540:
1541: DELETE FROM OKL_COST_ADJUSTMENTS_B WHERE id = p_id;
1542: DELETE FROM OKL_COST_ADJUSTMENTS_TL WHERE id = p_id;
1543:
1544: x_return_status := G_RET_STS_SUCCESS;
1545: