[Home] [Help]
10:
11: PROCEDURE Validate_svc_cle_id(
12: p_ac_rec IN ac_rec_type,
13: x_return_status OUT NOCOPY VARCHAR2) IS
14: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
15: BEGIN
16: IF p_ac_rec.Svc_Cle_id = OKC_API.G_MISS_NUM OR
17: p_ac_rec.Svc_Cle_id IS NULL
18: THEN
12: p_ac_rec IN ac_rec_type,
13: x_return_status OUT NOCOPY VARCHAR2) IS
14: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
15: BEGIN
16: IF p_ac_rec.Svc_Cle_id = OKC_API.G_MISS_NUM OR
17: p_ac_rec.Svc_Cle_id IS NULL
18: THEN
19: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Svc_Cle_id');
20:
15: BEGIN
16: IF p_ac_rec.Svc_Cle_id = OKC_API.G_MISS_NUM OR
17: p_ac_rec.Svc_Cle_id IS NULL
18: THEN
19: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Svc_Cle_id');
20:
21: l_return_status := OKC_API.G_RET_STS_ERROR;
22: END IF;
23: x_return_status := l_return_status;
17: p_ac_rec.Svc_Cle_id IS NULL
18: THEN
19: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Svc_Cle_id');
20:
21: l_return_status := OKC_API.G_RET_STS_ERROR;
22: END IF;
23: x_return_status := l_return_status;
24: EXCEPTION
25: WHEN OTHERS THEN
23: x_return_status := l_return_status;
24: EXCEPTION
25: WHEN OTHERS THEN
26: -- store SQL error message on message stack for caller
27: OKC_API.set_message(G_APP_NAME,
28: G_UNEXPECTED_ERROR,
29: G_SQLCODE_TOKEN,
30: SQLCODE,
31: G_SQLERRM_TOKEN,
30: SQLCODE,
31: G_SQLERRM_TOKEN,
32: SQLERRM);
33: -- notify caller of an UNEXPECTED error
34: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
35: END validate_svc_Cle_id;
36:
37: ---------------------------------------------------------------------------
38: -- PROCEDURE Validate_Line_id
39: ---------------------------------------------------------------------------
40: PROCEDURE Validate_Line_id(
41: p_line_id IN NUMBER,
42: x_return_status OUT NOCOPY VARCHAR2) IS
43: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
44: l_Count NUMBER;
45: CURSOR Cur_Line(P_Line_Id IN NUMBER) IS
46: SELECT COUNT(*) FROM OKC_K_LINES_V
47: WHERE id=P_Line_Id;
45: CURSOR Cur_Line(P_Line_Id IN NUMBER) IS
46: SELECT COUNT(*) FROM OKC_K_LINES_V
47: WHERE id=P_Line_Id;
48: BEGIN
49: IF P_Line_id = OKC_API.G_MISS_NUM OR
50: P_Line_Id IS NULL
51: THEN
52: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'P_Line_Id');
53:
48: BEGIN
49: IF P_Line_id = OKC_API.G_MISS_NUM OR
50: P_Line_Id IS NULL
51: THEN
52: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'P_Line_Id');
53:
54: l_return_status := OKC_API.G_RET_STS_ERROR;
55: END IF;
56:
50: P_Line_Id IS NULL
51: THEN
52: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'P_Line_Id');
53:
54: l_return_status := OKC_API.G_RET_STS_ERROR;
55: END IF;
56:
57: OPEN Cur_Line(P_LIne_Id);
58: FETCH Cur_Line INTO l_Count;
58: FETCH Cur_Line INTO l_Count;
59: CLOSE Cur_Line;
60: IF NOT l_Count = 1
61: THEN
62: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'P_Line_Id');
63:
64: l_return_status := OKC_API.G_RET_STS_ERROR;
65: END IF;
66: x_return_status := l_return_status;
60: IF NOT l_Count = 1
61: THEN
62: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'P_Line_Id');
63:
64: l_return_status := OKC_API.G_RET_STS_ERROR;
65: END IF;
66: x_return_status := l_return_status;
67: EXCEPTION
68: WHEN OTHERS THEN
66: x_return_status := l_return_status;
67: EXCEPTION
68: WHEN OTHERS THEN
69: -- store SQL error message on message stack for caller
70: OKC_API.set_message(G_APP_NAME,
71: G_UNEXPECTED_ERROR,
72: G_SQLCODE_TOKEN,
73: SQLCODE,
74: G_SQLERRM_TOKEN,
73: SQLCODE,
74: G_SQLERRM_TOKEN,
75: SQLERRM);
76: -- notify caller of an UNEXPECTED error
77: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
78: END Validate_Line_id;
79: PROCEDURE Validate_tmp_cle_id(
80: p_ac_rec IN ac_rec_type,
81: x_template_yn OUT NOCOPY VARCHAR2,
87: AND lse_id in (2,15,20)
88: and dnz_chr_id < 0;
89:
90: l_Count Number :=0;
91: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
92: BEGIN
93: IF p_ac_rec.tmp_cle_id = OKC_API.G_MISS_NUM OR
94: p_ac_rec.tmp_cle_id IS NULL
95: THEN
89:
90: l_Count Number :=0;
91: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
92: BEGIN
93: IF p_ac_rec.tmp_cle_id = OKC_API.G_MISS_NUM OR
94: p_ac_rec.tmp_cle_id IS NULL
95: THEN
96: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Tmp_cle_Id');
97:
92: BEGIN
93: IF p_ac_rec.tmp_cle_id = OKC_API.G_MISS_NUM OR
94: p_ac_rec.tmp_cle_id IS NULL
95: THEN
96: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Tmp_cle_Id');
97:
98: l_return_status := OKC_API.G_RET_STS_ERROR;
99: END IF;
100:
94: p_ac_rec.tmp_cle_id IS NULL
95: THEN
96: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Tmp_cle_Id');
97:
98: l_return_status := OKC_API.G_RET_STS_ERROR;
99: END IF;
100:
101: OPEN check_cov_tmpl(p_ac_rec.tmp_cle_id);
102: FETCH check_cov_tmpl INTO l_Count;
110: x_return_status := l_return_status;
111: EXCEPTION
112: WHEN OTHERS THEN
113: -- store SQL error message on message stack for caller
114: OKC_API.set_message(G_APP_NAME,
115: G_UNEXPECTED_ERROR,
116: G_SQLCODE_TOKEN,
117: SQLCODE,
118: G_SQLERRM_TOKEN,
117: SQLCODE,
118: G_SQLERRM_TOKEN,
119: SQLERRM);
120: -- notify caller of an UNEXPECTED error
121: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
122: END Validate_tmp_cle_id;
123:
124: PROCEDURE Init_Clev(P_Clev_Tbl_In_Out IN OUT NOCOPY OKC_Contract_Pub.Clev_Tbl_type) IS
125:
404: -- ******************************************************************************************
405:
406: PROCEDURE CREATE_ACTUAL_COVERAGE(
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,
412: p_ac_rec_in IN ac_rec_type,
900: Validate_svc_cle_id(
901: p_ac_rec => P_ac_rec_in,
902: x_return_status => l_return_status);
903:
904: IF NOT l_Return_status = OKC_API.G_RET_STS_SUCCESS
905: THEN
906: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Error in Service Line Validation');
907: RAISE G_EXCEPTION_HALT_VALIDATION;
908: END IF;
902: x_return_status => l_return_status);
903:
904: IF NOT l_Return_status = OKC_API.G_RET_STS_SUCCESS
905: THEN
906: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Error in Service Line Validation');
907: RAISE G_EXCEPTION_HALT_VALIDATION;
908: END IF;
909:
910: Validate_Tmp_cle_id(
911: p_ac_rec => P_ac_rec_in,
912: x_template_yn => l_cov_templ_yn,
913: x_return_status => l_return_status);
914:
915: IF NOT l_Return_status = OKC_API.G_RET_STS_SUCCESS
916: THEN
917: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Error in Coverage Template Line Validation');
918: RAISE G_EXCEPTION_HALT_VALIDATION;
919: END IF;
913: x_return_status => l_return_status);
914:
915: IF NOT l_Return_status = OKC_API.G_RET_STS_SUCCESS
916: THEN
917: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Error in Coverage Template Line Validation');
918: RAISE G_EXCEPTION_HALT_VALIDATION;
919: END IF;
920:
921: IF NOT (sysdate BETWEEN LineDet_Rec.Start_Date AND
921: IF NOT (sysdate BETWEEN LineDet_Rec.Start_Date AND
922: LineDet_Rec.End_Date)
923: THEN
924:
925: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage Template_dates');
926: x_return_status := OKC_API.G_RET_STS_ERROR;
927: RETURN;
928: END IF;
929:
922: LineDet_Rec.End_Date)
923: THEN
924:
925: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage Template_dates');
926: x_return_status := OKC_API.G_RET_STS_ERROR;
927: RETURN;
928: END IF;
929:
930:
933: CLOSE Check_Cur;
934:
935: IF NOT l_Exists=0
936: THEN l_Msg_data:='Coverage already Exists';
937: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage Exists');
938: x_return_status := OKC_API.G_RET_STS_ERROR;
939: RETURN;
940: END IF;
941:
934:
935: IF NOT l_Exists=0
936: THEN l_Msg_data:='Coverage already Exists';
937: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage Exists');
938: x_return_status := OKC_API.G_RET_STS_ERROR;
939: RETURN;
940: END IF;
941:
942: -- Contract Line for the Service Line
946: THEN
947: l_Parent_lse_Id:=LineDet_Rec.lse_Id;
948: g_chr_Id:=LineDet_Rec.chr_Id;
949: ELSE
950: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Given Service or Warranty does not exist');
951: CLOSE Cur_LineDet;
952: l_return_status := OKC_API.G_RET_STS_ERROR;
953: RAISE G_EXCEPTION_HALT_VALIDATION;
954: END IF;
948: g_chr_Id:=LineDet_Rec.chr_Id;
949: ELSE
950: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Given Service or Warranty does not exist');
951: CLOSE Cur_LineDet;
952: l_return_status := OKC_API.G_RET_STS_ERROR;
953: RAISE G_EXCEPTION_HALT_VALIDATION;
954: END IF;
955: CLOSE Cur_LineDet;
956:
961: IF Cur_LineDet%FOUND
962: THEN
963: tmp_lse_id:=LineDet_Rec.lse_Id;
964: ELSE
965: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage Template does not exist');
966: CLOSE Cur_LineDet;
967: l_return_status := OKC_API.G_RET_STS_ERROR;
968: RAISE G_EXCEPTION_HALT_VALIDATION;
969: END IF;
963: tmp_lse_id:=LineDet_Rec.lse_Id;
964: ELSE
965: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage Template does not exist');
966: CLOSE Cur_LineDet;
967: l_return_status := OKC_API.G_RET_STS_ERROR;
968: RAISE G_EXCEPTION_HALT_VALIDATION;
969: END IF;
970: CLOSE Cur_LineDet;
971:
973: -- added additional check tmp_lse_id NOT IN (2,20) for bug # 3378148
974:
975: IF (l_Parent_lse_id in (1,19)) THEN
976: IF (tmp_lse_id NOT IN (2,20)) THEN
977: OKC_API.set_message(G_APP_NAME, l_type_msmtch);
978: l_return_status := OKC_API.G_RET_STS_ERROR;
979: RAISE G_EXCEPTION_HALT_VALIDATION;
980: END IF;
981: ELSIF (l_Parent_lse_id = 14) THEN
974:
975: IF (l_Parent_lse_id in (1,19)) THEN
976: IF (tmp_lse_id NOT IN (2,20)) THEN
977: OKC_API.set_message(G_APP_NAME, l_type_msmtch);
978: l_return_status := OKC_API.G_RET_STS_ERROR;
979: RAISE G_EXCEPTION_HALT_VALIDATION;
980: END IF;
981: ELSIF (l_Parent_lse_id = 14) THEN
982: IF (tmp_lse_id <> 15) THEN
979: RAISE G_EXCEPTION_HALT_VALIDATION;
980: END IF;
981: ELSIF (l_Parent_lse_id = 14) THEN
982: IF (tmp_lse_id <> 15) THEN
983: OKC_API.set_message(G_APP_NAME, l_type_msmtch);
984: l_return_status := OKC_API.G_RET_STS_ERROR;
985: RAISE G_EXCEPTION_HALT_VALIDATION;
986: END IF;
987: -- commented on 15-Jan-2004 SMOHAPAT
980: END IF;
981: ELSIF (l_Parent_lse_id = 14) THEN
982: IF (tmp_lse_id <> 15) THEN
983: OKC_API.set_message(G_APP_NAME, l_type_msmtch);
984: l_return_status := OKC_API.G_RET_STS_ERROR;
985: RAISE G_EXCEPTION_HALT_VALIDATION;
986: END IF;
987: -- commented on 15-Jan-2004 SMOHAPAT
988: /* ELSIF (l_Parent_lse_id = 19) THEN
986: END IF;
987: -- commented on 15-Jan-2004 SMOHAPAT
988: /* ELSIF (l_Parent_lse_id = 19) THEN
989: IF (tmp_lse_id <> 20) THEN
990: OKC_API.set_message(G_APP_NAME, l_type_msmtch);
991: l_return_status := OKC_API.G_RET_STS_ERROR;
992: RAISE G_EXCEPTION_HALT_VALIDATION;
993: END IF;
994: */
987: -- commented on 15-Jan-2004 SMOHAPAT
988: /* ELSIF (l_Parent_lse_id = 19) THEN
989: IF (tmp_lse_id <> 20) THEN
990: OKC_API.set_message(G_APP_NAME, l_type_msmtch);
991: l_return_status := OKC_API.G_RET_STS_ERROR;
992: RAISE G_EXCEPTION_HALT_VALIDATION;
993: END IF;
994: */
995: END IF;
1046: IF (G_DEBUG_ENABLED = 'Y') THEN
1047: okc_debug.log('After okc_contract_pub create_contract_line', 2);
1048: END IF;
1049:
1050: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1051: RAISE G_EXCEPTION_HALT_VALIDATION;
1052: ELSE
1053: c_cle_id := l_clev_tbl_out(1).Id;
1054: END IF;
1090: okc_debug.log('After OKS_CONTRACT_LINE_PUB.CREATE_LINE', 2);
1091: END IF;
1092:
1093:
1094: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1095: RAISE G_EXCEPTION_HALT_VALIDATION;
1096: END IF;
1097: END LOOP;
1098:
1145: p_attribute15 => notes_rec.ATTRIBUTE15,
1146: p_context => notes_rec.CONTEXT,
1147: p_note_type => notes_rec.NOTE_TYPE);
1148:
1149: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1150: RAISE G_EXCEPTION_HALT_VALIDATION;
1151: END IF;
1152: END LOOP;
1153:
1176: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
1177: END IF;
1178:
1179:
1180: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1181: RAISE G_EXCEPTION_HALT_VALIDATION;
1182: END IF;
1183: END IF;
1184: END IF; -- end of IF condition if l_cov_templ_yn = N
1270:
1271:
1272:
1273:
1274: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1275: RAISE G_EXCEPTION_HALT_VALIDATION;
1276: ELSE
1277: txg_cle_Id:=l_clev_tbl_out(1).ID;
1278: END IF;
1299: x_msg_data => l_msg_data,
1300: p_cimv_tbl => l_cimv_tbl_in,
1301: x_cimv_tbl => l_cimv_tbl_out);
1302:
1303: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1304: RAISE G_EXCEPTION_HALT_VALIDATION;
1305: END IF;
1306: END LOOP;
1307:
1328: p_klnv_tbl => l_klnv_tbl_in,
1329: x_klnv_tbl => l_klnv_tbl_out,
1330: p_validate_yn => 'N');
1331:
1332: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1333: RAISE G_EXCEPTION_HALT_VALIDATION;
1334: END IF;
1335: l_klnv_tbl_in.delete;
1336: -- Create Cover Time Rule For BUS PROC FOR ACTUAL COVERAGE
1358: okc_debug.log('After OKS_CTZ_PVT insert_row'||l_return_status, 2);
1359: END IF;
1360:
1361:
1362: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1363: RAISE G_EXCEPTION_HALT_VALIDATION;
1364: END IF;
1365:
1366:
1406: okc_debug.log('After OKS_CVT_PVT insert_row'||l_return_status, 2);
1407: END IF;
1408:
1409:
1410: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1411: RAISE G_EXCEPTION_HALT_VALIDATION;
1412: END IF;
1413: END LOOP; -- End loop for OKS_BP_REC
1414:
1464: p_restricted_update => p_restricted_update,
1465: p_clev_tbl => l_clev_tbl_in,
1466: x_clev_tbl => l_clev_tbl_out);
1467:
1468: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1469: RAISE G_EXCEPTION_HALT_VALIDATION;
1470: ELSE
1471: crt_cle_id:=l_clev_tbl_out(1).ID;
1472: END IF;
1500: p_klnv_tbl => l_klnv_tbl_in,
1501: x_klnv_tbl => l_klnv_tbl_out,
1502: p_validate_yn => 'N');
1503:
1504: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1505: RAISE G_EXCEPTION_HALT_VALIDATION;
1506: END IF;
1507: l_rt_cle_id := l_klnv_tbl_out(1).id ;
1508: END LOOP; -- end loop for oks_react_rec
1532: END IF;
1533:
1534:
1535:
1536: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1537: RAISE G_EXCEPTION_HALT_VALIDATION;
1538: END IF;
1539: l_cov_act_type_line_id := l_act_type_tbl_out(1).id ;
1540:
1569: IF (G_DEBUG_ENABLED = 'Y') THEN
1570: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
1571: END IF;
1572:
1573: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1574: RAISE G_EXCEPTION_HALT_VALIDATION;
1575: END IF;
1576: END LOOP ; -- END LOOP FOR ACT_TYPE_REC
1577: END LOOP;
1619: x_msg_data => l_msg_data,
1620: p_cplv_tbl => l_cplv_tbl_in,
1621: x_cplv_tbl => l_cplv_tbl_out);
1622:
1623: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1624: RAISE G_EXCEPTION_HALT_VALIDATION;
1625: ELSE
1626: l_cpl_id :=l_cplv_tbl_out(1).Id;
1627: END IF;
1648: p_ctcv_tbl => l_ctcv_tbl_in,
1649: x_ctcv_tbl => l_ctcv_tbl_out);
1650:
1651:
1652: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1653: RAISE G_EXCEPTION_HALT_VALIDATION;
1654: ELSE
1655: l_contact_id :=l_ctcv_tbl_out(1).Id;
1656: END IF;
1738: p_clev_tbl => l_clev_tbl_in,
1739: x_clev_tbl => l_clev_tbl_out);
1740:
1741:
1742: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1743: RAISE G_EXCEPTION_HALT_VALIDATION;
1744: ELSE
1745: bt_cle_id:=l_clev_tbl_out(1).ID;
1746: END IF;
1768: x_klnv_tbl => l_klnv_tbl_out,
1769: p_validate_yn => 'N');
1770:
1771:
1772: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1773: RAISE G_EXCEPTION_HALT_VALIDATION;
1774: END IF;
1775: END LOOP;
1776: -- For all the Contract Item for BILL TYPE in TEMPLATE, create the same for Actual Coverage
1795: x_msg_data => l_msg_data,
1796: p_cimv_tbl => l_cimv_tbl_in,
1797: x_cimv_tbl => l_cimv_tbl_out);
1798:
1799: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1800: RAISE G_EXCEPTION_HALT_VALIDATION;
1801: END IF;
1802: END LOOP;
1803:
1865: p_restricted_update => p_restricted_update,
1866: p_clev_tbl => l_clev_tbl_in,
1867: x_clev_tbl => l_clev_tbl_out);
1868:
1869: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1870: RAISE G_EXCEPTION_HALT_VALIDATION;
1871: ELSE
1872: br_cle_id:=l_clev_tbl_out(1).ID;
1873: END IF;
1922: okc_debug.log('Exiting Create_Actual_Coverage', 2);
1923: okc_debug.Reset_Indentation;
1924: END IF;
1925:
1926: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1927: RAISE G_EXCEPTION_HALT_VALIDATION;
1928: END IF ;
1929: END LOOP ;
1930: END IF;
1949: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1950: x_return_status := l_return_status ;
1951: /* x_msg_count :=l_msg_count;
1952: x_msg_data:=l_msg_data;
1953: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1954: (
1955: l_api_name,
1956: 'Create_actual_coverage',
1957: 'OKC_API.G_RET_STS_ERROR',
1953: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1954: (
1955: l_api_name,
1956: 'Create_actual_coverage',
1957: 'OKC_API.G_RET_STS_ERROR',
1958: x_msg_count,
1959: x_msg_data,
1960: '_PVT'
1961: );
1958: x_msg_count,
1959: x_msg_data,
1960: '_PVT'
1961: );
1962: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1963: x_msg_count :=l_msg_count;
1964: x_msg_data:=l_msg_data;
1965: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1966: (
1961: );
1962: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1963: x_msg_count :=l_msg_count;
1964: x_msg_data:=l_msg_data;
1965: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1966: (
1967: l_api_name,
1968: 'Create_actual_coverage',
1969: 'OKC_API.G_RET_STS_ERROR',
1965: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1966: (
1967: l_api_name,
1968: 'Create_actual_coverage',
1969: 'OKC_API.G_RET_STS_ERROR',
1970: x_msg_count,
1971: x_msg_data,
1972: '_PVT'
1973: );
1970: x_msg_count,
1971: x_msg_data,
1972: '_PVT'
1973: );
1974: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1975: x_msg_count :=l_msg_count;
1976: x_msg_data:=l_msg_data;
1977: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1978: (
1973: );
1974: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1975: x_msg_count :=l_msg_count;
1976: x_msg_data:=l_msg_data;
1977: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1978: (
1979: l_api_name,
1980: 'Create_actual_coverage',
1981: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1977: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1978: (
1979: l_api_name,
1980: 'Create_actual_coverage',
1981: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1982: x_msg_count,
1983: x_msg_data,
1984: '_PVT'
1985: );
1991: END IF;
1992:
1993:
1994: WHEN OTHERS THEN
1995: OKC_API.SET_MESSAGE(
1996: p_app_name => g_app_name,
1997: p_msg_name => g_unexpected_error,
1998: p_token1 => g_sqlcode_token,
1999: p_token1_value => sqlcode,
1999: p_token1_value => sqlcode,
2000: p_token2 => g_sqlerrm_token,
2001: p_token2_value => sqlerrm);
2002: -- notify caller of an error as UNEXPETED error
2003: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2004: x_msg_count :=l_msg_count;
2005:
2006: IF (G_DEBUG_ENABLED = 'Y') THEN
2007: okc_debug.log('Exiting Create_Actual_Coverage'||SQLERRM, 2);
2012:
2013: -- ******************************************************************************************
2014: PROCEDURE Undo_Header(
2015: p_api_version IN NUMBER,
2016: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2017: x_return_status OUT NOCOPY VARCHAR2,
2018: x_msg_count OUT NOCOPY NUMBER,
2019: x_msg_data OUT NOCOPY VARCHAR2,
2020: P_Header_id IN NUMBER) IS
2049: BEGIN
2050:
2051: IF P_Header_Id IS NULL
2052: THEN l_msg_data:= 'Header_id Can not be Null';
2053: l_return_status := OKC_API.G_RET_STS_ERROR;
2054: RAISE e_Error;
2055: END IF;
2056: l_chrv_rec.id := P_Header_Id;
2057:
2077: x_return_status => l_return_status,
2078: x_msg_count => l_msg_count,
2079: x_msg_data => l_msg_data,
2080: p_gvev_tbl => l_gvev_tbl_in);
2081: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2082: l_msg_data:= 'Error while deleting governance -'||l_msg_data;
2083: return;
2084: end if;
2085: END IF;
2091: l_Line_Id:=l_line_tbl(v_Index);
2092: Undo_Counters( P_KLine_Id => l_Line_Id,
2093: x_return_status => l_return_status,
2094: x_msg_data => l_msg_data);
2095: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2096: l_msg_data:= 'Error while deleting Counters -'||l_msg_data;
2097: return;
2098: end if;
2099: END LOOP;
2104: x_return_status =>l_return_status,
2105: x_msg_count =>l_msg_count,
2106: x_msg_data =>l_msg_data,
2107: p_chrv_rec =>l_chrv_rec);
2108: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2109: l_msg_data:= 'Error while deleting Header -'||l_msg_data;
2110: return;
2111: end if;
2112: x_return_status:=l_return_status;
2115: x_msg_count :=l_msg_count;
2116: x_msg_data:=l_msg_data;
2117: x_return_status:=l_return_status;
2118:
2119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2120: (
2121: l_api_name,
2122: 'Undo_Header',
2123: 'OKC_API.G_RET_STS_ERROR',
2119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2120: (
2121: l_api_name,
2122: 'Undo_Header',
2123: 'OKC_API.G_RET_STS_ERROR',
2124: x_msg_count,
2125: x_msg_data,
2126: '_PVT'
2127: );
2124: x_msg_count,
2125: x_msg_data,
2126: '_PVT'
2127: );
2128: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2129: x_msg_count :=l_msg_count;
2130: x_msg_data:=l_msg_data;
2131:
2132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2128: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2129: x_msg_count :=l_msg_count;
2130: x_msg_data:=l_msg_data;
2131:
2132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2133: (
2134: l_api_name,
2135: 'Undo_Header',
2136: 'OKC_API.G_RET_STS_ERROR',
2132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2133: (
2134: l_api_name,
2135: 'Undo_Header',
2136: 'OKC_API.G_RET_STS_ERROR',
2137: x_msg_count,
2138: x_msg_data,
2139: '_PVT'
2140: );
2137: x_msg_count,
2138: x_msg_data,
2139: '_PVT'
2140: );
2141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2142: x_msg_count :=l_msg_count;
2143: x_msg_data:=l_msg_data;
2144: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2145: (
2140: );
2141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2142: x_msg_count :=l_msg_count;
2143: x_msg_data:=l_msg_data;
2144: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2145: (
2146: l_api_name,
2147: 'Undo_Header',
2148: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2144: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2145: (
2146: l_api_name,
2147: 'Undo_Header',
2148: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2149: x_msg_count,
2150: x_msg_data,
2151: '_PVT'
2152: );
2151: '_PVT'
2152: );
2153: WHEN OTHERS THEN
2154:
2155: OKC_API.SET_MESSAGE(
2156: p_app_name => g_app_name,
2157: p_msg_name => g_unexpected_Error,
2158: p_token1 => g_sqlcode_token,
2159: p_token1_value => sqlcode,
2159: p_token1_value => sqlcode,
2160: p_token2 => g_sqlerrm_token,
2161: p_token2_value => sqlerrm);
2162: -- notify caller of an error as UNEXPETED error
2163: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2164: x_msg_count :=l_msg_count;
2165: END Undo_Header;
2166:
2167: PROCEDURE Undo_Line(
2165: END Undo_Header;
2166:
2167: PROCEDURE Undo_Line(
2168: p_api_version IN NUMBER,
2169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2170: x_return_status OUT NOCOPY VARCHAR2,
2171: x_msg_count OUT NOCOPY NUMBER,
2172: x_msg_data OUT NOCOPY VARCHAR2,
2173: P_Line_Id IN NUMBER) IS
2179: l_Rule_Id NUMBER;
2180: l_cle_Id NUMBER;
2181: v_Index Binary_Integer;
2182:
2183: G_APP_NAME CONSTANT VARCHAR2(3) :=OKC_API.G_APP_NAME;
2184: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) :=OKC_API.G_REQUIRED_VALUE;
2185: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) :=OKC_API.G_COL_NAME_TOKEN;
2186: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKS_UNEXP_ERROR';
2187: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) :='SQLerrm';
2180: l_cle_Id NUMBER;
2181: v_Index Binary_Integer;
2182:
2183: G_APP_NAME CONSTANT VARCHAR2(3) :=OKC_API.G_APP_NAME;
2184: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) :=OKC_API.G_REQUIRED_VALUE;
2185: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) :=OKC_API.G_COL_NAME_TOKEN;
2186: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKS_UNEXP_ERROR';
2187: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) :='SQLerrm';
2188: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) :='SQLcode';
2181: v_Index Binary_Integer;
2182:
2183: G_APP_NAME CONSTANT VARCHAR2(3) :=OKC_API.G_APP_NAME;
2184: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) :=OKC_API.G_REQUIRED_VALUE;
2185: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) :=OKC_API.G_COL_NAME_TOKEN;
2186: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKS_UNEXP_ERROR';
2187: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) :='SQLerrm';
2188: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) :='SQLcode';
2189:
2470: CLOSE line_det_cur;
2471: */
2472: -- End of Bug:4535339 by Jvorugan
2473:
2474: x_return_status:=OKC_API.G_Ret_Sts_Success;
2475:
2476: OKS_COVERAGES_PVT.Validate_Line_id(p_line_id,l_return_status);
2477: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2478: -- IF NOT l_Return_Status ='S' THEN
2473:
2474: x_return_status:=OKC_API.G_Ret_Sts_Success;
2475:
2476: OKS_COVERAGES_PVT.Validate_Line_id(p_line_id,l_return_status);
2477: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2478: -- IF NOT l_Return_Status ='S' THEN
2479: RETURN;
2480: END IF;
2481:
2505: x_msg_data => l_msg_data , -- OUT NOCOPY VARCHAR2
2506: p_jtf_note_id => note_rec.jtf_note_id,
2507: p_use_AOL_security => 'F' --IN VARCHAR2 DEFAULT 'T'
2508: );
2509: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2510: RAISE e_Error;
2511: END IF;
2512: END LOOP;
2513:
2537: x_msg_count => l_msg_count,
2538: x_msg_data => l_msg_data,
2539: p_oks_billrate_schedules_v_tbl => l_brs_tbl_in);
2540:
2541: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2542: RAISE e_Error;
2543: end if;
2544:
2545:
2710: x_msg_data =>l_msg_data,
2711: p_cle_id =>l_pm_cle_id);
2712:
2713: --chkrishn 03/17/04 exception handling
2714: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2715: return;
2716: END IF;
2717:
2718:
2732: p_oks_billrate_schedules_v_tbl => l_brsv_tbl_in);
2733:
2734:
2735:
2736: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2737: return;
2738: END IF;
2739:
2740: END IF;
2750: x_msg_data => l_msg_data,
2751: p_klnv_tbl => l_klev_tbl_in);
2752:
2753:
2754: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2755: return;
2756: END IF;
2757:
2758: END IF;
2768: p_oks_coverage_times_v_tbl =>l_cvtv_tbl_in);
2769:
2770:
2771:
2772: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2773: return;
2774: END IF;
2775: END IF;
2776:
2783: x_msg_data => l_msg_data,
2784: p_oks_coverage_timezones_v_tbl => l_tzev_tbl_in);
2785:
2786:
2787: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2788: return;
2789: END IF;
2790:
2791: END IF;
2806: x_msg_data => l_msg_data,
2807: p_oks_action_times_v_tbl => l_acmv_tbl_in);
2808:
2809:
2810: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2811: return;
2812: END IF;
2813: END IF;
2814:
2829: p_oks_action_time_types_v_tbl => l_actv_tbl_in);
2830:
2831:
2832:
2833: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2834: return;
2835: END IF;
2836:
2837: IF (G_DEBUG_ENABLED = 'Y') THEN
2907: x_msg_count => l_msg_count,
2908: x_msg_data => l_msg_data,
2909: p_cocv_tbl => l_cocv_tbl_in);
2910:
2911: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
2912: then
2913: return;
2914: end if;
2915: END IF;
2931: x_msg_count => l_msg_count,
2932: x_msg_data => l_msg_data,
2933: p_codv_tbl => l_codv_tbl_in);
2934:
2935: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
2936: then
2937: return;
2938: end if;
2939: END IF;
2955: x_msg_count => l_msg_count,
2956: x_msg_data => l_msg_data,
2957: p_scrv_tbl => l_scrv_tbl_in);
2958:
2959: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
2960: then
2961: return;
2962: end if;
2963: END IF;
2980: x_msg_count => l_msg_count,
2981: x_msg_data => l_msg_data,
2982: p_crjv_tbl => l_crjv_tbl_in);
2983:
2984: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
2985: then
2986: return;
2987: end if;
2988: END IF;
3003: x_msg_count => l_msg_count,
3004: x_msg_data => l_msg_data,
3005: p_ctcv_tbl => l_ctcv_tbl_in);
3006:
3007: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3008: then
3009: return;
3010: end if;
3011: END IF;
3018: x_msg_count => l_msg_count,
3019: x_msg_data => l_msg_data,
3020: p_cplv_tbl => l_cplv_tbl_in);
3021:
3022: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3023: then
3024: return;
3025: end if;
3026: END IF;
3053: p_id => P_line_id ,
3054: p_flag => l_line_type,
3055: x_return_status => l_return_status);
3056:
3057: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
3058: x_return_status := OKC_API.G_RET_STS_ERROR;
3059:
3060: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR
3061: IN DELETING LEVEL_ELEMENTS');
3054: p_flag => l_line_type,
3055: x_return_status => l_return_status);
3056:
3057: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
3058: x_return_status := OKC_API.G_RET_STS_ERROR;
3059:
3060: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR
3061: IN DELETING LEVEL_ELEMENTS');
3062: RETURN;
3056:
3057: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
3058: x_return_status := OKC_API.G_RET_STS_ERROR;
3059:
3060: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR
3061: IN DELETING LEVEL_ELEMENTS');
3062: RETURN;
3063: END IF;
3064:
3082: x_msg_data => l_msg_data,
3083: p_oks_pm_schedules_v_tbl => l_pm_schedules_v_tbl);
3084: END IF ;
3085:
3086: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
3087: x_return_status := OKC_API.G_RET_STS_ERROR;
3088:
3089: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR
3090: IN DELETING PM_SCHEDULES');
3083: p_oks_pm_schedules_v_tbl => l_pm_schedules_v_tbl);
3084: END IF ;
3085:
3086: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
3087: x_return_status := OKC_API.G_RET_STS_ERROR;
3088:
3089: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR
3090: IN DELETING PM_SCHEDULES');
3091: RETURN;
3085:
3086: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
3087: x_return_status := OKC_API.G_RET_STS_ERROR;
3088:
3089: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR
3090: IN DELETING PM_SCHEDULES');
3091: RETURN;
3092: END IF;
3093: */
3101: x_msg_count => l_msg_count,
3102: x_msg_data => l_msg_data,
3103: p_cimv_tbl => l_cimv_tbl_in);
3104:
3105: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3106: RAISE e_Error;
3107: END IF;
3108: END IF;
3109:
3123: x_msg_data => l_msg_data,
3124: p_clev_tbl => l_clev_tbl_in);
3125:
3126:
3127: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3128: RAISE e_Error;
3129: END IF;
3130: END IF;
3131:
3132:
3133: Oks_Coverages_Pvt.UNDO_EVENTS (P_line_Id ,
3134: l_Return_Status ,
3135: l_msg_data ) ;
3136: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
3137: RAISE e_Error;
3138: end if;
3139:
3140: Oks_Coverages_Pvt.UNDO_Counters (P_line_Id ,
3139:
3140: Oks_Coverages_Pvt.UNDO_Counters (P_line_Id ,
3141: l_Return_Status ,
3142: l_msg_data ) ;
3143: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
3144: RAISE e_Error;
3145: end if;
3146: x_Return_status:=l_Return_status;
3147:
3172: okc_debug.Reset_Indentation;
3173: END IF;
3174:
3175: x_msg_count :=l_msg_count;
3176: OKC_API.SET_MESSAGE(
3177: p_app_name => g_app_name,
3178: p_msg_name => g_unexpected_error,
3179: p_token1 => g_sqlcode_token,
3180: p_token1_value => sqlcode,
3180: p_token1_value => sqlcode,
3181: p_token2 => g_sqlerrm_token,
3182: p_token2_value => sqlerrm);
3183: -- notify caller of an error as UNEXPETED error
3184: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3185:
3186: END Undo_Line;
3187:
3188:
3224: SELECT id FROM OKC_OUTCOMES_V WHERE cnh_Id=P_Cnh_Id;
3225: CURSOR Cur_oat (P_oce_Id IN NUMBER) IS
3226: SELECT id FROM okc_outcome_arguments_v WHERE oce_id=P_Oce_Id;
3227: BEGIN
3228: x_Return_Status := OKC_API.G_RET_STS_SUCCESS;
3229: FOR Cnh_Rec IN Cur_Cnh(P_KLine_Id)
3230: LOOP
3231: l_cnhv_tbl(c_Cnhv).Id:= Cnh_Rec.Id;
3232: c_Cnhv := c_Cnhv+1;
3265: x_return_status => l_return_status,
3266: x_msg_count => l_msg_count,
3267: x_msg_data => l_msg_data,
3268: p_oatv_tbl => l_Oatv_tbl);
3269: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3270: then x_Return_Status:=l_Return_status;
3271: return;
3272: end if;
3273: END IF;
3279: x_return_status => l_return_status,
3280: x_msg_count => l_msg_count,
3281: x_msg_data => l_msg_data,
3282: p_ocev_tbl => l_Ocev_tbl);
3283: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3284: then x_Return_Status:=l_Return_status;
3285: return;
3286: end if;
3287: END IF;
3293: x_return_status => l_return_status,
3294: x_msg_count => l_msg_count,
3295: x_msg_data => l_msg_data,
3296: p_aavv_tbl => l_aavv_tbl);
3297: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3298: then x_Return_Status:=l_Return_status;
3299: return;
3300: end if;
3301: END IF;
3307: x_return_status => l_return_status,
3308: x_msg_count => l_msg_count,
3309: x_msg_data => l_msg_data,
3310: p_coev_tbl => l_Coev_tbl);
3311: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3312: then x_Return_Status:=l_Return_status;
3313: return;
3314: end if;
3315: END IF;
3321: x_return_status => l_return_status,
3322: x_msg_count => l_msg_count,
3323: x_msg_data => l_msg_data,
3324: p_cnlv_tbl => l_cnlv_tbl);
3325: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3326: then x_Return_Status:=l_Return_status;
3327: return;
3328: end if;
3329: END IF;
3335: x_return_status => l_return_status,
3336: x_msg_count => l_msg_count,
3337: x_msg_data => l_msg_data,
3338: p_cnhv_tbl => l_cnhv_tbl);
3339: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3340: then x_Return_Status:=l_Return_status;
3341: return;
3342: end if;
3343: END IF;
3340: then x_Return_Status:=l_Return_status;
3341: return;
3342: end if;
3343: END IF;
3344: x_Return_Status:=OKC_API.G_RET_STS_SUCCESS;
3345: EXCEPTION
3346: WHEN OTHERS
3347: THEN x_Return_Status:=l_Return_status;
3348: x_msg_data:=sqlcode||'-'||sqlerrm;
3381: l_Commit Varchar2(3) ;
3382: l_Ctr_Grp_Rec CS_Counters_Pub.CtrGrp_Rec_Type;
3383: l_cascade_upd_to_instances Varchar2(1);
3384: BEGIN
3385: x_Return_Status := OKC_API.G_RET_STS_SUCCESS;
3386: FOR Cgp_Rec IN Cur_Cgp(P_KLine_Id)
3387: LOOP
3388: l_cgp_tbl(c_Cgp):=Cgp_Rec.counter_group_Id;
3389: c_Cgp:=c_Cgp+1;
3408: p_cascade_upd_to_instances =>l_cascade_upd_to_instances,
3409: x_object_version_number => x_object_version_number
3410: );
3411: END LOOP;
3412: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
3413: then x_Return_Status:=l_Return_status;
3414: return;
3415: end if;
3416: END LOOP;
3413: then x_Return_Status:=l_Return_status;
3414: return;
3415: end if;
3416: END LOOP;
3417: x_Return_Status:=OKC_API.G_RET_STS_SUCCESS;
3418:
3419:
3420: EXCEPTION
3421: WHEN OTHERS
3428:
3429:
3430: PROCEDURE Update_COVERAGE_Effectivity(
3431: p_api_version IN NUMBER,
3432: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3433: x_return_status OUT NOCOPY VARCHAR2,
3434: x_msg_count OUT NOCOPY NUMBER,
3435: x_msg_data OUT NOCOPY VARCHAR2,
3436: p_service_Line_Id IN NUMBER,
3438: p_New_End_Date IN DATE) IS
3439:
3440: l_api_version CONSTANT NUMBER := 1.0;
3441: l_init_msg_list CONSTANT VARCHAR2(1):= 'T';
3442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3443: l_msg_count NUMBER;
3444: l_message VARCHAR2(2000):=null;
3445: l_msg_data VARCHAR2(2000):=null;
3446: l_msg_index_out Number;
3594:
3595: -- IF Line Start Date is later that End Date
3596: IF l_start_date > P_New_End_Date
3597: THEN
3598: l_return_status:=OKC_API.G_RET_STS_ERROR;
3599: RAISE e_error;
3600: END IF;
3601:
3602: -- If there is no Offset, Coverage Start Date will be start date for Business Process
3661: IF (G_DEBUG_ENABLED = 'Y') THEN
3662: okc_debug.log('After okc_contract_pub.Update_Contract_Line'||l_return_status, 2);
3663: END IF;
3664:
3665: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3666:
3667: IF l_msg_count > 0 THEN
3668: FOR i in 1..l_msg_count LOOP
3669: fnd_msg_pub.get (p_msg_index => -1,
3699:
3700:
3701: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3702: --ROLLBACK ;
3703: OKC_API.SET_MESSAGE(g_app_name,'OKSMIS_REQUIRED_FIELD','FIELD_NAME','Coverage to run effectivity adjustment');
3704: x_return_status := 'E';
3705:
3706: WHEN e_Error THEN
3707:
3715: x_msg_count :=l_msg_count;
3716: x_msg_data:=l_msg_data;
3717: x_return_status := 'E';
3718:
3719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3720:
3721: IF (G_DEBUG_ENABLED = 'Y') THEN
3722: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3723: okc_debug.Reset_Indentation;
3728: x_msg_data:=l_msg_data;
3729: x_return_status := 'E';
3730:
3731:
3732: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3733:
3734: IF (G_DEBUG_ENABLED = 'Y') THEN
3735: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3736: okc_debug.Reset_Indentation;
3749: END IF;
3750:
3751: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3752: --ROLLBACK ;
3753: OKC_API.SET_MESSAGE(
3754: p_app_name => g_app_name,
3755: p_msg_name => g_unexpected_error,
3756: p_token1 => g_sqlcode_token,
3757: p_token1_value => sqlcode,
3757: p_token1_value => sqlcode,
3758: p_token2 => g_sqlerrm_token,
3759: p_token2_value => sqlerrm);
3760: -- notify caller of an error as UNEXPETED error
3761: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3762: x_msg_count :=l_msg_count;
3763:
3764: END Update_Coverage_Effectivity;
3765:
3765:
3766:
3767: PROCEDURE Undo_Line(
3768: p_api_version IN NUMBER,
3769: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3770: p_validate_status IN VARCHAR2 DEFAULT 'N',
3771: x_return_status OUT NOCOPY VARCHAR2,
3772: x_msg_count OUT NOCOPY NUMBER,
3773: x_msg_data OUT NOCOPY VARCHAR2,
3931: END Bp_Check;
3932:
3933:
3934: BEGIN
3935: x_return_status:=OKC_API.G_Ret_Sts_Success;
3936:
3937: Validate_Line_id(p_line_id,l_return_status);
3938: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3939: -- IF NOT l_Return_Status ='S' THEN
3934: BEGIN
3935: x_return_status:=OKC_API.G_Ret_Sts_Success;
3936:
3937: Validate_Line_id(p_line_id,l_return_status);
3938: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3939: -- IF NOT l_Return_Status ='S' THEN
3940: RETURN;
3941: END IF;
3942:
4071: x_msg_count => l_msg_count,
4072: x_msg_data => l_msg_data,
4073: p_cocv_tbl => l_cocv_tbl_in);
4074:
4075: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4076: then
4077: return;
4078: end if;
4079: END IF;
4088: x_msg_count => l_msg_count,
4089: x_msg_data => l_msg_data,
4090: p_codv_tbl => l_codv_tbl_in);
4091:
4092: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4093: then
4094: return;
4095: end if;
4096: END IF;
4105: x_msg_count => l_msg_count,
4106: x_msg_data => l_msg_data,
4107: p_scrv_tbl => l_scrv_tbl_in);
4108:
4109: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4110: then
4111: return;
4112: end if;
4113: END IF;
4122: x_msg_count => l_msg_count,
4123: x_msg_data => l_msg_data,
4124: p_crjv_tbl => l_crjv_tbl_in);
4125:
4126: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4127: then
4128: return;
4129: end if;
4130: END IF;
4137: x_msg_count => l_msg_count,
4138: x_msg_data => l_msg_data,
4139: p_ctcv_tbl => l_ctcv_tbl_in);
4140:
4141: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4142: then
4143: return;
4144: end if;
4145: END IF;
4152: x_msg_count => l_msg_count,
4153: x_msg_data => l_msg_data,
4154: p_cplv_tbl => l_cplv_tbl_in);
4155:
4156: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4157: then
4158: return;
4159: end if;
4160: END IF;
4190: p_id => P_line_id ,
4191: p_flag => l_line_type,
4192: x_return_status => l_return_status);
4193:
4194: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
4195: x_return_status := OKC_API.G_RET_STS_ERROR;
4196: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING LEVEL_ELEMENTS');
4197: RETURN;
4198: END IF;
4191: p_flag => l_line_type,
4192: x_return_status => l_return_status);
4193:
4194: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
4195: x_return_status := OKC_API.G_RET_STS_ERROR;
4196: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING LEVEL_ELEMENTS');
4197: RETURN;
4198: END IF;
4199:
4192: x_return_status => l_return_status);
4193:
4194: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
4195: x_return_status := OKC_API.G_RET_STS_ERROR;
4196: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING LEVEL_ELEMENTS');
4197: RETURN;
4198: END IF;
4199:
4200: okc_Rule_pub.delete_Rule (
4203: x_return_status => l_return_status,
4204: x_msg_count => l_msg_count,
4205: x_msg_data => l_msg_data,
4206: p_rulv_tbl => l_rulv_tbl_in);
4207: /---if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4208: THEN
4209:
4210: IF l_msg_count > 0
4211: THEN
4216: p_data => l_msg_data,
4217: p_msg_index_out => l_msg_index_out);
4218: END LOOP;
4219: END IF;---/
4220: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
4221: RAISE e_Error;
4222: END IF;
4223: END IF;
4224:
4231: x_msg_count => l_msg_count,
4232: x_msg_data => l_msg_data,
4233: p_rgpv_tbl => l_rgpv_tbl_in);
4234:
4235: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4236: then
4237: return;
4238: end if;
4239: END IF;
4259: p_msg_index_out => l_msg_index_out);
4260: END LOOP;
4261: END IF;
4262: RAISE e_Error; */
4263: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
4264: RAISE e_Error;
4265: END IF;
4266: END IF;
4267:
4286:
4287: EXCEPTION
4288: WHEN OTHERS THEN
4289: -- store SQL error message on message stack for caller
4290: OKC_API.set_message(G_APP_NAME,
4291: G_UNEXPECTED_ERROR,
4292: G_SQLCODE_TOKEN,
4293: SQLCODE,
4294: G_SQLERRM_TOKEN,
4293: SQLCODE,
4294: G_SQLERRM_TOKEN,
4295: SQLERRM);
4296: -- notify caller of an UNEXPECTED error
4297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4298: END;
4299: end loop;
4300: end if;
4301:
4311: p_msg_index_out => l_msg_index_out);
4312: END LOOP;
4313: END IF;
4314: RAISE e_Error;*/
4315: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
4316: RAISE e_Error;
4317: END IF;
4318: END IF;
4319:
4320:
4321: Oks_Coverages_Pvt.UNDO_EVENTS (P_line_Id ,
4322: l_Return_Status ,
4323: l_msg_data ) ;
4324: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4325: then
4326: RAISE e_Error;
4327: end if;
4328:
4328:
4329: Oks_Coverages_Pvt.UNDO_Counters (P_line_Id ,
4330: l_Return_Status ,
4331: l_msg_data ) ;
4332: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4333: then
4334: RAISE e_Error;
4335: end if;
4336: x_Return_status:=l_Return_status;
4340: -- notify caller of an error as UNEXPETED error
4341: x_msg_count :=l_msg_count;
4342: x_msg_data:=l_msg_data;
4343: x_Return_status:=l_Return_status;
4344: /* x_return_status := OKC_API.HANDLE_EXCEPTIONS
4345: (
4346: l_api_name,
4347: 'Undo_Line',
4348: 'OKC_API.G_RET_STS_ERROR',
4344: /* x_return_status := OKC_API.HANDLE_EXCEPTIONS
4345: (
4346: l_api_name,
4347: 'Undo_Line',
4348: 'OKC_API.G_RET_STS_ERROR',
4349: l_msg_count,
4350: l_msg_data,
4351: '_PVT'
4352: );
4349: l_msg_count,
4350: l_msg_data,
4351: '_PVT'
4352: );
4353: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4354: x_msg_count :=l_msg_count;
4355: x_msg_data:=l_msg_data;
4356: x_return_status := OKC_API.HANDLE_EXCEPTIONS
4357: (
4352: );
4353: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4354: x_msg_count :=l_msg_count;
4355: x_msg_data:=l_msg_data;
4356: x_return_status := OKC_API.HANDLE_EXCEPTIONS
4357: (
4358: l_api_name,
4359: 'Undo_Line',
4360: 'OKC_API.G_RET_STS_ERROR',
4356: x_return_status := OKC_API.HANDLE_EXCEPTIONS
4357: (
4358: l_api_name,
4359: 'Undo_Line',
4360: 'OKC_API.G_RET_STS_ERROR',
4361: l_msg_count,
4362: l_msg_data,
4363: '_PVT'
4364: );
4361: l_msg_count,
4362: l_msg_data,
4363: '_PVT'
4364: );
4365: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4366: x_msg_count :=l_msg_count;
4367: x_msg_data:=l_msg_data;
4368: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
4369: (
4364: );
4365: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4366: x_msg_count :=l_msg_count;
4367: x_msg_data:=l_msg_data;
4368: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
4369: (
4370: l_api_name,
4371: 'Undo_Line',
4372: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4368: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
4369: (
4370: l_api_name,
4371: 'Undo_Line',
4372: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4373: l_msg_count,
4374: l_msg_data,
4375: '_PVT'
4376: );*/
4375: '_PVT'
4376: );*/
4377: WHEN OTHERS THEN
4378: x_msg_count :=l_msg_count;
4379: OKC_API.SET_MESSAGE(
4380: p_app_name => g_app_name,
4381: p_msg_name => g_unexpected_error,
4382: p_token1 => g_sqlcode_token,
4383: p_token1_value => sqlcode,
4383: p_token1_value => sqlcode,
4384: p_token2 => g_sqlerrm_token,
4385: p_token2_value => sqlerrm);
4386: -- notify caller of an error as UNEXPETED error
4387: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4388:
4389: END Undo_Line;
4390:
4391:
4390:
4391:
4392: Procedure CHECK_COVERAGE_MATCH
4393: ( p_api_version IN NUMBER,
4394: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4395: x_return_status OUT NOCOPY VARCHAR2,
4396: x_msg_count OUT NOCOPY NUMBER,
4397: x_msg_data OUT NOCOPY VARCHAR2,
4398: P_Source_contract_Line_Id IN NUMBER,
5375: x_target_brs_tbl.DELETE;
5376:
5377:
5378:
5379: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
5380: x_coverage_match:= 'Y';
5381:
5382: Exception
5383:
5382: Exception
5383:
5384: When G_MISMATCH THEN
5385: x_coverage_match:= 'N';
5386: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
5387:
5388: WHEN OTHERS THEN
5389: OKC_API.set_message(G_APP_NAME,
5390: G_UNEXPECTED_ERROR,
5385: x_coverage_match:= 'N';
5386: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
5387:
5388: WHEN OTHERS THEN
5389: OKC_API.set_message(G_APP_NAME,
5390: G_UNEXPECTED_ERROR,
5391: G_SQLCODE_TOKEN,
5392: SQLCODE,
5393: G_SQLERRM_TOKEN,
5392: SQLCODE,
5393: G_SQLERRM_TOKEN,
5394: SQLERRM);
5395: -- notify caller of an UNEXPECTED error
5396: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5397: x_coverage_match:= 'E';
5398:
5399:
5400: END CHECK_COVERAGE_MATCH;
5400: END CHECK_COVERAGE_MATCH;
5401:
5402: Procedure CHECK_TimeZone_Exists
5403: ( p_api_version IN NUMBER,
5404: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5405: x_return_status OUT NOCOPY VARCHAR2,
5406: x_msg_count OUT NOCOPY NUMBER,
5407: x_msg_data OUT NOCOPY VARCHAR2,
5408: P_BP_Line_ID IN NUMBER,
5433: ELSE
5434: x_TimeZone_Exists := 'N';
5435: END IF;
5436:
5437: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
5438:
5439: EXCEPTION
5440: WHEN OTHERS THEN
5441:
5438:
5439: EXCEPTION
5440: WHEN OTHERS THEN
5441:
5442: OKC_API.SET_MESSAGE(
5443: p_app_name => g_app_name,
5444: p_msg_name => g_unexpected_error,
5445: p_token1 => g_sqlcode_token,
5446: p_token1_value => sqlcode,
5446: p_token1_value => sqlcode,
5447: p_token2 => g_sqlerrm_token,
5448: p_token2_value => sqlerrm);
5449:
5450: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5451:
5452:
5453: END CHECK_TimeZone_Exists;
5454:
5456:
5457:
5458: PROCEDURE CREATE_ADJUSTED_COVERAGE(
5459: p_api_version IN NUMBER,
5460: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5461: x_return_status OUT NOCOPY VARCHAR2,
5462: x_msg_count OUT NOCOPY NUMBER,
5463: x_msg_data OUT NOCOPY VARCHAR2,
5464: P_Source_contract_Line_Id IN NUMBER,
5507: IF Cur_LineDet%FOUND
5508: THEN
5509: l_ac_rec_in.tmp_cle_id := l_cov_Id;
5510: ELSE
5511: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage does not exist');
5512: CLOSE Cur_LineDet;
5513: l_return_status := OKC_API.G_RET_STS_ERROR;
5514: RAISE G_EXCEPTION_HALT_VALIDATION;
5515: END IF;
5509: l_ac_rec_in.tmp_cle_id := l_cov_Id;
5510: ELSE
5511: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Coverage does not exist');
5512: CLOSE Cur_LineDet;
5513: l_return_status := OKC_API.G_RET_STS_ERROR;
5514: RAISE G_EXCEPTION_HALT_VALIDATION;
5515: END IF;
5516: CLOSE Cur_LineDet;
5517:
5521: THEN
5522: l_ac_rec_in.Start_date := l_Start_date;
5523: l_ac_rec_in.End_date := l_End_date;
5524: ELSE
5525: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Target contract line does not exist');
5526: CLOSE Cur_LineDet1;
5527: l_return_status := OKC_API.G_RET_STS_ERROR;
5528: RAISE G_EXCEPTION_HALT_VALIDATION;
5529: END IF;
5523: l_ac_rec_in.End_date := l_End_date;
5524: ELSE
5525: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'Target contract line does not exist');
5526: CLOSE Cur_LineDet1;
5527: l_return_status := OKC_API.G_RET_STS_ERROR;
5528: RAISE G_EXCEPTION_HALT_VALIDATION;
5529: END IF;
5530: CLOSE Cur_LineDet1;
5531:
5559: p_msg_index_out => l_msg_index_out);
5560: END LOOP;
5561: END IF;*/
5562:
5563: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5564: RAISE G_EXCEPTION_HALT_VALIDATION;
5565: END IF;
5566:
5567: x_return_status := l_return_status;
5583: END IF;
5584: x_return_status := l_return_status ;
5585: /* x_msg_count :=l_msg_count;
5586: x_msg_data:=l_msg_data;
5587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5588: (
5589: l_api_name,
5590: 'Create_actual_coverage',
5591: 'OKC_API.G_RET_STS_ERROR',
5587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5588: (
5589: l_api_name,
5590: 'Create_actual_coverage',
5591: 'OKC_API.G_RET_STS_ERROR',
5592: x_msg_count,
5593: x_msg_data,
5594: '_PVT'
5595: );
5592: x_msg_count,
5593: x_msg_data,
5594: '_PVT'
5595: );
5596: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5597: x_msg_count :=l_msg_count;
5598: x_msg_data:=l_msg_data;
5599: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5600: (
5595: );
5596: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5597: x_msg_count :=l_msg_count;
5598: x_msg_data:=l_msg_data;
5599: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5600: (
5601: l_api_name,
5602: 'Create_actual_coverage',
5603: 'OKC_API.G_RET_STS_ERROR',
5599: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5600: (
5601: l_api_name,
5602: 'Create_actual_coverage',
5603: 'OKC_API.G_RET_STS_ERROR',
5604: x_msg_count,
5605: x_msg_data,
5606: '_PVT'
5607: );
5604: x_msg_count,
5605: x_msg_data,
5606: '_PVT'
5607: );
5608: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5609: x_msg_count :=l_msg_count;
5610: x_msg_data:=l_msg_data;
5611: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
5612: (
5607: );
5608: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5609: x_msg_count :=l_msg_count;
5610: x_msg_data:=l_msg_data;
5611: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
5612: (
5613: l_api_name,
5614: 'Create_actual_coverage',
5615: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5611: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
5612: (
5613: l_api_name,
5614: 'Create_actual_coverage',
5615: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5616: x_msg_count,
5617: x_msg_data,
5618: '_PVT'
5619: );
5625: okc_debug.log('Exp of CREATE_ADJUSTED_COVERAGE'||SQLERRM, 2);
5626: okc_debug.Reset_Indentation;
5627: END IF;
5628:
5629: OKC_API.SET_MESSAGE(
5630: p_app_name => g_app_name,
5631: p_msg_name => g_unexpected_error,
5632: p_token1 => g_sqlcode_token,
5633: p_token1_value => sqlcode,
5633: p_token1_value => sqlcode,
5634: p_token2 => g_sqlerrm_token,
5635: p_token2_value => sqlerrm);
5636: -- notify caller of an error as UNEXPETED error
5637: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5638: x_msg_count :=l_msg_count;
5639: END CREATE_ADJUSTED_COVERAGE;
5640:
5641: --=============================================================================
5644: IS
5645:
5646: BEGIN
5647:
5648: x_bill_rate_tbl(1).id := okc_api.g_miss_num ;
5649: x_bill_rate_tbl(1).cle_id := okc_api.g_miss_num ;
5650: x_bill_rate_tbl(1).bt_cle_id := okc_api.g_miss_num ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5645:
5646: BEGIN
5647:
5648: x_bill_rate_tbl(1).id := okc_api.g_miss_num ;
5649: x_bill_rate_tbl(1).cle_id := okc_api.g_miss_num ;
5650: x_bill_rate_tbl(1).bt_cle_id := okc_api.g_miss_num ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5646: BEGIN
5647:
5648: x_bill_rate_tbl(1).id := okc_api.g_miss_num ;
5649: x_bill_rate_tbl(1).cle_id := okc_api.g_miss_num ;
5650: x_bill_rate_tbl(1).bt_cle_id := okc_api.g_miss_num ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5647:
5648: x_bill_rate_tbl(1).id := okc_api.g_miss_num ;
5649: x_bill_rate_tbl(1).cle_id := okc_api.g_miss_num ;
5650: x_bill_rate_tbl(1).bt_cle_id := okc_api.g_miss_num ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5648: x_bill_rate_tbl(1).id := okc_api.g_miss_num ;
5649: x_bill_rate_tbl(1).cle_id := okc_api.g_miss_num ;
5650: x_bill_rate_tbl(1).bt_cle_id := okc_api.g_miss_num ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5649: x_bill_rate_tbl(1).cle_id := okc_api.g_miss_num ;
5650: x_bill_rate_tbl(1).bt_cle_id := okc_api.g_miss_num ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5650: x_bill_rate_tbl(1).bt_cle_id := okc_api.g_miss_num ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5651: x_bill_rate_tbl(1).dnz_chr_id := okc_api.g_miss_num;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5652: x_bill_rate_tbl(1).start_hour := okc_api.g_miss_num ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5653: x_bill_rate_tbl(1).start_minute := okc_api.g_miss_num ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5654: x_bill_rate_tbl(1).end_hour := okc_api.g_miss_num ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5655: x_bill_rate_tbl(1).end_minute := okc_api.g_miss_num ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5656: x_bill_rate_tbl(1).monday_flag := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5657: x_bill_rate_tbl(1).tuesday_flag := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5658: x_bill_rate_tbl(1).wednesday_flag := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5659: x_bill_rate_tbl(1).thursday_flag := okc_api.g_miss_char ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5660: x_bill_rate_tbl(1).friday_flag := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5661: x_bill_rate_tbl(1).saturday_flag := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5662: x_bill_rate_tbl(1).sunday_flag := okc_api.g_miss_char ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5663: x_bill_rate_tbl(1).object1_id1 := okc_api.g_miss_char ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5664: x_bill_rate_tbl(1).object1_id2 := okc_api.g_miss_char ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5665: x_bill_rate_tbl(1).jtot_object1_code := okc_api.g_miss_char ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5666: x_bill_rate_tbl(1).bill_rate_code := okc_api.g_miss_char ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5667: x_bill_rate_tbl(1).flat_rate := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5668: x_bill_rate_tbl(1).uom := okc_api.g_miss_char ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5669: x_bill_rate_tbl(1).holiday_yn := okc_api.g_miss_char ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5670: x_bill_rate_tbl(1).percent_over_list_price := okc_api.g_miss_num ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5678: x_bill_rate_tbl(1).last_update_date := okc_api.g_miss_date ;
5671: x_bill_rate_tbl(1).program_application_id := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5678: x_bill_rate_tbl(1).last_update_date := okc_api.g_miss_date ;
5679: x_bill_rate_tbl(1).last_update_login := okc_api.g_miss_num ;
5672: x_bill_rate_tbl(1).program_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5678: x_bill_rate_tbl(1).last_update_date := okc_api.g_miss_date ;
5679: x_bill_rate_tbl(1).last_update_login := okc_api.g_miss_num ;
5680: x_bill_rate_tbl(1).security_group_id := okc_api.g_miss_num ;
5673: x_bill_rate_tbl(1).program_update_date := okc_api.g_miss_date ;
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5678: x_bill_rate_tbl(1).last_update_date := okc_api.g_miss_date ;
5679: x_bill_rate_tbl(1).last_update_login := okc_api.g_miss_num ;
5680: x_bill_rate_tbl(1).security_group_id := okc_api.g_miss_num ;
5681:
5674: x_bill_rate_tbl(1).request_id := okc_api.g_miss_num ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5678: x_bill_rate_tbl(1).last_update_date := okc_api.g_miss_date ;
5679: x_bill_rate_tbl(1).last_update_login := okc_api.g_miss_num ;
5680: x_bill_rate_tbl(1).security_group_id := okc_api.g_miss_num ;
5681:
5682: END ;
5675: x_bill_rate_tbl(1).created_by := okc_api.g_miss_num ;
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5678: x_bill_rate_tbl(1).last_update_date := okc_api.g_miss_date ;
5679: x_bill_rate_tbl(1).last_update_login := okc_api.g_miss_num ;
5680: x_bill_rate_tbl(1).security_group_id := okc_api.g_miss_num ;
5681:
5682: END ;
5683: --===========================================================================================
5676: x_bill_rate_tbl(1).creation_date := okc_api.g_miss_date ;
5677: x_bill_rate_tbl(1).last_updated_by := okc_api.g_miss_num ;
5678: x_bill_rate_tbl(1).last_update_date := okc_api.g_miss_date ;
5679: x_bill_rate_tbl(1).last_update_login := okc_api.g_miss_num ;
5680: x_bill_rate_tbl(1).security_group_id := okc_api.g_miss_num ;
5681:
5682: END ;
5683: --===========================================================================================
5684:
5825:
5826: BEGIN
5827: --l_overlap_message := 'The following days have overlap :';
5828: -- Validating for Monday.
5829: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5830: l_time_tbl.DELETE;
5831: FOR monday_rec IN Cur_monday(p_billtype_line_id, p_holiday_yn)
5832: LOOP
5833:
5970: fnd_message.set_name('OKS','OKS_BILLRATE_DAYS_OVERLAP');
5971: fnd_message.set_token('DAYS', l_overlap_days);
5972: END IF;
5973:
5974: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5975:
5976: EXCEPTION
5977:
5978: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5974: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5975:
5976: EXCEPTION
5977:
5978: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5979: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5980: (
5981: l_api_name,
5982: G_PKG_NAME,
5975:
5976: EXCEPTION
5977:
5978: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5979: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5980: (
5981: l_api_name,
5982: G_PKG_NAME,
5983: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5979: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5980: (
5981: l_api_name,
5982: G_PKG_NAME,
5983: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5984: x_msg_count,
5985: x_msg_data,
5986: '_PVT'
5987: );
5986: '_PVT'
5987: );
5988: ROLLBACK;
5989: WHEN OTHERS THEN
5990: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5991: (
5992: l_api_name,
5993: G_PKG_NAME,
5994: 'OTHERS',
6058:
6059:
6060: PROCEDURE OKS_MIGRATE_BILLRATES(
6061: p_api_version IN NUMBER,
6062: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6063: x_return_status OUT NOCOPY VARCHAR2,
6064: x_msg_count OUT NOCOPY NUMBER,
6065: x_msg_data OUT NOCOPY VARCHAR2)
6066: IS
6165: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6166: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6167:
6168:
6169: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
6170: RAISE G_EXCEPTION_HALT_VALIDATION;
6171: END IF;
6172:
6173: x_return_status := l_return_status;
6184: SET object_version_number = 1 ;
6185:
6186: END IF;
6187:
6188: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6189: EXCEPTION
6190:
6191:
6192: WHEN G_EXCEPTION_RULE_UPDATE THEN
6189: EXCEPTION
6190:
6191:
6192: WHEN G_EXCEPTION_RULE_UPDATE THEN
6193: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6194: ( l_api_name,
6195: G_PKG_NAME,
6196: 'OKC_API.G_RET_STS_ERROR',
6197: x_msg_count,
6192: WHEN G_EXCEPTION_RULE_UPDATE THEN
6193: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6194: ( l_api_name,
6195: G_PKG_NAME,
6196: 'OKC_API.G_RET_STS_ERROR',
6197: x_msg_count,
6198: x_msg_data,
6199: '_PVT'
6200: );
6200: );
6201: ROLLBACK ;
6202:
6203: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6205: (
6206: l_api_name,
6207: G_PKG_NAME,
6208: 'OKC_API.G_RET_STS_ERROR',
6204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6205: (
6206: l_api_name,
6207: G_PKG_NAME,
6208: 'OKC_API.G_RET_STS_ERROR',
6209: x_msg_count,
6210: x_msg_data,
6211: '_PVT'
6212: );
6210: x_msg_data,
6211: '_PVT'
6212: );
6213: ROLLBACK ;
6214: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6215: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6216: (
6217: l_api_name,
6218: G_PKG_NAME,
6211: '_PVT'
6212: );
6213: ROLLBACK ;
6214: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6215: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6216: (
6217: l_api_name,
6218: G_PKG_NAME,
6219: 'OKC_API.G_RET_STS_UNEXP_ERROR',
6215: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6216: (
6217: l_api_name,
6218: G_PKG_NAME,
6219: 'OKC_API.G_RET_STS_UNEXP_ERROR',
6220: x_msg_count,
6221: x_msg_data,
6222: '_PVT'
6223: );
6222: '_PVT'
6223: );
6224: ROLLBACK;
6225: WHEN OTHERS THEN
6226: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6227: (
6228: l_api_name,
6229: G_PKG_NAME,
6230: 'OTHERS',
6238:
6239: --==========================================================================
6240: PROCEDURE OKS_BILLRATE_MAPPING(
6241: p_api_version IN NUMBER ,
6242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6243: p_business_process_id IN NUMBER,
6244: p_time_labor_tbl_in IN time_labor_tbl,
6245: x_return_status OUT NOCOPY VARCHAR2,
6246: x_msg_count OUT NOCOPY NUMBER,
6435: END IF;
6436:
6437:
6438:
6439: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
6440: RAISE G_EXCEPTION_BRS_UPDATE ;
6441: END IF;
6442:
6443: ELSE -- create lines in okc_k_lines_b, oks_billrate_schedules
6473: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE API...'||l_return_status);
6474: END IF;
6475:
6476:
6477: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
6478: RAISE G_EXCEPTION_HALT_VALIDATION ;
6479: END IF;
6480:
6481: l_cle_id := l_clev_tbl_out(1).id ;
6531: END IF;
6532:
6533:
6534:
6535: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
6536: RAISE G_EXCEPTION_HALT_VALIDATION;
6537: END IF;
6538:
6539:
6572:
6573: end if; -- status and operations check
6574:
6575: END LOOP ;
6576: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6577:
6578: IF fnd_global.conc_request_id <> -1 THEN
6579: fnd_file.put_line(FND_FILE.LOG, 'Return Status from API...'||x_return_status);
6580: END IF;
6581:
6582:
6583: EXCEPTION
6584: WHEN G_EXCEPTION_RULE_UPDATE THEN
6585: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6586: ( l_api_name,
6587: G_PKG_NAME,
6588: 'OKC_API.G_RET_STS_ERROR',
6589: x_msg_count,
6584: WHEN G_EXCEPTION_RULE_UPDATE THEN
6585: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6586: ( l_api_name,
6587: G_PKG_NAME,
6588: 'OKC_API.G_RET_STS_ERROR',
6589: x_msg_count,
6590: x_msg_data,
6591: '_PVT'
6592: );
6597:
6598:
6599:
6600: WHEN G_EXCEPTION_BRS_UPDATE THEN
6601: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6602: ( l_api_name,
6603: G_PKG_NAME,
6604: 'OKC_API.G_RET_STS_ERROR',
6605: x_msg_count,
6600: WHEN G_EXCEPTION_BRS_UPDATE THEN
6601: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6602: ( l_api_name,
6603: G_PKG_NAME,
6604: 'OKC_API.G_RET_STS_ERROR',
6605: x_msg_count,
6606: x_msg_data,
6607: '_PVT'
6608: );
6611: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_BRS_UPDATE');
6612: END IF;
6613:
6614: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6615: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6616: (
6617: l_api_name,
6618: G_PKG_NAME,
6619: 'OKC_API.G_RET_STS_ERROR',
6615: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6616: (
6617: l_api_name,
6618: G_PKG_NAME,
6619: 'OKC_API.G_RET_STS_ERROR',
6620: x_msg_count,
6621: x_msg_data,
6622: '_PVT'
6623: );
6626: IF fnd_global.conc_request_id <> -1 THEN
6627: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_HALT_VALIDATION');
6628: END IF;
6629:
6630: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6631: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6632: (
6633: l_api_name,
6634: G_PKG_NAME,
6627: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_HALT_VALIDATION');
6628: END IF;
6629:
6630: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6631: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6632: (
6633: l_api_name,
6634: G_PKG_NAME,
6635: 'OKC_API.G_RET_STS_UNEXP_ERROR',
6631: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6632: (
6633: l_api_name,
6634: G_PKG_NAME,
6635: 'OKC_API.G_RET_STS_UNEXP_ERROR',
6636: x_msg_count,
6637: x_msg_data,
6638: '_PVT'
6639: );
6643: END IF;
6644:
6645:
6646: WHEN OTHERS THEN
6647: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6648: (
6649: l_api_name,
6650: G_PKG_NAME,
6651: 'OTHERS',
6714: X_RETURN_STATUS := 'S';
6715: EXCEPTION
6716: WHEN OTHERS THEN
6717: X_RETURN_STATUS := 'E';
6718: OKC_API.set_message(G_APP_NAME,
6719: G_UNEXPECTED_ERROR,
6720: G_SQLCODE_TOKEN,
6721: SQLCODE,
6722: G_SQLERRM_TOKEN,
6727:
6728:
6729: PROCEDURE COPY_NOTES
6730: (p_api_version IN NUMBER ,
6731: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6732: p_line_id IN NUMBER,
6733: x_return_status OUT NOCOPY VARCHAR2,
6734: x_msg_count OUT NOCOPY NUMBER,
6735: x_msg_data OUT NOCOPY VARCHAR2) IS
6773:
6774:
6775: BEGIN
6776:
6777: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6778:
6779: FOR get_orig_contract_REC IN get_orig_contract_CUR(l_line_ID) LOOP
6780:
6781: /* Commented by Jvorugan for Bug:4489214 who columns not to be populated from old contract
6844: EXCEPTION
6845:
6846: WHEN OTHERS THEN
6847:
6848: OKC_API.set_message(G_APP_NAME,
6849: G_UNEXPECTED_ERROR,
6850: G_SQLCODE_TOKEN,
6851: SQLCODE,
6852: G_SQLERRM_TOKEN,
6850: G_SQLCODE_TOKEN,
6851: SQLCODE,
6852: G_SQLERRM_TOKEN,
6853: SQLERRM);
6854: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6855:
6856: END COPY_NOTES;
6857:
6858: PROCEDURE Copy_Coverage(p_api_version IN NUMBER,
6855:
6856: END COPY_NOTES;
6857:
6858: PROCEDURE Copy_Coverage(p_api_version IN NUMBER,
6859: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6860: x_return_status OUT NOCOPY VARCHAR2,
6861: x_msg_count OUT NOCOPY NUMBER,
6862: x_msg_data OUT NOCOPY VARCHAR2,
6863: p_contract_line_id IN NUMBER) IS
7439: WHERE cle_id = p_new_cle_id
7440: AND rownum=1;
7441:
7442: l_Count Number := 0;
7443: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7444:
7445: BEGIN
7446: OPEN check_line_exist;
7447: FETCH check_line_exist INTO l_Count;
7456: RETURN (x_return_status);
7457:
7458: EXCEPTION
7459: WHEN OTHERS THEN
7460: OKC_API.set_message(G_APP_NAME,
7461: G_UNEXPECTED_ERROR,
7462: G_SQLCODE_TOKEN,
7463: SQLCODE,
7464: G_SQLERRM_TOKEN,
7462: G_SQLCODE_TOKEN,
7463: SQLCODE,
7464: G_SQLERRM_TOKEN,
7465: SQLERRM);
7466: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7467: RETURN (x_return_status);
7468:
7469: END CHECK_OKSLINE_EXIST;
7470:
7547: IF (G_DEBUG_ENABLED = 'Y') THEN
7548: okc_debug.log('AFTER CHECK_OKSLINE_EXIST1'||l_return_status, 2);
7549: END IF;
7550:
7551: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7552: RAISE G_EXCEPTION_HALT_VALIDATION;
7553: END IF;
7554: x_return_status := l_return_status;
7555: IF l_oks_exist = 'N'
7586: okc_debug.log('After OKS_CONTRACT_LINE_PUB.CREATE_LINE'||l_return_status, 2);
7587: END IF;
7588:
7589:
7590: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7591: RAISE G_EXCEPTION_HALT_VALIDATION;
7592: END IF;
7593: x_return_status := l_return_status;
7594:
7606: IF (G_DEBUG_ENABLED = 'Y') THEN
7607: okc_debug.log('AFTER CALLING OKS_PM_PROGRAMS_PVT.Copy_pm_template'||l_return_status, 2);
7608: END IF;
7609:
7610: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7611: RAISE G_EXCEPTION_HALT_VALIDATION;
7612: END IF;
7613: END IF;
7614:
7641: IF (G_DEBUG_ENABLED = 'Y') THEN
7642: okc_debug.log('AFTER CHECK_OKSLINE_EXIST2'||l_return_status, 2);
7643: END IF;
7644:
7645: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7646: RAISE G_EXCEPTION_HALT_VALIDATION;
7647: END IF;
7648: x_return_status := l_return_status;
7649: IF l_oks_exist = 'N'
7675: p_klnv_tbl => l_klnv_tbl_in,
7676: x_klnv_tbl => l_klnv_tbl_out,
7677: p_validate_yn => l_validate_yn);
7678:
7679: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7680: RAISE G_EXCEPTION_HALT_VALIDATION;
7681: END IF;
7682: x_return_status := l_return_status;
7683: END IF ; -- 2 -- BP ENDS HERE
7685:
7686: /****************************************************/
7687:
7688:
7689: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN ---- For Time Zones
7690:
7691: INIT_OKS_TIMEZONE_LINE(l_timezone_tbl_in);
7692: INIT_OKS_COVER_TIME_LINE(l_cover_time_tbl_in);
7693:
7725: IF (G_DEBUG_ENABLED = 'Y') THEN
7726: okc_debug.log('After OKS_CTZ_PVT INSERT_ROW'||l_return_status, 2);
7727: END IF;
7728:
7729: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7730: IF l_timezone_tbl_out.COUNT > 0 THEN
7731: FOR I IN l_timezone_tbl_out.FIRST .. l_timezone_tbl_out.LAST LOOP
7732: l_new_TimeZone_Id :=l_timezone_tbl_out(m).ID;
7733: END LOOP;
7769: x_oks_coverage_times_v_tbl => l_cover_time_tbl_out);
7770:
7771: END IF;
7772:
7773: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7774: RAISE G_EXCEPTION_HALT_VALIDATION;
7775: ELSE
7776: l_timezone_tbl_in.DELETE;
7777: l_cover_time_tbl_in.DELETE;
7809: IF (G_DEBUG_ENABLED = 'Y') THEN
7810: okc_debug.log('AFTER CHECK_OKSLINE_EXIST3'||l_return_status, 2);
7811: END IF;
7812:
7813: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7814: RAISE G_EXCEPTION_HALT_VALIDATION;
7815: END IF;
7816: x_return_status := l_return_status;
7817: IF l_oks_exist = 'N'
7847: x_klnv_tbl => l_klnv_tbl_out,
7848: p_validate_yn => l_validate_yn);
7849:
7850:
7851: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7852: RAISE G_EXCEPTION_HALT_VALIDATION;
7853: ELSE
7854: l_klnv_tbl_in.DELETE;
7855: FOR I IN l_klnv_tbl_out.FIRST .. l_klnv_tbl_out.LAST LOOP
7886: IF (G_DEBUG_ENABLED = 'Y') THEN
7887: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);
7888: END IF;
7889:
7890: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7891: RAISE G_EXCEPTION_HALT_VALIDATION;
7892: ELSE
7893: FOR I IN l_act_pvt_tbl_out.FIRST .. l_act_pvt_tbl_out.LAST LOOP
7894: l_act_pvt_new_id := l_act_pvt_tbl_out(I).ID;
7928: IF (G_DEBUG_ENABLED = 'Y') THEN
7929: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
7930: END IF;
7931:
7932: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7933: RAISE G_EXCEPTION_HALT_VALIDATION;
7934: ELSE
7935: l_acm_pvt_tbl_in.DELETE;
7936: l_act_pvt_tbl_in.DELETE;
7979: IF (G_DEBUG_ENABLED = 'Y') THEN
7980: okc_debug.log('AFTER CHECK_OKSLINE_EXIST4'||l_return_status, 2);
7981: END IF;
7982:
7983: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7984: RAISE G_EXCEPTION_HALT_VALIDATION;
7985: END IF;
7986: x_return_status := l_return_status;
7987: IF l_oks_exist = 'N'
7996: p_klnv_tbl => l_klnv_tbl_in,
7997: x_klnv_tbl => l_klnv_tbl_out,
7998: p_validate_yn => l_validate_yn);
7999:
8000: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8001: RAISE G_EXCEPTION_HALT_VALIDATION;
8002: ELSE
8003: l_klnv_tbl_in.DELETE;
8004: FOR I IN l_klnv_tbl_out.FIRST .. l_klnv_tbl_out.LAST LOOP
8022: l_klnv_tbl_in(I).DNZ_CHR_ID := Bill_rate_REC.DNZ_CHR_ID;
8023: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
8024: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_klnv_tbl_in(I).CLE_ID,
8025: x_oks_exist =>l_oks_exist);
8026: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8027: RAISE G_EXCEPTION_HALT_VALIDATION;
8028: END IF;
8029: x_return_status := l_return_status;
8030: IF l_oks_exist = 'N'
8040: p_validate_yn => l_validate_yn);
8041:
8042:
8043:
8044: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8045: RAISE G_EXCEPTION_HALT_VALIDATION;
8046: END IF;
8047: END IF; -- End for oks_line_exist check
8048: END LOOP;
8100: IF (G_DEBUG_ENABLED = 'Y') THEN
8101: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);
8102: END IF;
8103:
8104: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8105: RAISE G_EXCEPTION_HALT_VALIDATION;
8106: END IF;
8107:
8108: x_return_status := l_return_status;
8133: okc_debug.log('AFTER COPY_NOTES'||l_return_status, 2);
8134: END IF;
8135:
8136:
8137: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8138: RAISE G_EXCEPTION_HALT_VALIDATION;
8139: END IF;
8140:
8141: -- Added as part of R12 coverage Rearchitecture,create Pm schedule and associate with the service line but not coverage line
8160: okc_debug.log('After RENEW_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
8161: END IF;
8162:
8163:
8164: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8165: RAISE G_EXCEPTION_HALT_VALIDATION;
8166: END IF;
8167: END IF;
8168: END IF;
8167: END IF;
8168: END IF;
8169: -- End changes for coverage Rearchitecture by jvorugan
8170:
8171: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
8172: l_klnv_tbl_in.DELETE;
8173: l_billrate_sch_tbl_in.DELETE;
8174: l_timezone_tbl_in.DELETE;
8175: l_cover_time_tbl_in.DELETE;
8190: END IF;
8191: x_return_status := l_return_status ;
8192: x_msg_count :=l_msg_count;
8193: x_msg_data:=l_msg_data;
8194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8195: (
8196: l_api_name,
8197: 'OKS_COPY_COVERAGE',
8198: 'OKC_API.G_RET_STS_ERROR',
8194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8195: (
8196: l_api_name,
8197: 'OKS_COPY_COVERAGE',
8198: 'OKC_API.G_RET_STS_ERROR',
8199: x_msg_count,
8200: x_msg_data,
8201: '_PVT'
8202: );
8199: x_msg_count,
8200: x_msg_data,
8201: '_PVT'
8202: );
8203: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8204: IF (G_DEBUG_ENABLED = 'Y') THEN
8205: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8206: okc_debug.Reset_Indentation;
8207: END IF;
8206: okc_debug.Reset_Indentation;
8207: END IF;
8208: x_msg_count :=l_msg_count;
8209: x_msg_data:=l_msg_data;
8210: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8211: (
8212: l_api_name,
8213: 'OKS_COPY_COVERAGE',
8214: 'OKC_API.G_RET_STS_ERROR',
8210: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8211: (
8212: l_api_name,
8213: 'OKS_COPY_COVERAGE',
8214: 'OKC_API.G_RET_STS_ERROR',
8215: x_msg_count,
8216: x_msg_data,
8217: '_PVT'
8218: );
8215: x_msg_count,
8216: x_msg_data,
8217: '_PVT'
8218: );
8219: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8220:
8221: IF (G_DEBUG_ENABLED = 'Y') THEN
8222: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8223: okc_debug.Reset_Indentation;
8223: okc_debug.Reset_Indentation;
8224: END IF;
8225: x_msg_count :=l_msg_count;
8226: x_msg_data:=l_msg_data;
8227: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
8228: (
8229: l_api_name,
8230: 'OKS_COPY_COVERAGE',
8231: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8227: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
8228: (
8229: l_api_name,
8230: 'OKS_COPY_COVERAGE',
8231: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8232: x_msg_count,
8233: x_msg_data,
8234: '_PVT'
8235: );
8239: IF (G_DEBUG_ENABLED = 'Y') THEN
8240: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8241: okc_debug.Reset_Indentation;
8242: END IF;
8243: OKC_API.SET_MESSAGE(
8244: p_app_name => g_app_name,
8245: p_msg_name => g_unexpected_error,
8246: p_token1 => g_sqlcode_token,
8247: p_token1_value => sqlcode,
8247: p_token1_value => sqlcode,
8248: p_token2 => g_sqlerrm_token,
8249: p_token2_value => sqlerrm);
8250: -- notify caller of an error as UNEXPETED error
8251: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8252: x_msg_count :=l_msg_count;
8253:
8254:
8255: END Copy_Coverage;
8262:
8263: BEGIN
8264:
8265:
8266: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8263: BEGIN
8264:
8265:
8266: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8264:
8265:
8266: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8265:
8266: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8266: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8268: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8270: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8271: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8273: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8274: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8278: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8279: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8281: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8284: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8285: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8286: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8288: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8289: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8293: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8295: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8297: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8299: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8301: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8303: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8304: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8306: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8307: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8319: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8321: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8322: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8323: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8327: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8329: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8334: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8335: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8338: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8339: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8340: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8348: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8341: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8348: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8349: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8342: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8348: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8349: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8350: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8343: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8348: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8349: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8350: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8351: END ;
8344: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8348: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8349: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8350: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8351: END ;
8352:
8345: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8348: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8349: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8350: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8351: END ;
8352:
8353: --================================================================================
8346: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8347: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8348: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8349: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8350: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8351: END ;
8352:
8353: --================================================================================
8354: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)
8354: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)
8355: IS
8356:
8357: BEGIN
8358: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8355: IS
8356:
8357: BEGIN
8358: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8356:
8357: BEGIN
8358: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8357: BEGIN
8358: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8359: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8361: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8362: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8370: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8363: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8370: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8371: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8364: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8370: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8371: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8372: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8365: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8370: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8371: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8372: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8373:
8366: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8370: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8371: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8372: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8373:
8374: END ;
8367: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8370: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8371: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8372: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8373:
8374: END ;
8375: --=================================================================================
8368: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8369: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8370: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8371: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8372: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8373:
8374: END ;
8375: --=================================================================================
8376: PROCEDURE INIT_OKS_COVER_TIME_LINE(x_cover_time_tbl OUT NOCOPY oks_cvt_pvt.oks_coverage_times_v_tbl_type)
8376: PROCEDURE INIT_OKS_COVER_TIME_LINE(x_cover_time_tbl OUT NOCOPY oks_cvt_pvt.oks_coverage_times_v_tbl_type)
8377:
8378: IS
8379: BEGIN
8380: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8381: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8382: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8377:
8378: IS
8379: BEGIN
8380: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8381: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8382: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8378: IS
8379: BEGIN
8380: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8381: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8382: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8379: BEGIN
8380: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8381: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8382: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8381: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8382: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8382: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8385: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8386: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8390: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8392: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8393: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8401: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8394: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8401: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8402: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8395: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8401: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8402: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8403: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8396: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8401: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8402: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8403: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8404:
8397: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8401: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8402: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8403: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8404:
8405: END ;
8398: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8401: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8402: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8403: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8404:
8405: END ;
8406: --==========================================================================
8399: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8400: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8401: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8402: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8403: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8404:
8405: END ;
8406: --==========================================================================
8407:
8408: PROCEDURE INIT_OKS_ACT_TYPE(x_act_time_tbl OUT NOCOPY OKS_ACT_PVT.OksActionTimeTypesVTblType)
8409: IS
8410: BEGIN
8411:
8412: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8413: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8409: IS
8410: BEGIN
8411:
8412: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8413: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8410: BEGIN
8411:
8412: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8413: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8411:
8412: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8413: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8412: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8413: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8413: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8423: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8416: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8423: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8417: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8423: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8425: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8418: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8423: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8425: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8426: END ;
8419: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8423: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8425: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8426: END ;
8427: --===============================================================================
8420: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8423: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8425: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8426: END ;
8427: --===============================================================================
8428: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8421: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8422: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8423: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8425: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8426: END ;
8427: --===============================================================================
8428: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8429:
8429:
8430: IS
8431: BEGIN
8432:
8433: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8430: IS
8431: BEGIN
8432:
8433: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8431: BEGIN
8432:
8433: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8432:
8433: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8439: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8441: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8442: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8444: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8452: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8445: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8452: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8453: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8446: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8452: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8453: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8454: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8447: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8452: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8453: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8454: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8455:
8448: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8452: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8453: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8454: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8455:
8456: END ;
8449: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8452: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8453: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8454: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8455:
8456: END ;
8457: --============================================================================
8450: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8451: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8452: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8453: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8454: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8455:
8456: END ;
8457: --============================================================================
8458:
8601:
8602:
8603: BEGIN
8604:
8605: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8606: l_time_tbl.DELETE;
8607: FOR monday_rec IN Cur_monday(p_tze_line_id)
8608: LOOP
8609:
8746: fnd_message.set_name('OKS','OKS_BILLRATE_DAYS_OVERLAP');
8747: fnd_message.set_token('DAYS', l_overlap_days);
8748: END IF;
8749:
8750: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8751:
8752: EXCEPTION
8753:
8754: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8750: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8751:
8752: EXCEPTION
8753:
8754: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8755: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8756: (
8757: l_api_name,
8758: G_PKG_NAME,
8751:
8752: EXCEPTION
8753:
8754: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8755: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8756: (
8757: l_api_name,
8758: G_PKG_NAME,
8759: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8755: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8756: (
8757: l_api_name,
8758: G_PKG_NAME,
8759: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8760: x_msg_count,
8761: x_msg_data,
8762: '_PVT'
8763: );
8762: '_PVT'
8763: );
8764: ROLLBACK;
8765: WHEN OTHERS THEN
8766: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8767: (
8768: l_api_name,
8769: G_PKG_NAME,
8770: 'OTHERS',
8777: END; -- Validate_covertime;
8778:
8779: --===========================================================================
8780: PROCEDURE MIGRATE_PRIMARY_RESOURCES(p_api_version IN NUMBER,
8781: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8782: x_return_status OUT NOCOPY VARCHAR2,
8783: x_msg_count OUT NOCOPY NUMBER,
8784: x_msg_data OUT NOCOPY VARCHAR2)IS
8785:
8809:
8810: l_msg_count NUMBER;
8811: l_msg_data VARCHAR2(1000);
8812: l_api_version NUMBER:= 1 ;
8813: l_init_msg_list VARCHAR2(1):= OKC_API.G_FALSE;
8814: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8815:
8816: BEGIN
8817:
8862: p_major_version => l_major_version);
8863:
8864:
8865: IF l_return_Status = 'S' THEN
8866: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8867: ELSE
8868: RAISE G_EXCEPTION_HALT_VALIDATION;
8869: END IF;
8870:
8870:
8871: EXCEPTION
8872: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8873:
8874: OKC_API.SET_MESSAGE(
8875: p_app_name => g_app_name,
8876: p_msg_name => g_unexpected_error,
8877: p_token1 => g_sqlcode_token,
8878: p_token1_value => sqlcode,
8878: p_token1_value => sqlcode,
8879: p_token2 => g_sqlerrm_token,
8880: p_token2_value => sqlerrm);
8881: -- notify caller of an error as UNEXPETED error
8882: x_return_status := OKC_API.G_RET_STS_ERROR;
8883: x_msg_count :=l_msg_count;
8884:
8885: WHEN OTHERS THEN
8886:
8883: x_msg_count :=l_msg_count;
8884:
8885: WHEN OTHERS THEN
8886:
8887: OKC_API.SET_MESSAGE(
8888: p_app_name => g_app_name,
8889: p_msg_name => g_unexpected_error,
8890: p_token1 => g_sqlcode_token,
8891: p_token1_value => sqlcode,
8891: p_token1_value => sqlcode,
8892: p_token2 => g_sqlerrm_token,
8893: p_token2_value => sqlerrm);
8894:
8895: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8896:
8897: END Version_Coverage;
8898:
8899:
8911:
8912: l_msg_count NUMBER;
8913: l_msg_data VARCHAR2(1000);
8914: l_api_version NUMBER:= 1 ;
8915: l_init_msg_list VARCHAR2(1):= OKC_API.G_FALSE;
8916: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8917:
8918: BEGIN
8919:
8964: p_chr_id => l_chr_id);
8965:
8966:
8967: IF l_return_Status = 'S' THEN
8968: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8969: ELSE
8970: RAISE G_EXCEPTION_HALT_VALIDATION;
8971: END IF;
8972:
8973: EXCEPTION
8974:
8975: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8976:
8977: OKC_API.SET_MESSAGE(
8978: p_app_name => g_app_name,
8979: p_msg_name => g_unexpected_error,
8980: p_token1 => g_sqlcode_token,
8981: p_token1_value => sqlcode,
8981: p_token1_value => sqlcode,
8982: p_token2 => g_sqlerrm_token,
8983: p_token2_value => sqlerrm);
8984: -- notify caller of an error as UNEXPETED error
8985: x_return_status := OKC_API.G_RET_STS_ERROR;
8986: x_msg_count :=l_msg_count;
8987:
8988: WHEN OTHERS THEN
8989:
8986: x_msg_count :=l_msg_count;
8987:
8988: WHEN OTHERS THEN
8989:
8990: OKC_API.SET_MESSAGE(
8991: p_app_name => g_app_name,
8992: p_msg_name => g_unexpected_error,
8993: p_token1 => g_sqlcode_token,
8994: p_token1_value => sqlcode,
8994: p_token1_value => sqlcode,
8995: p_token2 => g_sqlerrm_token,
8996: p_token2_value => sqlerrm);
8997:
8998: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8999:
9000: END Restore_Coverage;
9001:
9002:
9014:
9015: l_msg_count NUMBER;
9016: l_msg_data VARCHAR2(1000);
9017: l_api_version NUMBER:= 1 ;
9018: l_init_msg_list VARCHAR2(1):= OKC_API.G_FALSE;
9019: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9020:
9021: BEGIN
9022:
9045: p_chr_id => l_chr_id);
9046:
9047:
9048: IF l_return_Status = 'S' THEN
9049: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9050: ELSE
9051: RAISE G_EXCEPTION_HALT_VALIDATION;
9052: END IF;
9053:
9054: EXCEPTION
9055:
9056: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9057:
9058: OKC_API.SET_MESSAGE(
9059: p_app_name => g_app_name,
9060: p_msg_name => g_unexpected_error,
9061: p_token1 => g_sqlcode_token,
9062: p_token1_value => sqlcode,
9062: p_token1_value => sqlcode,
9063: p_token2 => g_sqlerrm_token,
9064: p_token2_value => sqlerrm);
9065: -- notify caller of an error as UNEXPETED error
9066: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9067: x_msg_count :=l_msg_count;
9068: WHEN OTHERS THEN
9069:
9070: OKC_API.SET_MESSAGE(
9066: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9067: x_msg_count :=l_msg_count;
9068: WHEN OTHERS THEN
9069:
9070: OKC_API.SET_MESSAGE(
9071: p_app_name => g_app_name,
9072: p_msg_name => g_unexpected_error,
9073: p_token1 => g_sqlcode_token,
9074: p_token1_value => sqlcode,
9074: p_token1_value => sqlcode,
9075: p_token2 => g_sqlerrm_token,
9076: p_token2_value => sqlerrm);
9077:
9078: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9079:
9080: END Delete_History;
9081:
9082:
9090: x_msg_data OUT NOCOPY VARCHAR2,
9091: p_chr_id IN NUMBER) IS
9092:
9093: l_api_version NUMBER := 1;
9094: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
9095: l_return_status VARCHAR2(1);
9096: l_return_msg VARCHAR2(2000);
9097: l_msg_count NUMBER;
9098: l_msg_data VARCHAR2(2000);
9101:
9102: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9103: BEGIN
9104:
9105: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
9106: p_init_msg_list,
9107: '_PUB',
9108: x_return_status);
9109:
9106: p_init_msg_list,
9107: '_PUB',
9108: x_return_status);
9109:
9110: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
9111: THEN
9112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9114: THEN
9108: x_return_status);
9109:
9110: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
9111: THEN
9112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9114: THEN
9115: raise OKC_API.G_EXCEPTION_ERROR;
9116: ELSIF l_return_status IS NULL
9109:
9110: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
9111: THEN
9112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9114: THEN
9115: raise OKC_API.G_EXCEPTION_ERROR;
9116: ELSIF l_return_status IS NULL
9117: THEN
9111: THEN
9112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9114: THEN
9115: raise OKC_API.G_EXCEPTION_ERROR;
9116: ELSIF l_return_status IS NULL
9117: THEN
9118: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9119: END IF;
9114: THEN
9115: raise OKC_API.G_EXCEPTION_ERROR;
9116: ELSIF l_return_status IS NULL
9117: THEN
9118: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9119: END IF;
9120:
9121:
9122: DELETE OKS_ACTION_TIME_TYPES_H
9151: p_chr_id => l_chr_id);
9152:
9153:
9154: IF l_return_Status = 'S' THEN
9155: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9156: ELSE
9157: RAISE G_EXCEPTION_HALT_VALIDATION;
9158: END IF;
9159:
9160: EXCEPTION
9161:
9162: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9163:
9164: OKC_API.SET_MESSAGE(
9165: p_app_name => g_app_name,
9166: p_msg_name => g_unexpected_error,
9167: p_token1 => g_sqlcode_token,
9168: p_token1_value => sqlcode,
9168: p_token1_value => sqlcode,
9169: p_token2 => g_sqlerrm_token,
9170: p_token2_value => sqlerrm);
9171: -- notify caller of an error as UNEXPETED error
9172: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9173: x_msg_count :=l_msg_count;
9174:
9175:
9176:
9173: x_msg_count :=l_msg_count;
9174:
9175:
9176:
9177: WHEN OKC_API.G_EXCEPTION_ERROR THEN
9178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9179: (l_api_name,
9180: G_PKG_NAME,
9181: 'OKC_API.G_RET_STS_ERROR',
9174:
9175:
9176:
9177: WHEN OKC_API.G_EXCEPTION_ERROR THEN
9178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9179: (l_api_name,
9180: G_PKG_NAME,
9181: 'OKC_API.G_RET_STS_ERROR',
9182: x_msg_count,
9177: WHEN OKC_API.G_EXCEPTION_ERROR THEN
9178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9179: (l_api_name,
9180: G_PKG_NAME,
9181: 'OKC_API.G_RET_STS_ERROR',
9182: x_msg_count,
9183: x_msg_data,
9184: '_PUB');
9185: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9181: 'OKC_API.G_RET_STS_ERROR',
9182: x_msg_count,
9183: x_msg_data,
9184: '_PUB');
9185: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9187: (l_api_name,
9188: G_PKG_NAME,
9189: 'OKC_API.G_RET_STS_UNEXP_ERROR',
9182: x_msg_count,
9183: x_msg_data,
9184: '_PUB');
9185: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9187: (l_api_name,
9188: G_PKG_NAME,
9189: 'OKC_API.G_RET_STS_UNEXP_ERROR',
9190: x_msg_count,
9185: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9187: (l_api_name,
9188: G_PKG_NAME,
9189: 'OKC_API.G_RET_STS_UNEXP_ERROR',
9190: x_msg_count,
9191: x_msg_data,
9192: '_PUB');
9193: WHEN OTHERS THEN
9190: x_msg_count,
9191: x_msg_data,
9192: '_PUB');
9193: WHEN OTHERS THEN
9194: OKC_API.set_message(p_app_name => g_app_name,
9195: p_msg_name => g_unexpected_error,
9196: p_token1 => g_sqlcode_token,
9197: p_token1_value => sqlcode,
9198: p_token2 => g_sqlerrm_token,
9196: p_token1 => g_sqlcode_token,
9197: p_token1_value => sqlcode,
9198: p_token2 => g_sqlerrm_token,
9199: p_token2_value => sqlerrm);
9200: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9201: ROLLBACK ;
9202: END Delete_Saved_Version;
9203: --===========================================================================
9204:
9203: --===========================================================================
9204:
9205: PROCEDURE COPY_K_HDR_NOTES
9206: (p_api_version IN NUMBER ,
9207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9208: p_chr_id IN NUMBER,
9209: x_return_status OUT NOCOPY VARCHAR2,
9210: x_msg_count OUT NOCOPY NUMBER,
9211: x_msg_data OUT NOCOPY VARCHAR2) IS
9297: END IF;
9298:
9299: END IF;
9300:
9301: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9302:
9303: EXCEPTION
9304:
9305: WHEN OTHERS THEN
9303: EXCEPTION
9304:
9305: WHEN OTHERS THEN
9306:
9307: OKC_API.set_message(G_APP_NAME,
9308: G_UNEXPECTED_ERROR,
9309: G_SQLCODE_TOKEN,
9310: SQLCODE,
9311: G_SQLERRM_TOKEN,
9310: SQLCODE,
9311: G_SQLERRM_TOKEN,
9312: SQLERRM);
9313:
9314: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9315:
9316: END COPY_K_HDR_NOTES;
9317:
9318: PROCEDURE Update_dnz_chr_id
9466: l_dnz_chr_id NUMBER:= -1;
9467: l_oks_line_id NUMBER;
9468: l_cle_id NUMBER;
9469: l_api_version CONSTANT NUMBER := 1.0;
9470: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
9471: l_return_status VARCHAR2(1) := 'S';
9472: l_msg_count Number;
9473: l_msg_data Varchar2(240);
9474: l_validate_yn VARCHAR2(1) := 'N';
10091: Create_K_coverage_ext can be called during the creation of service line from authoring or from renewal
10092: consolidation flow.
10093: */
10094: PROCEDURE Create_K_coverage_ext(p_api_version IN NUMBER,
10095: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10096: p_src_line_id IN NUMBER,
10097: p_tgt_line_id IN NUMBER,
10098: x_return_status OUT NOCOPY VARCHAR2,
10099: x_msg_count OUT NOCOPY NUMBER,
10268: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10269: END IF;
10270:
10271:
10272: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
10273: RAISE G_EXCEPTION_HALT_VALIDATION;
10274: END IF;
10275: END LOOP;
10276: --errorout_ad('before'||l_return_status);
10303: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
10304: END IF;
10305:
10306:
10307: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
10308: RAISE G_EXCEPTION_HALT_VALIDATION;
10309: END IF;
10310: END IF;
10311: x_return_status := l_return_status ;
10318: END IF;
10319: x_return_status := l_return_status ;
10320: x_msg_count :=l_msg_count;
10321: x_msg_data:=l_msg_data;
10322: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10323: (
10324: l_api_name,
10325: 'Create_K_coverage_ext',
10326: 'OKC_API.G_RET_STS_ERROR',
10322: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10323: (
10324: l_api_name,
10325: 'Create_K_coverage_ext',
10326: 'OKC_API.G_RET_STS_ERROR',
10327: x_msg_count,
10328: x_msg_data,
10329: '_PVT'
10330: );
10327: x_msg_count,
10328: x_msg_data,
10329: '_PVT'
10330: );
10331: WHEN OKC_API.G_EXCEPTION_ERROR THEN
10332: IF (G_DEBUG_ENABLED = 'Y') THEN
10333: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10334: okc_debug.Reset_Indentation;
10335: END IF;
10334: okc_debug.Reset_Indentation;
10335: END IF;
10336: x_msg_count :=l_msg_count;
10337: x_msg_data:=l_msg_data;
10338: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10339: (
10340: l_api_name,
10341: 'Create_K_coverage_ext',
10342: 'OKC_API.G_RET_STS_ERROR',
10338: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10339: (
10340: l_api_name,
10341: 'Create_K_coverage_ext',
10342: 'OKC_API.G_RET_STS_ERROR',
10343: x_msg_count,
10344: x_msg_data,
10345: '_PVT'
10346: );
10343: x_msg_count,
10344: x_msg_data,
10345: '_PVT'
10346: );
10347: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10348:
10349: IF (G_DEBUG_ENABLED = 'Y') THEN
10350: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10351: okc_debug.Reset_Indentation;
10351: okc_debug.Reset_Indentation;
10352: END IF;
10353: x_msg_count :=l_msg_count;
10354: x_msg_data:=l_msg_data;
10355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
10356: (
10357: l_api_name,
10358: 'Create_K_coverage_ext',
10359: 'OKC_API.G_RET_STS_UNEXP_ERROR',
10355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
10356: (
10357: l_api_name,
10358: 'Create_K_coverage_ext',
10359: 'OKC_API.G_RET_STS_UNEXP_ERROR',
10360: x_msg_count,
10361: x_msg_data,
10362: '_PVT'
10363: );
10366: IF (G_DEBUG_ENABLED = 'Y') THEN
10367: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10368: okc_debug.Reset_Indentation;
10369: END IF;
10370: OKC_API.SET_MESSAGE(
10371: p_app_name => g_app_name,
10372: p_msg_name => g_unexpected_error,
10373: p_token1 => g_sqlcode_token,
10374: p_token1_value => sqlcode,
10374: p_token1_value => sqlcode,
10375: p_token2 => g_sqlerrm_token,
10376: p_token2_value => sqlerrm);
10377: -- notify caller of an error as UNEXPETED error
10378: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10379: x_msg_count :=l_msg_count;
10380:
10381: END Create_K_coverage_ext;
10382:
10387: P_new_coverage_name -- Name of the Target coverage
10388: x_new_coverage_id -- New Id of the copied coverage */
10389: PROCEDURE COPY_STANDARD_COVERAGE(
10390: p_api_version IN NUMBER,
10391: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10392: x_return_status OUT NOCOPY VARCHAR2,
10393: x_msg_count OUT NOCOPY NUMBER,
10394: x_msg_data OUT NOCOPY VARCHAR2,
10395: P_old_coverage_id IN NUMBER,
10458: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10459: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10460: l_new_br_id OKC_K_LINES_B.ID%TYPE;
10461: l_cov_flag NUMBER;
10462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
10463:
10464: -- This function is called by copy_standard_coverage for insertion into okc_k_lines_b table
10465: FUNCTION CREATE_OKC_LINE(p_new_line_id NUMBER,
10466: p_old_line_id NUMBER,
10466: p_old_line_id NUMBER,
10467: p_flag NUMBER,
10468: p_cle_id NUMBER DEFAULT NULL) return VARCHAR2 IS
10469:
10470: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10471: l_start_date DATE;
10472: l_coverage_name VARCHAR2(150);
10473:
10474: BEGIN
10718: RETURN x_return_status;
10719:
10720: EXCEPTION
10721: when others then
10722: OKC_API.set_message(G_APP_NAME,
10723: G_UNEXPECTED_ERROR,
10724: G_SQLCODE_TOKEN,
10725: SQLCODE,
10726: G_SQLERRM_TOKEN,
10724: G_SQLCODE_TOKEN,
10725: SQLCODE,
10726: G_SQLERRM_TOKEN,
10727: SQLERRM);
10728: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10729: return x_return_status;
10730:
10731: END CREATE_OKC_LINE;
10732:
10735: FUNCTION CREATE_OKC_ITEM(p_new_item_id NUMBER,
10736: p_old_item_id NUMBER,
10737: p_cle_id NUMBER) return VARCHAR2 IS
10738:
10739: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10740:
10741: BEGIN
10742:
10743: INSERT INTO okc_k_items
10798: RETURN x_return_status;
10799:
10800: EXCEPTION
10801: when others then
10802: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10803: OKC_API.set_message(G_APP_NAME,
10804: G_UNEXPECTED_ERROR,
10805: G_SQLCODE_TOKEN,
10806: SQLCODE,
10799:
10800: EXCEPTION
10801: when others then
10802: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10803: OKC_API.set_message(G_APP_NAME,
10804: G_UNEXPECTED_ERROR,
10805: G_SQLCODE_TOKEN,
10806: SQLCODE,
10807: G_SQLERRM_TOKEN,
10815: FUNCTION CREATE_OKC_PARTY(p_new_party_id NUMBER,
10816: p_old_party_id NUMBER,
10817: p_cle_id NUMBER) return VARCHAR2 IS
10818:
10819: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10820:
10821: BEGIN
10822:
10823: INSERT INTO okc_k_party_roles_b
10945: RETURN x_return_status;
10946:
10947: EXCEPTION
10948: when others then
10949: OKC_API.set_message(G_APP_NAME,
10950: G_UNEXPECTED_ERROR,
10951: G_SQLCODE_TOKEN,
10952: SQLCODE,
10953: G_SQLERRM_TOKEN,
10951: G_SQLCODE_TOKEN,
10952: SQLCODE,
10953: G_SQLERRM_TOKEN,
10954: SQLERRM);
10955: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10956: return x_return_status;
10957: END CREATE_OKC_PARTY;
10958:
10959: -- This function is called by copy_standard_coverage for insertion into okc_contacts table
10960: FUNCTION CREATE_OKC_CONTACT(p_new_cpl_id NUMBER,
10961: p_old_cpl_id NUMBER) return VARCHAR2 IS
10962:
10963:
10964: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10965:
10966: BEGIN
10967:
10968: /*cgopinee bugfix for 6882512-Addded dnz_ste_code*/
11052: RETURN x_return_status;
11053:
11054: EXCEPTION
11055: WHEN others THEN
11056: OKC_API.set_message(G_APP_NAME,
11057: G_UNEXPECTED_ERROR,
11058: G_SQLCODE_TOKEN,
11059: SQLCODE,
11060: G_SQLERRM_TOKEN,
11058: G_SQLCODE_TOKEN,
11059: SQLCODE,
11060: G_SQLERRM_TOKEN,
11061: SQLERRM);
11062: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
11063: return x_return_status;
11064:
11065: END CREATE_OKC_CONTACT;
11066:
11082: IF (G_DEBUG_ENABLED = 'Y') THEN
11083: okc_debug.log('AFTER CREATE_OKC_LINE FOR COVERAGE'||l_return_status, 2);
11084: END IF;
11085:
11086: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11087: THEN
11088: RAISE G_EXCEPTION_HALT_VALIDATION;
11089: END IF;
11090:
11098: IF (G_DEBUG_ENABLED = 'Y') THEN
11099: okc_debug.log('AFTER CREATE_OKC_LINE FOR BP'||l_return_status, 2);
11100: END IF;
11101:
11102: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11103: THEN
11104: RAISE G_EXCEPTION_HALT_VALIDATION;
11105: END IF;
11106:
11113: IF (G_DEBUG_ENABLED = 'Y') THEN
11114: okc_debug.log('AFTER CREATE_OKC_ITEM'||l_return_status, 2);
11115: END IF;
11116:
11117: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11118: THEN
11119: RAISE G_EXCEPTION_HALT_VALIDATION;
11120: END IF;
11121: -- Done Business Process
11130: IF (G_DEBUG_ENABLED = 'Y') THEN
11131: okc_debug.log('AFTER CREATE_OKC_LINE FOR RT'||l_return_status, 2);
11132: END IF;
11133:
11134: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11135: THEN
11136: RAISE G_EXCEPTION_HALT_VALIDATION;
11137: END IF;
11138: IF tmp_crt_rec.lse_id in (5,59) -- For Billtypes
11146: IF (G_DEBUG_ENABLED = 'Y') THEN
11147: okc_debug.log('AFTER CREATE_OKC_ITEM FOR RT'||l_return_status, 2);
11148: END IF;
11149:
11150: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11151: THEN
11152: RAISE G_EXCEPTION_HALT_VALIDATION;
11153: END IF;
11154: --Create bill rate lines
11163: IF (G_DEBUG_ENABLED = 'Y') THEN
11164: okc_debug.log('AFTER CREATE_OKC_LINE FOR BR'||l_return_status, 2);
11165: END IF;
11166:
11167: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11168: THEN
11169: RAISE G_EXCEPTION_HALT_VALIDATION;
11170: END IF;
11171: END IF;
11185: IF (G_DEBUG_ENABLED = 'Y') THEN
11186: okc_debug.log('AFTER CREATE_OKC_PARTY'||l_return_status, 2);
11187: END IF;
11188:
11189: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11190: THEN
11191: RAISE G_EXCEPTION_HALT_VALIDATION;
11192: END IF;
11193: -- okc_contacts
11195: IF (G_DEBUG_ENABLED = 'Y') THEN
11196: okc_debug.log('AFTER CREATE_OKC_CONTACT'||l_return_status, 2);
11197: END IF;
11198:
11199: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11200: THEN
11201: RAISE G_EXCEPTION_HALT_VALIDATION;
11202: END IF;
11203: END IF;
11209: END LOOP; -- End loop for bp
11210: -- Create oks components
11211: Copy_Coverage
11212: (p_api_version => 1.0,
11213: p_init_msg_list => OKC_API.G_FALSE,
11214: x_return_status => l_return_status,
11215: x_msg_count => x_msg_count,
11216: x_msg_data => x_msg_data,
11217: p_contract_line_id => l_new_coverage_id);
11220: okc_debug.log('AFTER Copy_Coverage'||l_return_status, 2);
11221: END IF;
11222:
11223:
11224: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
11225: Raise G_EXCEPTION_HALT_VALIDATION;
11226: End If;
11227:
11228: x_new_coverage_id := l_new_coverage_id;
11232: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11233: x_return_status := l_return_status ;
11234: ROLLBACK to copy_standard_coverage;
11235: WHEN OTHERS THEN
11236: OKC_API.set_message(G_APP_NAME,
11237: G_UNEXPECTED_ERROR,
11238: G_SQLCODE_TOKEN,
11239: SQLCODE,
11240: G_SQLERRM_TOKEN,
11238: G_SQLCODE_TOKEN,
11239: SQLCODE,
11240: G_SQLERRM_TOKEN,
11241: SQLERRM);
11242: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
11243: ROLLBACK to copy_standard_coverage;
11244:
11245: END COPY_STANDARD_COVERAGE;
11246: END OKS_COVERAGES_PVT;