APPS.OKL_QQH_PVT dependencies on OKL_QUICK_QUOTES_B

Line 486: FROM okl_quick_quotes_b

482: FUNCTION validate_unique(p_qqhv_rec_type IN qqhv_rec_type) RETURN VARCHAR2 IS
483:
484: CURSOR chk_uniquness IS
485: SELECT 'x'
486: FROM okl_quick_quotes_b
487: WHERE reference_number = p_qqhv_rec_type.reference_number
488: AND id <> NVL(p_qqhv_rec_type.id, -9999);
489:
490: l_dummy_var VARCHAR2(1);

Line 803: INSERT INTO okl_quick_quotes_b (

799: BEGIN
800:
801: l_prog_name := G_PKG_NAME||'.insert_row (B)';
802:
803: INSERT INTO okl_quick_quotes_b (
804: id
805: ,object_version_number
806: ,attribute_category
807: ,attribute1

Line 1055: IF (okl_util.validate_seq_num('OKL_QQH_REF_SEQ','OKL_QUICK_QUOTES_B','REFERENCE_NUMBER',l_qqhv_rec.reference_number) = 'N') THEN

1051: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;
1054: --Bug 7022258-Added by kkorrapo
1055: IF (okl_util.validate_seq_num('OKL_QQH_REF_SEQ','OKL_QUICK_QUOTES_B','REFERENCE_NUMBER',l_qqhv_rec.reference_number) = 'N') THEN
1056: RAISE okl_api.g_exception_error;
1057: END IF;
1058: --Bug 7022258--Addition end
1059:

Line 1270: FROM OKL_QUICK_QUOTES_B

1266: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
1267:
1268: CURSOR lock_csr IS
1269: SELECT OBJECT_VERSION_NUMBER
1270: FROM OKL_QUICK_QUOTES_B
1271: WHERE ID = p_qqh_rec.id
1272: AND OBJECT_VERSION_NUMBER = p_qqh_rec.object_version_number
1273: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1274:

Line 1277: FROM OKL_QUICK_QUOTES_B

1273: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1274:
1275: CURSOR lchk_csr IS
1276: SELECT OBJECT_VERSION_NUMBER
1277: FROM OKL_QUICK_QUOTES_B
1278: WHERE ID = p_qqh_rec.id;
1279:
1280: l_object_version_number NUMBER;
1281: lc_object_version_number NUMBER;

Line 1382: UPDATE okl_quick_quotes_b

1378: ELSIF l_return_status = G_RET_STS_ERROR THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:
1382: UPDATE okl_quick_quotes_b
1383: SET
1384: object_version_number = p_qqh_rec.object_version_number+1
1385: ,attribute_category = p_qqh_rec.attribute_category
1386: ,attribute1 = p_qqh_rec.attribute1

Line 2137: DELETE FROM OKL_QUICK_QUOTES_B WHERE id = p_id;

2133: BEGIN
2134:
2135: l_prog_name := G_PKG_NAME||'.delete_row (V)';
2136:
2137: DELETE FROM OKL_QUICK_QUOTES_B WHERE id = p_id;
2138: DELETE FROM OKL_QUICK_QUOTES_TL WHERE id = p_id;
2139:
2140: x_return_status := G_RET_STS_SUCCESS;
2141: