APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_HEADERS_B

Line 391: -- Versioning OKS_K_HEADERS_B

387: BEGIN
388: OKC_API.init_msg_list(p_init_msg_list);
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,

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 570: FROM oks_k_headers_b

566: TAX_CLASSIFICATION_CODE,
567: EXEMPT_CERTIFICATE_NUMBER,
568: EXEMPT_REASON_CODE,
569: APPROVAL_TYPE_USED
570: FROM oks_k_headers_b
571: WHERE chr_id = p_chr_id;
572:
573: -- Versioning OKS_K_LINES_B
574: -- Inserting multiple records

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 1025: DELETE oks_k_headers_b

1021: (SELECT id FROM oks_k_lines_b
1022: WHERE dnz_chr_id = p_chr_id );
1023: DELETE oks_k_lines_b
1024: WHERE dnz_chr_id = p_chr_id;
1025: DELETE oks_k_headers_b
1026: WHERE chr_id = p_chr_id;
1027:
1028: -- Restoring OKS_K_HEADERS_B
1029: -- Inserting single record

Line 1028: -- Restoring OKS_K_HEADERS_B

1024: WHERE dnz_chr_id = p_chr_id;
1025: DELETE oks_k_headers_b
1026: WHERE chr_id = p_chr_id;
1027:
1028: -- Restoring OKS_K_HEADERS_B
1029: -- Inserting single record
1030: INSERT INTO oks_k_headers_b
1031: (id,
1032: chr_id,

Line 1030: INSERT INTO oks_k_headers_b

1026: WHERE chr_id = p_chr_id;
1027:
1028: -- Restoring OKS_K_HEADERS_B
1029: -- Inserting single record
1030: INSERT INTO oks_k_headers_b
1031: (id,
1032: chr_id,
1033: acct_rule_id,
1034: payment_type,

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 1520: -- Procedure for mass insert in OKS_K_HEADERS_B table

1516: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1517: END delete_history;
1518:
1519: ---------------------------------------------------------------
1520: -- Procedure for mass insert in OKS_K_HEADERS_B table
1521: ---------------------------------------------------------------
1522: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
1523: p_khrv_tbl IN khrv_tbl_type) IS
1524:

Line 1715: INTO OKS_K_HEADERS_B

1711: END LOOP;
1712:
1713: FORALL i IN 1..l_tabsize
1714: INSERT
1715: INTO OKS_K_HEADERS_B
1716: (
1717: id,
1718: chr_id,
1719: acct_rule_id,

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,