APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_LINES_BH

Line 578: INSERT INTO oks_k_lines_bh

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

Line 965: (SELECT id FROM oks_k_lines_bh

961: OKC_API.init_msg_list(p_init_msg_list);
962: x_return_status := G_RET_STS_SUCCESS;
963: DELETE oks_k_lines_tlh
964: WHERE id IN
965: (SELECT id FROM oks_k_lines_bh
966: WHERE dnz_chr_id = p_chr_id )
967: AND major_version = - 1;
968:
969: DELETE oks_k_lines_bh

Line 969: DELETE oks_k_lines_bh

965: (SELECT id FROM oks_k_lines_bh
966: WHERE dnz_chr_id = p_chr_id )
967: AND major_version = - 1;
968:
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

Line 1429: FROM oks_k_lines_bh

1425: /*** R12 Data Model Changes 27072005 End ***/
1426: --skuchima VRM ER
1427: revenue_impact_date,
1428: counter_value_id
1429: FROM oks_k_lines_bh
1430: WHERE dnz_chr_id = p_chr_id
1431: AND major_version = - 1;
1432:
1433: -- Restoring OKS_K_LINES_TL

Line 1507: (SELECT id FROM oks_k_lines_bh

1503: OKC_API.init_msg_list(p_init_msg_list);
1504: x_return_status := G_RET_STS_SUCCESS;
1505: DELETE oks_k_lines_tlh
1506: WHERE id IN
1507: (SELECT id FROM oks_k_lines_bh
1508: WHERE dnz_chr_id = p_chr_id );
1509:
1510: DELETE oks_k_lines_bh
1511: WHERE dnz_chr_id = p_chr_id;

Line 1510: DELETE oks_k_lines_bh

1506: WHERE id IN
1507: (SELECT id FROM oks_k_lines_bh
1508: WHERE dnz_chr_id = p_chr_id );
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;