APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_LINES_B

Line 576: -- Versioning OKS_K_LINES_B

572: cc_email_address /*Added for ER 13869562*/
573: FROM oks_k_headers_b
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,

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

781: /*** R12 Data Model Changes 27072005 End ***/
782: /* skuchima VRM Er Changes */
783: revenue_impact_date,
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

Line 824: oks_k_lines_b b

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:
828: -- Versioning Coverage Related Tables

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 1030: (SELECT id FROM oks_k_lines_b

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
1033: WHERE dnz_chr_id = p_chr_id;
1034: DELETE oks_k_headers_b

Line 1032: DELETE oks_k_lines_b

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
1033: WHERE dnz_chr_id = p_chr_id;
1034: DELETE oks_k_headers_b
1035: WHERE chr_id = p_chr_id;
1036:

Line 1222: -- Restoring OKS_K_LINES_B

1218: FROM oks_k_headers_bh
1219: WHERE chr_id = p_chr_id
1220: AND major_version = - 1;
1221:
1222: -- Restoring OKS_K_LINES_B
1223: -- Inserting multiple records
1224: INSERT INTO oks_k_lines_b
1225: (id,
1226: cle_id,

Line 1224: INSERT INTO oks_k_lines_b

1220: AND major_version = - 1;
1221:
1222: -- Restoring OKS_K_LINES_B
1223: -- Inserting multiple records
1224: INSERT INTO oks_k_lines_b
1225: (id,
1226: cle_id,
1227: dnz_chr_id,
1228: discount_list,

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 1467: oks_k_lines_b b

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;
1471:

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;