APPS.OKL_LSQ_PVT dependencies on OKL_LEASE_QUOTES_B

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

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

Line 556: IF (okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',p_reference_number) = 'N') THEN

552: RAISE OKL_API.G_EXCEPTION_ERROR;
553: END IF;
554:
555: --Bug 7022258-Added by kkorrapo
556: IF (okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',p_reference_number) = 'N') THEN
557: RAISE okl_api.g_exception_error;
558: END IF;
559: --Bug 7022258--Addition end
560:

Line 870: INSERT INTO okl_lease_quotes_b (

866: BEGIN
867:
868: l_prog_name := G_PKG_NAME||'.insert_row (B)';
869:
870: INSERT INTO okl_lease_quotes_b (
871: id
872: ,object_version_number
873: ,attribute_category
874: ,attribute1

Line 1367: FROM OKL_LEASE_QUOTES_B

1363: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
1364:
1365: CURSOR lock_csr IS
1366: SELECT OBJECT_VERSION_NUMBER
1367: FROM OKL_LEASE_QUOTES_B
1368: WHERE ID = p_lsq_rec.id
1369: AND OBJECT_VERSION_NUMBER = p_lsq_rec.object_version_number
1370: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1371:

Line 1374: FROM OKL_LEASE_QUOTES_B

1370: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1371:
1372: CURSOR lchk_csr IS
1373: SELECT OBJECT_VERSION_NUMBER
1374: FROM OKL_LEASE_QUOTES_B
1375: WHERE ID = p_lsq_rec.id;
1376:
1377: l_object_version_number NUMBER;
1378: lc_object_version_number NUMBER;

Line 1478: UPDATE okl_lease_quotes_b

1474: ELSIF l_return_status = G_RET_STS_ERROR THEN
1475: RAISE OKL_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:
1478: UPDATE okl_lease_quotes_b
1479: SET
1480: object_version_number = p_lsq_rec.object_version_number+1
1481: ,attribute_category = p_lsq_rec.attribute_category
1482: ,attribute1 = p_lsq_rec.attribute1

Line 2140: DELETE FROM OKL_LEASE_QUOTES_B WHERE id = p_id;

2136: BEGIN
2137:
2138: l_prog_name := G_PKG_NAME||'.delete_row (V)';
2139:
2140: DELETE FROM OKL_LEASE_QUOTES_B WHERE id = p_id;
2141: DELETE FROM OKL_LEASE_QUOTES_TL WHERE id = p_id;
2142:
2143: x_return_status := G_RET_STS_SUCCESS;
2144: