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.ECE_MVSTO_TRANSACTION dependencies on DBMS_SQL

Line 575: Header_sel_c := DBMS_SQL.OPEN_CURSOR;

571: -- *** for the data returned by the SQL statement
572: -- ***************************************************
573:
574: xProgress := 'MVSTOB-20-1200';
575: Header_sel_c := DBMS_SQL.OPEN_CURSOR;
576:
577: xProgress := 'MVSTOB-20-1210';
578: Line_sel_c := DBMS_SQL.OPEN_CURSOR;
579:

Line 578: Line_sel_c := DBMS_SQL.OPEN_CURSOR;

574: xProgress := 'MVSTOB-20-1200';
575: Header_sel_c := DBMS_SQL.OPEN_CURSOR;
576:
577: xProgress := 'MVSTOB-20-1210';
578: Line_sel_c := DBMS_SQL.OPEN_CURSOR;
579:
580: xProgress := 'MVSTOB-20-1220';
581: Location_sel_c := DBMS_SQL.OPEN_CURSOR;
582: -- ***************************************************

Line 581: Location_sel_c := DBMS_SQL.OPEN_CURSOR;

577: xProgress := 'MVSTOB-20-1210';
578: Line_sel_c := DBMS_SQL.OPEN_CURSOR;
579:
580: xProgress := 'MVSTOB-20-1220';
581: Location_sel_c := DBMS_SQL.OPEN_CURSOR;
582: -- ***************************************************
583: -- Parse each of the SELECT statement
584: -- so the database understands the command
585:

Line 589: DBMS_SQL.PARSE(Header_sel_c,

585:
586: -- ***************************************************
587: xProgress := 'MVSTOB-20-1230';
588: BEGIN
589: DBMS_SQL.PARSE(Header_sel_c,
590: cHeader_select,
591: DBMS_SQL.NATIVE);
592: EXCEPTION
593: WHEN OTHERS THEN

Line 591: DBMS_SQL.NATIVE);

587: xProgress := 'MVSTOB-20-1230';
588: BEGIN
589: DBMS_SQL.PARSE(Header_sel_c,
590: cHeader_select,
591: DBMS_SQL.NATIVE);
592: EXCEPTION
593: WHEN OTHERS THEN
594: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,
595: cHeader_select);

Line 594: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,

590: cHeader_select,
591: DBMS_SQL.NATIVE);
592: EXCEPTION
593: WHEN OTHERS THEN
594: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,
595: cHeader_select);
596: app_exception.raise_exception;
597: END;
598:

Line 601: DBMS_SQL.PARSE(Line_sel_c,

597: END;
598:
599: xProgress := 'MVSTOB-20-1240';
600: BEGIN
601: DBMS_SQL.PARSE(Line_sel_c,
602: cLine_select,
603: DBMS_SQL.NATIVE);
604: EXCEPTION
605: WHEN OTHERS THEN

Line 603: DBMS_SQL.NATIVE);

599: xProgress := 'MVSTOB-20-1240';
600: BEGIN
601: DBMS_SQL.PARSE(Line_sel_c,
602: cLine_select,
603: DBMS_SQL.NATIVE);
604: EXCEPTION
605: WHEN OTHERS THEN
606: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,
607: cLine_select);

Line 606: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,

602: cLine_select,
603: DBMS_SQL.NATIVE);
604: EXCEPTION
605: WHEN OTHERS THEN
606: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,
607: cLine_select);
608: app_exception.raise_exception;
609: END;
610:

Line 613: DBMS_SQL.PARSE(Location_sel_c,

609: END;
610:
611: xProgress := 'MVSTOB-20-1250';
612: BEGIN
613: DBMS_SQL.PARSE(Location_sel_c,
614: cLocation_select,
615: DBMS_SQL.NATIVE);
616: EXCEPTION
617: WHEN OTHERS THEN

Line 615: DBMS_SQL.NATIVE);

611: xProgress := 'MVSTOB-20-1250';
612: BEGIN
613: DBMS_SQL.PARSE(Location_sel_c,
614: cLocation_select,
615: DBMS_SQL.NATIVE);
616: EXCEPTION
617: WHEN OTHERS THEN
618: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,
619: cLocation_select);

Line 618: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,

614: cLocation_select,
615: DBMS_SQL.NATIVE);
616: EXCEPTION
617: WHEN OTHERS THEN
618: ECE_ERROR_HANDLING_PVT.print_parse_error(dbms_sql.last_error_position,
619: cLocation_select);
620: app_exception.raise_exception;
621: END;
622:

Line 683: DBMS_SQL.BIND_VARIABLE(Header_sel_c,

679:
680: -- Bind the Variables
681: xProgress := 'MVSTOB-20-1320';
682: IF cLegal_Entity IS NOT NULL THEN
683: DBMS_SQL.BIND_VARIABLE(Header_sel_c,
684: 'l_cLegal_Entity',
685: cLegal_Entity);
686: END IF;
687:

Line 690: DBMS_SQL.BIND_VARIABLE(Header_sel_c,

686: END IF;
687:
688: xProgress := 'MVSTOB-20-1321';
689: IF cZone_Code IS NOT NULL THEN
690: DBMS_SQL.BIND_VARIABLE(Header_sel_c,
691: 'l_cZone_Code',
692: cZone_Code);
693: END IF;
694:

Line 697: DBMS_SQL.BIND_VARIABLE(Header_sel_c,

693: END IF;
694:
695: xProgress := 'MVSTOB-20-1322';
696: IF cStat_Type IS NOT NULL THEN
697: DBMS_SQL.BIND_VARIABLE(Header_sel_c,
698: 'l_cStat_Type',
699: cStat_Type);
700: END IF;
701:

Line 704: DBMS_SQL.BIND_VARIABLE(Header_sel_c,

700: END IF;
701:
702: xProgress := 'MVSTOB-20-1323';
703: IF cPeriod_Name IS NOT NULL THEN
704: DBMS_SQL.BIND_VARIABLE(Header_sel_c,
705: 'l_cPeriod_Name',
706: cPeriod_Name);
707: END IF;
708:

Line 711: DBMS_SQL.BIND_VARIABLE(Header_sel_c,

707: END IF;
708:
709: xProgress := 'MVSTOB-20-1324';
710: IF cMovement_Type IS NOT NULL THEN
711: DBMS_SQL.BIND_VARIABLE(Header_sel_c,
712: 'l_cMovement_Type',
713: cMovement_Type);
714: END IF;
715:

Line 718: DBMS_SQL.BIND_VARIABLE(Line_sel_c,

714: END IF;
715:
716: xProgress := 'MVSTOB-20-1325';
717: IF cLegal_Entity IS NOT NULL THEN
718: DBMS_SQL.BIND_VARIABLE(Line_sel_c,
719: 'l_cLegal_Entity',
720: cLegal_Entity);
721: END IF;
722:

Line 725: DBMS_SQL.BIND_VARIABLE(Line_sel_c,

721: END IF;
722:
723: xProgress := 'MVSTOB-20-1326';
724: IF cZone_Code IS NOT NULL THEN
725: DBMS_SQL.BIND_VARIABLE(Line_sel_c,
726: 'l_cZone_Code',
727: cZone_Code);
728: END IF;
729:

Line 732: DBMS_SQL.BIND_VARIABLE(Line_sel_c,

728: END IF;
729:
730: xProgress := 'MVSTOB-20-1327';
731: IF cStat_Type IS NOT NULL THEN
732: DBMS_SQL.BIND_VARIABLE(Line_sel_c,
733: 'l_cStat_Type',
734: cStat_Type);
735: END IF;
736:

Line 739: DBMS_SQL.BIND_VARIABLE(Line_sel_c,

735: END IF;
736:
737: xProgress := 'MVSTOB-20-1328';
738: IF cPeriod_Name IS NOT NULL THEN
739: DBMS_SQL.BIND_VARIABLE(Line_sel_c,
740: 'l_cPeriod_Name',
741: cPeriod_Name);
742: END IF;
743:

Line 746: DBMS_SQL.BIND_VARIABLE(Line_sel_c,

742: END IF;
743:
744: xProgress := 'MVSTOB-20-1329';
745: IF cMovement_Type IS NOT NULL THEN
746: DBMS_SQL.BIND_VARIABLE(Line_sel_c,
747: 'l_cMovement_Type',
748: cMovement_Type);
749: END IF;
750:

Line 754: dummy := DBMS_SQL.EXECUTE(Header_sel_c);

750:
751: -- EXECUTE the SELECT statement
752:
753: xProgress := 'MVSTOB-20-1400';
754: dummy := DBMS_SQL.EXECUTE(Header_sel_c);
755:
756: -- ***************************************************
757: -- The model is:
758: -- HEADER - LINE - LOCATION...

Line 766: WHILE DBMS_SQL.FETCH_ROWS(Header_sel_c) > 0

762: -- to the line.
763: -- ***************************************************
764:
765: xProgress := 'MVSTOB-20-1410';
766: WHILE DBMS_SQL.FETCH_ROWS(Header_sel_c) > 0
767: LOOP -- Header
768:
769: -- **************************************
770: -- store internal values in pl/sql table

Line 841: dummy := DBMS_SQL.EXECUTE(Line_sel_c);

837: ece_mvsto_x.populate_ext_header (l_header_fkey,
838: l_header_tbl);
839:
840: xProgress := 'MVSTOB-20-1530';
841: dummy := DBMS_SQL.EXECUTE(Line_sel_c);
842:
843: -- *********************
844: -- line loop starts here
845: -- *********************

Line 848: WHILE DBMS_SQL.FETCH_ROWS(Line_sel_c) > 0

844: -- line loop starts here
845: -- *********************
846:
847: xProgress := 'MVSTOB-20-1540';
848: WHILE DBMS_SQL.FETCH_ROWS(Line_sel_c) > 0
849: LOOP --- Line
850:
851: -- ****************************
852: -- store values in pl/sql table

Line 957: DBMS_SQL.BIND_VARIABLE(Location_sel_c,

953: -- set LINE_NUMBER values
954: -- **********************
955:
956: xProgress := 'MVSTOB-20-1630';
957: DBMS_SQL.BIND_VARIABLE(Location_sel_c,
958: 'bill_to_site_use_id',
959: l_line_tbl(nBill_To_Site_pos).value);
960:
961:

Line 963: DBMS_SQL.BIND_VARIABLE(Location_sel_c,

959: l_line_tbl(nBill_To_Site_pos).value);
960:
961:
962: xProgress := 'MVSTOB-20-1635';
963: DBMS_SQL.BIND_VARIABLE(Location_sel_c,
964: 'ship_to_site_use_id',
965: l_line_tbl(nShip_To_Site_pos).value);
966:
967: xProgress := 'MVSTOB-20-1645';

Line 968: DBMS_SQL.BIND_VARIABLE(Location_sel_c,

964: 'ship_to_site_use_id',
965: l_line_tbl(nShip_To_Site_pos).value);
966:
967: xProgress := 'MVSTOB-20-1645';
968: DBMS_SQL.BIND_VARIABLE(Location_sel_c,
969: 'vendor_site_id',
970: l_line_tbl(nVendor_Site_pos).value);
971:
972: xProgress := 'MVSTOB-20-1646';

Line 973: DBMS_SQL.BIND_VARIABLE(Location_sel_c,

969: 'vendor_site_id',
970: l_line_tbl(nVendor_Site_pos).value);
971:
972: xProgress := 'MVSTOB-20-1646';
973: DBMS_SQL.BIND_VARIABLE(Location_sel_c,
974: 'l_cInclude_Address',
975: cInclude_Address);
976:
977: xProgress := 'MVSTOB-20-1650';

Line 978: dummy := DBMS_SQL.EXECUTE(Location_sel_c);

974: 'l_cInclude_Address',
975: cInclude_Address);
976:
977: xProgress := 'MVSTOB-20-1650';
978: dummy := DBMS_SQL.EXECUTE(Location_sel_c);
979:
980: -- *********************
981: -- location loop starts here
982: -- *********************

Line 985: WHILE DBMS_SQL.FETCH_ROWS(Location_sel_c) > 0

981: -- location loop starts here
982: -- *********************
983:
984: xProgress := 'MVSTOB-20-1655';
985: WHILE DBMS_SQL.FETCH_ROWS(Location_sel_c) > 0
986: LOOP --- Location
987:
988: -- ****************************
989: -- store values in pl/sql table

Line 1086: IF(dbms_sql.last_row_count = 0) THEN

1082:
1083: END LOOP; -- LINE LEVEL Loop
1084:
1085: xProgress := 'MVSTOB-20-1714';
1086: IF(dbms_sql.last_row_count = 0) THEN
1087: v_LevelProcessed := 'LINE';
1088: ec_debug.pl(1,
1089: 'EC',
1090: 'ECE_NO_DB_ROW_PROCESSED',

Line 1102: IF(dbms_sql.last_row_count = 0) THEN

1098:
1099: END LOOP; -- HEADER LEVEL Loop
1100:
1101: xProgress := 'MVSTOB-20-1716';
1102: IF(dbms_sql.last_row_count = 0) THEN
1103: v_LevelProcessed := 'HEADER';
1104: ec_debug.pl(0,
1105: 'EC',
1106: 'ECE_NO_DB_ROW_PROCESSED',

Line 1117: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);

1113: END IF;
1114:
1115:
1116: xProgress := 'MVSTOB-20-1730';
1117: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);
1118:
1119: xProgress := 'MVSTOB-20-1740';
1120: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);
1121: ec_debug.pop('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');

Line 1120: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);

1116: xProgress := 'MVSTOB-20-1730';
1117: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);
1118:
1119: xProgress := 'MVSTOB-20-1740';
1120: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);
1121: ec_debug.pop('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN

Line 1394: Header_sel_c := DBMS_SQL.OPEN_CURSOR;

1390: -- *** for the data returned by the SQL statement
1391: -- ***************************************************
1392:
1393: xProgress := 'MVSTOB-10-1080';
1394: Header_sel_c := DBMS_SQL.OPEN_CURSOR;
1395:
1396: xProgress := 'MVSTOB-10-1090';
1397: Line_sel_c := DBMS_SQL.OPEN_CURSOR;
1398:

Line 1397: Line_sel_c := DBMS_SQL.OPEN_CURSOR;

1393: xProgress := 'MVSTOB-10-1080';
1394: Header_sel_c := DBMS_SQL.OPEN_CURSOR;
1395:
1396: xProgress := 'MVSTOB-10-1090';
1397: Line_sel_c := DBMS_SQL.OPEN_CURSOR;
1398:
1399: xProgress := 'MVSTOB-10-1100';
1400: Location_sel_c := DBMS_SQL.OPEN_CURSOR;
1401:

Line 1400: Location_sel_c := DBMS_SQL.OPEN_CURSOR;

1396: xProgress := 'MVSTOB-10-1090';
1397: Line_sel_c := DBMS_SQL.OPEN_CURSOR;
1398:
1399: xProgress := 'MVSTOB-10-1100';
1400: Location_sel_c := DBMS_SQL.OPEN_CURSOR;
1401:
1402: xProgress := 'MVSTOB-10-1110';
1403: Header_del_c1 := DBMS_SQL.OPEN_CURSOR;
1404:

Line 1403: Header_del_c1 := DBMS_SQL.OPEN_CURSOR;

1399: xProgress := 'MVSTOB-10-1100';
1400: Location_sel_c := DBMS_SQL.OPEN_CURSOR;
1401:
1402: xProgress := 'MVSTOB-10-1110';
1403: Header_del_c1 := DBMS_SQL.OPEN_CURSOR;
1404:
1405: xProgress := 'MVSTOB-10-1120';
1406: Line_del_c1 := DBMS_SQL.OPEN_CURSOR;
1407:

Line 1406: Line_del_c1 := DBMS_SQL.OPEN_CURSOR;

1402: xProgress := 'MVSTOB-10-1110';
1403: Header_del_c1 := DBMS_SQL.OPEN_CURSOR;
1404:
1405: xProgress := 'MVSTOB-10-1120';
1406: Line_del_c1 := DBMS_SQL.OPEN_CURSOR;
1407:
1408: xProgress := 'MVSTOB-10-1130';
1409: Location_del_c1 := DBMS_SQL.OPEN_CURSOR;
1410:

Line 1409: Location_del_c1 := DBMS_SQL.OPEN_CURSOR;

1405: xProgress := 'MVSTOB-10-1120';
1406: Line_del_c1 := DBMS_SQL.OPEN_CURSOR;
1407:
1408: xProgress := 'MVSTOB-10-1130';
1409: Location_del_c1 := DBMS_SQL.OPEN_CURSOR;
1410:
1411: xProgress := 'MVSTOB-10-1140';
1412: Header_del_c2 := DBMS_SQL.OPEN_CURSOR;
1413:

Line 1412: Header_del_c2 := DBMS_SQL.OPEN_CURSOR;

1408: xProgress := 'MVSTOB-10-1130';
1409: Location_del_c1 := DBMS_SQL.OPEN_CURSOR;
1410:
1411: xProgress := 'MVSTOB-10-1140';
1412: Header_del_c2 := DBMS_SQL.OPEN_CURSOR;
1413:
1414: xProgress := 'MVSTOB-10-1150';
1415: Line_del_c2 := DBMS_SQL.OPEN_CURSOR;
1416:

Line 1415: Line_del_c2 := DBMS_SQL.OPEN_CURSOR;

1411: xProgress := 'MVSTOB-10-1140';
1412: Header_del_c2 := DBMS_SQL.OPEN_CURSOR;
1413:
1414: xProgress := 'MVSTOB-10-1150';
1415: Line_del_c2 := DBMS_SQL.OPEN_CURSOR;
1416:
1417: xProgress := 'MVSTOB-10-1160';
1418: Location_del_c2 := DBMS_SQL.OPEN_CURSOR;
1419:

Line 1418: Location_del_c2 := DBMS_SQL.OPEN_CURSOR;

1414: xProgress := 'MVSTOB-10-1150';
1415: Line_del_c2 := DBMS_SQL.OPEN_CURSOR;
1416:
1417: xProgress := 'MVSTOB-10-1160';
1418: Location_del_c2 := DBMS_SQL.OPEN_CURSOR;
1419:
1420:
1421: -- *****************************************
1422: -- Parse each of the SELECT statement

Line 1428: DBMS_SQL.PARSE(Header_sel_c,

1424: -- *****************************************
1425:
1426: xProgress := 'MVSTOB-10-1170';
1427: BEGIN
1428: DBMS_SQL.PARSE(Header_sel_c,
1429: cHeader_select,
1430: DBMS_SQL.NATIVE);
1431: EXCEPTION
1432: WHEN OTHERS THEN

Line 1430: DBMS_SQL.NATIVE);

1426: xProgress := 'MVSTOB-10-1170';
1427: BEGIN
1428: DBMS_SQL.PARSE(Header_sel_c,
1429: cHeader_select,
1430: DBMS_SQL.NATIVE);
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1434: cHeader_select);

Line 1433: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1429: cHeader_select,
1430: DBMS_SQL.NATIVE);
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1434: cHeader_select);
1435: app_exception.raise_exception;
1436: END;
1437:

Line 1440: DBMS_SQL.PARSE(Line_sel_c,

1436: END;
1437:
1438: xProgress := 'MVSTOB-10-1180';
1439: BEGIN
1440: DBMS_SQL.PARSE(Line_sel_c,
1441: cLine_select,
1442: DBMS_SQL.NATIVE);
1443: EXCEPTION
1444: WHEN OTHERS THEN

Line 1442: DBMS_SQL.NATIVE);

1438: xProgress := 'MVSTOB-10-1180';
1439: BEGIN
1440: DBMS_SQL.PARSE(Line_sel_c,
1441: cLine_select,
1442: DBMS_SQL.NATIVE);
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1446: cLine_select);

Line 1445: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1441: cLine_select,
1442: DBMS_SQL.NATIVE);
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1446: cLine_select);
1447: app_exception.raise_exception;
1448: END;
1449:

Line 1452: DBMS_SQL.PARSE(Location_sel_c,

1448: END;
1449:
1450: xProgress := 'MVSTOB-10-1190';
1451: BEGIN
1452: DBMS_SQL.PARSE(Location_sel_c,
1453: cLocation_select,
1454: DBMS_SQL.NATIVE);
1455: EXCEPTION
1456: WHEN OTHERS THEN

Line 1454: DBMS_SQL.NATIVE);

1450: xProgress := 'MVSTOB-10-1190';
1451: BEGIN
1452: DBMS_SQL.PARSE(Location_sel_c,
1453: cLocation_select,
1454: DBMS_SQL.NATIVE);
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1458: cLocation_select);

Line 1457: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1453: cLocation_select,
1454: DBMS_SQL.NATIVE);
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1458: cLocation_select);
1459: app_exception.raise_exception;
1460: END;
1461:

Line 1464: DBMS_SQL.PARSE(Header_del_c1 ,cHeader_delete1 ,DBMS_SQL.NATIVE);

1460: END;
1461:
1462: xProgress := 'MVSTOB-10-1200';
1463: BEGIN
1464: DBMS_SQL.PARSE(Header_del_c1 ,cHeader_delete1 ,DBMS_SQL.NATIVE);
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1468: cHeader_delete1);

Line 1467: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1463: BEGIN
1464: DBMS_SQL.PARSE(Header_del_c1 ,cHeader_delete1 ,DBMS_SQL.NATIVE);
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1468: cHeader_delete1);
1469: app_exception.raise_exception;
1470: END;
1471:

Line 1474: DBMS_SQL.PARSE(Line_del_c1 ,cLine_delete1 ,DBMS_SQL.NATIVE);

1470: END;
1471:
1472: xProgress := 'MVSTOB-10-1210';
1473: BEGIN
1474: DBMS_SQL.PARSE(Line_del_c1 ,cLine_delete1 ,DBMS_SQL.NATIVE);
1475: EXCEPTION
1476: WHEN OTHERS THEN
1477: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1478: cLine_delete1);

Line 1477: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1473: BEGIN
1474: DBMS_SQL.PARSE(Line_del_c1 ,cLine_delete1 ,DBMS_SQL.NATIVE);
1475: EXCEPTION
1476: WHEN OTHERS THEN
1477: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1478: cLine_delete1);
1479: app_exception.raise_exception;
1480: END;
1481:

Line 1484: DBMS_SQL.PARSE(Location_del_c1 ,cLocation_delete1 ,DBMS_SQL.NATIVE);

1480: END;
1481:
1482: xProgress := 'MVSTOB-10-1220';
1483: BEGIN
1484: DBMS_SQL.PARSE(Location_del_c1 ,cLocation_delete1 ,DBMS_SQL.NATIVE);
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1488: cLocation_delete1);

Line 1487: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1483: BEGIN
1484: DBMS_SQL.PARSE(Location_del_c1 ,cLocation_delete1 ,DBMS_SQL.NATIVE);
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1488: cLocation_delete1);
1489: app_exception.raise_exception;
1490: END;
1491:

Line 1494: DBMS_SQL.PARSE(Header_del_c2 ,cHeader_delete2 ,DBMS_SQL.NATIVE);

1490: END;
1491:
1492: xProgress := 'MVSTOB-10-1230';
1493: BEGIN
1494: DBMS_SQL.PARSE(Header_del_c2 ,cHeader_delete2 ,DBMS_SQL.NATIVE);
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1498: cHeader_delete2);

Line 1497: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1493: BEGIN
1494: DBMS_SQL.PARSE(Header_del_c2 ,cHeader_delete2 ,DBMS_SQL.NATIVE);
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1498: cHeader_delete2);
1499: app_exception.raise_exception;
1500: END;
1501:

Line 1504: DBMS_SQL.PARSE(Line_del_c2 ,cLine_delete2 ,DBMS_SQL.NATIVE);

1500: END;
1501:
1502: xProgress := 'MVSTOB-10-1240';
1503: BEGIN
1504: DBMS_SQL.PARSE(Line_del_c2 ,cLine_delete2 ,DBMS_SQL.NATIVE);
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1508: cLine_delete2);

Line 1507: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1503: BEGIN
1504: DBMS_SQL.PARSE(Line_del_c2 ,cLine_delete2 ,DBMS_SQL.NATIVE);
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1508: cLine_delete2);
1509: app_exception.raise_exception;
1510: END;
1511:

Line 1514: DBMS_SQL.PARSE(Location_del_c2 ,cLocation_delete2 ,DBMS_SQL.NATIVE);

1510: END;
1511:
1512: xProgress := 'MVSTOB-10-1250';
1513: BEGIN
1514: DBMS_SQL.PARSE(Location_del_c2 ,cLocation_delete2 ,DBMS_SQL.NATIVE);
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1518: cLocation_delete2);

Line 1517: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,

1513: BEGIN
1514: DBMS_SQL.PARSE(Location_del_c2 ,cLocation_delete2 ,DBMS_SQL.NATIVE);
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
1518: cLocation_delete2);
1519: app_exception.raise_exception;
1520: END;
1521:

Line 1552: DBMS_SQL.DEFINE_COLUMN_ROWID(Header_sel_c,

1548: -- Need rowid for delete (Header Level)
1549: -- ***************************************************
1550:
1551: xProgress := 'MVSTOB-10-1280';
1552: DBMS_SQL.DEFINE_COLUMN_ROWID(Header_sel_c,
1553: iHeader_count + 1,
1554: rHeader_rowid);
1555:
1556: xProgress := 'MVSTOB-10-1290';

Line 1557: DBMS_SQL.DEFINE_COLUMN_ROWID(Header_sel_c,

1553: iHeader_count + 1,
1554: rHeader_rowid);
1555:
1556: xProgress := 'MVSTOB-10-1290';
1557: DBMS_SQL.DEFINE_COLUMN_ROWID(Header_sel_c,
1558: iHeader_count + 2,
1559: rHeader_X_rowid);
1560:
1561: xProgress := 'MVSTOB-10-1310';

Line 1572: DBMS_SQL.DEFINE_COLUMN_ROWID(Line_sel_c,

1568: -- Need rowid for delete (Line Level)
1569: -- ***************************************************
1570:
1571: xProgress := 'MVSTOB-10-1320';
1572: DBMS_SQL.DEFINE_COLUMN_ROWID(Line_sel_c,
1573: iLine_count + 1,
1574: rLine_rowid);
1575:
1576: xProgress := 'MVSTOB-10-1330';

Line 1577: DBMS_SQL.DEFINE_COLUMN_ROWID(Line_sel_c,

1573: iLine_count + 1,
1574: rLine_rowid);
1575:
1576: xProgress := 'MVSTOB-10-1330';
1577: DBMS_SQL.DEFINE_COLUMN_ROWID(Line_sel_c,
1578: iLine_count + 2,
1579: rLine_X_rowid);
1580:
1581: xProgress := 'MVSTOB-10-1340';

Line 1593: DBMS_SQL.DEFINE_COLUMN_ROWID(Location_sel_c,

1589: -- Need rowid for delete (Location Level)
1590: -- ***************************************************
1591:
1592: xProgress := 'MVSTOB-10-1360';
1593: DBMS_SQL.DEFINE_COLUMN_ROWID(Location_sel_c,
1594: iLocation_count + 1,
1595: rLocation_rowid);
1596:
1597: xProgress := 'MVSTOB-10-1370';

Line 1598: DBMS_SQL.DEFINE_COLUMN_ROWID(Location_sel_c,

1594: iLocation_count + 1,
1595: rLocation_rowid);
1596:
1597: xProgress := 'MVSTOB-10-1370';
1598: DBMS_SQL.DEFINE_COLUMN_ROWID(Location_sel_c,
1599: iLocation_count + 2,
1600: rLocation_X_rowid);
1601:
1602: -- ************************************************************

Line 1616: DBMS_SQL.BIND_VARIABLE(Header_sel_c,

1612:
1613: -- Bind Variables
1614:
1615: xProgress := 'MVSTOB-10-1371';
1616: DBMS_SQL.BIND_VARIABLE(Header_sel_c,
1617: 'l_Run_id',
1618: iRun_Id);
1619:
1620: xProgress := 'MVSTOB-10-1372';

Line 1621: DBMS_SQL.BIND_VARIABLE(Line_sel_c,

1617: 'l_Run_id',
1618: iRun_Id);
1619:
1620: xProgress := 'MVSTOB-10-1372';
1621: DBMS_SQL.BIND_VARIABLE(Line_sel_c,
1622: 'm_Run_id',
1623: iRun_Id);
1624:
1625: xProgress := 'MVSTOB-10-1373';

Line 1626: DBMS_SQL.BIND_VARIABLE(Location_sel_c,

1622: 'm_Run_id',
1623: iRun_Id);
1624:
1625: xProgress := 'MVSTOB-10-1373';
1626: DBMS_SQL.BIND_VARIABLE(Location_sel_c,
1627: 'x_Run_id',
1628: iRun_Id);
1629:
1630: --- EXECUTE the SELECT statement

Line 1633: dummy := DBMS_SQL.EXECUTE(Header_sel_c);

1629:
1630: --- EXECUTE the SELECT statement
1631:
1632: xProgress := 'MVSTOB-10-1380';
1633: dummy := DBMS_SQL.EXECUTE(Header_sel_c);
1634:
1635: -- ********************************************************************
1636: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
1637: -- *** then populate ECE_OUTPUT with data from all DETAILS that belongs

Line 1645: WHILE DBMS_SQL.FETCH_ROWS(Header_sel_c) > 0

1641:
1642: -- HEADER - LINE - LOCATION...
1643:
1644: xProgress := 'MVSTOB-10-1390';
1645: WHILE DBMS_SQL.FETCH_ROWS(Header_sel_c) > 0
1646: LOOP -- Header
1647:
1648: -- ******************************
1649: -- store values in pl/sql table

Line 1657: DBMS_SQL.COLUMN_VALUE(Header_sel_c,

1653: ece_flatfile_pvt.ASSIGN_COLUMN_VALUE_TO_TBL(Header_sel_c,
1654: l_header_tbl);
1655:
1656: xProgress := 'MVSTOB-10-1410';
1657: DBMS_SQL.COLUMN_VALUE(Header_sel_c,
1658: iHeader_count + 1,
1659: rHeader_rowid);
1660:
1661: xProgress := 'MVSTOB-10-1420';

Line 1662: DBMS_SQL.COLUMN_VALUE(Header_sel_c,

1658: iHeader_count + 1,
1659: rHeader_rowid);
1660:
1661: xProgress := 'MVSTOB-10-1420';
1662: DBMS_SQL.COLUMN_VALUE(Header_sel_c,
1663: iHeader_count + 2,
1664: rHeader_X_rowid);
1665:
1666: xProgress := 'MVSTOB-10-1430';

Line 1706: DBMS_SQL.BIND_VARIABLE(Line_sel_c,

1702: iRun_id,
1703: c_file_common_key);
1704:
1705: xProgress := 'MVSTOB-10-1490';
1706: DBMS_SQL.BIND_VARIABLE(Line_sel_c,
1707: 'transaction_header_id',
1708: ntransaction_header_id);
1709:
1710: xProgress := 'MVSTOB-10-1500';

Line 1711: DBMS_SQL.BIND_VARIABLE(Location_sel_c,

1707: 'transaction_header_id',
1708: ntransaction_header_id);
1709:
1710: xProgress := 'MVSTOB-10-1500';
1711: DBMS_SQL.BIND_VARIABLE(Location_sel_c,
1712: 'transaction_header_id',
1713: ntransaction_header_id);
1714:
1715: xProgress := 'MVSTOB-10-1510';

Line 1716: dummy := DBMS_SQL.EXECUTE(Line_sel_c);

1712: 'transaction_header_id',
1713: ntransaction_header_id);
1714:
1715: xProgress := 'MVSTOB-10-1510';
1716: dummy := DBMS_SQL.EXECUTE(Line_sel_c);
1717:
1718: -- ***************************************************
1719: -- line loop starts here
1720: -- ***************************************************

Line 1722: WHILE DBMS_SQL.FETCH_ROWS(Line_sel_c) > 0

1718: -- ***************************************************
1719: -- line loop starts here
1720: -- ***************************************************
1721: xProgress := 'MVSTOB-10-1520';
1722: WHILE DBMS_SQL.FETCH_ROWS(Line_sel_c) > 0
1723: LOOP --- Line
1724:
1725: -- ***************************************************
1726: -- store values in pl/sql table

Line 1734: DBMS_SQL.COLUMN_VALUE(Line_sel_c,

1730: ece_flatfile_pvt.ASSIGN_COLUMN_VALUE_TO_TBL (Line_sel_c,
1731: l_line_tbl);
1732:
1733: xProgress := 'MVSTOB-10-1533';
1734: DBMS_SQL.COLUMN_VALUE(Line_sel_c,
1735: iLine_count + 1,
1736: rLine_rowid);
1737:
1738: xProgress := 'MVSTOB-10-1535';

Line 1739: DBMS_SQL.COLUMN_VALUE(Line_sel_c,

1735: iLine_count + 1,
1736: rLine_rowid);
1737:
1738: xProgress := 'MVSTOB-10-1535';
1739: DBMS_SQL.COLUMN_VALUE(Line_sel_c,
1740: iLine_count + 2,
1741: rLine_X_rowid);
1742:
1743: xProgress := 'MVSTOB-10-1445';

Line 1779: DBMS_SQL.BIND_VARIABLE(Location_sel_c,

1775: iRun_id,
1776: c_file_common_key);
1777:
1778: xProgress := 'MVSTOB-10-1570';
1779: DBMS_SQL.BIND_VARIABLE(Location_sel_c,
1780: 'transaction_line_id',
1781: ntransaction_line_id);
1782:
1783: xProgress := 'MVSTOB-10-1580';

Line 1784: dummy := DBMS_SQL.EXECUTE(Location_sel_c);

1780: 'transaction_line_id',
1781: ntransaction_line_id);
1782:
1783: xProgress := 'MVSTOB-10-1580';
1784: dummy := DBMS_SQL.EXECUTE(Location_sel_c);
1785:
1786: -- ***************************************************
1787: -- location loop starts here
1788: -- ***************************************************

Line 1790: WHILE DBMS_SQL.FETCH_ROWS(Location_sel_c) > 0

1786: -- ***************************************************
1787: -- location loop starts here
1788: -- ***************************************************
1789: xProgress := 'MVSTOB-10-1590';
1790: WHILE DBMS_SQL.FETCH_ROWS(Location_sel_c) > 0
1791: LOOP --- Line
1792:
1793: -- ***************************************************
1794: -- store values in pl/sql table

Line 1802: DBMS_SQL.COLUMN_VALUE(Location_sel_c,

1798: ece_flatfile_pvt.ASSIGN_COLUMN_VALUE_TO_TBL (Location_sel_c,
1799: l_location_tbl);
1800:
1801: xProgress := 'MVSTOB-10-1603';
1802: DBMS_SQL.COLUMN_VALUE(Location_sel_c,
1803: iLocation_count + 1,
1804: rLocation_rowid);
1805:
1806: xProgress := 'MVSTOB-10-1606';

Line 1807: DBMS_SQL.COLUMN_VALUE(Location_sel_c,

1803: iLocation_count + 1,
1804: rLocation_rowid);
1805:
1806: xProgress := 'MVSTOB-10-1606';
1807: DBMS_SQL.COLUMN_VALUE(Location_sel_c,
1808: iLocation_count + 2,
1809: rLocation_X_rowid);
1810:
1811: --Bug # 952306

Line 1829: DBMS_SQL.BIND_VARIABLE(Location_del_c1,

1825: iRun_id,
1826: c_file_common_key);
1827:
1828: xProgress := 'MVSTOB-10-1680';
1829: DBMS_SQL.BIND_VARIABLE(Location_del_c1,
1830: 'col_rowid',
1831: rLocation_rowid);
1832:
1833: xProgress := 'MVSTOB-10-1690';

Line 1834: DBMS_SQL.BIND_VARIABLE(Location_del_c2,

1830: 'col_rowid',
1831: rLocation_rowid);
1832:
1833: xProgress := 'MVSTOB-10-1690';
1834: DBMS_SQL.BIND_VARIABLE(Location_del_c2,
1835: 'col_rowid',
1836: rLocation_X_rowid);
1837:
1838: xProgress := 'MVSTOB-10-1660';

Line 1839: dummy := DBMS_SQL.EXECUTE(Location_del_c1);

1835: 'col_rowid',
1836: rLocation_X_rowid);
1837:
1838: xProgress := 'MVSTOB-10-1660';
1839: dummy := DBMS_SQL.EXECUTE(Location_del_c1);
1840:
1841: xProgress := 'MVSTOB-10-1670';
1842: dummy := DBMS_SQL.EXECUTE(Location_del_c2);
1843:

Line 1842: dummy := DBMS_SQL.EXECUTE(Location_del_c2);

1838: xProgress := 'MVSTOB-10-1660';
1839: dummy := DBMS_SQL.EXECUTE(Location_del_c1);
1840:
1841: xProgress := 'MVSTOB-10-1670';
1842: dummy := DBMS_SQL.EXECUTE(Location_del_c2);
1843:
1844: END LOOP; -- Location Level
1845:
1846: xProgress := 'MVSTOB-10-1674';

Line 1847: IF(dbms_sql.last_row_count = 0) THEN

1843:
1844: END LOOP; -- Location Level
1845:
1846: xProgress := 'MVSTOB-10-1674';
1847: IF(dbms_sql.last_row_count = 0) THEN
1848: v_LevelProcessed := 'LOCATION';
1849: ec_debug.pl(1,
1850: 'EC',
1851: 'ECE_NO_DB_ROW_PROCESSED',

Line 1865: DBMS_SQL.BIND_VARIABLE(Line_del_c1,

1861: -- Use rowid for delete
1862: -- *********************
1863:
1864: xProgress := 'MVSTOB-10-1680';
1865: DBMS_SQL.BIND_VARIABLE(Line_del_c1,
1866: 'col_rowid',
1867: rLine_rowid);
1868:
1869: xProgress := 'MVSTOB-10-1690';

Line 1870: DBMS_SQL.BIND_VARIABLE(Line_del_c2,

1866: 'col_rowid',
1867: rLine_rowid);
1868:
1869: xProgress := 'MVSTOB-10-1690';
1870: DBMS_SQL.BIND_VARIABLE(Line_del_c2,
1871: 'col_rowid',
1872: rLine_X_rowid);
1873:
1874: xProgress := 'MVSTOB-10-1700';

Line 1875: dummy := DBMS_SQL.EXECUTE(Line_del_c1);

1871: 'col_rowid',
1872: rLine_X_rowid);
1873:
1874: xProgress := 'MVSTOB-10-1700';
1875: dummy := DBMS_SQL.EXECUTE(Line_del_c1);
1876:
1877: xProgress := 'MVSTOB-10-1710';
1878: dummy := DBMS_SQL.EXECUTE(Line_del_c2);
1879:

Line 1878: dummy := DBMS_SQL.EXECUTE(Line_del_c2);

1874: xProgress := 'MVSTOB-10-1700';
1875: dummy := DBMS_SQL.EXECUTE(Line_del_c1);
1876:
1877: xProgress := 'MVSTOB-10-1710';
1878: dummy := DBMS_SQL.EXECUTE(Line_del_c2);
1879:
1880: END LOOP; -- Line Level
1881:
1882: xProgress := 'MVSTOB-10-1714';

Line 1883: IF(dbms_sql.last_row_count = 0) THEN

1879:
1880: END LOOP; -- Line Level
1881:
1882: xProgress := 'MVSTOB-10-1714';
1883: IF(dbms_sql.last_row_count = 0) THEN
1884: v_LevelProcessed := 'LINE';
1885: ec_debug.pl(1,
1886: 'EC',
1887: 'ECE_NO_DB_ROW_PROCESSED',

Line 1897: DBMS_SQL.BIND_VARIABLE(Header_del_c1,

1893: cTransaction_Type);
1894: END IF;
1895:
1896: xProgress := 'MVSTOB-10-1720';
1897: DBMS_SQL.BIND_VARIABLE(Header_del_c1,
1898: 'col_rowid',
1899: rHeader_rowid);
1900:
1901: xProgress := 'MVSTOB-10-1730';

Line 1902: DBMS_SQL.BIND_VARIABLE(Header_del_c2,

1898: 'col_rowid',
1899: rHeader_rowid);
1900:
1901: xProgress := 'MVSTOB-10-1730';
1902: DBMS_SQL.BIND_VARIABLE(Header_del_c2,
1903: 'col_rowid',
1904: rHeader_X_rowid);
1905:
1906: xProgress := 'MVSTOB-10-1740';

Line 1907: dummy := DBMS_SQL.EXECUTE(Header_del_c1);

1903: 'col_rowid',
1904: rHeader_X_rowid);
1905:
1906: xProgress := 'MVSTOB-10-1740';
1907: dummy := DBMS_SQL.EXECUTE(Header_del_c1);
1908:
1909: xProgress := 'MVSTOB-10-1750';
1910: dummy := DBMS_SQL.EXECUTE(Header_del_c2);
1911:

Line 1910: dummy := DBMS_SQL.EXECUTE(Header_del_c2);

1906: xProgress := 'MVSTOB-10-1740';
1907: dummy := DBMS_SQL.EXECUTE(Header_del_c1);
1908:
1909: xProgress := 'MVSTOB-10-1750';
1910: dummy := DBMS_SQL.EXECUTE(Header_del_c2);
1911:
1912: END LOOP; -- Header Level
1913:
1914: xProgress := 'MVSTOB-10-1754';

Line 1915: IF(dbms_sql.last_row_count = 0) THEN

1911:
1912: END LOOP; -- Header Level
1913:
1914: xProgress := 'MVSTOB-10-1754';
1915: IF(dbms_sql.last_row_count = 0) THEN
1916: v_LevelProcessed := 'HEADER';
1917: ec_debug.pl(1,
1918: 'EC',
1919: 'ECE_NO_DB_ROW_PROCESSED',

Line 1929: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);

1925: cTransaction_Type);
1926: END IF;
1927:
1928: xProgress := 'MVSTOB-10-1760';
1929: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);
1930:
1931: xProgress := 'MVSTOB-10-1770';
1932: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);
1933:

Line 1932: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);

1928: xProgress := 'MVSTOB-10-1760';
1929: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);
1930:
1931: xProgress := 'MVSTOB-10-1770';
1932: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);
1933:
1934: xProgress := 'MVSTOB-10-1780';
1935: DBMS_SQL.CLOSE_CURSOR(Location_sel_c);
1936:

Line 1935: DBMS_SQL.CLOSE_CURSOR(Location_sel_c);

1931: xProgress := 'MVSTOB-10-1770';
1932: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);
1933:
1934: xProgress := 'MVSTOB-10-1780';
1935: DBMS_SQL.CLOSE_CURSOR(Location_sel_c);
1936:
1937: xProgress := 'MVSTOB-10-1790';
1938: DBMS_SQL.CLOSE_CURSOR(Header_del_c1);
1939:

Line 1938: DBMS_SQL.CLOSE_CURSOR(Header_del_c1);

1934: xProgress := 'MVSTOB-10-1780';
1935: DBMS_SQL.CLOSE_CURSOR(Location_sel_c);
1936:
1937: xProgress := 'MVSTOB-10-1790';
1938: DBMS_SQL.CLOSE_CURSOR(Header_del_c1);
1939:
1940: xProgress := 'MVSTOB-10-1800';
1941: DBMS_SQL.CLOSE_CURSOR(Line_del_c1);
1942:

Line 1941: DBMS_SQL.CLOSE_CURSOR(Line_del_c1);

1937: xProgress := 'MVSTOB-10-1790';
1938: DBMS_SQL.CLOSE_CURSOR(Header_del_c1);
1939:
1940: xProgress := 'MVSTOB-10-1800';
1941: DBMS_SQL.CLOSE_CURSOR(Line_del_c1);
1942:
1943: xProgress := 'MVSTOB-10-1812';
1944: DBMS_SQL.CLOSE_CURSOR(Location_del_c1);
1945:

Line 1944: DBMS_SQL.CLOSE_CURSOR(Location_del_c1);

1940: xProgress := 'MVSTOB-10-1800';
1941: DBMS_SQL.CLOSE_CURSOR(Line_del_c1);
1942:
1943: xProgress := 'MVSTOB-10-1812';
1944: DBMS_SQL.CLOSE_CURSOR(Location_del_c1);
1945:
1946: xProgress := 'MVSTOB-10-1814';
1947: DBMS_SQL.CLOSE_CURSOR(Header_del_c2);
1948:

Line 1947: DBMS_SQL.CLOSE_CURSOR(Header_del_c2);

1943: xProgress := 'MVSTOB-10-1812';
1944: DBMS_SQL.CLOSE_CURSOR(Location_del_c1);
1945:
1946: xProgress := 'MVSTOB-10-1814';
1947: DBMS_SQL.CLOSE_CURSOR(Header_del_c2);
1948:
1949: xProgress := 'MVSTOB-10-1816';
1950: DBMS_SQL.CLOSE_CURSOR(Line_del_c2);
1951:

Line 1950: DBMS_SQL.CLOSE_CURSOR(Line_del_c2);

1946: xProgress := 'MVSTOB-10-1814';
1947: DBMS_SQL.CLOSE_CURSOR(Header_del_c2);
1948:
1949: xProgress := 'MVSTOB-10-1816';
1950: DBMS_SQL.CLOSE_CURSOR(Line_del_c2);
1951:
1952: xProgress := 'MVSTOB-10-1818';
1953: DBMS_SQL.CLOSE_CURSOR(Location_del_c2);
1954:

Line 1953: DBMS_SQL.CLOSE_CURSOR(Location_del_c2);

1949: xProgress := 'MVSTOB-10-1816';
1950: DBMS_SQL.CLOSE_CURSOR(Line_del_c2);
1951:
1952: xProgress := 'MVSTOB-10-1818';
1953: DBMS_SQL.CLOSE_CURSOR(Location_del_c2);
1954:
1955: xProgress := 'MVSTOB-10-1820';
1956: ec_debug.pop('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1957: