[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
7882: IF (G_DEBUG_ENABLED = 'Y') THEN
7883: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);
7884: END IF;
7885:
7886: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7887: RAISE G_EXCEPTION_HALT_VALIDATION;
7888: ELSE
7889: FOR I IN l_act_pvt_tbl_out.FIRST .. l_act_pvt_tbl_out.LAST LOOP
7890: l_act_pvt_new_id := l_act_pvt_tbl_out(I).ID;
7924: IF (G_DEBUG_ENABLED = 'Y') THEN
7925: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
7926: END IF;
7927:
7928: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7929: RAISE G_EXCEPTION_HALT_VALIDATION;
7930: ELSE
7931: l_acm_pvt_tbl_in.DELETE;
7932: l_act_pvt_tbl_in.DELETE;
7975: IF (G_DEBUG_ENABLED = 'Y') THEN
7976: okc_debug.log('AFTER CHECK_OKSLINE_EXIST4'||l_return_status, 2);
7977: END IF;
7978:
7979: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7980: RAISE G_EXCEPTION_HALT_VALIDATION;
7981: END IF;
7982: x_return_status := l_return_status;
7983: IF l_oks_exist = 'N'
7992: p_klnv_tbl => l_klnv_tbl_in,
7993: x_klnv_tbl => l_klnv_tbl_out,
7994: p_validate_yn => l_validate_yn);
7995:
7996: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7997: RAISE G_EXCEPTION_HALT_VALIDATION;
7998: ELSE
7999: l_klnv_tbl_in.DELETE;
8000: FOR I IN l_klnv_tbl_out.FIRST .. l_klnv_tbl_out.LAST LOOP
8012: l_klnv_tbl_in(I).DNZ_CHR_ID := Bill_rate_REC.DNZ_CHR_ID;
8013: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
8014: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_klnv_tbl_in(I).CLE_ID,
8015: x_oks_exist =>l_oks_exist);
8016: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8017: RAISE G_EXCEPTION_HALT_VALIDATION;
8018: END IF;
8019: x_return_status := l_return_status;
8020: IF l_oks_exist = 'N'
8030: p_validate_yn => l_validate_yn);
8031:
8032:
8033:
8034: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8035: RAISE G_EXCEPTION_HALT_VALIDATION;
8036: END IF;
8037: END IF; -- End for oks_line_exist check
8038: END LOOP;
8090: IF (G_DEBUG_ENABLED = 'Y') THEN
8091: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);
8092: END IF;
8093:
8094: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8095: RAISE G_EXCEPTION_HALT_VALIDATION;
8096: END IF;
8097:
8098: x_return_status := l_return_status;
8123: okc_debug.log('AFTER COPY_NOTES'||l_return_status, 2);
8124: END IF;
8125:
8126:
8127: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8128: RAISE G_EXCEPTION_HALT_VALIDATION;
8129: END IF;
8130:
8131: -- Added as part of R12 coverage Rearchitecture,create Pm schedule and associate with the service line but not coverage line
8150: okc_debug.log('After RENEW_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
8151: END IF;
8152:
8153:
8154: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8155: RAISE G_EXCEPTION_HALT_VALIDATION;
8156: END IF;
8157: END IF;
8158: END IF;
8157: END IF;
8158: END IF;
8159: -- End changes for coverage Rearchitecture by jvorugan
8160:
8161: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
8162: l_klnv_tbl_in.DELETE;
8163: l_billrate_sch_tbl_in.DELETE;
8164: l_timezone_tbl_in.DELETE;
8165: l_cover_time_tbl_in.DELETE;
8180: END IF;
8181: x_return_status := l_return_status ;
8182: x_msg_count :=l_msg_count;
8183: x_msg_data:=l_msg_data;
8184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8185: (
8186: l_api_name,
8187: 'OKS_COPY_COVERAGE',
8188: 'OKC_API.G_RET_STS_ERROR',
8184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8185: (
8186: l_api_name,
8187: 'OKS_COPY_COVERAGE',
8188: 'OKC_API.G_RET_STS_ERROR',
8189: x_msg_count,
8190: x_msg_data,
8191: '_PVT'
8192: );
8189: x_msg_count,
8190: x_msg_data,
8191: '_PVT'
8192: );
8193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8194: IF (G_DEBUG_ENABLED = 'Y') THEN
8195: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8196: okc_debug.Reset_Indentation;
8197: END IF;
8196: okc_debug.Reset_Indentation;
8197: END IF;
8198: x_msg_count :=l_msg_count;
8199: x_msg_data:=l_msg_data;
8200: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8201: (
8202: l_api_name,
8203: 'OKS_COPY_COVERAGE',
8204: 'OKC_API.G_RET_STS_ERROR',
8200: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8201: (
8202: l_api_name,
8203: 'OKS_COPY_COVERAGE',
8204: 'OKC_API.G_RET_STS_ERROR',
8205: x_msg_count,
8206: x_msg_data,
8207: '_PVT'
8208: );
8205: x_msg_count,
8206: x_msg_data,
8207: '_PVT'
8208: );
8209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8210:
8211: IF (G_DEBUG_ENABLED = 'Y') THEN
8212: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8213: okc_debug.Reset_Indentation;
8213: okc_debug.Reset_Indentation;
8214: END IF;
8215: x_msg_count :=l_msg_count;
8216: x_msg_data:=l_msg_data;
8217: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
8218: (
8219: l_api_name,
8220: 'OKS_COPY_COVERAGE',
8221: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8217: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
8218: (
8219: l_api_name,
8220: 'OKS_COPY_COVERAGE',
8221: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8222: x_msg_count,
8223: x_msg_data,
8224: '_PVT'
8225: );
8229: IF (G_DEBUG_ENABLED = 'Y') THEN
8230: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8231: okc_debug.Reset_Indentation;
8232: END IF;
8233: OKC_API.SET_MESSAGE(
8234: p_app_name => g_app_name,
8235: p_msg_name => g_unexpected_error,
8236: p_token1 => g_sqlcode_token,
8237: p_token1_value => sqlcode,
8237: p_token1_value => sqlcode,
8238: p_token2 => g_sqlerrm_token,
8239: p_token2_value => sqlerrm);
8240: -- notify caller of an error as UNEXPETED error
8241: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8242: x_msg_count :=l_msg_count;
8243:
8244:
8245: END Copy_Coverage;
8252:
8253: BEGIN
8254:
8255:
8256: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8257: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8258: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8253: BEGIN
8254:
8255:
8256: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8257: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8258: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8254:
8255:
8256: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8257: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8258: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8255:
8256: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8257: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8258: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8256: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
8257: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8258: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8257: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8258: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8258: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8259: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8260: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8261: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8262: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8263: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8264: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8265: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8266: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8267: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8268: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8269: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8270: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8271: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8272: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8273: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8274: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8275: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8276: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8277: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8278: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8279: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8280: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8281: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8282: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8283: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8284: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8285: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8286: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8287: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8288: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8289: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8290: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8291: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8292: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8293: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8294: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8295: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8296: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8297: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8298: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8299: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8300: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8301: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8302: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8303: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8304: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8305: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8306: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8307: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8308: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8309: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8310: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8311: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8312: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8313: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8314: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8315: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8316: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8317: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8318: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8319: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8320: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8321: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8322: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8323: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8324: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8325: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8326: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8327: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8328: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8329: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8330: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8338: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8331: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8338: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8339: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8332: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8338: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8339: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8340: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8333: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8338: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8339: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8340: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8341: END ;
8334: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8338: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8339: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8340: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8341: END ;
8342:
8335: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8338: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8339: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8340: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8341: END ;
8342:
8343: --================================================================================
8336: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8337: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8338: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8339: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8340: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8341: END ;
8342:
8343: --================================================================================
8344: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)
8344: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)
8345: IS
8346:
8347: BEGIN
8348: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8349: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8350: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8345: IS
8346:
8347: BEGIN
8348: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8349: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8350: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8346:
8347: BEGIN
8348: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8349: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8350: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8347: BEGIN
8348: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8349: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8350: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8348: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;
8349: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8350: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8349: x_timezone_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
8350: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8350: x_timezone_tbl(1).DEFAULT_YN := OKC_API.G_MISS_CHAR;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8351: x_timezone_tbl(1).TIMEZONE_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8352: x_timezone_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8353: x_timezone_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8361: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8354: x_timezone_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8361: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8362: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8355: x_timezone_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8361: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8362: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8363:
8356: x_timezone_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8361: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8362: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8363:
8364: END ;
8357: x_timezone_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8361: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8362: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8363:
8364: END ;
8365: --=================================================================================
8358: x_timezone_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8359: x_timezone_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8360: x_timezone_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8361: x_timezone_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8362: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8363:
8364: END ;
8365: --=================================================================================
8366: PROCEDURE INIT_OKS_COVER_TIME_LINE(x_cover_time_tbl OUT NOCOPY oks_cvt_pvt.oks_coverage_times_v_tbl_type)
8366: PROCEDURE INIT_OKS_COVER_TIME_LINE(x_cover_time_tbl OUT NOCOPY oks_cvt_pvt.oks_coverage_times_v_tbl_type)
8367:
8368: IS
8369: BEGIN
8370: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8371: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8372: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8367:
8368: IS
8369: BEGIN
8370: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8371: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8372: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8368: IS
8369: BEGIN
8370: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8371: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8372: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8369: BEGIN
8370: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8371: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8372: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8370: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;
8371: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8372: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8371: x_cover_time_tbl(1).COV_TZE_LINE_ID := OKC_API.G_MISS_NUM;
8372: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8372: x_cover_time_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8373: x_cover_time_tbl(1).START_HOUR := OKC_API.G_MISS_NUM;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8374: x_cover_time_tbl(1).START_MINUTE := OKC_API.G_MISS_NUM;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8375: x_cover_time_tbl(1).END_HOUR := OKC_API.G_MISS_NUM;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8376: x_cover_time_tbl(1).END_MINUTE := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8377: x_cover_time_tbl(1).MONDAY_YN := OKC_API.G_MISS_CHAR;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8378: x_cover_time_tbl(1).TUESDAY_YN := OKC_API.G_MISS_CHAR;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8379: x_cover_time_tbl(1).WEDNESDAY_YN := OKC_API.G_MISS_CHAR;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8380: x_cover_time_tbl(1).THURSDAY_YN := OKC_API.G_MISS_CHAR;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8381: x_cover_time_tbl(1).FRIDAY_YN := OKC_API.G_MISS_CHAR;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8382: x_cover_time_tbl(1).SATURDAY_YN := OKC_API.G_MISS_CHAR;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8383: x_cover_time_tbl(1).SUNDAY_YN := OKC_API.G_MISS_CHAR;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8384: x_cover_time_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8392: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8385: x_cover_time_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8392: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8393: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8386: x_cover_time_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8392: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8393: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8394:
8387: x_cover_time_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8392: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8393: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8394:
8395: END ;
8388: x_cover_time_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8392: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8393: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8394:
8395: END ;
8396: --==========================================================================
8389: x_cover_time_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
8390: x_cover_time_tbl(1).PROGRAM_APPLICATION_ID := OKC_API.G_MISS_NUM;
8391: x_cover_time_tbl(1).PROGRAM_ID := OKC_API.G_MISS_NUM;
8392: x_cover_time_tbl(1).PROGRAM_UPDATE_DATE := OKC_API.G_MISS_DATE;
8393: x_cover_time_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8394:
8395: END ;
8396: --==========================================================================
8397:
8398: PROCEDURE INIT_OKS_ACT_TYPE(x_act_time_tbl OUT NOCOPY OKS_ACT_PVT.OksActionTimeTypesVTblType)
8399: IS
8400: BEGIN
8401:
8402: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8403: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8404: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8399: IS
8400: BEGIN
8401:
8402: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8403: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8404: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8400: BEGIN
8401:
8402: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8403: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8404: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8401:
8402: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8403: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8404: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8402: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8403: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8404: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8403: x_act_time_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8404: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8404: x_act_time_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8405: x_act_time_tbl(1).action_type_code := OKC_API.G_MISS_CHAR;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8413: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8406: x_act_time_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8413: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8407: x_act_time_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8413: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8408: x_act_time_tbl(1).program_id := OKC_API.G_MISS_NUM;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8413: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8416: END ;
8409: x_act_time_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8413: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8416: END ;
8417: --===============================================================================
8410: x_act_time_tbl(1).request_id := OKC_API.G_MISS_NUM;
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8413: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8416: END ;
8417: --===============================================================================
8418: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8411: x_act_time_tbl(1).created_by := OKC_API.G_MISS_NUM;
8412: x_act_time_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8413: x_act_time_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8416: END ;
8417: --===============================================================================
8418: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8419:
8419:
8420: IS
8421: BEGIN
8422:
8423: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8424: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8425: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8420: IS
8421: BEGIN
8422:
8423: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8424: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8425: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8421: BEGIN
8422:
8423: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8424: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8425: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8422:
8423: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8424: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8425: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8423: x_act_type_tbl(1).id := OKC_API.G_MISS_NUM;
8424: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8425: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8424: x_act_type_tbl(1).cov_action_type_id := OKC_API.G_MISS_NUM;
8425: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8425: x_act_type_tbl(1).cle_id := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8426: x_act_type_tbl(1).dnz_chr_id := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8427: x_act_type_tbl(1).uom_code := OKC_API.G_MISS_CHAR;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8428: x_act_type_tbl(1).sun_duration := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8429: x_act_type_tbl(1).mon_duration := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8430: x_act_type_tbl(1).tue_duration := OKC_API.G_MISS_NUM;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8431: x_act_type_tbl(1).wed_duration := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8432: x_act_type_tbl(1).thu_duration := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8433: x_act_type_tbl(1).fri_duration := OKC_API.G_MISS_NUM;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8434: x_act_type_tbl(1).sat_duration := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8442: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8435: x_act_type_tbl(1).security_group_id := OKC_API.G_MISS_NUM;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8442: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8436: x_act_type_tbl(1).program_application_id := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8442: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8444: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8437: x_act_type_tbl(1).program_id := OKC_API.G_MISS_NUM;
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8442: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8444: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8445:
8438: x_act_type_tbl(1).program_update_date := OKC_API.G_MISS_DATE;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8442: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8444: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8445:
8446: END ;
8439: x_act_type_tbl(1).request_id := OKC_API.G_MISS_NUM;
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8442: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8444: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8445:
8446: END ;
8447: --============================================================================
8440: x_act_type_tbl(1).created_by := OKC_API.G_MISS_NUM;
8441: x_act_type_tbl(1).creation_date := OKC_API.G_MISS_DATE;
8442: x_act_type_tbl(1).last_updated_by := OKC_API.G_MISS_NUM;
8443: x_act_type_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8444: x_act_type_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8445:
8446: END ;
8447: --============================================================================
8448:
8591:
8592:
8593: BEGIN
8594:
8595: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8596: l_time_tbl.DELETE;
8597: FOR monday_rec IN Cur_monday(p_tze_line_id)
8598: LOOP
8599:
8736: fnd_message.set_name('OKS','OKS_BILLRATE_DAYS_OVERLAP');
8737: fnd_message.set_token('DAYS', l_overlap_days);
8738: END IF;
8739:
8740: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8741:
8742: EXCEPTION
8743:
8744: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8740: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8741:
8742: EXCEPTION
8743:
8744: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8745: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8746: (
8747: l_api_name,
8748: G_PKG_NAME,
8741:
8742: EXCEPTION
8743:
8744: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8745: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8746: (
8747: l_api_name,
8748: G_PKG_NAME,
8749: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8745: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8746: (
8747: l_api_name,
8748: G_PKG_NAME,
8749: 'OKC_API.G_RET_STS_UNEXP_ERROR',
8750: x_msg_count,
8751: x_msg_data,
8752: '_PVT'
8753: );
8752: '_PVT'
8753: );
8754: ROLLBACK;
8755: WHEN OTHERS THEN
8756: x_return_status := OKC_API.HANDLE_EXCEPTIONS
8757: (
8758: l_api_name,
8759: G_PKG_NAME,
8760: 'OTHERS',
8767: END; -- Validate_covertime;
8768:
8769: --===========================================================================
8770: PROCEDURE MIGRATE_PRIMARY_RESOURCES(p_api_version IN NUMBER,
8771: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8772: x_return_status OUT NOCOPY VARCHAR2,
8773: x_msg_count OUT NOCOPY NUMBER,
8774: x_msg_data OUT NOCOPY VARCHAR2)IS
8775:
8799:
8800: l_msg_count NUMBER;
8801: l_msg_data VARCHAR2(1000);
8802: l_api_version NUMBER:= 1 ;
8803: l_init_msg_list VARCHAR2(1):= OKC_API.G_FALSE;
8804: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8805:
8806: BEGIN
8807:
8852: p_major_version => l_major_version);
8853:
8854:
8855: IF l_return_Status = 'S' THEN
8856: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8857: ELSE
8858: RAISE G_EXCEPTION_HALT_VALIDATION;
8859: END IF;
8860:
8860:
8861: EXCEPTION
8862: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8863:
8864: OKC_API.SET_MESSAGE(
8865: p_app_name => g_app_name,
8866: p_msg_name => g_unexpected_error,
8867: p_token1 => g_sqlcode_token,
8868: p_token1_value => sqlcode,
8868: p_token1_value => sqlcode,
8869: p_token2 => g_sqlerrm_token,
8870: p_token2_value => sqlerrm);
8871: -- notify caller of an error as UNEXPETED error
8872: x_return_status := OKC_API.G_RET_STS_ERROR;
8873: x_msg_count :=l_msg_count;
8874:
8875: WHEN OTHERS THEN
8876:
8873: x_msg_count :=l_msg_count;
8874:
8875: WHEN OTHERS THEN
8876:
8877: OKC_API.SET_MESSAGE(
8878: p_app_name => g_app_name,
8879: p_msg_name => g_unexpected_error,
8880: p_token1 => g_sqlcode_token,
8881: p_token1_value => sqlcode,
8881: p_token1_value => sqlcode,
8882: p_token2 => g_sqlerrm_token,
8883: p_token2_value => sqlerrm);
8884:
8885: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8886:
8887: END Version_Coverage;
8888:
8889:
8901:
8902: l_msg_count NUMBER;
8903: l_msg_data VARCHAR2(1000);
8904: l_api_version NUMBER:= 1 ;
8905: l_init_msg_list VARCHAR2(1):= OKC_API.G_FALSE;
8906: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8907:
8908: BEGIN
8909:
8954: p_chr_id => l_chr_id);
8955:
8956:
8957: IF l_return_Status = 'S' THEN
8958: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8959: ELSE
8960: RAISE G_EXCEPTION_HALT_VALIDATION;
8961: END IF;
8962:
8963: EXCEPTION
8964:
8965: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8966:
8967: OKC_API.SET_MESSAGE(
8968: p_app_name => g_app_name,
8969: p_msg_name => g_unexpected_error,
8970: p_token1 => g_sqlcode_token,
8971: p_token1_value => sqlcode,
8971: p_token1_value => sqlcode,
8972: p_token2 => g_sqlerrm_token,
8973: p_token2_value => sqlerrm);
8974: -- notify caller of an error as UNEXPETED error
8975: x_return_status := OKC_API.G_RET_STS_ERROR;
8976: x_msg_count :=l_msg_count;
8977:
8978: WHEN OTHERS THEN
8979:
8976: x_msg_count :=l_msg_count;
8977:
8978: WHEN OTHERS THEN
8979:
8980: OKC_API.SET_MESSAGE(
8981: p_app_name => g_app_name,
8982: p_msg_name => g_unexpected_error,
8983: p_token1 => g_sqlcode_token,
8984: p_token1_value => sqlcode,
8984: p_token1_value => sqlcode,
8985: p_token2 => g_sqlerrm_token,
8986: p_token2_value => sqlerrm);
8987:
8988: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8989:
8990: END Restore_Coverage;
8991:
8992:
9004:
9005: l_msg_count NUMBER;
9006: l_msg_data VARCHAR2(1000);
9007: l_api_version NUMBER:= 1 ;
9008: l_init_msg_list VARCHAR2(1):= OKC_API.G_FALSE;
9009: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9010:
9011: BEGIN
9012:
9035: p_chr_id => l_chr_id);
9036:
9037:
9038: IF l_return_Status = 'S' THEN
9039: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9040: ELSE
9041: RAISE G_EXCEPTION_HALT_VALIDATION;
9042: END IF;
9043:
9044: EXCEPTION
9045:
9046: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9047:
9048: OKC_API.SET_MESSAGE(
9049: p_app_name => g_app_name,
9050: p_msg_name => g_unexpected_error,
9051: p_token1 => g_sqlcode_token,
9052: p_token1_value => sqlcode,
9052: p_token1_value => sqlcode,
9053: p_token2 => g_sqlerrm_token,
9054: p_token2_value => sqlerrm);
9055: -- notify caller of an error as UNEXPETED error
9056: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9057: x_msg_count :=l_msg_count;
9058: WHEN OTHERS THEN
9059:
9060: OKC_API.SET_MESSAGE(
9056: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9057: x_msg_count :=l_msg_count;
9058: WHEN OTHERS THEN
9059:
9060: OKC_API.SET_MESSAGE(
9061: p_app_name => g_app_name,
9062: p_msg_name => g_unexpected_error,
9063: p_token1 => g_sqlcode_token,
9064: p_token1_value => sqlcode,
9064: p_token1_value => sqlcode,
9065: p_token2 => g_sqlerrm_token,
9066: p_token2_value => sqlerrm);
9067:
9068: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9069:
9070: END Delete_History;
9071:
9072:
9080: x_msg_data OUT NOCOPY VARCHAR2,
9081: p_chr_id IN NUMBER) IS
9082:
9083: l_api_version NUMBER := 1;
9084: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
9085: l_return_status VARCHAR2(1);
9086: l_return_msg VARCHAR2(2000);
9087: l_msg_count NUMBER;
9088: l_msg_data VARCHAR2(2000);
9091:
9092: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9093: BEGIN
9094:
9095: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
9096: p_init_msg_list,
9097: '_PUB',
9098: x_return_status);
9099:
9096: p_init_msg_list,
9097: '_PUB',
9098: x_return_status);
9099:
9100: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
9101: THEN
9102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9104: THEN
9098: x_return_status);
9099:
9100: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
9101: THEN
9102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9104: THEN
9105: raise OKC_API.G_EXCEPTION_ERROR;
9106: ELSIF l_return_status IS NULL
9099:
9100: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
9101: THEN
9102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9104: THEN
9105: raise OKC_API.G_EXCEPTION_ERROR;
9106: ELSIF l_return_status IS NULL
9107: THEN
9101: THEN
9102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
9104: THEN
9105: raise OKC_API.G_EXCEPTION_ERROR;
9106: ELSIF l_return_status IS NULL
9107: THEN
9108: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9109: END IF;
9104: THEN
9105: raise OKC_API.G_EXCEPTION_ERROR;
9106: ELSIF l_return_status IS NULL
9107: THEN
9108: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9109: END IF;
9110:
9111:
9112: DELETE OKS_ACTION_TIME_TYPES_H
9141: p_chr_id => l_chr_id);
9142:
9143:
9144: IF l_return_Status = 'S' THEN
9145: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9146: ELSE
9147: RAISE G_EXCEPTION_HALT_VALIDATION;
9148: END IF;
9149:
9150: EXCEPTION
9151:
9152: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9153:
9154: OKC_API.SET_MESSAGE(
9155: p_app_name => g_app_name,
9156: p_msg_name => g_unexpected_error,
9157: p_token1 => g_sqlcode_token,
9158: p_token1_value => sqlcode,
9158: p_token1_value => sqlcode,
9159: p_token2 => g_sqlerrm_token,
9160: p_token2_value => sqlerrm);
9161: -- notify caller of an error as UNEXPETED error
9162: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9163: x_msg_count :=l_msg_count;
9164:
9165:
9166:
9163: x_msg_count :=l_msg_count;
9164:
9165:
9166:
9167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
9168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9169: (l_api_name,
9170: G_PKG_NAME,
9171: 'OKC_API.G_RET_STS_ERROR',
9164:
9165:
9166:
9167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
9168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9169: (l_api_name,
9170: G_PKG_NAME,
9171: 'OKC_API.G_RET_STS_ERROR',
9172: x_msg_count,
9167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
9168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9169: (l_api_name,
9170: G_PKG_NAME,
9171: 'OKC_API.G_RET_STS_ERROR',
9172: x_msg_count,
9173: x_msg_data,
9174: '_PUB');
9175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9171: 'OKC_API.G_RET_STS_ERROR',
9172: x_msg_count,
9173: x_msg_data,
9174: '_PUB');
9175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9176: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9177: (l_api_name,
9178: G_PKG_NAME,
9179: 'OKC_API.G_RET_STS_UNEXP_ERROR',
9172: x_msg_count,
9173: x_msg_data,
9174: '_PUB');
9175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9176: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9177: (l_api_name,
9178: G_PKG_NAME,
9179: 'OKC_API.G_RET_STS_UNEXP_ERROR',
9180: x_msg_count,
9175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9176: x_return_status := OKC_API.HANDLE_EXCEPTIONS
9177: (l_api_name,
9178: G_PKG_NAME,
9179: 'OKC_API.G_RET_STS_UNEXP_ERROR',
9180: x_msg_count,
9181: x_msg_data,
9182: '_PUB');
9183: WHEN OTHERS THEN
9180: x_msg_count,
9181: x_msg_data,
9182: '_PUB');
9183: WHEN OTHERS THEN
9184: OKC_API.set_message(p_app_name => g_app_name,
9185: p_msg_name => g_unexpected_error,
9186: p_token1 => g_sqlcode_token,
9187: p_token1_value => sqlcode,
9188: p_token2 => g_sqlerrm_token,
9186: p_token1 => g_sqlcode_token,
9187: p_token1_value => sqlcode,
9188: p_token2 => g_sqlerrm_token,
9189: p_token2_value => sqlerrm);
9190: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9191: ROLLBACK ;
9192: END Delete_Saved_Version;
9193: --===========================================================================
9194:
9193: --===========================================================================
9194:
9195: PROCEDURE COPY_K_HDR_NOTES
9196: (p_api_version IN NUMBER ,
9197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9198: p_chr_id IN NUMBER,
9199: x_return_status OUT NOCOPY VARCHAR2,
9200: x_msg_count OUT NOCOPY NUMBER,
9201: x_msg_data OUT NOCOPY VARCHAR2) IS
9287: END IF;
9288:
9289: END IF;
9290:
9291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9292:
9293: EXCEPTION
9294:
9295: WHEN OTHERS THEN
9293: EXCEPTION
9294:
9295: WHEN OTHERS THEN
9296:
9297: OKC_API.set_message(G_APP_NAME,
9298: G_UNEXPECTED_ERROR,
9299: G_SQLCODE_TOKEN,
9300: SQLCODE,
9301: G_SQLERRM_TOKEN,
9300: SQLCODE,
9301: G_SQLERRM_TOKEN,
9302: SQLERRM);
9303:
9304: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
9305:
9306: END COPY_K_HDR_NOTES;
9307:
9308: PROCEDURE Update_dnz_chr_id
9456: l_dnz_chr_id NUMBER:= -1;
9457: l_oks_line_id NUMBER;
9458: l_cle_id NUMBER;
9459: l_api_version CONSTANT NUMBER := 1.0;
9460: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
9461: l_return_status VARCHAR2(1) := 'S';
9462: l_msg_count Number;
9463: l_msg_data Varchar2(240);
9464: l_validate_yn VARCHAR2(1) := 'N';
10081: Create_K_coverage_ext can be called during the creation of service line from authoring or from renewal
10082: consolidation flow.
10083: */
10084: PROCEDURE Create_K_coverage_ext(p_api_version IN NUMBER,
10085: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10086: p_src_line_id IN NUMBER,
10087: p_tgt_line_id IN NUMBER,
10088: x_return_status OUT NOCOPY VARCHAR2,
10089: x_msg_count OUT NOCOPY NUMBER,
10258: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10259: END IF;
10260:
10261:
10262: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
10263: RAISE G_EXCEPTION_HALT_VALIDATION;
10264: END IF;
10265: END LOOP;
10266: --errorout_ad('before'||l_return_status);
10293: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
10294: END IF;
10295:
10296:
10297: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
10298: RAISE G_EXCEPTION_HALT_VALIDATION;
10299: END IF;
10300: END IF;
10301: x_return_status := l_return_status ;
10308: END IF;
10309: x_return_status := l_return_status ;
10310: x_msg_count :=l_msg_count;
10311: x_msg_data:=l_msg_data;
10312: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10313: (
10314: l_api_name,
10315: 'Create_K_coverage_ext',
10316: 'OKC_API.G_RET_STS_ERROR',
10312: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10313: (
10314: l_api_name,
10315: 'Create_K_coverage_ext',
10316: 'OKC_API.G_RET_STS_ERROR',
10317: x_msg_count,
10318: x_msg_data,
10319: '_PVT'
10320: );
10317: x_msg_count,
10318: x_msg_data,
10319: '_PVT'
10320: );
10321: WHEN OKC_API.G_EXCEPTION_ERROR THEN
10322: IF (G_DEBUG_ENABLED = 'Y') THEN
10323: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10324: okc_debug.Reset_Indentation;
10325: END IF;
10324: okc_debug.Reset_Indentation;
10325: END IF;
10326: x_msg_count :=l_msg_count;
10327: x_msg_data:=l_msg_data;
10328: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10329: (
10330: l_api_name,
10331: 'Create_K_coverage_ext',
10332: 'OKC_API.G_RET_STS_ERROR',
10328: x_return_status := OKC_API.HANDLE_EXCEPTIONS
10329: (
10330: l_api_name,
10331: 'Create_K_coverage_ext',
10332: 'OKC_API.G_RET_STS_ERROR',
10333: x_msg_count,
10334: x_msg_data,
10335: '_PVT'
10336: );
10333: x_msg_count,
10334: x_msg_data,
10335: '_PVT'
10336: );
10337: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10338:
10339: IF (G_DEBUG_ENABLED = 'Y') THEN
10340: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10341: okc_debug.Reset_Indentation;
10341: okc_debug.Reset_Indentation;
10342: END IF;
10343: x_msg_count :=l_msg_count;
10344: x_msg_data:=l_msg_data;
10345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
10346: (
10347: l_api_name,
10348: 'Create_K_coverage_ext',
10349: 'OKC_API.G_RET_STS_UNEXP_ERROR',
10345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
10346: (
10347: l_api_name,
10348: 'Create_K_coverage_ext',
10349: 'OKC_API.G_RET_STS_UNEXP_ERROR',
10350: x_msg_count,
10351: x_msg_data,
10352: '_PVT'
10353: );
10356: IF (G_DEBUG_ENABLED = 'Y') THEN
10357: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10358: okc_debug.Reset_Indentation;
10359: END IF;
10360: OKC_API.SET_MESSAGE(
10361: p_app_name => g_app_name,
10362: p_msg_name => g_unexpected_error,
10363: p_token1 => g_sqlcode_token,
10364: p_token1_value => sqlcode,
10364: p_token1_value => sqlcode,
10365: p_token2 => g_sqlerrm_token,
10366: p_token2_value => sqlerrm);
10367: -- notify caller of an error as UNEXPETED error
10368: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10369: x_msg_count :=l_msg_count;
10370:
10371: END Create_K_coverage_ext;
10372:
10377: P_new_coverage_name -- Name of the Target coverage
10378: x_new_coverage_id -- New Id of the copied coverage */
10379: PROCEDURE COPY_STANDARD_COVERAGE(
10380: p_api_version IN NUMBER,
10381: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10382: x_return_status OUT NOCOPY VARCHAR2,
10383: x_msg_count OUT NOCOPY NUMBER,
10384: x_msg_data OUT NOCOPY VARCHAR2,
10385: P_old_coverage_id IN NUMBER,
10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;
10451: l_cov_flag NUMBER;
10452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
10453:
10454: -- This function is called by copy_standard_coverage for insertion into okc_k_lines_b table
10455: FUNCTION CREATE_OKC_LINE(p_new_line_id NUMBER,
10456: p_old_line_id NUMBER,
10456: p_old_line_id NUMBER,
10457: p_flag NUMBER,
10458: p_cle_id NUMBER DEFAULT NULL) return VARCHAR2 IS
10459:
10460: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10461: l_start_date DATE;
10462: l_coverage_name VARCHAR2(150);
10463:
10464: BEGIN
10708: RETURN x_return_status;
10709:
10710: EXCEPTION
10711: when others then
10712: OKC_API.set_message(G_APP_NAME,
10713: G_UNEXPECTED_ERROR,
10714: G_SQLCODE_TOKEN,
10715: SQLCODE,
10716: G_SQLERRM_TOKEN,
10714: G_SQLCODE_TOKEN,
10715: SQLCODE,
10716: G_SQLERRM_TOKEN,
10717: SQLERRM);
10718: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10719: return x_return_status;
10720:
10721: END CREATE_OKC_LINE;
10722:
10725: FUNCTION CREATE_OKC_ITEM(p_new_item_id NUMBER,
10726: p_old_item_id NUMBER,
10727: p_cle_id NUMBER) return VARCHAR2 IS
10728:
10729: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10730:
10731: BEGIN
10732:
10733: INSERT INTO okc_k_items
10788: RETURN x_return_status;
10789:
10790: EXCEPTION
10791: when others then
10792: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10793: OKC_API.set_message(G_APP_NAME,
10794: G_UNEXPECTED_ERROR,
10795: G_SQLCODE_TOKEN,
10796: SQLCODE,
10789:
10790: EXCEPTION
10791: when others then
10792: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10793: OKC_API.set_message(G_APP_NAME,
10794: G_UNEXPECTED_ERROR,
10795: G_SQLCODE_TOKEN,
10796: SQLCODE,
10797: G_SQLERRM_TOKEN,
10805: FUNCTION CREATE_OKC_PARTY(p_new_party_id NUMBER,
10806: p_old_party_id NUMBER,
10807: p_cle_id NUMBER) return VARCHAR2 IS
10808:
10809: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10810:
10811: BEGIN
10812:
10813: INSERT INTO okc_k_party_roles_b
10935: RETURN x_return_status;
10936:
10937: EXCEPTION
10938: when others then
10939: OKC_API.set_message(G_APP_NAME,
10940: G_UNEXPECTED_ERROR,
10941: G_SQLCODE_TOKEN,
10942: SQLCODE,
10943: G_SQLERRM_TOKEN,
10941: G_SQLCODE_TOKEN,
10942: SQLCODE,
10943: G_SQLERRM_TOKEN,
10944: SQLERRM);
10945: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10946: return x_return_status;
10947: END CREATE_OKC_PARTY;
10948:
10949: -- This function is called by copy_standard_coverage for insertion into okc_contacts table
10950: FUNCTION CREATE_OKC_CONTACT(p_new_cpl_id NUMBER,
10951: p_old_cpl_id NUMBER) return VARCHAR2 IS
10952:
10953:
10954: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10955:
10956: BEGIN
10957:
10958: INSERT INTO okc_contacts
11038: RETURN x_return_status;
11039:
11040: EXCEPTION
11041: WHEN others THEN
11042: OKC_API.set_message(G_APP_NAME,
11043: G_UNEXPECTED_ERROR,
11044: G_SQLCODE_TOKEN,
11045: SQLCODE,
11046: G_SQLERRM_TOKEN,
11044: G_SQLCODE_TOKEN,
11045: SQLCODE,
11046: G_SQLERRM_TOKEN,
11047: SQLERRM);
11048: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
11049: return x_return_status;
11050:
11051: END CREATE_OKC_CONTACT;
11052:
11068: IF (G_DEBUG_ENABLED = 'Y') THEN
11069: okc_debug.log('AFTER CREATE_OKC_LINE FOR COVERAGE'||l_return_status, 2);
11070: END IF;
11071:
11072: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11073: THEN
11074: RAISE G_EXCEPTION_HALT_VALIDATION;
11075: END IF;
11076:
11084: IF (G_DEBUG_ENABLED = 'Y') THEN
11085: okc_debug.log('AFTER CREATE_OKC_LINE FOR BP'||l_return_status, 2);
11086: END IF;
11087:
11088: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11089: THEN
11090: RAISE G_EXCEPTION_HALT_VALIDATION;
11091: END IF;
11092:
11099: IF (G_DEBUG_ENABLED = 'Y') THEN
11100: okc_debug.log('AFTER CREATE_OKC_ITEM'||l_return_status, 2);
11101: END IF;
11102:
11103: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11104: THEN
11105: RAISE G_EXCEPTION_HALT_VALIDATION;
11106: END IF;
11107: -- Done Business Process
11116: IF (G_DEBUG_ENABLED = 'Y') THEN
11117: okc_debug.log('AFTER CREATE_OKC_LINE FOR RT'||l_return_status, 2);
11118: END IF;
11119:
11120: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11121: THEN
11122: RAISE G_EXCEPTION_HALT_VALIDATION;
11123: END IF;
11124: IF tmp_crt_rec.lse_id in (5,59) -- For Billtypes
11132: IF (G_DEBUG_ENABLED = 'Y') THEN
11133: okc_debug.log('AFTER CREATE_OKC_ITEM FOR RT'||l_return_status, 2);
11134: END IF;
11135:
11136: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11137: THEN
11138: RAISE G_EXCEPTION_HALT_VALIDATION;
11139: END IF;
11140: --Create bill rate lines
11149: IF (G_DEBUG_ENABLED = 'Y') THEN
11150: okc_debug.log('AFTER CREATE_OKC_LINE FOR BR'||l_return_status, 2);
11151: END IF;
11152:
11153: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11154: THEN
11155: RAISE G_EXCEPTION_HALT_VALIDATION;
11156: END IF;
11157: END IF;
11171: IF (G_DEBUG_ENABLED = 'Y') THEN
11172: okc_debug.log('AFTER CREATE_OKC_PARTY'||l_return_status, 2);
11173: END IF;
11174:
11175: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11176: THEN
11177: RAISE G_EXCEPTION_HALT_VALIDATION;
11178: END IF;
11179: -- okc_contacts
11181: IF (G_DEBUG_ENABLED = 'Y') THEN
11182: okc_debug.log('AFTER CREATE_OKC_CONTACT'||l_return_status, 2);
11183: END IF;
11184:
11185: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11186: THEN
11187: RAISE G_EXCEPTION_HALT_VALIDATION;
11188: END IF;
11189: END IF;
11195: END LOOP; -- End loop for bp
11196: -- Create oks components
11197: Copy_Coverage
11198: (p_api_version => 1.0,
11199: p_init_msg_list => OKC_API.G_FALSE,
11200: x_return_status => l_return_status,
11201: x_msg_count => x_msg_count,
11202: x_msg_data => x_msg_data,
11203: p_contract_line_id => l_new_coverage_id);
11206: okc_debug.log('AFTER Copy_Coverage'||l_return_status, 2);
11207: END IF;
11208:
11209:
11210: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
11211: Raise G_EXCEPTION_HALT_VALIDATION;
11212: End If;
11213:
11214: x_new_coverage_id := l_new_coverage_id;
11218: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11219: x_return_status := l_return_status ;
11220: ROLLBACK to copy_standard_coverage;
11221: WHEN OTHERS THEN
11222: OKC_API.set_message(G_APP_NAME,
11223: G_UNEXPECTED_ERROR,
11224: G_SQLCODE_TOKEN,
11225: SQLCODE,
11226: G_SQLERRM_TOKEN,
11224: G_SQLCODE_TOKEN,
11225: SQLCODE,
11226: G_SQLERRM_TOKEN,
11227: SQLERRM);
11228: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
11229: ROLLBACK to copy_standard_coverage;
11230:
11231: END COPY_STANDARD_COVERAGE;
11232: END OKS_COVERAGES_PVT;