DBA Data[Home] [Help]

APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_LINES_TLH

Line 790: INSERT INTO oks_k_lines_tlh

786: WHERE dnz_chr_id = p_chr_id;
787:
788: -- Versioning OKS_K_LINES_TL
789: -- Inserting multiple records
790: INSERT INTO oks_k_lines_tlh
791: (major_version,
792: id,
793: language,
794: source_lang,

Line 963: DELETE oks_k_lines_tlh

959: p_chr_id IN NUMBER) IS
960: BEGIN
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;

Line 1466: FROM oks_k_lines_tlh a,

1462: a.creation_date,
1463: a.last_updated_by,
1464: a.last_update_date,
1465: a.last_update_login
1466: FROM oks_k_lines_tlh a,
1467: oks_k_lines_b b
1468: WHERE a.id = b.id
1469: AND b.dnz_chr_id = p_chr_id
1470: AND a.major_version = - 1;

Line 1505: DELETE oks_k_lines_tlh

1501: p_chr_id IN NUMBER) IS
1502: BEGIN
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: