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 461: INSERT INTO okl_LINE_RELATIONSHIPS_b (

457: BEGIN
458:
459: l_prog_name := G_PKG_NAME||'.insert_row (B)';
460:
461: INSERT INTO okl_LINE_RELATIONSHIPS_b (
462: id
463: ,object_version_number
464: ,attribute_category
465: ,attribute1

Line 862: FROM OKL_LINE_RELATIONSHIPS_B

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

Line 869: FROM OKL_LINE_RELATIONSHIPS_B

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

Line 973: UPDATE okl_LINE_RELATIONSHIPS_b

969: ELSIF l_return_status = G_RET_STS_ERROR THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972:
973: UPDATE okl_LINE_RELATIONSHIPS_b
974: SET
975: object_version_number = p_lre_rec.object_version_number
976: ,attribute_category = p_lre_rec.attribute_category
977: ,attribute1 = p_lre_rec.attribute1

Line 1445: DELETE FROM OKL_LINE_RELATIONSHIPS_B WHERE id = p_id;

1441: BEGIN
1442:
1443: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1444:
1445: DELETE FROM OKL_LINE_RELATIONSHIPS_B WHERE id = p_id;
1446: DELETE FROM OKL_LINE_RELATIONSHIPS_TL WHERE id = p_id;
1447:
1448: x_return_status := G_RET_STS_SUCCESS;
1449: