DBA Data[Home] [Help]

APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_LINES_TL

Line 788: -- Versioning OKS_K_LINES_TL

784: counter_value_id
785: FROM oks_k_lines_b
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,

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 823: FROM oks_k_lines_tl a,

819: a.creation_date,
820: a.last_updated_by,
821: a.last_update_date,
822: a.last_update_login
823: FROM oks_k_lines_tl a,
824: oks_k_lines_b b
825: WHERE a.id = b.id
826: AND b.dnz_chr_id = p_chr_id;
827:

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 1028: DELETE oks_k_lines_tl

1024: BEGIN
1025: OKC_API.init_msg_list(p_init_msg_list);
1026: x_return_status := G_RET_STS_SUCCESS;
1027:
1028: DELETE oks_k_lines_tl
1029: WHERE id IN
1030: (SELECT id FROM oks_k_lines_b
1031: WHERE dnz_chr_id = p_chr_id );
1032: DELETE oks_k_lines_b

Line 1433: -- Restoring OKS_K_LINES_TL

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
1434: -- Inserting multiple records
1435: INSERT INTO oks_k_lines_tl
1436: (id,
1437: language,

Line 1435: INSERT INTO oks_k_lines_tl

1431: AND major_version = - 1;
1432:
1433: -- Restoring OKS_K_LINES_TL
1434: -- Inserting multiple records
1435: INSERT INTO oks_k_lines_tl
1436: (id,
1437: language,
1438: source_lang,
1439: sfwt_flag,

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: