APPS.OKS_CONTRACT_HDR_PUB dependencies on OKS_K_LINES_B

Line 573: -- Versioning OKS_K_LINES_B

569: APPROVAL_TYPE_USED
570: FROM oks_k_headers_b
571: WHERE chr_id = p_chr_id;
572:
573: -- Versioning OKS_K_LINES_B
574: -- Inserting multiple records
575: INSERT INTO oks_k_lines_bh
576: (major_version,
577: id,

Line 575: INSERT INTO oks_k_lines_bh

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

Line 776: FROM oks_k_lines_b

772: EXEMPT_REASON_CODE,
773: COVERAGE_ID,
774: STANDARD_COV_YN
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

Line 815: oks_k_lines_b b

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

Line 956: (SELECT id FROM oks_k_lines_bh

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;
959:
960: DELETE oks_k_lines_bh

Line 960: DELETE oks_k_lines_bh

956: (SELECT id FROM oks_k_lines_bh
957: WHERE dnz_chr_id = p_chr_id )
958: AND major_version = - 1;
959:
960: DELETE oks_k_lines_bh
961: WHERE dnz_chr_id = p_chr_id
962: AND major_version = - 1;
963:
964: DELETE oks_k_headers_bh

Line 1021: (SELECT id FROM oks_k_lines_b

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

Line 1023: DELETE oks_k_lines_b

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
1024: WHERE dnz_chr_id = p_chr_id;
1025: DELETE oks_k_headers_b
1026: WHERE chr_id = p_chr_id;
1027:

Line 1209: -- Restoring OKS_K_LINES_B

1205: FROM oks_k_headers_bh
1206: WHERE chr_id = p_chr_id
1207: AND major_version = - 1;
1208:
1209: -- Restoring OKS_K_LINES_B
1210: -- Inserting multiple records
1211: INSERT INTO oks_k_lines_b
1212: (id,
1213: cle_id,

Line 1211: INSERT INTO oks_k_lines_b

1207: AND major_version = - 1;
1208:
1209: -- Restoring OKS_K_LINES_B
1210: -- Inserting multiple records
1211: INSERT INTO oks_k_lines_b
1212: (id,
1213: cle_id,
1214: dnz_chr_id,
1215: discount_list,

Line 1410: FROM oks_k_lines_bh

1406: EXEMPT_REASON_CODE,
1407: COVERAGE_ID,
1408: STANDARD_COV_YN
1409: /*** R12 Data Model Changes 27072005 End ***/
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

Line 1448: oks_k_lines_b b

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

Line 1488: (SELECT id FROM oks_k_lines_bh

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:
1491: DELETE oks_k_lines_bh
1492: WHERE dnz_chr_id = p_chr_id;

Line 1491: DELETE oks_k_lines_bh

1487: WHERE id IN
1488: (SELECT id FROM oks_k_lines_bh
1489: WHERE dnz_chr_id = p_chr_id );
1490:
1491: DELETE oks_k_lines_bh
1492: WHERE dnz_chr_id = p_chr_id;
1493:
1494: DELETE oks_k_headers_bh
1495: WHERE chr_id = p_chr_id;