[Home] [Help]
175: l_clev_tbl_in(i).price_unit_percent :=NULL;
176: l_clev_tbl_in(i).price_negotiated :=NULL;
177: l_clev_tbl_in(i).price_level_ind :='N';
178: l_clev_tbl_in(i).block23text :=NULL;
179: l_clev_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(get_coverages_rec.Coverage_ID)
180: l_clev_tbl_in(i).CREATION_DATE := g_CREATION_DATE;
181: l_clev_tbl_in(i).CREATED_BY := -1;
182: l_clev_tbl_in(i).LAST_UPDATE_DATE := sysdate;
183: l_clev_tbl_in(i).LAST_UPDATED_BY := -1;
258: -- l_clev_tbl_in.delete;
259: -- dbms_output.put_line('----222222222222');
260:
261: -- Rule Group Creation----
262: l_rgpv_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(get_coverages_rec.Coverage_ID);
263: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).id='||TO_CHAR(l_rgpv_tbl_in(i).id));
264: l_rgpv_tbl_in(i).CREATION_DATE := g_CREATION_DATE;
265: l_rgpv_tbl_in(i).CREATED_BY := -1;
266: l_rgpv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
323: --OFS Rule
324: l_rulv_tbl_in(i).rgp_id := l_rgpv_tbl_in(i).id;
325: l_rulv_tbl_in(i).sfwt_flag := 'N';
326: l_rulv_tbl_in(i).rule_information_category := 'OFS';
327: l_rulv_tbl_in(i).rule_information1 := okc_p_util.raw_to_number(sys_guid());
328: l_rulv_tbl_in(i).std_template_yn := 'N';
329: l_rulv_tbl_in(i).warn_yn := 'Y';
330: l_rulv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
331: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(get_coverages_rec.Coverage_ID);
327: l_rulv_tbl_in(i).rule_information1 := okc_p_util.raw_to_number(sys_guid());
328: l_rulv_tbl_in(i).std_template_yn := 'N';
329: l_rulv_tbl_in(i).warn_yn := 'Y';
330: l_rulv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
331: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(get_coverages_rec.Coverage_ID);
332: l_rulv_tbl_in(i).CREATION_DATE := sysdate;
333: l_rulv_tbl_in(i).CREATED_BY := -1;
334: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
335: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;
415: l_isev_ext_tbl_in(i).object_version_number :=1;
416: l_isev_ext_tbl_in(i).sfwt_flag :='N';
417: l_isev_ext_tbl_in(i).spn_id :=Null;
418: l_isev_ext_tbl_in(i).uom_code :=l_timeunits;
419: l_isev_ext_tbl_in(i).tve_id_started :=okc_p_util.raw_to_number(sys_guid());
420: l_isev_ext_tbl_in(i).tve_id_ended :=Null;
421: l_isev_ext_tbl_in(i).tve_id_limited :=Null;
422: l_isev_ext_tbl_in(i).dnz_chr_id :=l_clev_tbl_In(i).dnz_chr_Id;
423: l_isev_ext_tbl_in(i).tze_id :=Null;
464:
465: l_rulv_tbl_in(i).std_template_yn := 'N';
466: l_rulv_tbl_in(i).warn_yn := 'Y';
467: l_rulv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
468: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(get_coverages_rec.Coverage_ID);
469: l_rulv_tbl_in(i).CREATION_DATE := sysdate;
470: l_rulv_tbl_in(i).CREATED_BY := -1;
471: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
472: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;
548: l_rulv_tbl_in(i).rule_information1 := l_transfer_all_flag;
549: l_rulv_tbl_in(i).std_template_yn := 'N';
550: l_rulv_tbl_in(i).warn_yn := 'Y';
551: l_rulv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
552: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(get_coverages_rec.Coverage_ID);
553: l_rulv_tbl_in(i).CREATION_DATE := sysdate;
554: l_rulv_tbl_in(i).CREATED_BY := -1;
555: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
556: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;
628: l_rulv_tbl_in(i).rule_information1 := Get_Cov_Type(get_coverages_rec.COVERAGE_TYPE_CODE);
629: l_rulv_tbl_in(i).std_template_yn := 'N';
630: l_rulv_tbl_in(i).warn_yn := 'Y';
631: l_rulv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
632: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
633: l_rulv_tbl_in(i).CREATION_DATE := sysdate;
634: l_rulv_tbl_in(i).CREATED_BY := -1;
635: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
636: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;
709: l_rulv_tbl_in(i).rule_information1 := get_coverages_rec.EXC_COVERAGE_ID;
710: l_rulv_tbl_in(i).std_template_yn := 'N';
711: l_rulv_tbl_in(i).warn_yn := 'Y';
712: l_rulv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
713: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(get_coverages_rec.Coverage_ID);
714: l_rulv_tbl_in(i).CREATION_DATE := g_CREATION_DATE;
715: l_rulv_tbl_in(i).CREATED_BY := -1;
716: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
717: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;
1157: START_DATE_tbl(i),
1158: l_time_unit,
1159: offset_duration_Tbl(i));
1160:
1161: l_clev_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(g_COVERAGE_TXN_GROUP_ID); --okc_p_util.raw_to_number(sys_guid());
1162: l_clev_tbl_in(i).CREATION_DATE := sysdate;
1163: l_clev_tbl_in(i).CREATED_BY := g_CREATED_BY;
1164: l_clev_tbl_in(i).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
1165: l_clev_tbl_in(i).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
1231: l_cimv_tbl_in(i).uom_code := Null;
1232: l_cimv_tbl_in(i).exception_yn := 'N';
1233: l_cimv_tbl_in(i).number_of_items := 1;
1234: l_cimv_tbl_in(i).dnz_chr_id := dnz_chr_id_tbl(i);
1235: l_cimv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid()); --Get_Seq_Id(g_COVERAGE_TXN_GROUP_ID); --okc_p_util.raw_to_number(sys_guid());
1236: l_cimv_tbl_in(i).CREATION_DATE := g_CREATION_DATE;
1237: l_cimv_tbl_in(i).CREATED_BY := g_CREATED_BY;
1238: l_cimv_tbl_in(i).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
1239: l_cimv_tbl_in(i).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
1254: l_rgpv_tbl_in(i).sfwt_flag := 'N';
1255: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';
1256: l_rgpv_tbl_in(i).rgp_type := 'KRG';
1257: l_rgpv_tbl_in(i).dnz_chr_id := dnz_chr_id_tbl(i);
1258: l_rgpv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
1259: l_rgpv_tbl_in(i).CREATION_DATE := g_CREATION_DATE;
1260: l_rgpv_tbl_in(i).CREATED_BY := g_CREATED_BY;
1261: l_rgpv_tbl_in(i).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
1262: l_rgpv_tbl_in(i).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
1297: ELSE
1298: IF l_Time_Unit is NOT NULL THEN
1299: /*------------------------------------------------------------------------------------------------*/
1300: l_isev_rel_tbl_in(i).dnz_chr_id :=dnz_chr_id_tbl(i);
1301: l_isev_rel_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid());
1302: l_isev_rel_tbl_in(i).object_version_number :=1;
1303: l_isev_rel_tbl_in(i).sfwt_flag :='N';
1304: l_isev_rel_tbl_in(i).spn_id :=Null;
1305: l_isev_rel_tbl_in(i).uom_code :=l_time_unit;
1302: l_isev_rel_tbl_in(i).object_version_number :=1;
1303: l_isev_rel_tbl_in(i).sfwt_flag :='N';
1304: l_isev_rel_tbl_in(i).spn_id :=Null;
1305: l_isev_rel_tbl_in(i).uom_code :=l_time_unit;
1306: l_isev_rel_tbl_in(i).start_tve_id_offset :=okc_p_util.raw_to_number(sys_guid());
1307: l_isev_rel_tbl_in(i).tve_id_ended :=Null;
1308: l_isev_rel_tbl_in(i).tve_id_limited :=Null;
1309: l_isev_rel_tbl_in(i).tze_id :=Null;
1310: l_isev_rel_tbl_in(i).description :=Null;
1350: l_isev_ext_tbl_in(i).end_date := end_date_tbl(i);
1351: -- dbms_output.put_line('Value of l_isev_ext_tbl_in(i).end_date='||TO_CHAR(l_isev_ext_tbl_in(i).end_date));
1352:
1353: l_isev_ext_tbl_in(i).dnz_chr_id :=dnz_chr_id_tbl(i);
1354: -- l_isev_ext_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid());
1355: l_isev_ext_tbl_in(i).id :=l_isev_rel_tbl_in(i).start_tve_id_offset;
1356: l_isev_ext_tbl_in(i).object_version_number :=1;
1357: l_isev_ext_tbl_in(i).sfwt_flag :='N';
1358: l_isev_ext_tbl_in(i).spn_id :=Null;
1396: l_rulv_tbl_in(i).rule_information1 := l_isev_ext_tbl_in(i).id;
1397: l_rulv_tbl_in(i).dnz_chr_id := l_clev_tbl_in(i).dnz_chr_id;
1398: l_rulv_tbl_in(i).std_template_yn := 'N';
1399: l_rulv_tbl_in(i).warn_YN := 'N';
1400: l_rulv_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid()); --okc_p_util.raw_to_number(sys_guid());
1401: l_rulv_tbl_in(i).CREATION_DATE := sysdate;
1402: l_rulv_tbl_in(i).CREATED_BY := -1;
1403: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
1404: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;
1472: l_rulv_tbl_in(i+1000).OBJECT1_ID1 := PRICE_LIST_ID_Tbl(i);
1473: l_rulv_tbl_in(i+1000).OBJECT1_ID2 := '#';
1474: l_rulv_tbl_in(i+1000).JTOT_OBJECT1_code := 'OKX_PRICE';
1475: l_rulv_tbl_in(i+1000).dnz_chr_id := dnz_chr_id_tbl(i);
1476: l_rulv_tbl_in(i+1000).id := okc_p_util.raw_to_number(sys_guid()); --okc_p_util.raw_to_number(sys_guid());
1477: l_rulv_tbl_in(i+1000).CREATION_DATE := sysdate;
1478: l_rulv_tbl_in(i+1000).CREATED_BY := -1;
1479: l_rulv_tbl_in(i+1000).LAST_UPDATE_DATE := sysdate;
1480: l_rulv_tbl_in(i+1000).LAST_UPDATED_BY := -1;
1529: l_rulv_tbl_in(i+3000).rule_information1 := null;
1530: l_rulv_tbl_in(i+3000).std_template_yn := 'N';
1531: l_rulv_tbl_in(i+3000).warn_YN := 'N';
1532: l_rulv_tbl_in(i+3000).dnz_chr_id := dnz_chr_id_tbl(i);
1533: l_rulv_tbl_in(i+3000).id := okc_p_util.raw_to_number(sys_guid());--Get_Seq_Id(g_COVERAGE_TXN_GROUP_ID); --okc_p_util.raw_to_number(sys_guid());
1534: l_rulv_tbl_in(i+3000).CREATION_DATE := g_CREATION_DATE;
1535: l_rulv_tbl_in(i+3000).CREATED_BY := g_CREATED_BY;
1536: l_rulv_tbl_in(i+3000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
1537: l_rulv_tbl_in(i+3000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
1578: l_rulv_tbl_in(i+3000).RULE_INFORMATION14 := NULL;
1579: l_rulv_tbl_in(i+3000).RULE_INFORMATION15 := NULL;
1580:
1581: IF COVERAGE_SUN_START_TIME_tbl(i) IS NOT NULL THEN
1582: l_igsv_ext_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid());
1583: l_igsv_ext_tbl_in(i).start_day_of_week := 'SUN';
1584: l_igsv_ext_tbl_in(i).start_hour := to_char(COVERAGE_SUN_START_TIME_tbl(i),'HH24');
1585: l_igsv_ext_tbl_in(i).start_minute := to_char(COVERAGE_SUN_START_TIME_tbl(i),'MI');
1586: l_igsv_ext_tbl_in(i).start_second := to_char(COVERAGE_SUN_START_TIME_tbl(i),'SS');
1634: End If;
1635:
1636:
1637: IF COVERAGE_MON_START_TIME_tbl(i) IS NOT NULL THEN
1638: l_igsv_ext_tbl_in(i+1000).id :=okc_p_util.raw_to_number(sys_guid());
1639: l_igsv_ext_tbl_in(i+1000).start_day_of_week := 'MON';
1640: l_igsv_ext_tbl_in(i+1000).start_hour := to_char(COVERAGE_MON_START_TIME_tbl(i),'HH24');
1641: l_igsv_ext_tbl_in(i+1000).start_minute := to_char(COVERAGE_MON_START_TIME_tbl(i),'MI');
1642: l_igsv_ext_tbl_in(i+1000).start_second := to_char(COVERAGE_MON_START_TIME_tbl(i),'SS');
1687: l_ctiv_tbl_in(i+1000).object_version_number := 1;
1688: End If;
1689:
1690: IF COVERAGE_TUE_START_TIME_tbl(i) IS NOT NULL THEN
1691: l_igsv_ext_tbl_in(i+2000).id :=okc_p_util.raw_to_number(sys_guid());
1692: l_igsv_ext_tbl_in(i+2000).start_day_of_week := 'TUE';
1693: l_igsv_ext_tbl_in(i+2000).start_hour := to_char(COVERAGE_TUE_START_TIME_tbl(i),'HH24');
1694: l_igsv_ext_tbl_in(i+2000).start_minute := to_char(COVERAGE_TUE_START_TIME_tbl(i),'MI');
1695: l_igsv_ext_tbl_in(i+2000).start_second := to_char(COVERAGE_TUE_START_TIME_tbl(i),'SS');
1740: l_ctiv_tbl_in(i+2000).object_version_number := 1;
1741: End If;
1742:
1743: IF COVERAGE_WED_START_TIME_tbl(i) IS NOT NULL THEN
1744: l_igsv_ext_tbl_in(i+3000).id :=okc_p_util.raw_to_number(sys_guid());
1745: l_igsv_ext_tbl_in(i+3000).start_day_of_week := 'WED';
1746: l_igsv_ext_tbl_in(i+3000).start_hour := to_char(COVERAGE_WED_START_TIME_tbl(i),'HH24');
1747: l_igsv_ext_tbl_in(i+3000).start_minute := to_char(COVERAGE_WED_START_TIME_tbl(i),'MI');
1748: l_igsv_ext_tbl_in(i+3000).start_second := to_char(COVERAGE_WED_START_TIME_tbl(i),'SS');
1794: End If;
1795:
1796: IF COVERAGE_THU_START_TIME_tbl(i) IS NOT NULL THEN
1797: ---- dbms_output.put_line('Test');
1798: l_igsv_ext_tbl_in(i+4000).id :=okc_p_util.raw_to_number(sys_guid());
1799: l_igsv_ext_tbl_in(i+4000).start_day_of_week := 'THU';
1800: l_igsv_ext_tbl_in(i+4000).start_hour := to_char(COVERAGE_THU_START_TIME_tbl(i),'HH24');
1801: l_igsv_ext_tbl_in(i+4000).start_minute := to_char(COVERAGE_THU_START_TIME_tbl(i),'MI');
1802: l_igsv_ext_tbl_in(i+4000).start_second := to_char(COVERAGE_THU_START_TIME_tbl(i),'SS');
1849:
1850: End If;
1851:
1852: IF COVERAGE_FRI_START_TIME_tbl(i) IS NOT NULL THEN
1853: l_igsv_ext_tbl_in(i+5000).id :=okc_p_util.raw_to_number(sys_guid());
1854: l_igsv_ext_tbl_in(i+5000).start_day_of_week := 'FRI';
1855: l_igsv_ext_tbl_in(i+5000).start_hour := to_char(COVERAGE_FRI_START_TIME_tbl(i),'HH24');
1856: l_igsv_ext_tbl_in(i+5000).start_minute := to_char(COVERAGE_FRI_START_TIME_tbl(i),'MI');
1857: l_igsv_ext_tbl_in(i+5000).start_second := to_char(COVERAGE_FRI_START_TIME_tbl(i),'SS');
1901: l_ctiv_tbl_in(i+5000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;
1902: l_ctiv_tbl_in(i+5000).object_version_number := 1;
1903: End If;
1904: IF COVERAGE_SAT_START_TIME_tbl(i) IS NOT NULL THEN
1905: l_igsv_ext_tbl_in(i+6000).id :=okc_p_util.raw_to_number(sys_guid());
1906: l_igsv_ext_tbl_in(i+6000).start_day_of_week := 'SAT';
1907: l_igsv_ext_tbl_in(i+6000).start_hour := to_char(COVERAGE_SAT_START_TIME_tbl(i),'HH24');
1908: l_igsv_ext_tbl_in(i+6000).start_minute := to_char(COVERAGE_SAT_START_TIME_tbl(i),'MI');
1909: l_igsv_ext_tbl_in(i+6000).start_second := to_char(COVERAGE_SAT_START_TIME_tbl(i),'SS');
1954: l_ctiv_tbl_in(i+6000).object_version_number := 1;
1955: End If;
1956:
1957: /* Temparary Changes Made to pass through QA check.
1958: l_cplv_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid());
1959: l_cplv_tbl_in(i).chr_id := NULL;
1960: l_cplv_tbl_in(i).sfwt_flag :='N';
1961: l_cplv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
1962: l_cplv_tbl_in(i).dnz_chr_id := l_clev_tbl_in(i).dnz_chr_Id;
1993: l_cplv_tbl_in(i).ATTRIBUTE13 :=null;
1994: l_cplv_tbl_in(i).ATTRIBUTE14 :=null;
1995: l_cplv_tbl_in(i).ATTRIBUTE15 :=null;
1996:
1997: l_ctcv_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid());
1998: l_ctcv_tbl_in(i).cpl_id := l_cplv_tbl_in(i).id;
1999: l_ctcv_tbl_in(i).cro_code := 'ENGINEER';
2000: l_ctcv_tbl_in(i).dnz_chr_id := l_clev_tbl_in(i).dnz_chr_Id;
2001: l_ctcv_tbl_in(i).contact_sequence := 1;
2028:
2029: */
2030: IF REACTION_TIME_ID_TBL(i) IS NOT NULL THEN
2031: -- -- dbms_output.put_line('Test1');
2032: l_clev_tbl_in(i+1000).id := okc_p_util.raw_to_number(sys_guid());
2033: l_clev_tbl_in(i+1000).CREATION_DATE := g_CREATION_DATE;
2034: l_clev_tbl_in(i+1000).CREATED_BY := g_CREATED_BY;
2035: l_clev_tbl_in(i+1000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
2036: l_clev_tbl_in(i+1000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
2099: l_rgpv_tbl_in(i+1000).sfwt_flag := 'N';
2100: l_rgpv_tbl_in(i+1000).rgd_code := 'SVC_K';
2101: l_rgpv_tbl_in(i+1000).rgp_type := 'KRG';
2102: l_rgpv_tbl_in(i+1000).dnz_chr_id := l_clev_tbl_in(i+1000).dnz_chr_Id;
2103: l_rgpv_tbl_in(i+1000).id := okc_p_util.raw_to_number(sys_guid());
2104: l_rgpv_tbl_in(i+1000).CREATION_DATE := g_CREATION_DATE;
2105: l_rgpv_tbl_in(i+1000).CREATED_BY := g_CREATED_BY;
2106: l_rgpv_tbl_in(i+1000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
2107: l_rgpv_tbl_in(i+1000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
2136:
2137: l_rulv_tbl_in(i+4000).rgp_id := l_rgpv_tbl_in(i+1000).id;
2138: l_rulv_tbl_in(i+4000).sfwt_flag := 'N';
2139: l_rulv_tbl_in(i+4000).rule_information_category := 'RCN';
2140: l_rulv_tbl_in(i+4000).id := okc_p_util.raw_to_number(sys_guid());
2141: l_rulv_tbl_in(i+4000).CREATION_DATE := g_CREATION_DATE;
2142: l_rulv_tbl_in(i+4000).CREATED_BY := g_CREATED_BY;
2143: l_rulv_tbl_in(i+4000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
2144: l_rulv_tbl_in(i+4000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
2194:
2195: l_rulv_tbl_in(i+5000).rgp_id := l_rgpv_tbl_in(i+1000).id;
2196: l_rulv_tbl_in(i+5000).sfwt_flag := 'N';
2197: l_rulv_tbl_in(i+5000).rule_information_category := 'RSN';
2198: l_rulv_tbl_in(i+5000).id := okc_p_util.raw_to_number(sys_guid());
2199: l_rulv_tbl_in(i+5000).CREATION_DATE := g_CREATION_DATE;
2200: l_rulv_tbl_in(i+5000).CREATED_BY := g_CREATED_BY;
2201: l_rulv_tbl_in(i+5000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
2202: l_rulv_tbl_in(i+5000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
2252: END IF; -------Incident_severity_id_Tbl(i)
2253:
2254: IF SUN_REACTION_TIMES_tbl(i) IS NOT NULL
2255: THEN
2256: l_tgdv_ext_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid());
2257: l_tgdv_ext_tbl_in(i).day_of_week := 'SUN';
2258: l_tgdv_ext_tbl_in(i).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2259: l_tgdv_ext_tbl_in(i).CREATION_DATE := g_CREATION_DATE;
2260: l_tgdv_ext_tbl_in(i).CREATED_BY := g_CREATED_BY;
2308: END IF; ---SUN_REACTION_TIMES_tbl
2309:
2310: IF MON_REACTION_TIMES_tbl(i) IS NOT NULL
2311: THEN
2312: l_tgdv_ext_tbl_in(i+1000).id :=okc_p_util.raw_to_number(sys_guid());
2313: l_tgdv_ext_tbl_in(i+1000).day_of_week := 'MON';
2314: l_tgdv_ext_tbl_in(i+1000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2315: l_tgdv_ext_tbl_in(i+1000).CREATION_DATE := g_CREATION_DATE;
2316: l_tgdv_ext_tbl_in(i+1000).CREATED_BY := g_CREATED_BY;
2416: l_rilv_tbl_in(i+2000).object_version_number := 1;
2417: END IF; ---TUE_REACTION_TIMES_tbl
2418: IF WED_REACTION_TIMES_tbl(i) IS NOT NULL
2419: THEN
2420: l_tgdv_ext_tbl_in(i+3000).id :=okc_p_util.raw_to_number(sys_guid());
2421: l_tgdv_ext_tbl_in(i+3000).day_of_week := 'WED';
2422: l_tgdv_ext_tbl_in(i+3000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2423: l_tgdv_ext_tbl_in(i+3000).CREATION_DATE := g_CREATION_DATE;
2424: l_tgdv_ext_tbl_in(i+3000).CREATED_BY := g_CREATED_BY;
2471: END IF; ---WED_REACTION_TIMES_tbl
2472:
2473: IF THU_REACTION_TIMES_tbl(i) IS NOT NULL
2474: THEN
2475: l_tgdv_ext_tbl_in(i+4000).id :=okc_p_util.raw_to_number(sys_guid());
2476: l_tgdv_ext_tbl_in(i+4000).day_of_week := 'THU';
2477: l_tgdv_ext_tbl_in(i+4000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2478: l_tgdv_ext_tbl_in(i+4000).CREATION_DATE := g_CREATION_DATE;
2479: l_tgdv_ext_tbl_in(i+4000).CREATED_BY := g_CREATED_BY;
2526: END IF; ---THU_REACTION_TIMES_tbl
2527:
2528: IF FRI_REACTION_TIMES_tbl(i) IS NOT NULL
2529: THEN
2530: l_tgdv_ext_tbl_in(i+5000).id :=okc_p_util.raw_to_number(sys_guid());
2531: l_tgdv_ext_tbl_in(i+5000).day_of_week := 'FRI';
2532: l_tgdv_ext_tbl_in(i+5000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2533: l_tgdv_ext_tbl_in(i+5000).CREATION_DATE := g_CREATION_DATE;
2534: l_tgdv_ext_tbl_in(i+5000).CREATED_BY := g_CREATED_BY;
2581: END IF; ---FRI_REACTION_TIMES_tbl
2582:
2583: IF SAT_REACTION_TIMES_tbl(i) IS NOT NULL
2584: THEN
2585: l_tgdv_ext_tbl_in(i+6000).id :=okc_p_util.raw_to_number(sys_guid());
2586: l_tgdv_ext_tbl_in(i+6000).day_of_week := 'SAT';
2587: l_tgdv_ext_tbl_in(i+6000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2588: l_tgdv_ext_tbl_in(i+6000).CREATION_DATE := g_CREATION_DATE;
2589: l_tgdv_ext_tbl_in(i+6000).CREATED_BY := g_CREATED_BY;
2635: l_rilv_tbl_in(i+6000).object_version_number := 1;
2636: END IF; ---SAT_REACTION_TIMES_tbl
2637: IF SUN_RESOLUTION_TIMES_tbl(i) IS NOT NULL
2638: THEN
2639: l_tgdv_rcn_tbl_in(i).id :=okc_p_util.raw_to_number(sys_guid());
2640: l_tgdv_rcn_tbl_in(i).day_of_week := 'SUN';
2641: l_tgdv_rcn_tbl_in(i).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2642: l_tgdv_rcn_tbl_in(i).CREATION_DATE := g_CREATION_DATE;
2643: l_tgdv_rcn_tbl_in(i).CREATED_BY := g_CREATED_BY;
2691: END IF; ---SUN_RESOLUTION_TIMES_tbl
2692:
2693: IF MON_RESOLUTION_TIMES_tbl(i) IS NOT NULL
2694: THEN
2695: l_tgdv_rcn_tbl_in(i+1000).id :=okc_p_util.raw_to_number(sys_guid());
2696: l_tgdv_rcn_tbl_in(i+1000).day_of_week := 'MON';
2697: l_tgdv_rcn_tbl_in(i+1000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2698: l_tgdv_rcn_tbl_in(i+1000).CREATION_DATE := g_CREATION_DATE;
2699: l_tgdv_rcn_tbl_in(i+1000).CREATED_BY := g_CREATED_BY;
2799: l_rilt_tbl_in(i+2000).object_version_number := 1;
2800: END IF; ---TUE_RESOLUTION_TIMES_tbl
2801: IF WED_RESOLUTION_TIMES_tbl(i) IS NOT NULL
2802: THEN
2803: l_tgdv_rcn_tbl_in(i+3000).id :=okc_p_util.raw_to_number(sys_guid());
2804: l_tgdv_rcn_tbl_in(i+3000).day_of_week := 'WED';
2805: l_tgdv_rcn_tbl_in(i+3000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2806: l_tgdv_rcn_tbl_in(i+3000).CREATION_DATE := g_CREATION_DATE;
2807: l_tgdv_rcn_tbl_in(i+3000).CREATED_BY := g_CREATED_BY;
2854: END IF; ---WED_RESOLUTION_TIMES_tbl
2855:
2856: IF THU_RESOLUTION_TIMES_tbl(i) IS NOT NULL
2857: THEN
2858: l_tgdv_rcn_tbl_in(i+4000).id :=okc_p_util.raw_to_number(sys_guid());
2859: l_tgdv_rcn_tbl_in(i+4000).day_of_week := 'THU';
2860: l_tgdv_rcn_tbl_in(i+4000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2861: l_tgdv_rcn_tbl_in(i+4000).CREATION_DATE := g_CREATION_DATE;
2862: l_tgdv_rcn_tbl_in(i+4000).CREATED_BY := g_CREATED_BY;
2909: END IF; ---THU_RESOLUTION_TIMES_tbl
2910:
2911: IF FRI_RESOLUTION_TIMES_tbl(i) IS NOT NULL
2912: THEN
2913: l_tgdv_rcn_tbl_in(i+5000).id :=okc_p_util.raw_to_number(sys_guid());
2914: l_tgdv_rcn_tbl_in(i+5000).day_of_week := 'FRI';
2915: l_tgdv_rcn_tbl_in(i+5000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2916: l_tgdv_rcn_tbl_in(i+5000).CREATION_DATE := g_CREATION_DATE;
2917: l_tgdv_rcn_tbl_in(i+5000).CREATED_BY := g_CREATED_BY;
2964: END IF; ---FRI_RESOLUTION_TIMES_tbl
2965:
2966: IF SAT_RESOLUTION_TIMES_tbl(i) IS NOT NULL
2967: THEN
2968: l_tgdv_rcn_tbl_in(i+6000).id :=okc_p_util.raw_to_number(sys_guid());
2969: l_tgdv_rcn_tbl_in(i+6000).day_of_week := 'SAT';
2970: l_tgdv_rcn_tbl_in(i+6000).dnz_chr_id :=l_clev_tbl_in(i).dnz_chr_Id;
2971: l_tgdv_rcn_tbl_in(i+6000).CREATION_DATE := g_CREATION_DATE;
2972: l_tgdv_rcn_tbl_in(i+6000).CREATED_BY := g_CREATED_BY;
3494: IF ( COV_BP_BILLING_TYPE_ID_tbl.COUNT > 0) THEN
3495: FOR i IN COV_BP_BILLING_TYPE_ID_tbl.FIRST .. COV_BP_BILLING_TYPE_ID_tbl.LAST
3496: LOOP
3497: -- dbms_output.put_line('Test44');
3498: l_clev_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
3499: l_clev_tbl_in(i).CREATION_DATE := sysdate;
3500: l_clev_tbl_in(i).CREATED_BY := -1;
3501: l_clev_tbl_in(i).LAST_UPDATE_DATE := sysdate;
3502: l_clev_tbl_in(i).LAST_UPDATED_BY := -1;
3568: l_cimv_tbl_in(i).JTOT_OBJECT1_CODE := 'OKX_BILLTYPE';
3569: l_cimv_tbl_in(i).exception_yn := 'N';
3570: l_cimv_tbl_in(i).number_of_items := 1;
3571: l_cimv_tbl_in(i).dnz_chr_id := dnz_chr_id_tbl(i);
3572: l_cimv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
3573: l_cimv_tbl_in(i).CREATION_DATE := sysdate;
3574: l_cimv_tbl_in(i).CREATED_BY := -1 ;
3575: l_cimv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
3576: l_cimv_tbl_in(i).LAST_UPDATED_BY := -1 ;
3588: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
3589: l_rgpv_tbl_in(i).sfwt_flag := 'N';
3590: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';
3591: l_rgpv_tbl_in(i).rgp_type := 'KRG';
3592: l_rgpv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
3593: l_rgpv_tbl_in(i).CREATION_DATE := sysdate;
3594: l_rgpv_tbl_in(i).CREATED_BY := -1 ;
3595: l_rgpv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
3596: l_rgpv_tbl_in(i).LAST_UPDATED_BY := -1 ;
3629: l_rulv_tbl_in(i).rule_information4 := Percent_cover_Tbl(i);
3630: l_rulv_tbl_in(i).std_template_yn := 'N';
3631: l_rulv_tbl_in(i).warn_yn := 'N';
3632: l_rulv_tbl_in(i).dnz_chr_id :=dnz_chr_id_tbl(i);
3633: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
3634: l_rulv_tbl_in(i).CREATION_DATE := sysdate;
3635: l_rulv_tbl_in(i).CREATED_BY := -1 ;
3636: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
3637: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;
3956: if (COVERAGE_BILL_RATE_ID_tbl.count > 0) then
3957: ---- dbms_output.put_line('Test2');
3958: FOR i IN COVERAGE_BILL_RATE_ID_tbl.FIRST .. COVERAGE_BILL_RATE_ID_tbl.LAST
3959: LOOP
3960: l_clev_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
3961: l_clev_tbl_in(i).CREATION_DATE := sysdate;
3962: l_clev_tbl_in(i).CREATED_BY := -1;
3963: l_clev_tbl_in(i).LAST_UPDATE_DATE := sysdate;
3964: l_clev_tbl_in(i).LAST_UPDATED_BY := -1 ;
4019: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
4020: l_rgpv_tbl_in(i).sfwt_flag := 'N';
4021: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';
4022: l_rgpv_tbl_in(i).rgp_type := 'KRG';
4023: l_rgpv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
4024: l_rgpv_tbl_in(i).CREATION_DATE := sysdate;
4025: l_rgpv_tbl_in(i).CREATED_BY := -1;
4026: l_rgpv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
4027: l_rgpv_tbl_in(i).LAST_UPDATED_BY := -1;
4065: l_rulv_tbl_in(i).rule_information4 := BILL_RATE_CODE_Tbl(i);
4066: l_rulv_tbl_in(i).std_template_yn := 'N';
4067: l_rulv_tbl_in(i).warn_yn := 'N';
4068: l_rulv_tbl_in(i).dnz_chr_id := dnz_chr_id_Tbl(i);
4069: l_rulv_tbl_in(i).id := okc_p_util.raw_to_number(sys_guid());
4070: l_rulv_tbl_in(i).CREATION_DATE :=sysdate;
4071: l_rulv_tbl_in(i).CREATED_BY := -1;
4072: l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;
4073: l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;