eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LOP_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 748: INSERT INTO okl_lease_opportunities_b (

744: BEGIN
745:
746: l_prog_name := G_PKG_NAME||'.insert_row (B)';
747:
748: INSERT INTO okl_lease_opportunities_b (
749: id
750: ,object_version_number
751: ,attribute_category
752: ,attribute1

Line 993: l_valid := okl_util.validate_seq_num('OKL_LOP_REF_SEQ','OKL_LEASE_OPPORTUNITIES_B','REFERENCE_NUMBER',l_lopv_rec.reference_number);

989:
990: l_return_status := validate_attributes(l_lopv_rec);
991:
992: --Bug 7022258-Added by kkorrapo
993: l_valid := okl_util.validate_seq_num('OKL_LOP_REF_SEQ','OKL_LEASE_OPPORTUNITIES_B','REFERENCE_NUMBER',l_lopv_rec.reference_number);
994:
995: IF l_valid = 'N' THEN
996: RAISE OKL_API.G_EXCEPTION_ERROR;
997: END IF;

Line 1216: FROM OKL_LEASE_OPPORTUNITIES_B

1212: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
1213:
1214: CURSOR lock_csr IS
1215: SELECT OBJECT_VERSION_NUMBER
1216: FROM OKL_LEASE_OPPORTUNITIES_B
1217: WHERE ID = p_lop_rec.id
1218: AND OBJECT_VERSION_NUMBER = p_lop_rec.object_version_number
1219: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1220:

Line 1223: FROM OKL_LEASE_OPPORTUNITIES_B

1219: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1220:
1221: CURSOR lchk_csr IS
1222: SELECT OBJECT_VERSION_NUMBER
1223: FROM OKL_LEASE_OPPORTUNITIES_B
1224: WHERE ID = p_lop_rec.id;
1225:
1226: l_object_version_number NUMBER;
1227: lc_object_version_number NUMBER;

Line 1327: UPDATE okl_lease_opportunities_b

1323: ELSIF l_return_status = G_RET_STS_ERROR THEN
1324: RAISE OKL_API.G_EXCEPTION_ERROR;
1325: END IF;
1326:
1327: UPDATE okl_lease_opportunities_b
1328: SET
1329: object_version_number = p_lop_rec.object_version_number+1
1330: ,attribute_category = p_lop_rec.attribute_category
1331: ,attribute1 = p_lop_rec.attribute1

Line 1914: DELETE FROM OKL_LEASE_OPPORTUNITIES_B WHERE id = p_id;

1910: BEGIN
1911:
1912: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1913:
1914: DELETE FROM OKL_LEASE_OPPORTUNITIES_B WHERE id = p_id;
1915: DELETE FROM OKL_LEASE_OPPORTUNITIES_TL WHERE id = p_id;
1916:
1917: x_return_status := G_RET_STS_SUCCESS;
1918: