APPS.OKL_QQL_PVT dependencies on OKL_QUICK_QUOTE_LINES_B

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

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

Line 454: INSERT INTO okl_quick_quote_lines_b (

450: BEGIN
451:
452: l_prog_name := G_PKG_NAME||'.insert_row (B)';
453:
454: INSERT INTO okl_quick_quote_lines_b (
455: id
456: ,object_version_number
457: ,attribute_category
458: ,attribute1

Line 865: FROM OKL_QUICK_QUOTE_LINES_B

861: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
862:
863: CURSOR lock_csr IS
864: SELECT OBJECT_VERSION_NUMBER
865: FROM OKL_QUICK_QUOTE_LINES_B
866: WHERE ID = p_qql_rec.id
867: AND OBJECT_VERSION_NUMBER = p_qql_rec.object_version_number
868: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
869:

Line 872: FROM OKL_QUICK_QUOTE_LINES_B

868: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
869:
870: CURSOR lchk_csr IS
871: SELECT OBJECT_VERSION_NUMBER
872: FROM OKL_QUICK_QUOTE_LINES_B
873: WHERE ID = p_qql_rec.id;
874:
875: l_object_version_number NUMBER;
876: lc_object_version_number NUMBER;

Line 976: UPDATE okl_quick_quote_lines_b

972: ELSIF l_return_status = G_RET_STS_ERROR THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;
975:
976: UPDATE okl_quick_quote_lines_b
977: SET
978: object_version_number = p_qql_rec.object_version_number+1
979: ,attribute_category = p_qql_rec.attribute_category
980: ,attribute1 = p_qql_rec.attribute1

Line 1562: DELETE FROM OKL_QUICK_QUOTE_LINES_B WHERE id = p_id;

1558: BEGIN
1559:
1560: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1561:
1562: DELETE FROM OKL_QUICK_QUOTE_LINES_B WHERE id = p_id;
1563: DELETE FROM OKL_QUICK_QUOTE_LINES_TL WHERE id = p_id;
1564:
1565: x_return_status := G_RET_STS_SUCCESS;
1566: