DBA Data[Home] [Help]

APPS.OKS_RENCPY_PVT dependencies on OKS_K_LINES_B

Line 1075: UPDATE oks_k_lines_b SET

1071: ELSE
1072: x_return_status := l_return_status;
1073: END IF;
1074:
1075: UPDATE oks_k_lines_b SET
1076: trxn_extension_id = l_trx_ext_id
1077: WHERE cle_id = p_cle_id;
1078:
1079: END IF;

Line 1501: FROM okc_k_items a, oks_k_lines_b b

1497: l_actual_coverage_id NUMBER;
1498:
1499: CURSOR c_item IS
1500: SELECT a.object1_id1, b.standard_cov_yn
1501: FROM okc_k_items a, oks_k_lines_b b
1502: WHERE a.cle_id = p_old_cle_id
1503: AND b.cle_id = p_old_cle_id;
1504:
1505: CURSOR l_ctr_csr (p_id NUMBER) IS

Line 1623: UPDATE oks_k_lines_b SET

1619: END IF;
1620:
1621: --update oks top line with the newly created non-std coverage
1622: --the oks top line must be present before this can be done
1623: UPDATE oks_k_lines_b SET
1624: coverage_id = l_actual_coverage_id
1625: WHERE cle_id = p_new_cle_id;
1626: END IF;
1627: