eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_COVERAGES_MIGRATION dependencies on DBMS_OUTPUT

Line 164: -- dbms_output.put_line('Value of get_coverages_rec.COVERAGE_ID='||TO_CHAR(get_coverages_rec.COVERAGE_ID));

160: loop
161: fetch get_coverages_cur into get_coverages_rec;
162:
163: exit when get_coverages_cur%notfound;
164: -- dbms_output.put_line('Value of get_coverages_rec.COVERAGE_ID='||TO_CHAR(get_coverages_rec.COVERAGE_ID));
165: open get_okc_lines_cur(get_coverages_rec.COVERAGE_ID) ;
166: loop
167: fetch get_okc_lines_cur into get_okc_lines_rec;
168: exit when get_okc_lines_cur%notfound;

Line 170: -- dbms_output.put_line('1111111111');

166: loop
167: fetch get_okc_lines_cur into get_okc_lines_rec;
168: exit when get_okc_lines_cur%notfound;
169:
170: -- dbms_output.put_line('1111111111');
171: -- dbms_output.put_line('Value of get_okc_lines_rec.dnz_chr_id='||TO_CHAR(get_okc_lines_rec.dnz_chr_id));
172: l_clev_tbl_in(i).cle_id_renewed :=NULL;
173: l_clev_tbl_in(i).comments :=NULL;
174: l_clev_tbl_in(i).price_unit :=NULL;

Line 171: -- dbms_output.put_line('Value of get_okc_lines_rec.dnz_chr_id='||TO_CHAR(get_okc_lines_rec.dnz_chr_id));

167: fetch get_okc_lines_cur into get_okc_lines_rec;
168: exit when get_okc_lines_cur%notfound;
169:
170: -- dbms_output.put_line('1111111111');
171: -- dbms_output.put_line('Value of get_okc_lines_rec.dnz_chr_id='||TO_CHAR(get_okc_lines_rec.dnz_chr_id));
172: l_clev_tbl_in(i).cle_id_renewed :=NULL;
173: l_clev_tbl_in(i).comments :=NULL;
174: l_clev_tbl_in(i).price_unit :=NULL;
175: l_clev_tbl_in(i).price_unit_percent :=NULL;

Line 235: -- dbms_output.put_line('Before Insert');

231:
232: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
233: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
234:
235: -- dbms_output.put_line('Before Insert');
236:
237: If l_validate_flag = 'Y' THEN
238:
239:

Line 251: dbms_output.put_line('Value of l_return_status='||l_return_status);

247: x_msg_data => l_msg_data,
248: p_clev_tbl => l_clev_tbl_in,
249: x_clev_tbl => x_clev_tbl_in);
250:
251: dbms_output.put_line('Value of l_return_status='||l_return_status);
252: End If;
253: ELSE
254: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
255:

Line 259: -- dbms_output.put_line('----222222222222');

255:
256: END IF;
257:
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));

Line 263: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).id='||TO_CHAR(l_rgpv_tbl_in(i).id));

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;
267: l_rgpv_tbl_in(i).LAST_UPDATED_BY := -1;

Line 271: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).cle_id='||TO_CHAR(l_rgpv_tbl_in(i).cle_id));

267: l_rgpv_tbl_in(i).LAST_UPDATED_BY := -1;
268: l_rgpv_tbl_in(i).LAST_UPDATE_LOGIN := -1;
269: l_rgpv_tbl_in(i).object_version_number := 1;
270: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
271: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).cle_id='||TO_CHAR(l_rgpv_tbl_in(i).cle_id));
272: l_rgpv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
273: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).dnz_chr_id='||TO_CHAR(l_rgpv_tbl_in(i).dnz_chr_id));
274: l_rgpv_tbl_in(i).sfwt_flag :='N';
275: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';

Line 273: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).dnz_chr_id='||TO_CHAR(l_rgpv_tbl_in(i).dnz_chr_id));

269: l_rgpv_tbl_in(i).object_version_number := 1;
270: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
271: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).cle_id='||TO_CHAR(l_rgpv_tbl_in(i).cle_id));
272: l_rgpv_tbl_in(i).dnz_chr_id := l_clev_tbl_In(i).dnz_chr_Id;
273: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).dnz_chr_id='||TO_CHAR(l_rgpv_tbl_in(i).dnz_chr_id));
274: l_rgpv_tbl_in(i).sfwt_flag :='N';
275: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';
276: l_rgpv_tbl_in(i).rgp_type := 'KRG';
277: -- dbms_output.put_line('333333333333333');

Line 277: -- dbms_output.put_line('333333333333333');

273: -- dbms_output.put_line('Value of l_rgpv_tbl_in(i).dnz_chr_id='||TO_CHAR(l_rgpv_tbl_in(i).dnz_chr_id));
274: l_rgpv_tbl_in(i).sfwt_flag :='N';
275: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';
276: l_rgpv_tbl_in(i).rgp_type := 'KRG';
277: -- dbms_output.put_line('333333333333333');
278: l_rgpv_tbl_in(i).CHR_ID :=Null;
279: l_rgpv_tbl_in(i).PARENT_RGP_ID :=Null;
280: l_rgpv_tbl_in(i).SAT_CODE :=Null;
281: l_rgpv_tbl_in(i).COMMENTS :=Null;

Line 298: -- dbms_output.put_line('4444444444444');

294: l_rgpv_tbl_in(i).ATTRIBUTE12 :=Null;
295: l_rgpv_tbl_in(i).ATTRIBUTE13 :=Null;
296: l_rgpv_tbl_in(i).ATTRIBUTE14 :=Null;
297: l_rgpv_tbl_in(i).ATTRIBUTE15 :=Null;
298: -- dbms_output.put_line('4444444444444');
299: If l_validate_flag = 'Y' THEN
300:
301:
302: If l_rgpv_tbl_in.count > 0 Then

Line 313: dbms_output.put_line('Value of l_return_status='||l_return_status);

309: x_msg_data => l_msg_data,
310: p_rgpv_tbl => l_rgpv_tbl_in,
311: x_rgpv_tbl => x_rgpv_tbl_in);
312:
313: dbms_output.put_line('Value of l_return_status='||l_return_status);
314: End If;
315: ELSE
316: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
317:

Line 321: -- dbms_output.put_line('---55555555555');

317:
318: END IF;
319:
320:
321: -- dbms_output.put_line('---55555555555');
322: /*Inserting Rule Informations */
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';

Line 397: dbms_output.put_line('Value of l_return_status='||l_return_status);

393: x_msg_data => l_msg_data,
394: p_rulv_tbl => l_rulv_tbl_in,
395: x_rulv_tbl => x_rulv_tbl_in);
396:
397: dbms_output.put_line('Value of l_return_status='||l_return_status);
398: End If;
399: ELSE
400: okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);
401:

Line 413: -- dbms_output.put_line('232323323232');

409: x_duration => l_duration,
410: x_timeunit => l_timeunits,
411: x_return_status => l_return_status
412: );
413: -- dbms_output.put_line('232323323232');
414: l_isev_ext_tbl_in(i).id :=l_rulv_tbl_in(i).rule_information1;
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;

Line 532: dbms_output.put_line('Value of l_return_status='||l_return_status);

528: x_msg_data => l_msg_data,
529: p_rulv_tbl => l_rulv_tbl_in,
530: x_rulv_tbl => x_rulv_tbl_in);
531:
532: dbms_output.put_line('Value of l_return_status='||l_return_status);
533: End If;
534: ELSE
535: okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);
536:

Line 615: dbms_output.put_line('Value of l_return_status='||l_return_status);

611: x_msg_data => l_msg_data,
612: p_rulv_tbl => l_rulv_tbl_in,
613: x_rulv_tbl => x_rulv_tbl_in);
614:
615: dbms_output.put_line('Value of l_return_status='||l_return_status);
616: End If;
617: ELSE
618: okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);
619:

Line 695: dbms_output.put_line('Value of l_return_status='||l_return_status);

691: x_msg_data => l_msg_data,
692: p_rulv_tbl => l_rulv_tbl_in,
693: x_rulv_tbl => x_rulv_tbl_in);
694:
695: dbms_output.put_line('Value of l_return_status='||l_return_status);
696: End If;
697: ELSE
698: okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);
699:

Line 705: -- dbms_output.put_line('6666666666666');

701: l_rulv_tbl_in.delete;
702: END IF; -- End of CVE Rule COVERAGE_TYPE_CODE --
703:
704: IF get_coverages_rec.EXC_COVERAGE_ID IS NOT NULL then
705: -- dbms_output.put_line('6666666666666');
706: l_rulv_tbl_in(i).rgp_id := l_rgpv_tbl_in(i).id;
707: l_rulv_tbl_in(i).sfwt_flag := 'N';
708: l_rulv_tbl_in(i).rule_information_category := 'ECE';
709: l_rulv_tbl_in(i).rule_information1 := get_coverages_rec.EXC_COVERAGE_ID;

Line 774: dbms_output.put_line('Value of l_return_status='||l_return_status);

770: x_msg_data => l_msg_data,
771: p_rulv_tbl => l_rulv_tbl_in,
772: x_rulv_tbl => x_rulv_tbl_in);
773:
774: dbms_output.put_line('Value of l_return_status='||l_return_status);
775: End If;
776: ELSE
777: okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);
778:

Line 786: -- dbms_output.put_line('Before 0 Commit');

782:
783: /*Complete Inserting Rule Informations */
784:
785:
786: -- dbms_output.put_line('Before 0 Commit');
787: commit;
788: l_clev_tbl_in.delete;
789: l_rgpv_tbl_in.delete;
790: -- dbms_output.put_line('After 0 Delete');

Line 790: -- dbms_output.put_line('After 0 Delete');

786: -- dbms_output.put_line('Before 0 Commit');
787: commit;
788: l_clev_tbl_in.delete;
789: l_rgpv_tbl_in.delete;
790: -- dbms_output.put_line('After 0 Delete');
791:
792: end loop;
793: UPDATE oks_coverages_int_all
794: SET INTERFACED_STATUS_FLAG = 'S',

Line 811: -- dbms_output.put_line('Before 1 Commit');

807: if (get_coverages_cur%notfound)
808: then
809: close get_coverages_cur;
810: end if;
811: -- dbms_output.put_line('Before 1 Commit');
812: commit;
813: --end loop; --get_cov_id_cur
814: exception when others then
815: ROLLBACK;

Line 1143: ---- dbms_output.put_line('Test');

1139: LIMIT 1000;
1140:
1141:
1142: IF (COVERAGE_BUSS_PROCESS_ID_tbl.COUNT > 0) then
1143: ---- dbms_output.put_line('Test');
1144: FOR i IN COVERAGE_BUSS_PROCESS_ID_tbl.FIRST .. COVERAGE_BUSS_PROCESS_ID_tbl.LAST
1145: LOOP
1146: g_CREATION_DATE := sysdate;
1147: g_CREATED_BY := -1;

Line 1180: -- dbms_output.put_line('Test3');

1176: l_clev_tbl_in(i).Currency_Code :=Currency_Code_Tbl(i);
1177: l_clev_tbl_in(i).exception_yn :='N'; -- clarify
1178: l_clev_tbl_in(i).start_date :=START_DATE_tbl(i);
1179: l_clev_tbl_in(i).end_date :=END_DATE_tbl(i);
1180: -- dbms_output.put_line('Test3');
1181: l_clev_tbl_in(i).attribute1 :=Attribute1_Tbl(i);
1182: l_clev_tbl_in(i).attribute2 :=Attribute2_Tbl(i);
1183: l_clev_tbl_in(i).attribute3 :=Attribute3_Tbl(i);
1184: l_clev_tbl_in(i).attribute4 :=Attribute4_Tbl(i);

Line 1197: -- -- dbms_output.put_line('Test4');

1193: l_clev_tbl_in(i).attribute13 :=Attribute13_Tbl(i);
1194: l_clev_tbl_in(i).attribute14 :=Attribute14_Tbl(i);
1195: l_clev_tbl_in(i).attribute15 :=Attribute15_Tbl(i);
1196: l_clev_tbl_in(i).attribute_Category := attribute_Category_tbl(i);
1197: -- -- dbms_output.put_line('Test4');
1198: l_clev_tbl_in(i).Upg_Orig_System_Ref :=g_bpline_ref;
1199: l_clev_tbl_in(i).Upg_Orig_System_Ref_Id :=COVERAGE_BUSS_PROCESS_ID_tbl(i);
1200: l_clev_tbl_in(i).INVOICE_LINE_LEVEL_IND :=Null;
1201: l_clev_tbl_in(i).DPAS_RATING :=Null;

Line 1223: -- -- dbms_output.put_line('Test5');

1219: l_clev_tbl_in(i).price_level_ind :='N';
1220: l_clev_tbl_in(i).block23text :=NULL;
1221: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
1222: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
1223: -- -- dbms_output.put_line('Test5');
1224: IF COVERAGE_BUSS_PROCESS_ID_tbl(i) IS NOT NULL
1225: THEN
1226:
1227: l_cimv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;

Line 1287: -- dbms_output.put_line('Before Time Period');

1283: l_rgpv_tbl_in(i).ATTRIBUTE14 :=Null;
1284: l_rgpv_tbl_in(i).ATTRIBUTE15 :=Null;
1285:
1286:
1287: -- dbms_output.put_line('Before Time Period');
1288:
1289:
1290: -------------------OFFSET PERIOD -----
1291:

Line 1293: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);

1289:
1290: -------------------OFFSET PERIOD -----
1291:
1292: l_Time_Unit:=GetTimeUOM(offset_period_Tbl(i));
1293: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);
1294: IF l_Time_Unit IS NULL THEN NULL;
1295: -- RAISE e_Error;
1296: -- dbms_output.put_line('Error');
1297: ELSE

Line 1296: -- dbms_output.put_line('Error');

1292: l_Time_Unit:=GetTimeUOM(offset_period_Tbl(i));
1293: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);
1294: IF l_Time_Unit IS NULL THEN NULL;
1295: -- RAISE e_Error;
1296: -- dbms_output.put_line('Error');
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);

Line 1339: -- dbms_output.put_line('After Time Period');

1335: l_isev_rel_tbl_in(i).LAST_UPDATED_BY := -1;
1336: l_isev_rel_tbl_in(i).LAST_UPDATE_LOGIN := -1;
1337: /*------------------------------------------------------------------------------------------------*/
1338:
1339: -- dbms_output.put_line('After Time Period');
1340: -- dbms_output.put_line('Value of offset_duration_Tbl(i='||offset_duration_Tbl(i));
1341: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);
1342: -- dbms_output.put_line('Value of START_DATE_tbl(i)='||TO_CHAR(START_DATE_tbl(i)));
1343: l_isev_ext_tbl_in(i).start_date:=OKC_TIME_UTIL_PUB.get_enddate(

Line 1340: -- dbms_output.put_line('Value of offset_duration_Tbl(i='||offset_duration_Tbl(i));

1336: l_isev_rel_tbl_in(i).LAST_UPDATE_LOGIN := -1;
1337: /*------------------------------------------------------------------------------------------------*/
1338:
1339: -- dbms_output.put_line('After Time Period');
1340: -- dbms_output.put_line('Value of offset_duration_Tbl(i='||offset_duration_Tbl(i));
1341: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);
1342: -- dbms_output.put_line('Value of START_DATE_tbl(i)='||TO_CHAR(START_DATE_tbl(i)));
1343: l_isev_ext_tbl_in(i).start_date:=OKC_TIME_UTIL_PUB.get_enddate(
1344: START_DATE_tbl(i),

Line 1341: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);

1337: /*------------------------------------------------------------------------------------------------*/
1338:
1339: -- dbms_output.put_line('After Time Period');
1340: -- dbms_output.put_line('Value of offset_duration_Tbl(i='||offset_duration_Tbl(i));
1341: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);
1342: -- dbms_output.put_line('Value of START_DATE_tbl(i)='||TO_CHAR(START_DATE_tbl(i)));
1343: l_isev_ext_tbl_in(i).start_date:=OKC_TIME_UTIL_PUB.get_enddate(
1344: START_DATE_tbl(i),
1345: l_time_unit,

Line 1342: -- dbms_output.put_line('Value of START_DATE_tbl(i)='||TO_CHAR(START_DATE_tbl(i)));

1338:
1339: -- dbms_output.put_line('After Time Period');
1340: -- dbms_output.put_line('Value of offset_duration_Tbl(i='||offset_duration_Tbl(i));
1341: -- dbms_output.put_line('Value of l_time_unit='||l_time_unit);
1342: -- dbms_output.put_line('Value of START_DATE_tbl(i)='||TO_CHAR(START_DATE_tbl(i)));
1343: l_isev_ext_tbl_in(i).start_date:=OKC_TIME_UTIL_PUB.get_enddate(
1344: START_DATE_tbl(i),
1345: l_time_unit,
1346: offset_duration_Tbl(i)

Line 1348: -- dbms_output.put_line('Value of l_isev_ext_tbl_in(i).start_date='||TO_CHAR(l_isev_ext_tbl_in(i).start_date));

1344: START_DATE_tbl(i),
1345: l_time_unit,
1346: offset_duration_Tbl(i)
1347: );
1348: -- dbms_output.put_line('Value of l_isev_ext_tbl_in(i).start_date='||TO_CHAR(l_isev_ext_tbl_in(i).start_date));
1349:
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:

Line 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));

1347: );
1348: -- dbms_output.put_line('Value of l_isev_ext_tbl_in(i).start_date='||TO_CHAR(l_isev_ext_tbl_in(i).start_date));
1349:
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;

Line 1391: -- dbms_output.put_line('Value of l_isev_ext_tbl_in(i).uom_code='||l_isev_ext_tbl_in(i).uom_code);

1387: l_isev_ext_tbl_in(i).LAST_UPDATE_DATE := sysdate;
1388: l_isev_ext_tbl_in(i).LAST_UPDATED_BY := -1;
1389: l_isev_ext_tbl_in(i).LAST_UPDATE_LOGIN := -1;
1390:
1391: -- dbms_output.put_line('Value of l_isev_ext_tbl_in(i).uom_code='||l_isev_ext_tbl_in(i).uom_code);
1392:
1393: l_rulv_tbl_in(i).rgp_id := l_rgpv_tbl_in(i).id;
1394: l_rulv_tbl_in(i).sfwt_flag := 'N';
1395: l_rulv_tbl_in(i).rule_information_category := 'OFS';

Line 1453: -- -- dbms_output.put_line('Value of l_isev_rel_tbl_in(i+1000.end_date='||TO_CHAR(l_isev_rel_tbl_in(i+1000.end_date));

1449:
1450:
1451: /*----------------------------------------------------------------------
1452:
1453: -- -- dbms_output.put_line('Value of l_isev_rel_tbl_in(i+1000.end_date='||TO_CHAR(l_isev_rel_tbl_in(i+1000.end_date));
1454:
1455:
1456:
1457: -------------------------------------------------------------------------*/

Line 1797: ---- dbms_output.put_line('Test');

1793: l_ctiv_tbl_in(i+3000).object_version_number := 1;
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');

Line 1816: -- -- dbms_output.put_line('Test1');

1812: l_igsv_ext_tbl_in(i+4000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;
1813: l_igsv_ext_tbl_in(i+4000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;
1814: l_igsv_ext_tbl_in(i+4000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;
1815: l_igsv_ext_tbl_in(i+4000).Object_version_Number :=1;
1816: -- -- dbms_output.put_line('Test1');
1817: l_igsv_ext_tbl_in(i+4000).sfwt_flag :='N';
1818: l_igsv_ext_tbl_in(i+4000).tve_id_ended :=Null;
1819: l_igsv_ext_tbl_in(i+4000).tve_id_limited :=Null;
1820: l_igsv_ext_tbl_in(i+4000).description :=Null;

Line 2031: -- -- dbms_output.put_line('Test1');

2027: l_ctcv_tbl_in(i).ATTRIBUTE15 :=null;
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;

Line 2044: -- -- dbms_output.put_line('Test2');

2040: l_clev_tbl_in(i+1000).dnz_chr_id := l_clev_tbl_in(i).dnz_chr_Id;
2041: l_clev_tbl_in(i+1000).sfwt_flag :='N';
2042: l_clev_tbl_in(i+1000).lse_id :=4;
2043: l_clev_tbl_in(i+1000).line_number :=1;
2044: -- -- dbms_output.put_line('Test2');
2045: -- l_clev_tbl_in(i+1000).sts_code :='ENTERED'; --Get_New_Status(Contract_Line_Status_Id_Tbl(i));
2046: l_clev_tbl_in(i+1000).sts_code :=sts_code_tbl(i);
2047: l_clev_tbl_in(i+1000).display_sequence :=1;
2048: l_clev_tbl_in(i+1000).item_description :=reaction_Description_Tbl(i);

Line 2054: -- -- dbms_output.put_line('Test3');

2050: l_clev_tbl_in(i+1000).exception_yn :='N'; -- clarify
2051: l_clev_tbl_in(i+1000).Currency_Code :=Currency_Code_Tbl(i);
2052: l_clev_tbl_in(i+1000).start_date :=start_date_tbl(i);
2053: l_clev_tbl_in(i+1000).end_date :=end_date_tbl(i);
2054: -- -- dbms_output.put_line('Test3');
2055: l_clev_tbl_in(i+1000).attribute1 :=Attribute1_Tbl(i);
2056: l_clev_tbl_in(i+1000).attribute2 :=Attribute2_Tbl(i);
2057: l_clev_tbl_in(i+1000).attribute3 :=Attribute3_Tbl(i);
2058: l_clev_tbl_in(i+1000).attribute4 :=Attribute4_Tbl(i);

Line 2070: -- -- dbms_output.put_line('Test4');

2066: l_clev_tbl_in(i+1000).attribute12 :=Attribute12_Tbl(i);
2067: l_clev_tbl_in(i+1000).attribute13 :=Attribute13_Tbl(i);
2068: l_clev_tbl_in(i+1000).attribute14 :=Attribute14_Tbl(i);
2069: l_clev_tbl_in(i+1000).attribute15 :=Attribute15_Tbl(i);
2070: -- -- dbms_output.put_line('Test4');
2071: l_clev_tbl_in(i+1000).attribute_Category :=attribute_Category_Tbl(i);
2072: l_clev_tbl_in(i+1000).Upg_Orig_System_Ref :='oks_cov_txn_groups_int_all REACTION_TIMES';
2073: l_clev_tbl_in(i+1000).Upg_Orig_System_Ref_Id :=Reaction_Time_ID_Tbl(i);
2074: l_clev_tbl_in(i+1000).INVOICE_LINE_LEVEL_IND :=Null;

Line 2095: -- -- dbms_output.put_line('Test5');

2091: l_clev_tbl_in(i+1000).price_level_ind :='N';
2092: l_clev_tbl_in(i+1000).block23text :=NULL;
2093: l_clev_tbl_in(i+1000).program_application_id:= fnd_global.prog_appl_id;
2094: l_clev_tbl_in(i+1000).program_id:= fnd_global.CONC_PROGRAM_ID;
2095: -- -- dbms_output.put_line('Test5');
2096:
2097:
2098: l_rgpv_tbl_in(i+1000).cle_id := l_clev_tbl_in(i+1000).id;
2099: l_rgpv_tbl_in(i+1000).sfwt_flag := 'N';

Line 3022: -- -- dbms_output.put_line('Test6');

3018: l_rilt_tbl_in(i+6000).object_version_number := 1;
3019: END IF; ---SAT_RESOLUTION_TIMES_tbl
3020:
3021: END LOOP;
3022: -- -- dbms_output.put_line('Test6');
3023: END IF;
3024: IF L_validate_flag = 'Y' THEN
3025:
3026:

Line 3040: dbms_output.put_line('Value of l_return_status='||l_return_status);

3036: x_msg_data => l_msg_data,
3037: p_clev_tbl => l_clev_tbl_in,
3038: x_clev_tbl => x_clev_tbl_in);
3039:
3040: dbms_output.put_line('Value of l_return_status='||l_return_status);
3041: End If;
3042:
3043: l_Clev_tbl_in.DELETE;
3044:

Line 3056: dbms_output.put_line('Value of l_return_status='||l_return_status);

3052: x_msg_count => l_msg_count,
3053: x_msg_data => l_msg_data,
3054: p_cimv_tbl => l_cimv_tbl_in,
3055: x_cimv_tbl => x_cimv_tbl_in);
3056: dbms_output.put_line('Value of l_return_status='||l_return_status);
3057: END IF;
3058: l_Cimv_tbl_in.DELETE;
3059:
3060:

Line 3073: dbms_output.put_line('Value of l_return_status='||l_return_status);

3069: x_msg_data => l_msg_data,
3070: p_rgpv_tbl => l_rgpv_tbl_in,
3071: x_rgpv_tbl => x_rgpv_tbl_in);
3072:
3073: dbms_output.put_line('Value of l_return_status='||l_return_status);
3074: END IF;
3075: l_rgpv_tbl_in.DELETE;
3076:
3077:

Line 3090: dbms_output.put_line('Value of l_return_status='||l_return_status);

3086: x_msg_data => l_msg_data,
3087: p_rulv_tbl => l_rulv_tbl_in,
3088: x_rulv_tbl => x_rulv_tbl_in);
3089:
3090: dbms_output.put_line('Value of l_return_status='||l_return_status);
3091: END IF;
3092: l_rulv_tbl_in.delete;
3093:
3094: IF l_Cplv_tbl_In.COUNT>0

Line 3106: dbms_output.put_line('Value of l_return_status='||l_return_status);

3102: x_msg_data => l_msg_data,
3103: p_cplv_tbl => l_cplv_tbl_in,
3104: x_cplv_tbl => x_cplv_tbl_in);
3105:
3106: dbms_output.put_line('Value of l_return_status='||l_return_status);
3107: END IF;
3108: l_Cplv_Tbl_In.DELETE;
3109:
3110: IF l_ctcv_tbl_In.COUNT>0

Line 3122: dbms_output.put_line('Value of l_return_status='||l_return_status);

3118: x_msg_data => l_msg_data,
3119: p_ctcv_tbl => l_ctcv_tbl_in,
3120: x_ctcv_tbl => x_ctcv_tbl_in);
3121:
3122: dbms_output.put_line('Value of l_return_status='||l_return_status);
3123: END IF;
3124: l_ctcv_Tbl_In.DELETE;
3125:
3126: /*----------------------------------------*/

Line 3163: dbms_output.put_line('Value of l_return_status='||l_return_status);

3159: x_msg_data => l_msg_data,
3160: p_ctiv_tbl => l_ctiv_tbl_in,
3161: x_ctiv_tbl => x_ctiv_tbl_in);
3162:
3163: dbms_output.put_line('Value of l_return_status='||l_return_status);
3164:
3165: END IF;
3166: l_ctiv_Tbl_In.DELETE;
3167: IF l_tgdv_ext_tbl_in.COUNT>0

Line 3187: dbms_output.put_line('Value of l_return_status='||l_return_status);

3183: x_msg_data => l_msg_data,
3184: p_rilv_tbl => l_rilv_tbl_in,
3185: x_rilv_tbl => x_rilv_tbl_in);
3186:
3187: dbms_output.put_line('Value of l_return_status='||l_return_status);
3188: END IF;
3189: l_rilv_tbl_in.DELETE;
3190:
3191: IF l_tgdv_rcn_tbl_in.COUNT>0

Line 3211: dbms_output.put_line('Value of l_return_status='||l_return_status);

3207: x_msg_data => l_msg_data,
3208: p_rilv_tbl => l_rilt_tbl_in,
3209: x_rilv_tbl => x_rilt_tbl_in);
3210:
3211: dbms_output.put_line('Value of l_return_status='||l_return_status);
3212: END IF;
3213: l_rilt_tbl_in.DELETE;
3214:
3215:

Line 3226: -- dbms_output.put_line('In Sert');

3222:
3223: IF l_Clev_tbl_in.COUNT>0
3224: THEN
3225: l_error_message := 'okc_cle_pvt -';
3226: -- dbms_output.put_line('In Sert');
3227: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
3228: END IF;
3229: l_Clev_tbl_in.DELETE;
3230:

Line 3350: -- dbms_output.put_line('Outer Block'||sqlerrm);

3346: END IF;
3347: exception when others then
3348: ROLLBACK;
3349: RAISE_APPLICATION_ERROR(-20000,'Error in Business Process Interface');
3350: -- dbms_output.put_line('Outer Block'||sqlerrm);
3351:
3352: END; ---Business_Processes_migrate
3353:
3354: PROCEDURE Bill_Types_Migrate (P_FromId IN NUMBER,

Line 3454: ---- dbms_output.put_line('Test');

3450: Return(l_status_tab(p_k_status_id).new_status);
3451: END Get_new_status;
3452:
3453: Begin -- Main Begin of Bill Types --
3454: ---- dbms_output.put_line('Test');
3455: open get_bill_types (p_FromId,p_ToID);
3456: loop
3457: BEGIN
3458: fetch get_bill_types bulk collect into

Line 3488: -- dbms_output.put_line('Value of COV_BP_BILLING_TYPE_ID_tbl.COUNT='||TO_CHAR(COV_BP_BILLING_TYPE_ID_tbl.COUNT));

3484: end_date_tbl,
3485: currency_code_tbl
3486: LIMIT 1000;
3487:
3488: -- dbms_output.put_line('Value of COV_BP_BILLING_TYPE_ID_tbl.COUNT='||TO_CHAR(COV_BP_BILLING_TYPE_ID_tbl.COUNT));
3489: /*
3490: if (get_bill_types%notfound) then
3491: close get_bill_types;
3492: end if;

Line 3497: -- dbms_output.put_line('Test44');

3493: */
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;

Line 3513: -- dbms_output.put_line('Test55');

3509: l_clev_tbl_in(i).lse_id := 5;
3510: l_clev_tbl_in(i).sts_code :=sts_code_tbl(i);
3511: -- l_clev_tbl_in(i).orig_system_id1 := NULL;
3512: l_clev_tbl_in(i).display_sequence :=1;
3513: -- dbms_output.put_line('Test55');
3514: l_clev_tbl_in(i).Name :='Upgraded'; --Name;
3515: l_clev_tbl_in(i).exception_yn :='N'; -- clarify
3516: l_clev_tbl_in(i).Currency_Code :=Currency_Code_Tbl(i);
3517: l_clev_tbl_in(i).start_date :=start_date_tbl(i);

Line 3536: -- dbms_output.put_line('Test66');

3532: l_clev_tbl_in(i).attribute14 :=Attribute14_Tbl(i);
3533: l_clev_tbl_in(i).attribute15 :=Attribute15_Tbl(i);
3534: l_clev_tbl_in(i).attribute_Category :=ATTRIBUTE_CATEGORY_tbl(i);
3535: l_clev_tbl_in(i).Upg_Orig_System_Ref :=g_btline_ref ;
3536: -- dbms_output.put_line('Test66');
3537: l_clev_tbl_in(i).Upg_Orig_System_Ref_Id :=COV_BP_BILLING_TYPE_ID_tbl(i);
3538: l_clev_tbl_in(i).INVOICE_LINE_LEVEL_IND :=Null;
3539: l_clev_tbl_in(i).DPAS_RATING :=Null;
3540: l_clev_tbl_in(i).TEMPLATE_USED :=Null;

Line 3551: -- dbms_output.put_line('Test77');

3547: l_clev_tbl_in(i).DATE_TERMINATED :=Null;
3548: l_clev_tbl_in(i).CLE_ID_RENEWED_TO :=Null;
3549: l_clev_tbl_in(i).CURRENCY_CODE_RENEWED :=Null;
3550: l_clev_tbl_in(i).PRICE_NEGOTIATED_RENEWED :=Null;
3551: -- dbms_output.put_line('Test77');
3552: l_clev_tbl_in(i).cle_id_renewed :=NULL;
3553: l_clev_tbl_in(i).comments :=NULL;
3554: l_clev_tbl_in(i).price_unit :=NULL;
3555: l_clev_tbl_in(i).price_unit_percent :=NULL;

Line 3561: -- -- dbms_output.put_line('Test');

3557: l_clev_tbl_in(i).price_level_ind :='N';
3558: l_clev_tbl_in(i).block23text :=NULL;
3559: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
3560: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
3561: -- -- dbms_output.put_line('Test');
3562:
3563: l_cimv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
3564: l_cimv_tbl_in(i).chr_id := null;
3565: l_cimv_tbl_in(i).cle_id_for := Null;

Line 3770: -- dbms_output.put_line('Before Commit');

3766: l_Cimv_tbl_in.DELETE;
3767: l_rgpv_tbl_in.DELETE;
3768: l_rulv_tbl_in.DELETE;
3769: l_Clev_tbl_in.DELETE;
3770: -- dbms_output.put_line('Before Commit');
3771:
3772: FORALL i in 1 .. COV_BP_BILLING_TYPE_ID_tbl.COUNT
3773:
3774: UPDATE oks_cov_bill_types_int_all

Line 3916: ---- dbms_output.put_line('Test');

3912: END IF;
3913: RETURN l_TimeUnit;
3914: END GetTimeUom;
3915: begin
3916: ---- dbms_output.put_line('Test');
3917:
3918: open get_bill_rates_cur (p_fromid,p_toid);
3919: loop
3920: begin

Line 3957: ---- dbms_output.put_line('Test2');

3953: close get_bill_rates_cur;
3954: end if;
3955: */
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;