APPS.GML_GPOAO dependencies on DBMS_SQL

Line 791: v_ORD_Cursor := dbms_sql.open_cursor;

787: /* statement. */
788: /* */
789:
790: xProgress := 'GPOAOB-10-1410';
791: v_ORD_Cursor := dbms_sql.open_cursor;
792: xProgress := 'GPOAOB-10-1420';
793: v_OAC_Cursor := dbms_sql.open_cursor;
794: xProgress := 'GPOAOB-10-1430';
795: v_OTX_Cursor := dbms_sql.open_cursor;

Line 793: v_OAC_Cursor := dbms_sql.open_cursor;

789:
790: xProgress := 'GPOAOB-10-1410';
791: v_ORD_Cursor := dbms_sql.open_cursor;
792: xProgress := 'GPOAOB-10-1420';
793: v_OAC_Cursor := dbms_sql.open_cursor;
794: xProgress := 'GPOAOB-10-1430';
795: v_OTX_Cursor := dbms_sql.open_cursor;
796: xProgress := 'GPOAOB-10-1440';
797: v_DTL_Cursor := dbms_sql.open_cursor;

Line 795: v_OTX_Cursor := dbms_sql.open_cursor;

791: v_ORD_Cursor := dbms_sql.open_cursor;
792: xProgress := 'GPOAOB-10-1420';
793: v_OAC_Cursor := dbms_sql.open_cursor;
794: xProgress := 'GPOAOB-10-1430';
795: v_OTX_Cursor := dbms_sql.open_cursor;
796: xProgress := 'GPOAOB-10-1440';
797: v_DTL_Cursor := dbms_sql.open_cursor;
798: xProgress := 'GPOAOB-10-1450';
799: v_DAC_Cursor := dbms_sql.open_cursor;

Line 797: v_DTL_Cursor := dbms_sql.open_cursor;

793: v_OAC_Cursor := dbms_sql.open_cursor;
794: xProgress := 'GPOAOB-10-1430';
795: v_OTX_Cursor := dbms_sql.open_cursor;
796: xProgress := 'GPOAOB-10-1440';
797: v_DTL_Cursor := dbms_sql.open_cursor;
798: xProgress := 'GPOAOB-10-1450';
799: v_DAC_Cursor := dbms_sql.open_cursor;
800: xProgress := 'GPOAOB-10-1460';
801: v_DTX_Cursor := dbms_sql.open_cursor;

Line 799: v_DAC_Cursor := dbms_sql.open_cursor;

795: v_OTX_Cursor := dbms_sql.open_cursor;
796: xProgress := 'GPOAOB-10-1440';
797: v_DTL_Cursor := dbms_sql.open_cursor;
798: xProgress := 'GPOAOB-10-1450';
799: v_DAC_Cursor := dbms_sql.open_cursor;
800: xProgress := 'GPOAOB-10-1460';
801: v_DTX_Cursor := dbms_sql.open_cursor;
802: xProgress := 'GPOAOB-10-1470';
803: v_ALL_Cursor := dbms_sql.open_cursor;

Line 801: v_DTX_Cursor := dbms_sql.open_cursor;

797: v_DTL_Cursor := dbms_sql.open_cursor;
798: xProgress := 'GPOAOB-10-1450';
799: v_DAC_Cursor := dbms_sql.open_cursor;
800: xProgress := 'GPOAOB-10-1460';
801: v_DTX_Cursor := dbms_sql.open_cursor;
802: xProgress := 'GPOAOB-10-1470';
803: v_ALL_Cursor := dbms_sql.open_cursor;
804: xProgress := 'GPOAOB-10-1480';
805:

Line 803: v_ALL_Cursor := dbms_sql.open_cursor;

799: v_DAC_Cursor := dbms_sql.open_cursor;
800: xProgress := 'GPOAOB-10-1460';
801: v_DTX_Cursor := dbms_sql.open_cursor;
802: xProgress := 'GPOAOB-10-1470';
803: v_ALL_Cursor := dbms_sql.open_cursor;
804: xProgress := 'GPOAOB-10-1480';
805:
806: /* */
807: /* Parse each SELECT statement so the database understands the */

Line 812: dbms_sql.parse ( v_ORD_Cursor,

808: /* command. */
809: /* */
810:
811: xProgress := 'GPOAOB-10-1500';
812: dbms_sql.parse ( v_ORD_Cursor,
813: v_ORD_Select,
814: dbms_sql.native );
815: ec_debug.pl (3, 'v_ORD_Select:', v_ORD_Select);
816:

Line 814: dbms_sql.native );

810:
811: xProgress := 'GPOAOB-10-1500';
812: dbms_sql.parse ( v_ORD_Cursor,
813: v_ORD_Select,
814: dbms_sql.native );
815: ec_debug.pl (3, 'v_ORD_Select:', v_ORD_Select);
816:
817: xProgress := 'GPOAOB-10-1510';
818: dbms_sql.parse ( v_OAC_Cursor,

Line 818: dbms_sql.parse ( v_OAC_Cursor,

814: dbms_sql.native );
815: ec_debug.pl (3, 'v_ORD_Select:', v_ORD_Select);
816:
817: xProgress := 'GPOAOB-10-1510';
818: dbms_sql.parse ( v_OAC_Cursor,
819: v_OAC_Select,
820: dbms_sql.native );
821:
822: xProgress := 'GPOAOB-10-1520';

Line 820: dbms_sql.native );

816:
817: xProgress := 'GPOAOB-10-1510';
818: dbms_sql.parse ( v_OAC_Cursor,
819: v_OAC_Select,
820: dbms_sql.native );
821:
822: xProgress := 'GPOAOB-10-1520';
823: dbms_sql.parse ( v_OTX_Cursor,
824: v_OTX_Select,

Line 823: dbms_sql.parse ( v_OTX_Cursor,

819: v_OAC_Select,
820: dbms_sql.native );
821:
822: xProgress := 'GPOAOB-10-1520';
823: dbms_sql.parse ( v_OTX_Cursor,
824: v_OTX_Select,
825: dbms_sql.native );
826:
827: xProgress := 'GPOAOB-10-1530';

Line 825: dbms_sql.native );

821:
822: xProgress := 'GPOAOB-10-1520';
823: dbms_sql.parse ( v_OTX_Cursor,
824: v_OTX_Select,
825: dbms_sql.native );
826:
827: xProgress := 'GPOAOB-10-1530';
828: dbms_sql.parse ( v_DTL_Cursor,
829: v_DTL_Select,

Line 828: dbms_sql.parse ( v_DTL_Cursor,

824: v_OTX_Select,
825: dbms_sql.native );
826:
827: xProgress := 'GPOAOB-10-1530';
828: dbms_sql.parse ( v_DTL_Cursor,
829: v_DTL_Select,
830: dbms_sql.native );
831:
832: xProgress := 'GPOAOB-10-1540';

Line 830: dbms_sql.native );

826:
827: xProgress := 'GPOAOB-10-1530';
828: dbms_sql.parse ( v_DTL_Cursor,
829: v_DTL_Select,
830: dbms_sql.native );
831:
832: xProgress := 'GPOAOB-10-1540';
833: dbms_sql.parse ( v_DAC_Cursor,
834: v_DAC_Select,

Line 833: dbms_sql.parse ( v_DAC_Cursor,

829: v_DTL_Select,
830: dbms_sql.native );
831:
832: xProgress := 'GPOAOB-10-1540';
833: dbms_sql.parse ( v_DAC_Cursor,
834: v_DAC_Select,
835: dbms_sql.native );
836:
837: xProgress := 'GPOAOB-10-1550';

Line 835: dbms_sql.native );

831:
832: xProgress := 'GPOAOB-10-1540';
833: dbms_sql.parse ( v_DAC_Cursor,
834: v_DAC_Select,
835: dbms_sql.native );
836:
837: xProgress := 'GPOAOB-10-1550';
838: dbms_sql.parse ( v_DTX_Cursor,
839: v_DTX_Select,

Line 838: dbms_sql.parse ( v_DTX_Cursor,

834: v_DAC_Select,
835: dbms_sql.native );
836:
837: xProgress := 'GPOAOB-10-1550';
838: dbms_sql.parse ( v_DTX_Cursor,
839: v_DTX_Select,
840: dbms_sql.native );
841:
842: xProgress := 'GPOAOB-10-1560';

Line 840: dbms_sql.native );

836:
837: xProgress := 'GPOAOB-10-1550';
838: dbms_sql.parse ( v_DTX_Cursor,
839: v_DTX_Select,
840: dbms_sql.native );
841:
842: xProgress := 'GPOAOB-10-1560';
843: dbms_sql.parse ( v_ALL_Cursor,
844: v_ALL_Select,

Line 843: dbms_sql.parse ( v_ALL_Cursor,

839: v_DTX_Select,
840: dbms_sql.native );
841:
842: xProgress := 'GPOAOB-10-1560';
843: dbms_sql.parse ( v_ALL_Cursor,
844: v_ALL_Select,
845: dbms_sql.native );
846:
847: /* */

Line 845: dbms_sql.native );

841:
842: xProgress := 'GPOAOB-10-1560';
843: dbms_sql.parse ( v_ALL_Cursor,
844: v_ALL_Select,
845: dbms_sql.native );
846:
847: /* */
848: /* Initialize all counters. */
849: /* */

Line 890: dbms_sql.define_column ( v_ORD_Cursor,

886: xProgress := 'GPOAOB-10-1600';
887: FOR v_LoopCount IN 1..v_ORD_Count
888: LOOP
889: xProgress := 'GPOAOB-10-1605';
890: dbms_sql.define_column ( v_ORD_Cursor,
891: v_LoopCount,
892: v_ORD_Select,
893: ece_extract_utils_pub.G_MaxColWidth );
894: END LOOP;

Line 900: dbms_sql.define_column ( v_OAC_Cursor,

896: xProgress := 'GPOAOB-10-1610';
897: FOR v_LoopCount IN 1..v_OAC_Count
898: LOOP
899: xProgress := 'GPOAOB-10-1615';
900: dbms_sql.define_column ( v_OAC_Cursor,
901: v_LoopCount,
902: v_OAC_Select,
903: ece_extract_utils_pub.G_MaxColWidth );
904: END LOOP;

Line 910: dbms_sql.define_column ( v_OTX_Cursor,

906: xProgress := 'GPOAOB-10-1620';
907: FOR v_LoopCount IN 1..v_OTX_Count
908: LOOP
909: xProgress := 'GPOAOB-10-1625';
910: dbms_sql.define_column ( v_OTX_Cursor,
911: v_LoopCount,
912: v_OTX_Select,
913: ece_extract_utils_pub.G_MaxColWidth );
914: END LOOP;

Line 920: dbms_sql.define_column ( v_DTL_Cursor,

916: xProgress := 'GPOAOB-10-1630';
917: FOR v_LoopCount IN 1..v_DTL_Count
918: LOOP
919: xProgress := 'GPOAOB-10-1635';
920: dbms_sql.define_column ( v_DTL_Cursor,
921: v_LoopCount,
922: v_DTL_Select,
923: ece_extract_utils_pub.G_MaxColWidth );
924: END LOOP;

Line 930: dbms_sql.define_column ( v_DAC_Cursor,

926: xProgress := 'GPOAOB-10-1640';
927: FOR v_LoopCount IN 1..v_DAC_Count
928: LOOP
929: xProgress := 'GPOAOB-10-1645';
930: dbms_sql.define_column ( v_DAC_Cursor,
931: v_LoopCount,
932: v_DAC_Select,
933: ece_extract_utils_pub.G_MaxColWidth );
934: END LOOP;

Line 940: dbms_sql.define_column ( v_DTX_Cursor,

936: xProgress := 'GPOAOB-10-1650';
937: FOR v_LoopCount IN 1..v_DTX_Count
938: LOOP
939: xProgress := 'GPOAOB-10-1655';
940: dbms_sql.define_column ( v_DTX_Cursor,
941: v_LoopCount,
942: v_DTX_Select,
943: ece_extract_utils_pub.G_MaxColWidth );
944: END LOOP;

Line 950: dbms_sql.define_column ( v_ALL_Cursor,

946: xProgress := 'GPOAOB-10-1660';
947: FOR v_LoopCount IN 1..v_ALL_Count
948: LOOP
949: xProgress := 'GPOAOB-10-1665';
950: dbms_sql.define_column ( v_ALL_Cursor,
951: v_LoopCount,
952: v_ALL_Select,
953: ece_extract_utils_pub.G_MaxColWidth );
954: END LOOP;

Line 961: dbms_sql.bind_variable ( v_ORD_Cursor,

957: /* Bind the variables in the Order level SELECT clause. */
958: /* */
959:
960: xProgress := 'GPOAOB-10-1700';
961: dbms_sql.bind_variable ( v_ORD_Cursor,
962: 'ORGN_CODE',
963: v_Orgn_Code );
964:
965: If v_Order_No_From is not NULL Then

Line 967: dbms_sql.bind_variable ( v_ORD_Cursor,

963: v_Orgn_Code );
964:
965: If v_Order_No_From is not NULL Then
966: xProgress := 'GPOAOB-10-1701';
967: dbms_sql.bind_variable ( v_ORD_Cursor,
968: 'Order_No_From',
969: v_Order_No_From );
970: If v_Order_No_To is not NULL Then
971: xProgress := 'GPOAOB-10-1702';

Line 972: dbms_sql.bind_variable ( v_ORD_Cursor,

968: 'Order_No_From',
969: v_Order_No_From );
970: If v_Order_No_To is not NULL Then
971: xProgress := 'GPOAOB-10-1702';
972: dbms_sql.bind_variable ( v_ORD_Cursor,
973: 'Order_No_To',
974: v_Order_No_To );
975: End If;
976: End If;

Line 980: dbms_sql.bind_variable ( v_ORD_Cursor,

976: End If;
977:
978: If v_Creation_Date_From is not NULL Then
979: xProgress := 'GPOAOB-10-1703';
980: dbms_sql.bind_variable ( v_ORD_Cursor,
981: 'Creation_Date_From',
982: v_Creation_Date_From );
983: If v_Creation_Date_To is not NULL Then
984: xProgress := 'GPOAOB-10-1704';

Line 985: dbms_sql.bind_variable ( v_ORD_Cursor,

981: 'Creation_Date_From',
982: v_Creation_Date_From );
983: If v_Creation_Date_To is not NULL Then
984: xProgress := 'GPOAOB-10-1704';
985: dbms_sql.bind_variable ( v_ORD_Cursor,
986: 'Creation_Date_To',
987: v_Creation_Date_To );
988: End If;
989: End If;

Line 993: dbms_sql.bind_variable ( v_ORD_Cursor,

989: End If;
990:
991: If v_Customer_Name is not NULL Then
992: xProgress := 'GPOAOB-10-1705';
993: dbms_sql.bind_variable ( v_ORD_Cursor,
994: 'Customer_Name',
995: v_Customer_Name );
996: End If;
997:

Line 1003: v_Dummy := dbms_sql.execute ( v_ORD_Cursor );

999: /* Execute the Order level SELECT statement. */
1000: /* */
1001:
1002: xProgress := 'GPOAOB-10-1710';
1003: v_Dummy := dbms_sql.execute ( v_ORD_Cursor );
1004:
1005: /* */
1006: /* Begin the Order level loop. */
1007: /* */

Line 1010: WHILE dbms_sql.fetch_rows ( v_ORD_Cursor ) > 0

1006: /* Begin the Order level loop. */
1007: /* */
1008:
1009: xProgress := 'GPOAOB-10-1720';
1010: WHILE dbms_sql.fetch_rows ( v_ORD_Cursor ) > 0
1011: LOOP
1012:
1013: /* */
1014: /* Store the returned values in the PL/SQL table. */

Line 1021: dbms_sql.column_value ( v_ORD_Cursor,

1017: xProgress := 'GPOAOB-10-1730';
1018: FOR v_LoopCount IN 1..v_ORD_Count
1019: LOOP
1020: xProgress := 'GPOAOB-10-1740';
1021: dbms_sql.column_value ( v_ORD_Cursor,
1022: v_LoopCount,
1023: v_ORD_Table(v_LoopCount).value );
1024: END LOOP;
1025:

Line 1092: dbms_sql.bind_variable ( v_OAC_Cursor,

1088: /* Execute the Order Charges level SELECT statement. */
1089: /* */
1090:
1091: xProgress := 'GPOAOB-10-1754';
1092: dbms_sql.bind_variable ( v_OAC_Cursor,
1093: 'ORDER_ID',
1094: v_Order_ID );
1095:
1096: xProgress := 'GPOAOB-10-1840';

Line 1097: v_Dummy := dbms_sql.execute ( v_OAC_Cursor );

1093: 'ORDER_ID',
1094: v_Order_ID );
1095:
1096: xProgress := 'GPOAOB-10-1840';
1097: v_Dummy := dbms_sql.execute ( v_OAC_Cursor );
1098:
1099: /* */
1100: /* Begin the Order Charges level loop. */
1101: /* */

Line 1104: WHILE dbms_sql.fetch_rows ( v_OAC_Cursor ) > 0

1100: /* Begin the Order Charges level loop. */
1101: /* */
1102:
1103: xProgress := 'GPOAOB-10-1850';
1104: WHILE dbms_sql.fetch_rows ( v_OAC_Cursor ) > 0
1105: LOOP
1106:
1107: /* */
1108: /* Store the returned values in the PL/SQL table. */

Line 1115: dbms_sql.column_value ( v_OAC_Cursor,

1111: xProgress := 'GPOAOB-10-1860';
1112: FOR v_LoopCount IN 1..v_OAC_Count
1113: LOOP
1114: xProgress := 'GPOAOB-10-1870';
1115: dbms_sql.column_value ( v_OAC_Cursor,
1116: v_LoopCount,
1117: v_OAC_Table(v_LoopCount).value );
1118: END LOOP;
1119:

Line 1164: dbms_sql.bind_variable ( v_OTX_Cursor,

1160: /* Execute the Order Text level SELECT statement. */
1161: /* */
1162:
1163: xProgress := 'GPOAOB-10-1670';
1164: dbms_sql.bind_variable ( v_OTX_Cursor,
1165: 'ORDER_ID',
1166: v_Order_ID );
1167:
1168: xProgress := 'GPOAOB-10-1900';

Line 1169: v_Dummy := dbms_sql.execute ( v_OTX_Cursor );

1165: 'ORDER_ID',
1166: v_Order_ID );
1167:
1168: xProgress := 'GPOAOB-10-1900';
1169: v_Dummy := dbms_sql.execute ( v_OTX_Cursor );
1170:
1171: /* */
1172: /* Begin the Order Text level loop. */
1173: /* */

Line 1176: WHILE dbms_sql.fetch_rows ( v_OTX_Cursor ) > 0

1172: /* Begin the Order Text level loop. */
1173: /* */
1174:
1175: xProgress := 'GPOAOB-10-1910';
1176: WHILE dbms_sql.fetch_rows ( v_OTX_Cursor ) > 0
1177: LOOP
1178:
1179: /* */
1180: /* Store the returned values in the PL/SQL table. */

Line 1187: dbms_sql.column_value ( v_OTX_Cursor,

1183: xProgress := 'GPOAOB-10-1920';
1184: FOR v_LoopCount IN 1..v_OTX_Count
1185: LOOP
1186: xProgress := 'GPOAOB-10-1930';
1187: dbms_sql.column_value ( v_OTX_Cursor,
1188: v_LoopCount,
1189: v_OTX_Table(v_LoopCount).value );
1190: END LOOP;
1191:

Line 1232: dbms_sql.bind_variable ( v_DTL_Cursor,

1228:
1229: END LOOP; /* while otx */
1230:
1231: xProgress := 'GPOAOB-10-1970';
1232: dbms_sql.bind_variable ( v_DTL_Cursor,
1233: 'ORDER_ID',
1234: v_Order_ID );
1235: /* */
1236: /* Execute the Detail level SELECT statement. */

Line 1240: v_Dummy := dbms_sql.execute ( v_DTL_Cursor );

1236: /* Execute the Detail level SELECT statement. */
1237: /* */
1238:
1239: xProgress := 'GPOAOB-10-1980';
1240: v_Dummy := dbms_sql.execute ( v_DTL_Cursor );
1241:
1242: /* */
1243: /* Begin the Detail level loop. */
1244: /* */

Line 1247: WHILE dbms_sql.fetch_rows ( v_DTL_Cursor ) > 0

1243: /* Begin the Detail level loop. */
1244: /* */
1245:
1246: xProgress := 'GPOAOB-10-1990';
1247: WHILE dbms_sql.fetch_rows ( v_DTL_Cursor ) > 0
1248: LOOP
1249:
1250: /* */
1251: /* Store the returned values in the PL/SQL table. */

Line 1258: dbms_sql.column_value ( v_DTL_Cursor,

1254: xProgress := 'GPOAOB-10-2000';
1255: FOR v_LoopCount IN 1..v_DTL_Count
1256: LOOP
1257: xProgress := 'GPOAOB-10-2010';
1258: dbms_sql.column_value ( v_DTL_Cursor,
1259: v_LoopCount,
1260: v_DTL_Table(v_LoopCount).value );
1261: END LOOP;
1262:

Line 1330: dbms_sql.bind_variable ( v_DAC_Cursor,

1326: /* Execute the Detail Charges level SELECT statement. */
1327: /* */
1328:
1329: xProgress := 'GPOAOB-10-2040';
1330: dbms_sql.bind_variable ( v_DAC_Cursor,
1331: 'LINE_ID',
1332: v_Line_ID );
1333:
1334: xProgress := 'GPOAOB-10-2100';

Line 1335: v_Dummy := dbms_sql.execute ( v_DAC_Cursor );

1331: 'LINE_ID',
1332: v_Line_ID );
1333:
1334: xProgress := 'GPOAOB-10-2100';
1335: v_Dummy := dbms_sql.execute ( v_DAC_Cursor );
1336:
1337: /* */
1338: /* Begin the Detail Charges level loop. */
1339: /* */

Line 1341: WHILE dbms_sql.fetch_rows ( v_DAC_Cursor ) > 0

1337: /* */
1338: /* Begin the Detail Charges level loop. */
1339: /* */
1340: xProgress := 'GPOAOB-10-2110';
1341: WHILE dbms_sql.fetch_rows ( v_DAC_Cursor ) > 0
1342: LOOP
1343: /* */
1344: /* Store the returned values in the PL/SQL table. */
1345: /* */

Line 1351: dbms_sql.column_value ( v_DAC_Cursor,

1347: xProgress := 'GPOAOB-10-2120';
1348: FOR v_LoopCount IN 1..v_DAC_Count
1349: LOOP
1350: xProgress := 'GPOAOB-10-2130';
1351: dbms_sql.column_value ( v_DAC_Cursor,
1352: v_LoopCount,
1353: v_DAC_Table(v_LoopCount).value );
1354: END LOOP;
1355:

Line 1399: dbms_sql.bind_variable ( v_DTX_Cursor,

1395: /* Execute the Detail Text level SELECT statement. */
1396: /* */
1397:
1398: xProgress := 'GPOAOB-10-2160';
1399: dbms_sql.bind_variable ( v_DTX_Cursor,
1400: 'LINE_ID',
1401: v_Line_ID );
1402:
1403: xProgress := 'GPOAOB-10-2170';

Line 1404: v_Dummy := dbms_sql.execute ( v_DTX_Cursor );

1400: 'LINE_ID',
1401: v_Line_ID );
1402:
1403: xProgress := 'GPOAOB-10-2170';
1404: v_Dummy := dbms_sql.execute ( v_DTX_Cursor );
1405:
1406: /* */
1407: /* Begin the Detail Text level loop. */
1408: /* */

Line 1411: WHILE dbms_sql.fetch_rows ( v_DTX_Cursor ) > 0

1407: /* Begin the Detail Text level loop. */
1408: /* */
1409:
1410: xProgress := 'GPOAOB-10-2180';
1411: WHILE dbms_sql.fetch_rows ( v_DTX_Cursor ) > 0
1412: LOOP
1413:
1414: /* */
1415: /* Store the returned values in the PL/SQL table. */

Line 1422: dbms_sql.column_value ( v_DTX_Cursor,

1418: xProgress := 'GPOAOB-10-2190';
1419: FOR v_LoopCount IN 1..v_DTX_Count
1420: LOOP
1421: xProgress := 'GPOAOB-10-2200';
1422: dbms_sql.column_value ( v_DTX_Cursor,
1423: v_LoopCount,
1424: v_DTX_Table(v_LoopCount).value );
1425: END LOOP;
1426:

Line 1469: dbms_sql.bind_variable ( v_ALL_Cursor,

1465: /* Execute the Allocations level SELECT statement. */
1466: /* */
1467:
1468: xProgress := 'GPOAOB-10-2160';
1469: dbms_sql.bind_variable ( v_ALL_Cursor,
1470: 'LINE_ID',
1471: v_Line_ID );
1472:
1473: xProgress := 'GPOAOB-10-2170';

Line 1474: v_Dummy := dbms_sql.execute ( v_ALL_Cursor );

1470: 'LINE_ID',
1471: v_Line_ID );
1472:
1473: xProgress := 'GPOAOB-10-2170';
1474: v_Dummy := dbms_sql.execute ( v_ALL_Cursor );
1475:
1476: /* */
1477: /* Begin the Allocations level loop. */
1478: /* */

Line 1480: WHILE dbms_sql.fetch_rows ( v_ALL_Cursor ) > 0

1476: /* */
1477: /* Begin the Allocations level loop. */
1478: /* */
1479: xProgress := 'GPOAOB-10-2180';
1480: WHILE dbms_sql.fetch_rows ( v_ALL_Cursor ) > 0
1481: LOOP
1482:
1483: /* */
1484: /* Store the returned values in the PL/SQL table. */

Line 1491: dbms_sql.column_value ( v_ALL_Cursor,

1487: xProgress := 'GPOAOB-10-2190';
1488: FOR v_LoopCount IN 1..v_ALL_Count
1489: LOOP
1490: xProgress := 'GPOAOB-10-2200';
1491: dbms_sql.column_value ( v_ALL_Cursor,
1492: v_LoopCount,
1493: v_ALL_Table(v_LoopCount).value );
1494: END LOOP;
1495:

Line 1567: dbms_sql.close_cursor ( v_ORD_Cursor );

1563: /* Close all open cursors. */
1564: /* */
1565:
1566: xProgress := 'GPOAOB-10-2310';
1567: dbms_sql.close_cursor ( v_ORD_Cursor );
1568: xProgress := 'GPOAOB-10-2310';
1569: dbms_sql.close_cursor ( v_OAC_Cursor );
1570: xProgress := 'GPOAOB-10-2310';
1571: dbms_sql.close_cursor ( v_OTX_Cursor );

Line 1569: dbms_sql.close_cursor ( v_OAC_Cursor );

1565:
1566: xProgress := 'GPOAOB-10-2310';
1567: dbms_sql.close_cursor ( v_ORD_Cursor );
1568: xProgress := 'GPOAOB-10-2310';
1569: dbms_sql.close_cursor ( v_OAC_Cursor );
1570: xProgress := 'GPOAOB-10-2310';
1571: dbms_sql.close_cursor ( v_OTX_Cursor );
1572: xProgress := 'GPOAOB-10-2310';
1573: dbms_sql.close_cursor ( v_DTL_Cursor );

Line 1571: dbms_sql.close_cursor ( v_OTX_Cursor );

1567: dbms_sql.close_cursor ( v_ORD_Cursor );
1568: xProgress := 'GPOAOB-10-2310';
1569: dbms_sql.close_cursor ( v_OAC_Cursor );
1570: xProgress := 'GPOAOB-10-2310';
1571: dbms_sql.close_cursor ( v_OTX_Cursor );
1572: xProgress := 'GPOAOB-10-2310';
1573: dbms_sql.close_cursor ( v_DTL_Cursor );
1574: xProgress := 'GPOAOB-10-2310';
1575: dbms_sql.close_cursor ( v_DAC_Cursor );

Line 1573: dbms_sql.close_cursor ( v_DTL_Cursor );

1569: dbms_sql.close_cursor ( v_OAC_Cursor );
1570: xProgress := 'GPOAOB-10-2310';
1571: dbms_sql.close_cursor ( v_OTX_Cursor );
1572: xProgress := 'GPOAOB-10-2310';
1573: dbms_sql.close_cursor ( v_DTL_Cursor );
1574: xProgress := 'GPOAOB-10-2310';
1575: dbms_sql.close_cursor ( v_DAC_Cursor );
1576: xProgress := 'GPOAOB-10-2310';
1577: dbms_sql.close_cursor ( v_DTX_Cursor );

Line 1575: dbms_sql.close_cursor ( v_DAC_Cursor );

1571: dbms_sql.close_cursor ( v_OTX_Cursor );
1572: xProgress := 'GPOAOB-10-2310';
1573: dbms_sql.close_cursor ( v_DTL_Cursor );
1574: xProgress := 'GPOAOB-10-2310';
1575: dbms_sql.close_cursor ( v_DAC_Cursor );
1576: xProgress := 'GPOAOB-10-2310';
1577: dbms_sql.close_cursor ( v_DTX_Cursor );
1578: xProgress := 'GPOAOB-10-2310';
1579: dbms_sql.close_cursor ( v_ALL_Cursor );

Line 1577: dbms_sql.close_cursor ( v_DTX_Cursor );

1573: dbms_sql.close_cursor ( v_DTL_Cursor );
1574: xProgress := 'GPOAOB-10-2310';
1575: dbms_sql.close_cursor ( v_DAC_Cursor );
1576: xProgress := 'GPOAOB-10-2310';
1577: dbms_sql.close_cursor ( v_DTX_Cursor );
1578: xProgress := 'GPOAOB-10-2310';
1579: dbms_sql.close_cursor ( v_ALL_Cursor );
1580:
1581: EXCEPTION

Line 1579: dbms_sql.close_cursor ( v_ALL_Cursor );

1575: dbms_sql.close_cursor ( v_DAC_Cursor );
1576: xProgress := 'GPOAOB-10-2310';
1577: dbms_sql.close_cursor ( v_DTX_Cursor );
1578: xProgress := 'GPOAOB-10-2310';
1579: dbms_sql.close_cursor ( v_ALL_Cursor );
1580:
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: ec_debug.pl ( 0,

Line 2162: v_ORD_Select_Cursor := dbms_sql.open_cursor;

2158: /* SELECT and DELETE statements. */
2159: /* */
2160:
2161: xProgress := 'GPOAOB-40-1120';
2162: v_ORD_Select_Cursor := dbms_sql.open_cursor;
2163: xProgress := 'GPOAOB-40-1122';
2164: v_OAC_Select_Cursor := dbms_sql.open_cursor;
2165: xProgress := 'GPOAOB-40-1124';
2166: v_OTX_Select_Cursor := dbms_sql.open_cursor;

Line 2164: v_OAC_Select_Cursor := dbms_sql.open_cursor;

2160:
2161: xProgress := 'GPOAOB-40-1120';
2162: v_ORD_Select_Cursor := dbms_sql.open_cursor;
2163: xProgress := 'GPOAOB-40-1122';
2164: v_OAC_Select_Cursor := dbms_sql.open_cursor;
2165: xProgress := 'GPOAOB-40-1124';
2166: v_OTX_Select_Cursor := dbms_sql.open_cursor;
2167: xProgress := 'GPOAOB-40-1126';
2168: v_DTL_Select_Cursor := dbms_sql.open_cursor;

Line 2166: v_OTX_Select_Cursor := dbms_sql.open_cursor;

2162: v_ORD_Select_Cursor := dbms_sql.open_cursor;
2163: xProgress := 'GPOAOB-40-1122';
2164: v_OAC_Select_Cursor := dbms_sql.open_cursor;
2165: xProgress := 'GPOAOB-40-1124';
2166: v_OTX_Select_Cursor := dbms_sql.open_cursor;
2167: xProgress := 'GPOAOB-40-1126';
2168: v_DTL_Select_Cursor := dbms_sql.open_cursor;
2169: xProgress := 'GPOAOB-40-1128';
2170: v_DAC_Select_Cursor := dbms_sql.open_cursor;

Line 2168: v_DTL_Select_Cursor := dbms_sql.open_cursor;

2164: v_OAC_Select_Cursor := dbms_sql.open_cursor;
2165: xProgress := 'GPOAOB-40-1124';
2166: v_OTX_Select_Cursor := dbms_sql.open_cursor;
2167: xProgress := 'GPOAOB-40-1126';
2168: v_DTL_Select_Cursor := dbms_sql.open_cursor;
2169: xProgress := 'GPOAOB-40-1128';
2170: v_DAC_Select_Cursor := dbms_sql.open_cursor;
2171: xProgress := 'GPOAOB-40-1130';
2172: v_DTX_Select_Cursor := dbms_sql.open_cursor;

Line 2170: v_DAC_Select_Cursor := dbms_sql.open_cursor;

2166: v_OTX_Select_Cursor := dbms_sql.open_cursor;
2167: xProgress := 'GPOAOB-40-1126';
2168: v_DTL_Select_Cursor := dbms_sql.open_cursor;
2169: xProgress := 'GPOAOB-40-1128';
2170: v_DAC_Select_Cursor := dbms_sql.open_cursor;
2171: xProgress := 'GPOAOB-40-1130';
2172: v_DTX_Select_Cursor := dbms_sql.open_cursor;
2173: xProgress := 'GPOAOB-40-1132';
2174: v_ALL_Select_Cursor := dbms_sql.open_cursor;

Line 2172: v_DTX_Select_Cursor := dbms_sql.open_cursor;

2168: v_DTL_Select_Cursor := dbms_sql.open_cursor;
2169: xProgress := 'GPOAOB-40-1128';
2170: v_DAC_Select_Cursor := dbms_sql.open_cursor;
2171: xProgress := 'GPOAOB-40-1130';
2172: v_DTX_Select_Cursor := dbms_sql.open_cursor;
2173: xProgress := 'GPOAOB-40-1132';
2174: v_ALL_Select_Cursor := dbms_sql.open_cursor;
2175:
2176: xProgress := 'GPOAOB-40-1134';

Line 2174: v_ALL_Select_Cursor := dbms_sql.open_cursor;

2170: v_DAC_Select_Cursor := dbms_sql.open_cursor;
2171: xProgress := 'GPOAOB-40-1130';
2172: v_DTX_Select_Cursor := dbms_sql.open_cursor;
2173: xProgress := 'GPOAOB-40-1132';
2174: v_ALL_Select_Cursor := dbms_sql.open_cursor;
2175:
2176: xProgress := 'GPOAOB-40-1134';
2177: v_ORD_Delete_Cursor := dbms_sql.open_cursor;
2178: xProgress := 'GPOAOB-40-1136';

Line 2177: v_ORD_Delete_Cursor := dbms_sql.open_cursor;

2173: xProgress := 'GPOAOB-40-1132';
2174: v_ALL_Select_Cursor := dbms_sql.open_cursor;
2175:
2176: xProgress := 'GPOAOB-40-1134';
2177: v_ORD_Delete_Cursor := dbms_sql.open_cursor;
2178: xProgress := 'GPOAOB-40-1136';
2179: v_OAC_Delete_Cursor := dbms_sql.open_cursor;
2180: xProgress := 'GPOAOB-40-1138';
2181: v_OTX_Delete_Cursor := dbms_sql.open_cursor;

Line 2179: v_OAC_Delete_Cursor := dbms_sql.open_cursor;

2175:
2176: xProgress := 'GPOAOB-40-1134';
2177: v_ORD_Delete_Cursor := dbms_sql.open_cursor;
2178: xProgress := 'GPOAOB-40-1136';
2179: v_OAC_Delete_Cursor := dbms_sql.open_cursor;
2180: xProgress := 'GPOAOB-40-1138';
2181: v_OTX_Delete_Cursor := dbms_sql.open_cursor;
2182: xProgress := 'GPOAOB-40-1140';
2183: v_DTL_Delete_Cursor := dbms_sql.open_cursor;

Line 2181: v_OTX_Delete_Cursor := dbms_sql.open_cursor;

2177: v_ORD_Delete_Cursor := dbms_sql.open_cursor;
2178: xProgress := 'GPOAOB-40-1136';
2179: v_OAC_Delete_Cursor := dbms_sql.open_cursor;
2180: xProgress := 'GPOAOB-40-1138';
2181: v_OTX_Delete_Cursor := dbms_sql.open_cursor;
2182: xProgress := 'GPOAOB-40-1140';
2183: v_DTL_Delete_Cursor := dbms_sql.open_cursor;
2184: xProgress := 'GPOAOB-40-1142';
2185: v_DAC_Delete_Cursor := dbms_sql.open_cursor;

Line 2183: v_DTL_Delete_Cursor := dbms_sql.open_cursor;

2179: v_OAC_Delete_Cursor := dbms_sql.open_cursor;
2180: xProgress := 'GPOAOB-40-1138';
2181: v_OTX_Delete_Cursor := dbms_sql.open_cursor;
2182: xProgress := 'GPOAOB-40-1140';
2183: v_DTL_Delete_Cursor := dbms_sql.open_cursor;
2184: xProgress := 'GPOAOB-40-1142';
2185: v_DAC_Delete_Cursor := dbms_sql.open_cursor;
2186: xProgress := 'GPOAOB-40-1144';
2187: v_DTX_Delete_Cursor := dbms_sql.open_cursor;

Line 2185: v_DAC_Delete_Cursor := dbms_sql.open_cursor;

2181: v_OTX_Delete_Cursor := dbms_sql.open_cursor;
2182: xProgress := 'GPOAOB-40-1140';
2183: v_DTL_Delete_Cursor := dbms_sql.open_cursor;
2184: xProgress := 'GPOAOB-40-1142';
2185: v_DAC_Delete_Cursor := dbms_sql.open_cursor;
2186: xProgress := 'GPOAOB-40-1144';
2187: v_DTX_Delete_Cursor := dbms_sql.open_cursor;
2188: xProgress := 'GPOAOB-40-1146';
2189: v_ALL_Delete_Cursor := dbms_sql.open_cursor;

Line 2187: v_DTX_Delete_Cursor := dbms_sql.open_cursor;

2183: v_DTL_Delete_Cursor := dbms_sql.open_cursor;
2184: xProgress := 'GPOAOB-40-1142';
2185: v_DAC_Delete_Cursor := dbms_sql.open_cursor;
2186: xProgress := 'GPOAOB-40-1144';
2187: v_DTX_Delete_Cursor := dbms_sql.open_cursor;
2188: xProgress := 'GPOAOB-40-1146';
2189: v_ALL_Delete_Cursor := dbms_sql.open_cursor;
2190:
2191: xProgress := 'GPOAOB-40-1148';

Line 2189: v_ALL_Delete_Cursor := dbms_sql.open_cursor;

2185: v_DAC_Delete_Cursor := dbms_sql.open_cursor;
2186: xProgress := 'GPOAOB-40-1144';
2187: v_DTX_Delete_Cursor := dbms_sql.open_cursor;
2188: xProgress := 'GPOAOB-40-1146';
2189: v_ALL_Delete_Cursor := dbms_sql.open_cursor;
2190:
2191: xProgress := 'GPOAOB-40-1148';
2192: v_ORD_Delete_XCursor := dbms_sql.open_cursor;
2193: xProgress := 'GPOAOB-40-1150';

Line 2192: v_ORD_Delete_XCursor := dbms_sql.open_cursor;

2188: xProgress := 'GPOAOB-40-1146';
2189: v_ALL_Delete_Cursor := dbms_sql.open_cursor;
2190:
2191: xProgress := 'GPOAOB-40-1148';
2192: v_ORD_Delete_XCursor := dbms_sql.open_cursor;
2193: xProgress := 'GPOAOB-40-1150';
2194: v_OAC_Delete_XCursor := dbms_sql.open_cursor;
2195: xProgress := 'GPOAOB-40-1152';
2196: v_OTX_Delete_XCursor := dbms_sql.open_cursor;

Line 2194: v_OAC_Delete_XCursor := dbms_sql.open_cursor;

2190:
2191: xProgress := 'GPOAOB-40-1148';
2192: v_ORD_Delete_XCursor := dbms_sql.open_cursor;
2193: xProgress := 'GPOAOB-40-1150';
2194: v_OAC_Delete_XCursor := dbms_sql.open_cursor;
2195: xProgress := 'GPOAOB-40-1152';
2196: v_OTX_Delete_XCursor := dbms_sql.open_cursor;
2197: xProgress := 'GPOAOB-40-1154';
2198: v_DTL_Delete_XCursor := dbms_sql.open_cursor;

Line 2196: v_OTX_Delete_XCursor := dbms_sql.open_cursor;

2192: v_ORD_Delete_XCursor := dbms_sql.open_cursor;
2193: xProgress := 'GPOAOB-40-1150';
2194: v_OAC_Delete_XCursor := dbms_sql.open_cursor;
2195: xProgress := 'GPOAOB-40-1152';
2196: v_OTX_Delete_XCursor := dbms_sql.open_cursor;
2197: xProgress := 'GPOAOB-40-1154';
2198: v_DTL_Delete_XCursor := dbms_sql.open_cursor;
2199: xProgress := 'GPOAOB-40-1156';
2200: v_DAC_Delete_XCursor := dbms_sql.open_cursor;

Line 2198: v_DTL_Delete_XCursor := dbms_sql.open_cursor;

2194: v_OAC_Delete_XCursor := dbms_sql.open_cursor;
2195: xProgress := 'GPOAOB-40-1152';
2196: v_OTX_Delete_XCursor := dbms_sql.open_cursor;
2197: xProgress := 'GPOAOB-40-1154';
2198: v_DTL_Delete_XCursor := dbms_sql.open_cursor;
2199: xProgress := 'GPOAOB-40-1156';
2200: v_DAC_Delete_XCursor := dbms_sql.open_cursor;
2201: xProgress := 'GPOAOB-40-1158';
2202: v_DTX_Delete_XCursor := dbms_sql.open_cursor;

Line 2200: v_DAC_Delete_XCursor := dbms_sql.open_cursor;

2196: v_OTX_Delete_XCursor := dbms_sql.open_cursor;
2197: xProgress := 'GPOAOB-40-1154';
2198: v_DTL_Delete_XCursor := dbms_sql.open_cursor;
2199: xProgress := 'GPOAOB-40-1156';
2200: v_DAC_Delete_XCursor := dbms_sql.open_cursor;
2201: xProgress := 'GPOAOB-40-1158';
2202: v_DTX_Delete_XCursor := dbms_sql.open_cursor;
2203: xProgress := 'GPOAOB-40-1160';
2204: v_ALL_Delete_XCursor := dbms_sql.open_cursor;

Line 2202: v_DTX_Delete_XCursor := dbms_sql.open_cursor;

2198: v_DTL_Delete_XCursor := dbms_sql.open_cursor;
2199: xProgress := 'GPOAOB-40-1156';
2200: v_DAC_Delete_XCursor := dbms_sql.open_cursor;
2201: xProgress := 'GPOAOB-40-1158';
2202: v_DTX_Delete_XCursor := dbms_sql.open_cursor;
2203: xProgress := 'GPOAOB-40-1160';
2204: v_ALL_Delete_XCursor := dbms_sql.open_cursor;
2205:
2206: /* */

Line 2204: v_ALL_Delete_XCursor := dbms_sql.open_cursor;

2200: v_DAC_Delete_XCursor := dbms_sql.open_cursor;
2201: xProgress := 'GPOAOB-40-1158';
2202: v_DTX_Delete_XCursor := dbms_sql.open_cursor;
2203: xProgress := 'GPOAOB-40-1160';
2204: v_ALL_Delete_XCursor := dbms_sql.open_cursor;
2205:
2206: /* */
2207: /* Parse each SELECT and DELETE statement so the database understands */
2208: /* the command. */

Line 2212: dbms_sql.parse ( v_ORD_Select_Cursor,

2208: /* the command. */
2209: /* */
2210:
2211: xProgress := 'GPOAOB-40-1170';
2212: dbms_sql.parse ( v_ORD_Select_Cursor,
2213: v_ORD_Select,
2214: dbms_sql.native );
2215:
2216: xProgress := 'GPOAOB-40-1171';

Line 2214: dbms_sql.native );

2210:
2211: xProgress := 'GPOAOB-40-1170';
2212: dbms_sql.parse ( v_ORD_Select_Cursor,
2213: v_ORD_Select,
2214: dbms_sql.native );
2215:
2216: xProgress := 'GPOAOB-40-1171';
2217: dbms_sql.parse ( v_OAC_Select_Cursor,
2218: v_OAC_Select,

Line 2217: dbms_sql.parse ( v_OAC_Select_Cursor,

2213: v_ORD_Select,
2214: dbms_sql.native );
2215:
2216: xProgress := 'GPOAOB-40-1171';
2217: dbms_sql.parse ( v_OAC_Select_Cursor,
2218: v_OAC_Select,
2219: dbms_sql.native );
2220:
2221: xProgress := 'GPOAOB-40-1172';

Line 2219: dbms_sql.native );

2215:
2216: xProgress := 'GPOAOB-40-1171';
2217: dbms_sql.parse ( v_OAC_Select_Cursor,
2218: v_OAC_Select,
2219: dbms_sql.native );
2220:
2221: xProgress := 'GPOAOB-40-1172';
2222: dbms_sql.parse ( v_OTX_Select_Cursor,
2223: v_OTX_Select,

Line 2222: dbms_sql.parse ( v_OTX_Select_Cursor,

2218: v_OAC_Select,
2219: dbms_sql.native );
2220:
2221: xProgress := 'GPOAOB-40-1172';
2222: dbms_sql.parse ( v_OTX_Select_Cursor,
2223: v_OTX_Select,
2224: dbms_sql.native );
2225:
2226: xProgress := 'GPOAOB-40-1173';

Line 2224: dbms_sql.native );

2220:
2221: xProgress := 'GPOAOB-40-1172';
2222: dbms_sql.parse ( v_OTX_Select_Cursor,
2223: v_OTX_Select,
2224: dbms_sql.native );
2225:
2226: xProgress := 'GPOAOB-40-1173';
2227: dbms_sql.parse ( v_DTL_Select_Cursor,
2228: v_DTL_Select,

Line 2227: dbms_sql.parse ( v_DTL_Select_Cursor,

2223: v_OTX_Select,
2224: dbms_sql.native );
2225:
2226: xProgress := 'GPOAOB-40-1173';
2227: dbms_sql.parse ( v_DTL_Select_Cursor,
2228: v_DTL_Select,
2229: dbms_sql.native );
2230:
2231: xProgress := 'GPOAOB-40-1174';

Line 2229: dbms_sql.native );

2225:
2226: xProgress := 'GPOAOB-40-1173';
2227: dbms_sql.parse ( v_DTL_Select_Cursor,
2228: v_DTL_Select,
2229: dbms_sql.native );
2230:
2231: xProgress := 'GPOAOB-40-1174';
2232: dbms_sql.parse ( v_DAC_Select_Cursor,
2233: v_DAC_Select,

Line 2232: dbms_sql.parse ( v_DAC_Select_Cursor,

2228: v_DTL_Select,
2229: dbms_sql.native );
2230:
2231: xProgress := 'GPOAOB-40-1174';
2232: dbms_sql.parse ( v_DAC_Select_Cursor,
2233: v_DAC_Select,
2234: dbms_sql.native );
2235:
2236: xProgress := 'GPOAOB-40-1175';

Line 2234: dbms_sql.native );

2230:
2231: xProgress := 'GPOAOB-40-1174';
2232: dbms_sql.parse ( v_DAC_Select_Cursor,
2233: v_DAC_Select,
2234: dbms_sql.native );
2235:
2236: xProgress := 'GPOAOB-40-1175';
2237: dbms_sql.parse ( v_DTX_Select_Cursor,
2238: v_DTX_Select,

Line 2237: dbms_sql.parse ( v_DTX_Select_Cursor,

2233: v_DAC_Select,
2234: dbms_sql.native );
2235:
2236: xProgress := 'GPOAOB-40-1175';
2237: dbms_sql.parse ( v_DTX_Select_Cursor,
2238: v_DTX_Select,
2239: dbms_sql.native );
2240:
2241: xProgress := 'GPOAOB-40-1176';

Line 2239: dbms_sql.native );

2235:
2236: xProgress := 'GPOAOB-40-1175';
2237: dbms_sql.parse ( v_DTX_Select_Cursor,
2238: v_DTX_Select,
2239: dbms_sql.native );
2240:
2241: xProgress := 'GPOAOB-40-1176';
2242: dbms_sql.parse ( v_ALL_Select_Cursor,
2243: v_ALL_Select,

Line 2242: dbms_sql.parse ( v_ALL_Select_Cursor,

2238: v_DTX_Select,
2239: dbms_sql.native );
2240:
2241: xProgress := 'GPOAOB-40-1176';
2242: dbms_sql.parse ( v_ALL_Select_Cursor,
2243: v_ALL_Select,
2244: dbms_sql.native );
2245:
2246: xProgress := 'GPOAOB-40-1180';

Line 2244: dbms_sql.native );

2240:
2241: xProgress := 'GPOAOB-40-1176';
2242: dbms_sql.parse ( v_ALL_Select_Cursor,
2243: v_ALL_Select,
2244: dbms_sql.native );
2245:
2246: xProgress := 'GPOAOB-40-1180';
2247: dbms_sql.parse ( v_ORD_Delete_Cursor,
2248: v_ORD_Delete,

Line 2247: dbms_sql.parse ( v_ORD_Delete_Cursor,

2243: v_ALL_Select,
2244: dbms_sql.native );
2245:
2246: xProgress := 'GPOAOB-40-1180';
2247: dbms_sql.parse ( v_ORD_Delete_Cursor,
2248: v_ORD_Delete,
2249: dbms_sql.native );
2250:
2251: xProgress := 'GPOAOB-40-1181';

Line 2249: dbms_sql.native );

2245:
2246: xProgress := 'GPOAOB-40-1180';
2247: dbms_sql.parse ( v_ORD_Delete_Cursor,
2248: v_ORD_Delete,
2249: dbms_sql.native );
2250:
2251: xProgress := 'GPOAOB-40-1181';
2252: dbms_sql.parse ( v_OAC_Delete_Cursor,
2253: v_OAC_Delete,

Line 2252: dbms_sql.parse ( v_OAC_Delete_Cursor,

2248: v_ORD_Delete,
2249: dbms_sql.native );
2250:
2251: xProgress := 'GPOAOB-40-1181';
2252: dbms_sql.parse ( v_OAC_Delete_Cursor,
2253: v_OAC_Delete,
2254: dbms_sql.native );
2255:
2256: xProgress := 'GPOAOB-40-1182';

Line 2254: dbms_sql.native );

2250:
2251: xProgress := 'GPOAOB-40-1181';
2252: dbms_sql.parse ( v_OAC_Delete_Cursor,
2253: v_OAC_Delete,
2254: dbms_sql.native );
2255:
2256: xProgress := 'GPOAOB-40-1182';
2257: dbms_sql.parse ( v_OTX_Delete_Cursor,
2258: v_OTX_Delete,

Line 2257: dbms_sql.parse ( v_OTX_Delete_Cursor,

2253: v_OAC_Delete,
2254: dbms_sql.native );
2255:
2256: xProgress := 'GPOAOB-40-1182';
2257: dbms_sql.parse ( v_OTX_Delete_Cursor,
2258: v_OTX_Delete,
2259: dbms_sql.native );
2260:
2261: xProgress := 'GPOAOB-40-1183';

Line 2259: dbms_sql.native );

2255:
2256: xProgress := 'GPOAOB-40-1182';
2257: dbms_sql.parse ( v_OTX_Delete_Cursor,
2258: v_OTX_Delete,
2259: dbms_sql.native );
2260:
2261: xProgress := 'GPOAOB-40-1183';
2262: dbms_sql.parse ( v_DTL_Delete_Cursor,
2263: v_DTL_Delete,

Line 2262: dbms_sql.parse ( v_DTL_Delete_Cursor,

2258: v_OTX_Delete,
2259: dbms_sql.native );
2260:
2261: xProgress := 'GPOAOB-40-1183';
2262: dbms_sql.parse ( v_DTL_Delete_Cursor,
2263: v_DTL_Delete,
2264: dbms_sql.native );
2265:
2266: xProgress := 'GPOAOB-40-1184';

Line 2264: dbms_sql.native );

2260:
2261: xProgress := 'GPOAOB-40-1183';
2262: dbms_sql.parse ( v_DTL_Delete_Cursor,
2263: v_DTL_Delete,
2264: dbms_sql.native );
2265:
2266: xProgress := 'GPOAOB-40-1184';
2267: dbms_sql.parse ( v_DAC_Delete_Cursor,
2268: v_DAC_Delete,

Line 2267: dbms_sql.parse ( v_DAC_Delete_Cursor,

2263: v_DTL_Delete,
2264: dbms_sql.native );
2265:
2266: xProgress := 'GPOAOB-40-1184';
2267: dbms_sql.parse ( v_DAC_Delete_Cursor,
2268: v_DAC_Delete,
2269: dbms_sql.native );
2270:
2271: xProgress := 'GPOAOB-40-1185';

Line 2269: dbms_sql.native );

2265:
2266: xProgress := 'GPOAOB-40-1184';
2267: dbms_sql.parse ( v_DAC_Delete_Cursor,
2268: v_DAC_Delete,
2269: dbms_sql.native );
2270:
2271: xProgress := 'GPOAOB-40-1185';
2272: dbms_sql.parse ( v_DTX_Delete_Cursor,
2273: v_DTX_Delete,

Line 2272: dbms_sql.parse ( v_DTX_Delete_Cursor,

2268: v_DAC_Delete,
2269: dbms_sql.native );
2270:
2271: xProgress := 'GPOAOB-40-1185';
2272: dbms_sql.parse ( v_DTX_Delete_Cursor,
2273: v_DTX_Delete,
2274: dbms_sql.native );
2275:
2276: xProgress := 'GPOAOB-40-1186';

Line 2274: dbms_sql.native );

2270:
2271: xProgress := 'GPOAOB-40-1185';
2272: dbms_sql.parse ( v_DTX_Delete_Cursor,
2273: v_DTX_Delete,
2274: dbms_sql.native );
2275:
2276: xProgress := 'GPOAOB-40-1186';
2277: dbms_sql.parse ( v_ALL_Delete_Cursor,
2278: v_ALL_Delete,

Line 2277: dbms_sql.parse ( v_ALL_Delete_Cursor,

2273: v_DTX_Delete,
2274: dbms_sql.native );
2275:
2276: xProgress := 'GPOAOB-40-1186';
2277: dbms_sql.parse ( v_ALL_Delete_Cursor,
2278: v_ALL_Delete,
2279: dbms_sql.native );
2280:
2281: xProgress := 'GPOAOB-40-1190';

Line 2279: dbms_sql.native );

2275:
2276: xProgress := 'GPOAOB-40-1186';
2277: dbms_sql.parse ( v_ALL_Delete_Cursor,
2278: v_ALL_Delete,
2279: dbms_sql.native );
2280:
2281: xProgress := 'GPOAOB-40-1190';
2282: dbms_sql.parse ( v_ORD_Delete_XCursor,
2283: v_ORD_Delete,

Line 2282: dbms_sql.parse ( v_ORD_Delete_XCursor,

2278: v_ALL_Delete,
2279: dbms_sql.native );
2280:
2281: xProgress := 'GPOAOB-40-1190';
2282: dbms_sql.parse ( v_ORD_Delete_XCursor,
2283: v_ORD_Delete,
2284: dbms_sql.native );
2285:
2286: xProgress := 'GPOAOB-40-1191';

Line 2284: dbms_sql.native );

2280:
2281: xProgress := 'GPOAOB-40-1190';
2282: dbms_sql.parse ( v_ORD_Delete_XCursor,
2283: v_ORD_Delete,
2284: dbms_sql.native );
2285:
2286: xProgress := 'GPOAOB-40-1191';
2287: dbms_sql.parse ( v_OAC_Delete_XCursor,
2288: v_OAC_Delete,

Line 2287: dbms_sql.parse ( v_OAC_Delete_XCursor,

2283: v_ORD_Delete,
2284: dbms_sql.native );
2285:
2286: xProgress := 'GPOAOB-40-1191';
2287: dbms_sql.parse ( v_OAC_Delete_XCursor,
2288: v_OAC_Delete,
2289: dbms_sql.native );
2290:
2291: xProgress := 'GPOAOB-40-1192';

Line 2289: dbms_sql.native );

2285:
2286: xProgress := 'GPOAOB-40-1191';
2287: dbms_sql.parse ( v_OAC_Delete_XCursor,
2288: v_OAC_Delete,
2289: dbms_sql.native );
2290:
2291: xProgress := 'GPOAOB-40-1192';
2292: dbms_sql.parse ( v_OTX_Delete_XCursor,
2293: v_OTX_Delete,

Line 2292: dbms_sql.parse ( v_OTX_Delete_XCursor,

2288: v_OAC_Delete,
2289: dbms_sql.native );
2290:
2291: xProgress := 'GPOAOB-40-1192';
2292: dbms_sql.parse ( v_OTX_Delete_XCursor,
2293: v_OTX_Delete,
2294: dbms_sql.native );
2295:
2296: xProgress := 'GPOAOB-40-1193';

Line 2294: dbms_sql.native );

2290:
2291: xProgress := 'GPOAOB-40-1192';
2292: dbms_sql.parse ( v_OTX_Delete_XCursor,
2293: v_OTX_Delete,
2294: dbms_sql.native );
2295:
2296: xProgress := 'GPOAOB-40-1193';
2297: dbms_sql.parse ( v_DTL_Delete_XCursor,
2298: v_DTL_Delete,

Line 2297: dbms_sql.parse ( v_DTL_Delete_XCursor,

2293: v_OTX_Delete,
2294: dbms_sql.native );
2295:
2296: xProgress := 'GPOAOB-40-1193';
2297: dbms_sql.parse ( v_DTL_Delete_XCursor,
2298: v_DTL_Delete,
2299: dbms_sql.native );
2300:
2301: xProgress := 'GPOAOB-40-1194';

Line 2299: dbms_sql.native );

2295:
2296: xProgress := 'GPOAOB-40-1193';
2297: dbms_sql.parse ( v_DTL_Delete_XCursor,
2298: v_DTL_Delete,
2299: dbms_sql.native );
2300:
2301: xProgress := 'GPOAOB-40-1194';
2302: dbms_sql.parse ( v_DAC_Delete_XCursor,
2303: v_DAC_Delete,

Line 2302: dbms_sql.parse ( v_DAC_Delete_XCursor,

2298: v_DTL_Delete,
2299: dbms_sql.native );
2300:
2301: xProgress := 'GPOAOB-40-1194';
2302: dbms_sql.parse ( v_DAC_Delete_XCursor,
2303: v_DAC_Delete,
2304: dbms_sql.native );
2305:
2306: xProgress := 'GPOAOB-40-1195';

Line 2304: dbms_sql.native );

2300:
2301: xProgress := 'GPOAOB-40-1194';
2302: dbms_sql.parse ( v_DAC_Delete_XCursor,
2303: v_DAC_Delete,
2304: dbms_sql.native );
2305:
2306: xProgress := 'GPOAOB-40-1195';
2307: dbms_sql.parse ( v_DTX_Delete_XCursor,
2308: v_DTX_Delete,

Line 2307: dbms_sql.parse ( v_DTX_Delete_XCursor,

2303: v_DAC_Delete,
2304: dbms_sql.native );
2305:
2306: xProgress := 'GPOAOB-40-1195';
2307: dbms_sql.parse ( v_DTX_Delete_XCursor,
2308: v_DTX_Delete,
2309: dbms_sql.native );
2310:
2311: xProgress := 'GPOAOB-40-1196';

Line 2309: dbms_sql.native );

2305:
2306: xProgress := 'GPOAOB-40-1195';
2307: dbms_sql.parse ( v_DTX_Delete_XCursor,
2308: v_DTX_Delete,
2309: dbms_sql.native );
2310:
2311: xProgress := 'GPOAOB-40-1196';
2312: dbms_sql.parse ( v_ALL_Delete_XCursor,
2313: v_ALL_Delete,

Line 2312: dbms_sql.parse ( v_ALL_Delete_XCursor,

2308: v_DTX_Delete,
2309: dbms_sql.native );
2310:
2311: xProgress := 'GPOAOB-40-1196';
2312: dbms_sql.parse ( v_ALL_Delete_XCursor,
2313: v_ALL_Delete,
2314: dbms_sql.native );
2315:
2316: /* */

Line 2314: dbms_sql.native );

2310:
2311: xProgress := 'GPOAOB-40-1196';
2312: dbms_sql.parse ( v_ALL_Delete_XCursor,
2313: v_ALL_Delete,
2314: dbms_sql.native );
2315:
2316: /* */
2317: /* Initialize all counters. */
2318: /* */

Line 2346: dbms_sql.define_column ( v_ORD_Select_Cursor,

2342: xProgress := 'GPOAOB-40-1500';
2343: FOR v_LoopCount IN 1..v_ORD_Count
2344: LOOP
2345: xProgress := 'GPOAOB-40-1510';
2346: dbms_sql.define_column ( v_ORD_Select_Cursor,
2347: v_LoopCount,
2348: v_ORD_Select,
2349: ece_extract_utils_pub.G_MaxColWidth );
2350: END LOOP;

Line 2357: dbms_sql.define_column_rowid ( v_ORD_Select_Cursor,

2353: /* Define the ROWIDs for the DELETE statements. */
2354: /* */
2355:
2356: xProgress := 'GPOAOB-40-1520';
2357: dbms_sql.define_column_rowid ( v_ORD_Select_Cursor,
2358: v_ORD_Count + 1,
2359: v_ORD_RowID );
2360:
2361: xProgress := 'GPOAOB-40-1530';

Line 2362: dbms_sql.define_column_rowid ( v_ORD_Select_Cursor,

2358: v_ORD_Count + 1,
2359: v_ORD_RowID );
2360:
2361: xProgress := 'GPOAOB-40-1530';
2362: dbms_sql.define_column_rowid ( v_ORD_Select_Cursor,
2363: v_ORD_Count + 2,
2364: v_ORD_XRowID );
2365:
2366: /* */

Line 2370: dbms_sql.define_column ( v_ORD_Select_Cursor,

2366: /* */
2367: /* Define the internal ID columns. */
2368: /* */
2369: xProgress := 'GPOAOB-40-1550';
2370: dbms_sql.define_column ( v_ORD_Select_Cursor,
2371: v_ORD_Count + 3,
2372: v_TransactionRecordID );
2373:
2374: xProgress := 'GPOAOB-40-1600';

Line 2378: dbms_sql.define_column ( v_OAC_Select_Cursor,

2374: xProgress := 'GPOAOB-40-1600';
2375: FOR v_LoopCount IN 1..v_OAC_Count
2376: LOOP
2377: xProgress := 'GPOAOB-40-1610';
2378: dbms_sql.define_column ( v_OAC_Select_Cursor,
2379: v_LoopCount,
2380: v_OAC_Select,
2381: ece_extract_utils_pub.G_MaxColWidth );
2382: END LOOP;

Line 2389: dbms_sql.define_column_rowid ( v_OAC_Select_Cursor,

2385: /* Define the ROWIDs for the DELETE statements. */
2386: /* */
2387:
2388: xProgress := 'GPOAOB-40-1620';
2389: dbms_sql.define_column_rowid ( v_OAC_Select_Cursor,
2390: v_OAC_Count + 1,
2391: v_OAC_RowID );
2392:
2393: xProgress := 'GPOAOB-40-1630';

Line 2394: dbms_sql.define_column_rowid ( v_OAC_Select_Cursor,

2390: v_OAC_Count + 1,
2391: v_OAC_RowID );
2392:
2393: xProgress := 'GPOAOB-40-1630';
2394: dbms_sql.define_column_rowid ( v_OAC_Select_Cursor,
2395: v_OAC_Count + 2,
2396: v_OAC_XRowID );
2397:
2398: /* */

Line 2403: dbms_sql.define_column ( v_OAC_Select_Cursor,

2399: /* Define the internal ID columns. */
2400: /* */
2401:
2402: xProgress := 'GPOAOB-40-1640';
2403: dbms_sql.define_column ( v_OAC_Select_Cursor,
2404: v_OAC_Count + 3,
2405: v_TransactionRecordID );
2406:
2407: /* */

Line 2412: dbms_sql.define_column ( v_OTX_Select_Cursor,

2408: xProgress := 'GPOAOB-40-1700';
2409: FOR v_LoopCount IN 1..v_OTX_Count
2410: LOOP
2411: xProgress := 'GPOAOB-40-1710';
2412: dbms_sql.define_column ( v_OTX_Select_Cursor,
2413: v_LoopCount,
2414: v_OTX_Select,
2415: ece_extract_utils_pub.G_MaxColWidth );
2416: END LOOP;

Line 2423: dbms_sql.define_column_rowid ( v_OTX_Select_Cursor,

2419: /* Define the ROWIDs for the DELETE statements. */
2420: /* */
2421:
2422: xProgress := 'GPOAOB-40-1720';
2423: dbms_sql.define_column_rowid ( v_OTX_Select_Cursor,
2424: v_OTX_Count + 1,
2425: v_OTX_RowID );
2426:
2427: xProgress := 'GPOAOB-40-1730';

Line 2428: dbms_sql.define_column_rowid ( v_OTX_Select_Cursor,

2424: v_OTX_Count + 1,
2425: v_OTX_RowID );
2426:
2427: xProgress := 'GPOAOB-40-1730';
2428: dbms_sql.define_column_rowid ( v_OTX_Select_Cursor,
2429: v_OTX_Count + 2,
2430: v_OTX_XRowID );
2431:
2432: /* */

Line 2437: dbms_sql.define_column ( v_OTX_Select_Cursor,

2433: /* Define the internal ID columns. */
2434: /* */
2435:
2436: xProgress := 'GPOAOB-40-1750';
2437: dbms_sql.define_column ( v_OTX_Select_Cursor,
2438: v_OTX_Count + 3,
2439: v_TransactionRecordID );
2440:
2441: xProgress := 'GPOAOB-40-1800';

Line 2445: dbms_sql.define_column ( v_DTL_Select_Cursor,

2441: xProgress := 'GPOAOB-40-1800';
2442: FOR v_LoopCount IN 1..v_DTL_Count
2443: LOOP
2444: xProgress := 'GPOAOB-40-1810';
2445: dbms_sql.define_column ( v_DTL_Select_Cursor,
2446: v_LoopCount,
2447: v_DTL_Select,
2448: ece_extract_utils_pub.G_MaxColWidth );
2449: END LOOP;

Line 2456: dbms_sql.define_column_rowid ( v_DTL_Select_Cursor,

2452: /* Define the ROWIDs for the DELETE statements. */
2453: /* */
2454:
2455: xProgress := 'GPOAOB-40-1820';
2456: dbms_sql.define_column_rowid ( v_DTL_Select_Cursor,
2457: v_DTL_Count + 1,
2458: v_DTL_RowID );
2459:
2460: xProgress := 'GPOAOB-40-1830';

Line 2461: dbms_sql.define_column_rowid ( v_DTL_Select_Cursor,

2457: v_DTL_Count + 1,
2458: v_DTL_RowID );
2459:
2460: xProgress := 'GPOAOB-40-1830';
2461: dbms_sql.define_column_rowid ( v_DTL_Select_Cursor,
2462: v_DTL_Count + 2,
2463: v_DTL_XRowID );
2464:
2465: /* */

Line 2470: dbms_sql.define_column ( v_DTL_Select_Cursor,

2466: /* Define the internal ID columns. */
2467: /* */
2468:
2469: xProgress := 'GPOAOB-40-1850';
2470: dbms_sql.define_column ( v_DTL_Select_Cursor,
2471: v_DTL_Count + 3,
2472: v_TransactionRecordID );
2473:
2474: xProgress := 'GPOAOB-40-1900';

Line 2478: dbms_sql.define_column ( v_DAC_Select_Cursor,

2474: xProgress := 'GPOAOB-40-1900';
2475: FOR v_LoopCount IN 1..v_DAC_Count
2476: LOOP
2477: xProgress := 'GPOAOB-40-1910';
2478: dbms_sql.define_column ( v_DAC_Select_Cursor,
2479: v_LoopCount,
2480: v_DAC_Select,
2481: ece_extract_utils_pub.G_MaxColWidth );
2482: END LOOP;

Line 2489: dbms_sql.define_column_rowid ( v_DAC_Select_Cursor,

2485: /* Define the ROWIDs for the DELETE statements. */
2486: /* */
2487:
2488: xProgress := 'GPOAOB-40-1920';
2489: dbms_sql.define_column_rowid ( v_DAC_Select_Cursor,
2490: v_DAC_Count + 1,
2491: v_DAC_RowID );
2492:
2493: xProgress := 'GPOAOB-40-1930';

Line 2494: dbms_sql.define_column_rowid ( v_DAC_Select_Cursor,

2490: v_DAC_Count + 1,
2491: v_DAC_RowID );
2492:
2493: xProgress := 'GPOAOB-40-1930';
2494: dbms_sql.define_column_rowid ( v_DAC_Select_Cursor,
2495: v_DAC_Count + 2,
2496: v_DAC_XRowID );
2497:
2498: /* */

Line 2503: dbms_sql.define_column ( v_DAC_Select_Cursor,

2499: /* Define the internal ID columns. */
2500: /* */
2501:
2502: xProgress := 'GPOAOB-40-1950';
2503: dbms_sql.define_column ( v_DAC_Select_Cursor,
2504: v_DAC_Count + 3,
2505: v_TransactionRecordID );
2506:
2507: xProgress := 'GPOAOB-40-2000';

Line 2511: dbms_sql.define_column ( v_DTX_Select_Cursor,

2507: xProgress := 'GPOAOB-40-2000';
2508: FOR v_LoopCount IN 1..v_DTX_Count
2509: LOOP
2510: xProgress := 'GPOAOB-40-2010';
2511: dbms_sql.define_column ( v_DTX_Select_Cursor,
2512: v_LoopCount,
2513: v_DTX_Select,
2514: ece_extract_utils_pub.G_MaxColWidth );
2515: END LOOP;

Line 2522: dbms_sql.define_column_rowid ( v_DTX_Select_Cursor,

2518: /* Define the ROWIDs for the DELETE statements. */
2519: /* */
2520:
2521: xProgress := 'GPOAOB-40-2020';
2522: dbms_sql.define_column_rowid ( v_DTX_Select_Cursor,
2523: v_DTX_Count + 1,
2524: v_DTX_RowID );
2525:
2526: xProgress := 'GPOAOB-40-2030';

Line 2527: dbms_sql.define_column_rowid ( v_DTX_Select_Cursor,

2523: v_DTX_Count + 1,
2524: v_DTX_RowID );
2525:
2526: xProgress := 'GPOAOB-40-2030';
2527: dbms_sql.define_column_rowid ( v_DTX_Select_Cursor,
2528: v_DTX_Count + 2,
2529: v_DTX_XRowID );
2530:
2531: /* */

Line 2536: dbms_sql.define_column ( v_DTX_Select_Cursor,

2532: /* Define the internal ID columns. */
2533: /* */
2534:
2535: xProgress := 'GPOAOB-40-2050';
2536: dbms_sql.define_column ( v_DTX_Select_Cursor,
2537: v_DTX_Count + 3,
2538: v_TransactionRecordID );
2539:
2540: xProgress := 'GPOAOB-40-2100';

Line 2544: dbms_sql.define_column ( v_ALL_Select_Cursor,

2540: xProgress := 'GPOAOB-40-2100';
2541: FOR v_LoopCount IN 1..v_ALL_Count
2542: LOOP
2543: xProgress := 'GPOAOB-40-2110';
2544: dbms_sql.define_column ( v_ALL_Select_Cursor,
2545: v_LoopCount,
2546: v_ALL_Select,
2547: ece_extract_utils_pub.G_MaxColWidth );
2548: END LOOP;

Line 2555: dbms_sql.define_column_rowid ( v_ALL_Select_Cursor,

2551: /* Define the ROWIDs for the DELETE statements. */
2552: /* */
2553:
2554: xProgress := 'GPOAOB-40-2120';
2555: dbms_sql.define_column_rowid ( v_ALL_Select_Cursor,
2556: v_ALL_Count + 1,
2557: v_ALL_RowID );
2558:
2559: xProgress := 'GPOAOB-40-2210';

Line 2560: dbms_sql.define_column_rowid ( v_ALL_Select_Cursor,

2556: v_ALL_Count + 1,
2557: v_ALL_RowID );
2558:
2559: xProgress := 'GPOAOB-40-2210';
2560: dbms_sql.define_column_rowid ( v_ALL_Select_Cursor,
2561: v_ALL_Count + 2,
2562: v_ALL_XRowID );
2563:
2564: /* */

Line 2569: dbms_sql.define_column ( v_ALL_Select_Cursor,

2565: /* Define the internal ID columns. */
2566: /* */
2567:
2568: xProgress := 'GPOAOB-40-2150';
2569: dbms_sql.define_column ( v_ALL_Select_Cursor,
2570: v_ALL_Count + 3,
2571: v_TransactionRecordID );
2572:
2573: /* */

Line 2578: dbms_sql.bind_variable ( v_ORD_Select_Cursor,

2574: /* Bind columns needed for order select */
2575: /* */
2576:
2577: xProgress := 'GPOAOB-40-2170';
2578: dbms_sql.bind_variable ( v_ORD_Select_Cursor,
2579: 'RUN_ID',
2580: p_RunID );
2581:
2582: /* */

Line 2587: v_Dummy := dbms_sql.execute ( v_ORD_Select_Cursor );

2583: /* Execute the Order level SELECT statement. */
2584: /* */
2585:
2586: xProgress := 'GPOAOB-40-2200';
2587: v_Dummy := dbms_sql.execute ( v_ORD_Select_Cursor );
2588:
2589: /* ********************************************************* */
2590: /* ** Order Level Loop ** */
2591: /* ********************************************************* */

Line 2594: WHILE dbms_sql.fetch_rows ( v_ORD_Select_Cursor ) > 0

2590: /* ** Order Level Loop ** */
2591: /* ********************************************************* */
2592:
2593: xProgress := 'GPOAOB-40-2210';
2594: WHILE dbms_sql.fetch_rows ( v_ORD_Select_Cursor ) > 0
2595: LOOP
2596:
2597: /* */
2598: /* Store the returned values in the PL/SQL table. */

Line 2605: dbms_sql.column_value ( v_ORD_Select_Cursor,

2601: xProgress := 'GPOAOB-40-2220';
2602: FOR v_LoopCount IN 1..v_ORD_Count
2603: LOOP
2604: xProgress := 'GPOAOB-40-2230';
2605: dbms_sql.column_value ( v_ORD_Select_Cursor,
2606: v_LoopCount,
2607: v_ORD_Table(v_LoopCount).value );
2608: END LOOP;
2609:

Line 2615: dbms_sql.column_value ( v_ORD_Select_Cursor,

2611: /* Store the ROWIDs. */
2612: /* */
2613:
2614: xProgress := 'GPOAOB-40-2240';
2615: dbms_sql.column_value ( v_ORD_Select_Cursor,
2616: v_ORD_Count + 1,
2617: v_ORD_RowID );
2618:
2619: xProgress := 'GPOAOB-40-2250';

Line 2620: dbms_sql.column_value ( v_ORD_Select_Cursor,

2616: v_ORD_Count + 1,
2617: v_ORD_RowID );
2618:
2619: xProgress := 'GPOAOB-40-2250';
2620: dbms_sql.column_value ( v_ORD_Select_Cursor,
2621: v_ORD_Count + 2,
2622: v_ORD_XRowID );
2623:
2624: /* */

Line 2687: dbms_sql.column_value ( v_ORD_Select_Cursor,

2683: /* in the SELECT clauses of the Order Charges, Text, Detail levels */
2684: /* */
2685:
2686: xProgress := 'GPOAOB-40-2320';
2687: dbms_sql.column_value ( v_ORD_Select_Cursor,
2688: v_ORD_Count + 3,
2689: v_TransactionRecordID );
2690:
2691: xProgress := 'GPOAOB-40-2323';

Line 2707: dbms_sql.bind_variable ( v_OAC_Select_Cursor,

2703: xProgress := 'GPOAOB-40-2324';
2704: v_Order_Id := TO_NUMBER ( v_ORD_Table(v_Order_Id_Position).value );
2705:
2706: xProgress := 'GPOAOB-40-2325';
2707: dbms_sql.bind_variable ( v_OAC_Select_Cursor,
2708: 'RUN_ID',
2709: p_RunID );
2710:
2711: xProgress := 'GPOAOB-40-2326';

Line 2712: dbms_sql.bind_variable ( v_OAC_Select_Cursor,

2708: 'RUN_ID',
2709: p_RunID );
2710:
2711: xProgress := 'GPOAOB-40-2326';
2712: dbms_sql.bind_variable ( v_OAC_Select_Cursor,
2713: 'Order_ID',
2714: v_Order_ID );
2715:
2716: xProgress := 'GPOAOB-40-2327';

Line 2717: dbms_sql.bind_variable ( v_OTX_Select_Cursor,

2713: 'Order_ID',
2714: v_Order_ID );
2715:
2716: xProgress := 'GPOAOB-40-2327';
2717: dbms_sql.bind_variable ( v_OTX_Select_Cursor,
2718: 'RUN_ID',
2719: p_RunID );
2720:
2721: xProgress := 'GPOAOB-40-2328';

Line 2722: dbms_sql.bind_variable ( v_OTX_Select_Cursor,

2718: 'RUN_ID',
2719: p_RunID );
2720:
2721: xProgress := 'GPOAOB-40-2328';
2722: dbms_sql.bind_variable ( v_OTX_Select_Cursor,
2723: 'Order_ID',
2724: v_Order_ID );
2725:
2726: /* */

Line 2731: v_Dummy := dbms_sql.execute ( v_OAC_Select_Cursor );

2727: /* Execute the Order Charges SELECT statement. */
2728: /* */
2729:
2730: xProgress := 'GPOAOB-40-2330';
2731: v_Dummy := dbms_sql.execute ( v_OAC_Select_Cursor );
2732:
2733: /* ********************************************************* */
2734: /* ** Order Charges Level Loop ** */
2735: /* ********************************************************* */

Line 2743: WHILE dbms_sql.fetch_rows ( v_OAC_Select_Cursor ) > 0

2739: /* PL/SQL table. */
2740: /* */
2741:
2742: xProgress := 'GPOAOB-40-2340';
2743: WHILE dbms_sql.fetch_rows ( v_OAC_Select_Cursor ) > 0
2744: LOOP
2745: xProgress := 'GPOAOB-40-2350';
2746: FOR v_LoopCount IN 1..v_OAC_Count
2747: LOOP

Line 2749: dbms_sql.column_value ( v_OAC_Select_Cursor,

2745: xProgress := 'GPOAOB-40-2350';
2746: FOR v_LoopCount IN 1..v_OAC_Count
2747: LOOP
2748: xProgress := 'GPOAOB-40-2360';
2749: dbms_sql.column_value ( v_OAC_Select_Cursor,
2750: v_LoopCount,
2751: v_OAC_Table(v_LoopCount).value );
2752: END LOOP;
2753:

Line 2759: dbms_sql.column_value ( v_OAC_Select_Cursor,

2755: /* Get the ROWIDs. */
2756: /* */
2757:
2758: xProgress := 'GPOAOB-40-2370';
2759: dbms_sql.column_value ( v_OAC_Select_Cursor,
2760: v_OAC_Count + 1,
2761: v_OAC_RowID );
2762:
2763: xProgress := 'GPOAOB-40-2380';

Line 2764: dbms_sql.column_value ( v_OAC_Select_Cursor,

2760: v_OAC_Count + 1,
2761: v_OAC_RowID );
2762:
2763: xProgress := 'GPOAOB-40-2380';
2764: dbms_sql.column_value ( v_OAC_Select_Cursor,
2765: v_OAC_Count + 2,
2766: v_OAC_XRowID );
2767:
2768: /* */

Line 2807: dbms_sql.bind_variable ( v_OAC_Delete_Cursor,

2803: /* OAC interface tables. */
2804: /* */
2805:
2806: xProgress := 'GPOAOB-40-2391';
2807: dbms_sql.bind_variable ( v_OAC_Delete_Cursor,
2808: 'Row_ID',
2809: v_OAC_RowID );
2810:
2811: xProgress := 'GPOAOB-40-2392';

Line 2812: dbms_sql.bind_variable ( v_OAC_Delete_XCursor,

2808: 'Row_ID',
2809: v_OAC_RowID );
2810:
2811: xProgress := 'GPOAOB-40-2392';
2812: dbms_sql.bind_variable ( v_OAC_Delete_XCursor,
2813: 'Row_ID',
2814: v_OAC_XRowID );
2815:
2816: /* */

Line 2821: v_Dummy := dbms_sql.execute ( v_OAC_Delete_Cursor );

2817: /* Delete the rows from the interface tables. */
2818: /* */
2819:
2820: xProgress := 'GPOAOB-40-2393';
2821: v_Dummy := dbms_sql.execute ( v_OAC_Delete_Cursor );
2822:
2823: xProgress := 'GPOAOB-40-2394';
2824: v_Dummy := dbms_sql.execute ( v_OAC_Delete_XCursor );
2825:

Line 2824: v_Dummy := dbms_sql.execute ( v_OAC_Delete_XCursor );

2820: xProgress := 'GPOAOB-40-2393';
2821: v_Dummy := dbms_sql.execute ( v_OAC_Delete_Cursor );
2822:
2823: xProgress := 'GPOAOB-40-2394';
2824: v_Dummy := dbms_sql.execute ( v_OAC_Delete_XCursor );
2825:
2826: END LOOP; /* Order Charge Level */
2827:
2828: /* */

Line 2833: v_Dummy := dbms_sql.execute ( v_OTX_Select_Cursor );

2829: /* Execute the Order Text SELECT statement. */
2830: /* */
2831:
2832: xProgress := 'GPOAOB-40-2330';
2833: v_Dummy := dbms_sql.execute ( v_OTX_Select_Cursor );
2834:
2835: /* ********************************************************* */
2836: /* ** Order Text Level Loop ** */
2837: /* ********************************************************* */

Line 2846: WHILE dbms_sql.fetch_rows ( v_OTX_Select_Cursor ) > 0

2842: /* PL/SQL table. */
2843: /* */
2844:
2845: xProgress := 'GPOAOB-40-2440';
2846: WHILE dbms_sql.fetch_rows ( v_OTX_Select_Cursor ) > 0
2847: LOOP
2848: xProgress := 'GPOAOB-40-2450';
2849: FOR v_LoopCount IN 1..v_OTX_Count
2850: LOOP

Line 2852: dbms_sql.column_value ( v_OTX_Select_Cursor,

2848: xProgress := 'GPOAOB-40-2450';
2849: FOR v_LoopCount IN 1..v_OTX_Count
2850: LOOP
2851: xProgress := 'GPOAOB-40-2460';
2852: dbms_sql.column_value ( v_OTX_Select_Cursor,
2853: v_LoopCount,
2854: v_OTX_Table(v_LoopCount).value );
2855: END LOOP;
2856:

Line 2862: dbms_sql.column_value ( v_OTX_Select_Cursor,

2858: /* Get the ROWIDs. */
2859: /* */
2860:
2861: xProgress := 'GPOAOB-40-2470';
2862: dbms_sql.column_value ( v_OTX_Select_Cursor,
2863: v_OTX_Count + 1,
2864: v_OTX_RowID );
2865:
2866: xProgress := 'GPOAOB-40-2480';

Line 2867: dbms_sql.column_value ( v_OTX_Select_Cursor,

2863: v_OTX_Count + 1,
2864: v_OTX_RowID );
2865:
2866: xProgress := 'GPOAOB-40-2480';
2867: dbms_sql.column_value ( v_OTX_Select_Cursor,
2868: v_OTX_Count + 2,
2869: v_OTX_XRowID );
2870:
2871: /* */

Line 2911: dbms_sql.bind_variable ( v_OTX_Delete_Cursor,

2907: /* OTX interface tables. */
2908: /* */
2909:
2910: xProgress := 'GPOAOB-40-2491';
2911: dbms_sql.bind_variable ( v_OTX_Delete_Cursor,
2912: 'Row_ID',
2913: v_OTX_RowID );
2914:
2915: xProgress := 'GPOAOB-40-2492';

Line 2916: dbms_sql.bind_variable ( v_OTX_Delete_XCursor,

2912: 'Row_ID',
2913: v_OTX_RowID );
2914:
2915: xProgress := 'GPOAOB-40-2492';
2916: dbms_sql.bind_variable ( v_OTX_Delete_XCursor,
2917: 'Row_ID',
2918: v_OTX_XRowID );
2919:
2920: /* */

Line 2925: v_Dummy := dbms_sql.execute ( v_OTX_Delete_Cursor );

2921: /* Delete the rows from the interface tables. */
2922: /* */
2923:
2924: xProgress := 'GPOAOB-40-2493';
2925: v_Dummy := dbms_sql.execute ( v_OTX_Delete_Cursor );
2926:
2927: xProgress := 'GPOAOB-40-2494';
2928: v_Dummy := dbms_sql.execute ( v_OTX_Delete_XCursor );
2929:

Line 2928: v_Dummy := dbms_sql.execute ( v_OTX_Delete_XCursor );

2924: xProgress := 'GPOAOB-40-2493';
2925: v_Dummy := dbms_sql.execute ( v_OTX_Delete_Cursor );
2926:
2927: xProgress := 'GPOAOB-40-2494';
2928: v_Dummy := dbms_sql.execute ( v_OTX_Delete_XCursor );
2929:
2930: END LOOP; /* Order Text Level */
2931:
2932: /* */

Line 2941: dbms_sql.bind_variable ( v_DTL_Select_Cursor,

2937: /* */
2938: /* Execute the Detail level SELECT statement. */
2939: /* */
2940: xProgress := 'GPOAOB-40-2500';
2941: dbms_sql.bind_variable ( v_DTL_Select_Cursor,
2942: 'RUN_ID',
2943: p_RunID );
2944:
2945: dbms_sql.bind_variable ( v_DTL_Select_Cursor,

Line 2945: dbms_sql.bind_variable ( v_DTL_Select_Cursor,

2941: dbms_sql.bind_variable ( v_DTL_Select_Cursor,
2942: 'RUN_ID',
2943: p_RunID );
2944:
2945: dbms_sql.bind_variable ( v_DTL_Select_Cursor,
2946: 'Order_ID',
2947: v_Order_ID );
2948:
2949: xProgress := 'GPOAOB-40-2510';

Line 2950: v_Dummy := dbms_sql.execute ( v_DTL_Select_Cursor );

2946: 'Order_ID',
2947: v_Order_ID );
2948:
2949: xProgress := 'GPOAOB-40-2510';
2950: v_Dummy := dbms_sql.execute ( v_DTL_Select_Cursor );
2951:
2952: /* */
2953: /* Begin the Detail level loop. */
2954: /* */

Line 2956: WHILE dbms_sql.fetch_rows ( v_DTL_Select_Cursor ) > 0

2952: /* */
2953: /* Begin the Detail level loop. */
2954: /* */
2955: xProgress := 'GPOAOB-40-2520';
2956: WHILE dbms_sql.fetch_rows ( v_DTL_Select_Cursor ) > 0
2957: LOOP
2958: xProgress := 'GPOAOB-40-2530';
2959: FOR v_LoopCount IN 1..v_DTL_Count
2960: LOOP

Line 2962: dbms_sql.column_value ( v_DTL_Select_Cursor,

2958: xProgress := 'GPOAOB-40-2530';
2959: FOR v_LoopCount IN 1..v_DTL_Count
2960: LOOP
2961: xProgress := 'GPOAOB-40-2540';
2962: dbms_sql.column_value ( v_DTL_Select_Cursor,
2963: v_LoopCount,
2964: v_DTL_Table(v_LoopCount).value);
2965: END LOOP;
2966:

Line 2972: dbms_sql.column_value ( v_DTL_Select_Cursor,

2968: /* Store the ROWIDs. */
2969: /* */
2970:
2971: xProgress := 'GPOAOB-40-2550';
2972: dbms_sql.column_value ( v_DTL_Select_Cursor,
2973: v_DTL_Count + 1,
2974: v_DTL_RowID );
2975:
2976: xProgress := 'GPOAOB-40-2560';

Line 2977: dbms_sql.column_value ( v_DTL_Select_Cursor,

2973: v_DTL_Count + 1,
2974: v_DTL_RowID );
2975:
2976: xProgress := 'GPOAOB-40-2560';
2977: dbms_sql.column_value ( v_DTL_Select_Cursor,
2978: v_DTL_Count + 2,
2979: v_DTL_XRowID );
2980:
2981: /* */

Line 3015: dbms_sql.bind_variable ( v_DTL_Delete_Cursor,

3011: p_RunID,
3012: v_FileCommonKey );
3013:
3014: xProgress := 'GPOAOB-40-2610';
3015: dbms_sql.bind_variable ( v_DTL_Delete_Cursor,
3016: 'Row_ID',
3017: v_DTL_RowID );
3018:
3019: xProgress := 'GPOAOB-40-2620';

Line 3020: dbms_sql.bind_variable ( v_DTL_Delete_XCursor,

3016: 'Row_ID',
3017: v_DTL_RowID );
3018:
3019: xProgress := 'GPOAOB-40-2620';
3020: dbms_sql.bind_variable ( v_DTL_Delete_XCursor,
3021: 'Row_ID',
3022: v_DTL_XRowID );
3023:
3024: /* */

Line 3029: v_Dummy := dbms_sql.execute ( v_DTL_Delete_Cursor );

3025: /* Delete the rows from the interface table. */
3026: /* */
3027:
3028: xProgress := 'GPOAOB-40-2630';
3029: v_Dummy := dbms_sql.execute ( v_DTL_Delete_Cursor );
3030:
3031: xProgress := 'GPOAOB-40-2640';
3032: v_Dummy := dbms_sql.execute ( v_DTL_Delete_XCursor );
3033:

Line 3032: v_Dummy := dbms_sql.execute ( v_DTL_Delete_XCursor );

3028: xProgress := 'GPOAOB-40-2630';
3029: v_Dummy := dbms_sql.execute ( v_DTL_Delete_Cursor );
3030:
3031: xProgress := 'GPOAOB-40-2640';
3032: v_Dummy := dbms_sql.execute ( v_DTL_Delete_XCursor );
3033:
3034: /* */
3035: /* Execute the Detail DAC SELECT statement. */
3036: /* */

Line 3046: dbms_sql.bind_variable ( v_DAC_Select_Cursor,

3042: xProgress := 'GPOAOB-40-2660';
3043: v_Line_Id := TO_NUMBER ( v_DTL_Table(v_Line_Id_Position).value );
3044:
3045: xProgress := 'GPOAOB-40-2670';
3046: dbms_sql.bind_variable ( v_DAC_Select_Cursor,
3047: 'RUN_ID',
3048: p_RunID );
3049:
3050: dbms_sql.bind_variable ( v_DAC_Select_Cursor,

Line 3050: dbms_sql.bind_variable ( v_DAC_Select_Cursor,

3046: dbms_sql.bind_variable ( v_DAC_Select_Cursor,
3047: 'RUN_ID',
3048: p_RunID );
3049:
3050: dbms_sql.bind_variable ( v_DAC_Select_Cursor,
3051: 'Line_ID',
3052: v_Line_ID );
3053:
3054: xProgress := 'GPOAOB-40-2680';

Line 3055: v_Dummy := dbms_sql.execute ( v_DAC_Select_Cursor );

3051: 'Line_ID',
3052: v_Line_ID );
3053:
3054: xProgress := 'GPOAOB-40-2680';
3055: v_Dummy := dbms_sql.execute ( v_DAC_Select_Cursor );
3056:
3057: /* */
3058: /* Begin the DETAIL DAC loop. */
3059: /* */

Line 3062: WHILE dbms_sql.fetch_rows ( v_DAC_Select_Cursor ) > 0

3058: /* Begin the DETAIL DAC loop. */
3059: /* */
3060:
3061: xProgress := 'GPOAOB-40-2690';
3062: WHILE dbms_sql.fetch_rows ( v_DAC_Select_Cursor ) > 0
3063: LOOP
3064: xProgress := 'GPOAOB-40-2700';
3065: FOR v_LoopCount IN 1..v_DAC_Count
3066: LOOP

Line 3068: dbms_sql.column_value ( v_DAC_Select_Cursor,

3064: xProgress := 'GPOAOB-40-2700';
3065: FOR v_LoopCount IN 1..v_DAC_Count
3066: LOOP
3067: xProgress := 'GPOAOB-40-2710';
3068: dbms_sql.column_value ( v_DAC_Select_Cursor,
3069: v_LoopCount,
3070: v_DAC_Table(v_LoopCount).value );
3071: END LOOP;
3072:

Line 3078: dbms_sql.column_value ( v_DAC_Select_Cursor,

3074: /* Store the ROWIDs. */
3075: /* */
3076:
3077: xProgress := 'GPOAOB-40-2720';
3078: dbms_sql.column_value ( v_DAC_Select_Cursor,
3079: v_DAC_Count + 1,
3080: v_DAC_RowID );
3081:
3082: xProgress := 'GPOAOB-40-2730';

Line 3083: dbms_sql.column_value ( v_DAC_Select_Cursor,

3079: v_DAC_Count + 1,
3080: v_DAC_RowID );
3081:
3082: xProgress := 'GPOAOB-40-2730';
3083: dbms_sql.column_value ( v_DAC_Select_Cursor,
3084: v_DAC_Count + 2,
3085: v_DAC_XRowID );
3086:
3087: xProgress := 'GPOAOB-40-2735';

Line 3115: dbms_sql.bind_variable ( v_DAC_Delete_Cursor,

3111: p_RunID,
3112: v_FileCommonKey );
3113:
3114: xProgress := 'GPOAOB-40-2780';
3115: dbms_sql.bind_variable ( v_DAC_Delete_Cursor,
3116: 'Row_ID',
3117: v_DAC_RowID );
3118:
3119: xProgress := 'GPOAOB-40-2790';

Line 3120: dbms_sql.bind_variable ( v_DAC_Delete_XCursor,

3116: 'Row_ID',
3117: v_DAC_RowID );
3118:
3119: xProgress := 'GPOAOB-40-2790';
3120: dbms_sql.bind_variable ( v_DAC_Delete_XCursor,
3121: 'Row_ID',
3122: v_DAC_XRowID );
3123:
3124: xProgress := 'GPOAOB-40-2800';

Line 3125: v_Dummy := dbms_sql.execute ( v_DAC_Delete_Cursor );

3121: 'Row_ID',
3122: v_DAC_XRowID );
3123:
3124: xProgress := 'GPOAOB-40-2800';
3125: v_Dummy := dbms_sql.execute ( v_DAC_Delete_Cursor );
3126:
3127: xProgress := 'GPOAOB-40-2340';
3128: v_Dummy := dbms_sql.execute ( v_DAC_Delete_XCursor );
3129: END LOOP; /* while dac */

Line 3128: v_Dummy := dbms_sql.execute ( v_DAC_Delete_XCursor );

3124: xProgress := 'GPOAOB-40-2800';
3125: v_Dummy := dbms_sql.execute ( v_DAC_Delete_Cursor );
3126:
3127: xProgress := 'GPOAOB-40-2340';
3128: v_Dummy := dbms_sql.execute ( v_DAC_Delete_XCursor );
3129: END LOOP; /* while dac */
3130:
3131: xProgress := 'GPOAOB-40-2670';
3132: dbms_sql.bind_variable ( v_DTX_Select_Cursor,

Line 3132: dbms_sql.bind_variable ( v_DTX_Select_Cursor,

3128: v_Dummy := dbms_sql.execute ( v_DAC_Delete_XCursor );
3129: END LOOP; /* while dac */
3130:
3131: xProgress := 'GPOAOB-40-2670';
3132: dbms_sql.bind_variable ( v_DTX_Select_Cursor,
3133: 'RUN_ID',
3134: p_RunID );
3135:
3136: dbms_sql.bind_variable ( v_DTX_Select_Cursor,

Line 3136: dbms_sql.bind_variable ( v_DTX_Select_Cursor,

3132: dbms_sql.bind_variable ( v_DTX_Select_Cursor,
3133: 'RUN_ID',
3134: p_RunID );
3135:
3136: dbms_sql.bind_variable ( v_DTX_Select_Cursor,
3137: 'Line_ID',
3138: v_Line_ID );
3139:
3140: xProgress := 'GPOAOB-40-2680';

Line 3141: v_Dummy := dbms_sql.execute ( v_DTX_Select_Cursor );

3137: 'Line_ID',
3138: v_Line_ID );
3139:
3140: xProgress := 'GPOAOB-40-2680';
3141: v_Dummy := dbms_sql.execute ( v_DTX_Select_Cursor );
3142:
3143: /* */
3144: /* Begin the DETAIL Text loop. */
3145: /* */

Line 3148: WHILE dbms_sql.fetch_rows ( v_DTX_Select_Cursor ) > 0

3144: /* Begin the DETAIL Text loop. */
3145: /* */
3146:
3147: xProgress := 'GPOAOB-40-2690';
3148: WHILE dbms_sql.fetch_rows ( v_DTX_Select_Cursor ) > 0
3149: LOOP
3150: xProgress := 'GPOAOB-40-2700';
3151: FOR v_LoopCount IN 1..v_DTX_Count
3152: LOOP

Line 3154: dbms_sql.column_value ( v_DTX_Select_Cursor,

3150: xProgress := 'GPOAOB-40-2700';
3151: FOR v_LoopCount IN 1..v_DTX_Count
3152: LOOP
3153: xProgress := 'GPOAOB-40-2710';
3154: dbms_sql.column_value ( v_DTX_Select_Cursor,
3155: v_LoopCount,
3156: v_DTX_Table(v_LoopCount).value );
3157: END LOOP;
3158:

Line 3164: dbms_sql.column_value ( v_DTX_Select_Cursor,

3160: /* Store the ROWIDs. */
3161: /* */
3162:
3163: xProgress := 'GPOAOB-40-2720';
3164: dbms_sql.column_value ( v_DTX_Select_Cursor,
3165: v_DTX_Count + 1,
3166: v_DTX_RowID );
3167:
3168: xProgress := 'GPOAOB-40-2730';

Line 3169: dbms_sql.column_value ( v_DTX_Select_Cursor,

3165: v_DTX_Count + 1,
3166: v_DTX_RowID );
3167:
3168: xProgress := 'GPOAOB-40-2730';
3169: dbms_sql.column_value ( v_DTX_Select_Cursor,
3170: v_DTX_Count + 2,
3171: v_DTX_XRowID );
3172:
3173:

Line 3202: dbms_sql.bind_variable ( v_DTX_Delete_Cursor,

3198: p_RunID,
3199: v_FileCommonKey );
3200:
3201: xProgress := 'GPOAOB-40-2780';
3202: dbms_sql.bind_variable ( v_DTX_Delete_Cursor,
3203: 'Row_ID',
3204: v_DTX_RowID );
3205:
3206: xProgress := 'GPOAOB-40-2790';

Line 3207: dbms_sql.bind_variable ( v_DTX_Delete_XCursor,

3203: 'Row_ID',
3204: v_DTX_RowID );
3205:
3206: xProgress := 'GPOAOB-40-2790';
3207: dbms_sql.bind_variable ( v_DTX_Delete_XCursor,
3208: 'Row_ID',
3209: v_DTX_XRowID );
3210:
3211: xProgress := 'GPOAOB-40-2800';

Line 3212: v_Dummy := dbms_sql.execute ( v_DTX_Delete_Cursor );

3208: 'Row_ID',
3209: v_DTX_XRowID );
3210:
3211: xProgress := 'GPOAOB-40-2800';
3212: v_Dummy := dbms_sql.execute ( v_DTX_Delete_Cursor );
3213:
3214: xProgress := 'GPOAOB-40-2340';
3215: v_Dummy := dbms_sql.execute ( v_DTX_Delete_XCursor );
3216: END LOOP; /* while dtx */

Line 3215: v_Dummy := dbms_sql.execute ( v_DTX_Delete_XCursor );

3211: xProgress := 'GPOAOB-40-2800';
3212: v_Dummy := dbms_sql.execute ( v_DTX_Delete_Cursor );
3213:
3214: xProgress := 'GPOAOB-40-2340';
3215: v_Dummy := dbms_sql.execute ( v_DTX_Delete_XCursor );
3216: END LOOP; /* while dtx */
3217:
3218: xProgress := 'GPOAOB-40-2670';
3219: dbms_sql.bind_variable ( v_ALL_Select_Cursor,

Line 3219: dbms_sql.bind_variable ( v_ALL_Select_Cursor,

3215: v_Dummy := dbms_sql.execute ( v_DTX_Delete_XCursor );
3216: END LOOP; /* while dtx */
3217:
3218: xProgress := 'GPOAOB-40-2670';
3219: dbms_sql.bind_variable ( v_ALL_Select_Cursor,
3220: 'RUN_ID',
3221: p_RunID );
3222:
3223: dbms_sql.bind_variable ( v_ALL_Select_Cursor,

Line 3223: dbms_sql.bind_variable ( v_ALL_Select_Cursor,

3219: dbms_sql.bind_variable ( v_ALL_Select_Cursor,
3220: 'RUN_ID',
3221: p_RunID );
3222:
3223: dbms_sql.bind_variable ( v_ALL_Select_Cursor,
3224: 'Line_ID',
3225: v_Line_ID );
3226:
3227: xProgress := 'GPOAOB-40-2680';

Line 3228: v_Dummy := dbms_sql.execute ( v_ALL_Select_Cursor );

3224: 'Line_ID',
3225: v_Line_ID );
3226:
3227: xProgress := 'GPOAOB-40-2680';
3228: v_Dummy := dbms_sql.execute ( v_ALL_Select_Cursor );
3229:
3230: /* */
3231: /* Begin the Allocations loop. */
3232: /* */

Line 3235: WHILE dbms_sql.fetch_rows ( v_ALL_Select_Cursor ) > 0

3231: /* Begin the Allocations loop. */
3232: /* */
3233:
3234: xProgress := 'GPOAOB-40-2690';
3235: WHILE dbms_sql.fetch_rows ( v_ALL_Select_Cursor ) > 0
3236: LOOP
3237: xProgress := 'GPOAOB-40-2700';
3238: FOR v_LoopCount IN 1..v_ALL_Count
3239: LOOP

Line 3241: dbms_sql.column_value ( v_ALL_Select_Cursor,

3237: xProgress := 'GPOAOB-40-2700';
3238: FOR v_LoopCount IN 1..v_ALL_Count
3239: LOOP
3240: xProgress := 'GPOAOB-40-2710';
3241: dbms_sql.column_value ( v_ALL_Select_Cursor,
3242: v_LoopCount,
3243: v_ALL_Table(v_LoopCount).value );
3244: END LOOP;
3245:

Line 3251: dbms_sql.column_value ( v_ALL_Select_Cursor,

3247: /* Store the ROWIDs. */
3248: /* */
3249:
3250: xProgress := 'GPOAOB-40-2720';
3251: dbms_sql.column_value ( v_ALL_Select_Cursor,
3252: v_ALL_Count + 1,
3253: v_ALL_RowID );
3254:
3255: xProgress := 'GPOAOB-40-2730';

Line 3256: dbms_sql.column_value ( v_ALL_Select_Cursor,

3252: v_ALL_Count + 1,
3253: v_ALL_RowID );
3254:
3255: xProgress := 'GPOAOB-40-2730';
3256: dbms_sql.column_value ( v_ALL_Select_Cursor,
3257: v_ALL_Count + 2,
3258: v_ALL_XRowID );
3259:
3260:

Line 3289: dbms_sql.bind_variable ( v_ALL_Delete_Cursor,

3285: p_RunID,
3286: v_FileCommonKey );
3287:
3288: xProgress := 'GPOAOB-40-2780';
3289: dbms_sql.bind_variable ( v_ALL_Delete_Cursor,
3290: 'Row_ID',
3291: v_ALL_RowID );
3292:
3293: xProgress := 'GPOAOB-40-2790';

Line 3294: dbms_sql.bind_variable ( v_ALL_Delete_XCursor,

3290: 'Row_ID',
3291: v_ALL_RowID );
3292:
3293: xProgress := 'GPOAOB-40-2790';
3294: dbms_sql.bind_variable ( v_ALL_Delete_XCursor,
3295: 'Row_ID',
3296: v_ALL_XRowID );
3297:
3298: xProgress := 'GPOAOB-40-2800';

Line 3299: v_Dummy := dbms_sql.execute ( v_ALL_Delete_Cursor );

3295: 'Row_ID',
3296: v_ALL_XRowID );
3297:
3298: xProgress := 'GPOAOB-40-2800';
3299: v_Dummy := dbms_sql.execute ( v_ALL_Delete_Cursor );
3300:
3301: xProgress := 'GPOAOB-40-2340';
3302: v_Dummy := dbms_sql.execute ( v_ALL_Delete_XCursor );
3303: END LOOP; /* while all */

Line 3302: v_Dummy := dbms_sql.execute ( v_ALL_Delete_XCursor );

3298: xProgress := 'GPOAOB-40-2800';
3299: v_Dummy := dbms_sql.execute ( v_ALL_Delete_Cursor );
3300:
3301: xProgress := 'GPOAOB-40-2340';
3302: v_Dummy := dbms_sql.execute ( v_ALL_Delete_XCursor );
3303: END LOOP; /* while all */
3304:
3305: END LOOP; /* while dtl */
3306:

Line 3308: dbms_sql.bind_variable ( v_ORD_Delete_Cursor,

3304:
3305: END LOOP; /* while dtl */
3306:
3307: xProgress := 'GPOAOB-40-2990';
3308: dbms_sql.bind_variable ( v_ORD_Delete_Cursor,
3309: 'Row_ID',
3310: v_ORD_RowID );
3311:
3312: xProgress := 'GPOAOB-40-3000';

Line 3313: dbms_sql.bind_variable ( v_ORD_Delete_XCursor,

3309: 'Row_ID',
3310: v_ORD_RowID );
3311:
3312: xProgress := 'GPOAOB-40-3000';
3313: dbms_sql.bind_variable ( v_ORD_Delete_XCursor,
3314: 'Row_ID',
3315: v_ORD_XRowID );
3316:
3317: /* */

Line 3322: v_Dummy := dbms_sql.execute ( v_ORD_Delete_Cursor );

3318: /* Delete the rows from the interface tables. */
3319: /* */
3320:
3321: xProgress := 'GPOAOB-40-3030';
3322: v_Dummy := dbms_sql.execute ( v_ORD_Delete_Cursor );
3323:
3324: xProgress := 'GPOAOB-40-3040';
3325: v_Dummy := dbms_sql.execute ( v_ORD_Delete_XCursor );
3326:

Line 3325: v_Dummy := dbms_sql.execute ( v_ORD_Delete_XCursor );

3321: xProgress := 'GPOAOB-40-3030';
3322: v_Dummy := dbms_sql.execute ( v_ORD_Delete_Cursor );
3323:
3324: xProgress := 'GPOAOB-40-3040';
3325: v_Dummy := dbms_sql.execute ( v_ORD_Delete_XCursor );
3326:
3327: END LOOP; /* Order Level */
3328:
3329: /* */

Line 3342: dbms_sql.close_cursor ( v_ORD_Select_Cursor );

3338: /* Close all open cursors. */
3339: /* */
3340:
3341: xProgress := 'GPOAOB-40-3080';
3342: dbms_sql.close_cursor ( v_ORD_Select_Cursor );
3343: xProgress := 'GPOAOB-40-3081';
3344: dbms_sql.close_cursor ( v_OAC_Select_Cursor );
3345: xProgress := 'GPOAOB-40-3082';
3346: dbms_sql.close_cursor ( v_OTX_Select_Cursor );

Line 3344: dbms_sql.close_cursor ( v_OAC_Select_Cursor );

3340:
3341: xProgress := 'GPOAOB-40-3080';
3342: dbms_sql.close_cursor ( v_ORD_Select_Cursor );
3343: xProgress := 'GPOAOB-40-3081';
3344: dbms_sql.close_cursor ( v_OAC_Select_Cursor );
3345: xProgress := 'GPOAOB-40-3082';
3346: dbms_sql.close_cursor ( v_OTX_Select_Cursor );
3347: xProgress := 'GPOAOB-40-3083';
3348: dbms_sql.close_cursor ( v_DTL_Select_Cursor );

Line 3346: dbms_sql.close_cursor ( v_OTX_Select_Cursor );

3342: dbms_sql.close_cursor ( v_ORD_Select_Cursor );
3343: xProgress := 'GPOAOB-40-3081';
3344: dbms_sql.close_cursor ( v_OAC_Select_Cursor );
3345: xProgress := 'GPOAOB-40-3082';
3346: dbms_sql.close_cursor ( v_OTX_Select_Cursor );
3347: xProgress := 'GPOAOB-40-3083';
3348: dbms_sql.close_cursor ( v_DTL_Select_Cursor );
3349: xProgress := 'GPOAOB-40-3084';
3350: dbms_sql.close_cursor ( v_DAC_Select_Cursor );

Line 3348: dbms_sql.close_cursor ( v_DTL_Select_Cursor );

3344: dbms_sql.close_cursor ( v_OAC_Select_Cursor );
3345: xProgress := 'GPOAOB-40-3082';
3346: dbms_sql.close_cursor ( v_OTX_Select_Cursor );
3347: xProgress := 'GPOAOB-40-3083';
3348: dbms_sql.close_cursor ( v_DTL_Select_Cursor );
3349: xProgress := 'GPOAOB-40-3084';
3350: dbms_sql.close_cursor ( v_DAC_Select_Cursor );
3351: xProgress := 'GPOAOB-40-3085';
3352: dbms_sql.close_cursor ( v_DTX_Select_Cursor );

Line 3350: dbms_sql.close_cursor ( v_DAC_Select_Cursor );

3346: dbms_sql.close_cursor ( v_OTX_Select_Cursor );
3347: xProgress := 'GPOAOB-40-3083';
3348: dbms_sql.close_cursor ( v_DTL_Select_Cursor );
3349: xProgress := 'GPOAOB-40-3084';
3350: dbms_sql.close_cursor ( v_DAC_Select_Cursor );
3351: xProgress := 'GPOAOB-40-3085';
3352: dbms_sql.close_cursor ( v_DTX_Select_Cursor );
3353: xProgress := 'GPOAOB-40-3086';
3354: dbms_sql.close_cursor ( v_ALL_Select_Cursor );

Line 3352: dbms_sql.close_cursor ( v_DTX_Select_Cursor );

3348: dbms_sql.close_cursor ( v_DTL_Select_Cursor );
3349: xProgress := 'GPOAOB-40-3084';
3350: dbms_sql.close_cursor ( v_DAC_Select_Cursor );
3351: xProgress := 'GPOAOB-40-3085';
3352: dbms_sql.close_cursor ( v_DTX_Select_Cursor );
3353: xProgress := 'GPOAOB-40-3086';
3354: dbms_sql.close_cursor ( v_ALL_Select_Cursor );
3355:
3356: xProgress := 'GPOAOB-40-3088';

Line 3354: dbms_sql.close_cursor ( v_ALL_Select_Cursor );

3350: dbms_sql.close_cursor ( v_DAC_Select_Cursor );
3351: xProgress := 'GPOAOB-40-3085';
3352: dbms_sql.close_cursor ( v_DTX_Select_Cursor );
3353: xProgress := 'GPOAOB-40-3086';
3354: dbms_sql.close_cursor ( v_ALL_Select_Cursor );
3355:
3356: xProgress := 'GPOAOB-40-3088';
3357: dbms_sql.close_cursor ( v_ORD_Delete_Cursor );
3358: xProgress := 'GPOAOB-40-3089';

Line 3357: dbms_sql.close_cursor ( v_ORD_Delete_Cursor );

3353: xProgress := 'GPOAOB-40-3086';
3354: dbms_sql.close_cursor ( v_ALL_Select_Cursor );
3355:
3356: xProgress := 'GPOAOB-40-3088';
3357: dbms_sql.close_cursor ( v_ORD_Delete_Cursor );
3358: xProgress := 'GPOAOB-40-3089';
3359: dbms_sql.close_cursor ( v_OAC_Delete_Cursor );
3360: xProgress := 'GPOAOB-40-3090';
3361: dbms_sql.close_cursor ( v_OTX_Delete_Cursor );

Line 3359: dbms_sql.close_cursor ( v_OAC_Delete_Cursor );

3355:
3356: xProgress := 'GPOAOB-40-3088';
3357: dbms_sql.close_cursor ( v_ORD_Delete_Cursor );
3358: xProgress := 'GPOAOB-40-3089';
3359: dbms_sql.close_cursor ( v_OAC_Delete_Cursor );
3360: xProgress := 'GPOAOB-40-3090';
3361: dbms_sql.close_cursor ( v_OTX_Delete_Cursor );
3362: xProgress := 'GPOAOB-40-3091';
3363: dbms_sql.close_cursor ( v_DTL_Delete_Cursor );

Line 3361: dbms_sql.close_cursor ( v_OTX_Delete_Cursor );

3357: dbms_sql.close_cursor ( v_ORD_Delete_Cursor );
3358: xProgress := 'GPOAOB-40-3089';
3359: dbms_sql.close_cursor ( v_OAC_Delete_Cursor );
3360: xProgress := 'GPOAOB-40-3090';
3361: dbms_sql.close_cursor ( v_OTX_Delete_Cursor );
3362: xProgress := 'GPOAOB-40-3091';
3363: dbms_sql.close_cursor ( v_DTL_Delete_Cursor );
3364: xProgress := 'GPOAOB-40-3092';
3365: dbms_sql.close_cursor ( v_DAC_Delete_Cursor );

Line 3363: dbms_sql.close_cursor ( v_DTL_Delete_Cursor );

3359: dbms_sql.close_cursor ( v_OAC_Delete_Cursor );
3360: xProgress := 'GPOAOB-40-3090';
3361: dbms_sql.close_cursor ( v_OTX_Delete_Cursor );
3362: xProgress := 'GPOAOB-40-3091';
3363: dbms_sql.close_cursor ( v_DTL_Delete_Cursor );
3364: xProgress := 'GPOAOB-40-3092';
3365: dbms_sql.close_cursor ( v_DAC_Delete_Cursor );
3366: xProgress := 'GPOAOB-40-3093';
3367: dbms_sql.close_cursor ( v_DTX_Delete_Cursor );

Line 3365: dbms_sql.close_cursor ( v_DAC_Delete_Cursor );

3361: dbms_sql.close_cursor ( v_OTX_Delete_Cursor );
3362: xProgress := 'GPOAOB-40-3091';
3363: dbms_sql.close_cursor ( v_DTL_Delete_Cursor );
3364: xProgress := 'GPOAOB-40-3092';
3365: dbms_sql.close_cursor ( v_DAC_Delete_Cursor );
3366: xProgress := 'GPOAOB-40-3093';
3367: dbms_sql.close_cursor ( v_DTX_Delete_Cursor );
3368: xProgress := 'GPOAOB-40-3094';
3369: dbms_sql.close_cursor ( v_ALL_Delete_Cursor );

Line 3367: dbms_sql.close_cursor ( v_DTX_Delete_Cursor );

3363: dbms_sql.close_cursor ( v_DTL_Delete_Cursor );
3364: xProgress := 'GPOAOB-40-3092';
3365: dbms_sql.close_cursor ( v_DAC_Delete_Cursor );
3366: xProgress := 'GPOAOB-40-3093';
3367: dbms_sql.close_cursor ( v_DTX_Delete_Cursor );
3368: xProgress := 'GPOAOB-40-3094';
3369: dbms_sql.close_cursor ( v_ALL_Delete_Cursor );
3370:
3371: xProgress := 'GPOAOB-40-3096';

Line 3369: dbms_sql.close_cursor ( v_ALL_Delete_Cursor );

3365: dbms_sql.close_cursor ( v_DAC_Delete_Cursor );
3366: xProgress := 'GPOAOB-40-3093';
3367: dbms_sql.close_cursor ( v_DTX_Delete_Cursor );
3368: xProgress := 'GPOAOB-40-3094';
3369: dbms_sql.close_cursor ( v_ALL_Delete_Cursor );
3370:
3371: xProgress := 'GPOAOB-40-3096';
3372: dbms_sql.close_cursor ( v_ORD_Delete_XCursor );
3373: xProgress := 'GPOAOB-40-3097';

Line 3372: dbms_sql.close_cursor ( v_ORD_Delete_XCursor );

3368: xProgress := 'GPOAOB-40-3094';
3369: dbms_sql.close_cursor ( v_ALL_Delete_Cursor );
3370:
3371: xProgress := 'GPOAOB-40-3096';
3372: dbms_sql.close_cursor ( v_ORD_Delete_XCursor );
3373: xProgress := 'GPOAOB-40-3097';
3374: dbms_sql.close_cursor ( v_OAC_Delete_XCursor );
3375: xProgress := 'GPOAOB-40-3098';
3376: dbms_sql.close_cursor ( v_OTX_Delete_XCursor );

Line 3374: dbms_sql.close_cursor ( v_OAC_Delete_XCursor );

3370:
3371: xProgress := 'GPOAOB-40-3096';
3372: dbms_sql.close_cursor ( v_ORD_Delete_XCursor );
3373: xProgress := 'GPOAOB-40-3097';
3374: dbms_sql.close_cursor ( v_OAC_Delete_XCursor );
3375: xProgress := 'GPOAOB-40-3098';
3376: dbms_sql.close_cursor ( v_OTX_Delete_XCursor );
3377: xProgress := 'GPOAOB-40-3099';
3378: dbms_sql.close_cursor ( v_DTL_Delete_XCursor );

Line 3376: dbms_sql.close_cursor ( v_OTX_Delete_XCursor );

3372: dbms_sql.close_cursor ( v_ORD_Delete_XCursor );
3373: xProgress := 'GPOAOB-40-3097';
3374: dbms_sql.close_cursor ( v_OAC_Delete_XCursor );
3375: xProgress := 'GPOAOB-40-3098';
3376: dbms_sql.close_cursor ( v_OTX_Delete_XCursor );
3377: xProgress := 'GPOAOB-40-3099';
3378: dbms_sql.close_cursor ( v_DTL_Delete_XCursor );
3379: xProgress := 'GPOAOB-40-3100';
3380: dbms_sql.close_cursor ( v_DAC_Delete_XCursor );

Line 3378: dbms_sql.close_cursor ( v_DTL_Delete_XCursor );

3374: dbms_sql.close_cursor ( v_OAC_Delete_XCursor );
3375: xProgress := 'GPOAOB-40-3098';
3376: dbms_sql.close_cursor ( v_OTX_Delete_XCursor );
3377: xProgress := 'GPOAOB-40-3099';
3378: dbms_sql.close_cursor ( v_DTL_Delete_XCursor );
3379: xProgress := 'GPOAOB-40-3100';
3380: dbms_sql.close_cursor ( v_DAC_Delete_XCursor );
3381: xProgress := 'GPOAOB-40-3101';
3382: dbms_sql.close_cursor ( v_DTX_Delete_XCursor );

Line 3380: dbms_sql.close_cursor ( v_DAC_Delete_XCursor );

3376: dbms_sql.close_cursor ( v_OTX_Delete_XCursor );
3377: xProgress := 'GPOAOB-40-3099';
3378: dbms_sql.close_cursor ( v_DTL_Delete_XCursor );
3379: xProgress := 'GPOAOB-40-3100';
3380: dbms_sql.close_cursor ( v_DAC_Delete_XCursor );
3381: xProgress := 'GPOAOB-40-3101';
3382: dbms_sql.close_cursor ( v_DTX_Delete_XCursor );
3383: xProgress := 'GPOAOB-40-3102';
3384: dbms_sql.close_cursor ( v_ALL_Delete_XCursor );

Line 3382: dbms_sql.close_cursor ( v_DTX_Delete_XCursor );

3378: dbms_sql.close_cursor ( v_DTL_Delete_XCursor );
3379: xProgress := 'GPOAOB-40-3100';
3380: dbms_sql.close_cursor ( v_DAC_Delete_XCursor );
3381: xProgress := 'GPOAOB-40-3101';
3382: dbms_sql.close_cursor ( v_DTX_Delete_XCursor );
3383: xProgress := 'GPOAOB-40-3102';
3384: dbms_sql.close_cursor ( v_ALL_Delete_XCursor );
3385:
3386: EXCEPTION

Line 3384: dbms_sql.close_cursor ( v_ALL_Delete_XCursor );

3380: dbms_sql.close_cursor ( v_DAC_Delete_XCursor );
3381: xProgress := 'GPOAOB-40-3101';
3382: dbms_sql.close_cursor ( v_DTX_Delete_XCursor );
3383: xProgress := 'GPOAOB-40-3102';
3384: dbms_sql.close_cursor ( v_ALL_Delete_XCursor );
3385:
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388: