APPS.OKL_LAP_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 606: FROM OKL_LEASE_APPLICATIONS_B

602: --Cursor to check uniqueness of Lease Application Number
603: CURSOR chk_lse_app_num_csr(cp_lse_app_num VARCHAR2
604: ,cp_lse_app_id NUMBER) IS
605: SELECT 'x'
606: FROM OKL_LEASE_APPLICATIONS_B
607: WHERE UPPER(REFERENCE_NUMBER) = UPPER(cp_lse_app_num)
608: AND id <> cp_lse_app_id;
609:
610: l_dummy VARCHAR2(1);

Line 723: INSERT INTO okl_lease_applications_b (

719: BEGIN
720:
721: l_prog_name := G_PKG_NAME||'.insert_row (B)';
722:
723: INSERT INTO okl_lease_applications_b (
724: id
725: ,object_version_number
726: ,attribute_category
727: ,attribute1

Line 955: IF (okl_util.validate_seq_num('OKL_LAP_REF_SEQ','OKL_LEASE_APPLICATIONS_B','REFERENCE_NUMBER',l_lapv_rec.reference_number) = 'N') THEN

951: RAISE OKL_API.G_EXCEPTION_ERROR;
952: END IF;
953:
954: --Bug 7022258-Added by kkorrapo
955: IF (okl_util.validate_seq_num('OKL_LAP_REF_SEQ','OKL_LEASE_APPLICATIONS_B','REFERENCE_NUMBER',l_lapv_rec.reference_number) = 'N') THEN
956: RAISE okl_api.g_exception_error;
957: END IF;
958: --Bug 7022258--Addition end
959:

Line 1170: FROM OKL_LEASE_APPLICATIONS_B

1166: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
1167:
1168: CURSOR lock_csr IS
1169: SELECT OBJECT_VERSION_NUMBER
1170: FROM OKL_LEASE_APPLICATIONS_B
1171: WHERE ID = p_lap_rec.id
1172: AND OBJECT_VERSION_NUMBER = p_lap_rec.object_version_number
1173: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1174:

Line 1177: FROM OKL_LEASE_APPLICATIONS_B

1173: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1174:
1175: CURSOR lchk_csr IS
1176: SELECT OBJECT_VERSION_NUMBER
1177: FROM OKL_LEASE_APPLICATIONS_B
1178: WHERE ID = p_lap_rec.id;
1179:
1180: l_object_version_number NUMBER;
1181: lc_object_version_number NUMBER;

Line 1281: UPDATE okl_lease_applications_b

1277: ELSIF l_return_status = G_RET_STS_ERROR THEN
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280:
1281: UPDATE okl_lease_applications_b
1282: SET
1283: object_version_number = p_lap_rec.object_version_number+1
1284: ,attribute_category = p_lap_rec.attribute_category
1285: ,attribute1 = p_lap_rec.attribute1

Line 1834: DELETE FROM OKL_LEASE_APPLICATIONS_B WHERE id = p_id;

1830: BEGIN
1831:
1832: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1833:
1834: DELETE FROM OKL_LEASE_APPLICATIONS_B WHERE id = p_id;
1835: DELETE FROM OKL_LEASE_APPLICATIONS_TL WHERE id = p_id;
1836:
1837: x_return_status := G_RET_STS_SUCCESS;
1838: