APPS.OKL_LRE_PVT dependencies on OKL_LINE_RELATIONSHIPS_B

Line 12: WHERE NOT EXISTS (SELECT NULL FROM OKL_LINE_RELATIONSHIPS_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_LINE_RELATIONSHIPS_B B WHERE B.ID =T.ID);
13:
14: UPDATE OKL_LINE_RELATIONSHIPS_TL T
15: SET (SHORT_DESCRIPTION,
16: DESCRIPTION,

Line 519: INSERT INTO okl_LINE_RELATIONSHIPS_b (

515: BEGIN
516:
517: l_prog_name := G_PKG_NAME||'.insert_row (B)';
518:
519: INSERT INTO okl_LINE_RELATIONSHIPS_b (
520: id
521: ,object_version_number
522: ,attribute_category
523: ,attribute1

Line 928: FROM OKL_LINE_RELATIONSHIPS_B

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

Line 935: FROM OKL_LINE_RELATIONSHIPS_B

931: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
932:
933: CURSOR lchk_csr IS
934: SELECT OBJECT_VERSION_NUMBER
935: FROM OKL_LINE_RELATIONSHIPS_B
936: WHERE ID = p_lre_rec.id;
937:
938: l_object_version_number NUMBER;
939: lc_object_version_number NUMBER;

Line 1039: UPDATE okl_LINE_RELATIONSHIPS_b

1035: ELSIF l_return_status = G_RET_STS_ERROR THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: UPDATE okl_LINE_RELATIONSHIPS_b
1040: SET
1041: object_version_number = p_lre_rec.object_version_number
1042: ,attribute_category = p_lre_rec.attribute_category
1043: ,attribute1 = p_lre_rec.attribute1

Line 1520: DELETE FROM OKL_LINE_RELATIONSHIPS_B WHERE id = p_id;

1516: BEGIN
1517:
1518: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1519:
1520: DELETE FROM OKL_LINE_RELATIONSHIPS_B WHERE id = p_id;
1521: DELETE FROM OKL_LINE_RELATIONSHIPS_TL WHERE id = p_id;
1522:
1523: x_return_status := G_RET_STS_SUCCESS;
1524: