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 973: DELETE oks_k_headers_bh

969: DELETE oks_k_lines_bh
970: WHERE dnz_chr_id = p_chr_id
971: AND major_version = - 1;
972:
973: DELETE oks_k_headers_bh
974: WHERE chr_id = p_chr_id
975: AND major_version = - 1;
976:
977: oks_coverages_pub.delete_saved_version

Line 1218: FROM oks_k_headers_bh

1214: EXEMPT_REASON_CODE,
1215: APPROVAL_TYPE_USED,
1216: renewal_comment,
1217: cc_email_address /*Added for ER 13869562*/
1218: FROM oks_k_headers_bh
1219: WHERE chr_id = p_chr_id
1220: AND major_version = - 1;
1221:
1222: -- Restoring OKS_K_LINES_B

Line 1513: DELETE oks_k_headers_bh

1509:
1510: DELETE oks_k_lines_bh
1511: WHERE dnz_chr_id = p_chr_id;
1512:
1513: DELETE oks_k_headers_bh
1514: WHERE chr_id = p_chr_id;
1515: -- Purging Coverage Related Tables
1516: oks_coverages_pub.delete_history
1517: (

Line 1928: -- Procedure for mass insert in OKS_K_HEADERS_BH

1924: --RAISE;
1925: END INSERT_ROW_UPG;
1926:
1927: ---------------------------------------------------------------
1928: -- Procedure for mass insert in OKS_K_HEADERS_BH
1929: ---------------------------------------------------------------
1930: PROCEDURE CREATE_HDR_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
1931: p_khrhv_tbl IN khrhv_tbl_type) IS
1932:

Line 2127: INSERT INTO OKS_K_HEADERS_BH

2123: i := p_khrhv_tbl.NEXT(i);
2124: END LOOP;
2125:
2126: FORALL i IN 1..l_tabsize
2127: INSERT INTO OKS_K_HEADERS_BH
2128: (
2129: id,
2130: major_version,
2131: chr_id,