APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_LINES_BH

Line 575: INSERT INTO oks_k_lines_bh

571: WHERE chr_id = p_chr_id;
572:
573: -- Versioning OKS_K_LINES_B
574: -- Inserting multiple records
575: INSERT INTO oks_k_lines_bh
576: (major_version,
577: id,
578: cle_id,
579: dnz_chr_id,

Line 956: (SELECT id FROM oks_k_lines_bh

952: OKC_API.init_msg_list(p_init_msg_list);
953: x_return_status := G_RET_STS_SUCCESS;
954: DELETE oks_k_lines_tlh
955: WHERE id IN
956: (SELECT id FROM oks_k_lines_bh
957: WHERE dnz_chr_id = p_chr_id )
958: AND major_version = - 1;
959:
960: DELETE oks_k_lines_bh

Line 960: DELETE oks_k_lines_bh

956: (SELECT id FROM oks_k_lines_bh
957: WHERE dnz_chr_id = p_chr_id )
958: AND major_version = - 1;
959:
960: DELETE oks_k_lines_bh
961: WHERE dnz_chr_id = p_chr_id
962: AND major_version = - 1;
963:
964: DELETE oks_k_headers_bh

Line 1410: FROM oks_k_lines_bh

1406: EXEMPT_REASON_CODE,
1407: COVERAGE_ID,
1408: STANDARD_COV_YN
1409: /*** R12 Data Model Changes 27072005 End ***/
1410: FROM oks_k_lines_bh
1411: WHERE dnz_chr_id = p_chr_id
1412: AND major_version = - 1;
1413:
1414: -- Restoring OKS_K_LINES_TL

Line 1488: (SELECT id FROM oks_k_lines_bh

1484: OKC_API.init_msg_list(p_init_msg_list);
1485: x_return_status := G_RET_STS_SUCCESS;
1486: DELETE oks_k_lines_tlh
1487: WHERE id IN
1488: (SELECT id FROM oks_k_lines_bh
1489: WHERE dnz_chr_id = p_chr_id );
1490:
1491: DELETE oks_k_lines_bh
1492: WHERE dnz_chr_id = p_chr_id;

Line 1491: DELETE oks_k_lines_bh

1487: WHERE id IN
1488: (SELECT id FROM oks_k_lines_bh
1489: WHERE dnz_chr_id = p_chr_id );
1490:
1491: DELETE oks_k_lines_bh
1492: WHERE dnz_chr_id = p_chr_id;
1493:
1494: DELETE oks_k_headers_bh
1495: WHERE chr_id = p_chr_id;