APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_HEADERS_BH

Line 393: INSERT INTO oks_k_headers_bh

389: x_return_status := G_RET_STS_SUCCESS;
390:
391: -- Versioning OKS_K_HEADERS_B
392: -- Inserting single record
393: INSERT INTO oks_k_headers_bh
394: (major_version,
395: id,
396: chr_id,
397: acct_rule_id,

Line 964: DELETE oks_k_headers_bh

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
965: WHERE chr_id = p_chr_id
966: AND major_version = - 1;
967:
968: oks_coverages_pub.delete_saved_version

Line 1205: FROM oks_k_headers_bh

1201: TAX_CLASSIFICATION_CODE,
1202: EXEMPT_CERTIFICATE_NUMBER,
1203: EXEMPT_REASON_CODE,
1204: APPROVAL_TYPE_USED
1205: FROM oks_k_headers_bh
1206: WHERE chr_id = p_chr_id
1207: AND major_version = - 1;
1208:
1209: -- Restoring OKS_K_LINES_B

Line 1494: DELETE oks_k_headers_bh

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;
1496: -- Purging Coverage Related Tables
1497: oks_coverages_pub.delete_history
1498: (

Line 1909: -- Procedure for mass insert in OKS_K_HEADERS_BH

1905: --RAISE;
1906: END INSERT_ROW_UPG;
1907:
1908: ---------------------------------------------------------------
1909: -- Procedure for mass insert in OKS_K_HEADERS_BH
1910: ---------------------------------------------------------------
1911: PROCEDURE CREATE_HDR_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
1912: p_khrhv_tbl IN khrhv_tbl_type) IS
1913:

Line 2108: INSERT INTO OKS_K_HEADERS_BH

2104: i := p_khrhv_tbl.NEXT(i);
2105: END LOOP;
2106:
2107: FORALL i IN 1..l_tabsize
2108: INSERT INTO OKS_K_HEADERS_BH
2109: (
2110: id,
2111: major_version,
2112: chr_id,