APPS.OKL_QUL_PVT dependencies on OKL_QUOTE_SUBPOOL_USAGE

Line 187: FROM okl_quote_subpool_usage_v

183: ,l_qulv_rec.subsidy_amount
184: ,l_qulv_rec.subsidy_currency_code
185: ,l_qulv_rec.vendor_id
186: ,l_qulv_rec.conversion_rate
187: FROM okl_quote_subpool_usage_v
188: WHERE id = p_id;
189:
190: x_return_status := G_RET_STS_SUCCESS;
191: RETURN l_qulv_rec;

Line 326: INSERT INTO okl_quote_subpool_usage (

322: BEGIN
323:
324: l_prog_name := G_PKG_NAME||'.insert_row (B)';
325:
326: INSERT INTO okl_quote_subpool_usage (
327: id
328: ,object_version_number
329: ,attribute_category
330: ,attribute1

Line 658: FROM OKL_QUOTE_SUBPOOL_USAGE

654: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
655:
656: CURSOR lock_csr IS
657: SELECT OBJECT_VERSION_NUMBER
658: FROM OKL_QUOTE_SUBPOOL_USAGE
659: WHERE ID = p_qul_rec.id
660: AND OBJECT_VERSION_NUMBER = p_qul_rec.object_version_number
661: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
662:

Line 665: FROM OKL_QUOTE_SUBPOOL_USAGE

661: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
662:
663: CURSOR lchk_csr IS
664: SELECT OBJECT_VERSION_NUMBER
665: FROM OKL_QUOTE_SUBPOOL_USAGE
666: WHERE ID = p_qul_rec.id;
667:
668: l_object_version_number NUMBER;
669: lc_object_version_number NUMBER;

Line 769: UPDATE okl_quote_subpool_usage

765: ELSIF l_return_status = G_RET_STS_ERROR THEN
766: RAISE OKL_API.G_EXCEPTION_ERROR;
767: END IF;
768:
769: UPDATE okl_quote_subpool_usage
770: SET
771: object_version_number = p_qul_rec.object_version_number+1
772: ,attribute_category = p_qul_rec.attribute_category
773: ,attribute1 = p_qul_rec.attribute1

Line 1206: DELETE FROM OKL_QUOTE_SUBPOOL_USAGE WHERE id = p_id;

1202: BEGIN
1203:
1204: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1205:
1206: DELETE FROM OKL_QUOTE_SUBPOOL_USAGE WHERE id = p_id;
1207:
1208: x_return_status := G_RET_STS_SUCCESS;
1209:
1210: EXCEPTION