DBA Data[Home] [Help]

APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_LINES_TL

Line 779: -- Versioning OKS_K_LINES_TL

775: /*** R12 Data Model Changes 27072005 End ***/
776: FROM oks_k_lines_b
777: WHERE dnz_chr_id = p_chr_id;
778:
779: -- Versioning OKS_K_LINES_TL
780: -- Inserting multiple records
781: INSERT INTO oks_k_lines_tlh
782: (major_version,
783: id,

Line 781: INSERT INTO oks_k_lines_tlh

777: WHERE dnz_chr_id = p_chr_id;
778:
779: -- Versioning OKS_K_LINES_TL
780: -- Inserting multiple records
781: INSERT INTO oks_k_lines_tlh
782: (major_version,
783: id,
784: language,
785: source_lang,

Line 814: FROM oks_k_lines_tl a,

810: a.creation_date,
811: a.last_updated_by,
812: a.last_update_date,
813: a.last_update_login
814: FROM oks_k_lines_tl a,
815: oks_k_lines_b b
816: WHERE a.id = b.id
817: AND b.dnz_chr_id = p_chr_id;
818:

Line 954: DELETE oks_k_lines_tlh

950: p_chr_id IN NUMBER) IS
951: BEGIN
952: OKC_API.init_msg_list(p_init_msg_list);
953: x_return_status := G_RET_STS_SUCCESS;
954: DELETE oks_k_lines_tlh
955: WHERE id IN
956: (SELECT id FROM oks_k_lines_bh
957: WHERE dnz_chr_id = p_chr_id )
958: AND major_version = - 1;

Line 1019: DELETE oks_k_lines_tl

1015: BEGIN
1016: OKC_API.init_msg_list(p_init_msg_list);
1017: x_return_status := G_RET_STS_SUCCESS;
1018:
1019: DELETE oks_k_lines_tl
1020: WHERE id IN
1021: (SELECT id FROM oks_k_lines_b
1022: WHERE dnz_chr_id = p_chr_id );
1023: DELETE oks_k_lines_b

Line 1414: -- Restoring OKS_K_LINES_TL

1410: FROM oks_k_lines_bh
1411: WHERE dnz_chr_id = p_chr_id
1412: AND major_version = - 1;
1413:
1414: -- Restoring OKS_K_LINES_TL
1415: -- Inserting multiple records
1416: INSERT INTO oks_k_lines_tl
1417: (id,
1418: language,

Line 1416: INSERT INTO oks_k_lines_tl

1412: AND major_version = - 1;
1413:
1414: -- Restoring OKS_K_LINES_TL
1415: -- Inserting multiple records
1416: INSERT INTO oks_k_lines_tl
1417: (id,
1418: language,
1419: source_lang,
1420: sfwt_flag,

Line 1447: FROM oks_k_lines_tlh a,

1443: a.creation_date,
1444: a.last_updated_by,
1445: a.last_update_date,
1446: a.last_update_login
1447: FROM oks_k_lines_tlh a,
1448: oks_k_lines_b b
1449: WHERE a.id = b.id
1450: AND b.dnz_chr_id = p_chr_id
1451: AND a.major_version = - 1;

Line 1486: DELETE oks_k_lines_tlh

1482: p_chr_id IN NUMBER) IS
1483: BEGIN
1484: OKC_API.init_msg_list(p_init_msg_list);
1485: x_return_status := G_RET_STS_SUCCESS;
1486: DELETE oks_k_lines_tlh
1487: WHERE id IN
1488: (SELECT id FROM oks_k_lines_bh
1489: WHERE dnz_chr_id = p_chr_id );
1490: