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.MSC_CL_PRE_PROCESS dependencies on MSC_ST_BATCH_ID_S

Line 5819: SELECT msc_st_batch_id_s.NEXTVAL

5815:
5816: -- Dividing records in batches based on batchsize
5817: LOOP
5818: v_sql_stmt := 03;
5819: SELECT msc_st_batch_id_s.NEXTVAL
5820: INTO lv_batch_id
5821: FROM DUAL;
5822:
5823: v_sql_stmt := 04;

Line 6626: SELECT msc_st_batch_id_s.NEXTVAL

6622:
6623: -- Dividing records in batches based on batchsize
6624: LOOP
6625: v_sql_stmt := 05;
6626: SELECT msc_st_batch_id_s.NEXTVAL
6627: INTO lv_batch_id
6628: FROM DUAL;
6629:
6630: v_sql_stmt := 06;

Line 7767: SELECT msc_st_batch_id_s.NEXTVAL

7763: -- Dividing records in batches based on batchsize
7764:
7765: LOOP
7766: v_sql_stmt := 21;
7767: SELECT msc_st_batch_id_s.NEXTVAL
7768: INTO lv_batch_id
7769: FROM DUAL;
7770:
7771: v_sql_stmt := 22;

Line 8514: SELECT msc_st_batch_id_s.NEXTVAL

8510: -- Dividing records in batches based on batchsize
8511:
8512: LOOP
8513: v_sql_stmt := 29;
8514: SELECT msc_st_batch_id_s.NEXTVAL
8515: INTO lv_batch_id
8516: FROM DUAL;
8517:
8518: v_sql_stmt := 30;

Line 8858: SELECT msc_st_batch_id_s.NEXTVAL

8854:
8855: -- Dividing records in batches based on batchsize
8856: LOOP
8857: v_sql_stmt := 36;
8858: SELECT msc_st_batch_id_s.NEXTVAL
8859: INTO lv_batch_id
8860: FROM DUAL;
8861:
8862: v_sql_stmt := 37;

Line 9461: SELECT msc_st_batch_id_s.NEXTVAL

9457:
9458: -- Dividing records in batches based on batchsize
9459: LOOP
9460: v_sql_stmt := 47;
9461: SELECT msc_st_batch_id_s.NEXTVAL
9462: INTO lv_batch_id
9463: FROM DUAL;
9464:
9465: v_sql_stmt := 48;

Line 9871: SELECT msc_st_batch_id_s.NEXTVAL

9867:
9868: -- Dividing records in batches based on batchsize
9869: LOOP
9870: v_sql_stmt := 54;
9871: SELECT msc_st_batch_id_s.NEXTVAL
9872: INTO lv_batch_id
9873: FROM dual;
9874:
9875: v_sql_stmt := 55;

Line 10537: SELECT msc_st_batch_id_s.NEXTVAL

10533: -- Dividing records in batches based on batchsize
10534:
10535: LOOP
10536: v_sql_stmt := 70;
10537: SELECT msc_st_batch_id_s.NEXTVAL
10538: INTO lv_batch_id
10539: FROM DUAL;
10540:
10541: v_sql_stmt := 71;

Line 11246: SELECT msc_st_batch_id_s.NEXTVAL

11242: ||'COMPANY_NAME';
11243:
11244: LOOP
11245: v_sql_stmt := 03;
11246: SELECT msc_st_batch_id_s.NEXTVAL
11247: INTO lv_batch_id
11248: FROM dual;
11249:
11250: v_sql_stmt := 04;

Line 12076: SELECT msc_st_batch_id_s.NEXTVAL

12072:
12073:
12074: LOOP
12075: v_sql_stmt := 03;
12076: SELECT msc_st_batch_id_s.NEXTVAL
12077: INTO lv_batch_id
12078: FROM dual;
12079:
12080: v_sql_stmt := 04;

Line 12732: SELECT msc_st_batch_id_s.NEXTVAL

12728:
12729: -- Dividing records in batches based on batchsize
12730: LOOP
12731: v_sql_stmt := 03;
12732: SELECT msc_st_batch_id_s.NEXTVAL
12733: INTO lv_batch_id
12734: FROM DUAL;
12735:
12736: v_sql_stmt := 04;

Line 13712: ' SELECT msc_st_batch_id_s.NEXTVAL '

13708: -- Now processing by batch
13709: LOOP
13710: v_sql_stmt := 03;
13711: lv_cursor_stmt :=
13712: ' SELECT msc_st_batch_id_s.NEXTVAL '
13713: ||' FROM dual';
13714:
13715: OPEN c1 FOR lv_cursor_stmt;
13716: FETCH c1 INTO lv_batch_id;

Line 14322: SELECT msc_st_batch_id_s.NEXTVAL

14318: ||'DELETED_FLAG';
14319:
14320: LOOP
14321:
14322: SELECT msc_st_batch_id_s.NEXTVAL
14323: INTO lv_batch_id
14324: FROM DUAL;
14325:
14326: lv_sql_stmt :=

Line 14905: ' SELECT msc_st_batch_id_s.NEXTVAL '

14901: -- Now processing by batch
14902: LOOP
14903: v_sql_stmt := 03;
14904: lv_cursor_stmt :=
14905: ' SELECT msc_st_batch_id_s.NEXTVAL '
14906: ||' FROM dual';
14907:
14908: OPEN c1 FOR lv_cursor_stmt;
14909: FETCH c1 INTO lv_batch_id;

Line 15409: ' SELECT msc_st_batch_id_s.NEXTVAL '

15405: -- Now processing by batch
15406: LOOP
15407:
15408: lv_cursor_stmt :=
15409: ' SELECT msc_st_batch_id_s.NEXTVAL '
15410: ||' FROM dual';
15411:
15412: OPEN c1 FOR lv_cursor_stmt;
15413: FETCH c1 INTO lv_batch_id;

Line 15838: SELECT msc_st_batch_id_s.NEXTVAL

15834: ||'DELETED_FLAG ';
15835:
15836: LOOP
15837: v_sql_stmt := 03;
15838: SELECT msc_st_batch_id_s.NEXTVAL
15839: INTO lv_batch_id
15840: FROM dual;
15841:
15842: v_sql_stmt := 04;

Line 16288: SELECT msc_st_batch_id_s.NEXTVAL

16284: ||'DELETED_FLAG';
16285:
16286: LOOP
16287: v_sql_stmt := 03;
16288: SELECT msc_st_batch_id_s.NEXTVAL
16289: INTO lv_batch_id
16290: FROM dual;
16291:
16292: v_sql_stmt := 04;

Line 16798: SELECT msc_st_batch_id_s.NEXTVAL

16794: ||'DELETED_FLAG';
16795:
16796: LOOP
16797: v_sql_stmt := 12;
16798: SELECT msc_st_batch_id_s.NEXTVAL
16799: INTO lv_batch_id
16800: FROM dual;
16801:
16802: v_sql_stmt := 13;

Line 17368: SELECT msc_st_batch_id_s.NEXTVAL

17364: ||'DELETED_FLAG';
17365:
17366: LOOP
17367: v_sql_stmt := 25;
17368: SELECT msc_st_batch_id_s.NEXTVAL
17369: INTO lv_batch_id
17370: FROM dual;
17371:
17372: v_sql_stmt := 26;

Line 17957: SELECT msc_st_batch_id_s.NEXTVAL

17953:
17954: LOOP
17955: v_sql_stmt := 03;
17956:
17957: SELECT msc_st_batch_id_s.NEXTVAL
17958: INTO lv_batch_id
17959: FROM dual;
17960:
17961: v_sql_stmt := 04;

Line 20915: SELECT msc_st_batch_id_s.NEXTVAL

20911: ||'DELETED_FLAG ';
20912:
20913: LOOP
20914: v_sql_stmt := 03;
20915: SELECT msc_st_batch_id_s.NEXTVAL
20916: INTO lv_batch_id
20917: FROM dual;
20918:
20919: v_sql_stmt := 04;

Line 21616: SELECT msc_st_batch_id_s.NEXTVAL

21612: ||'DELETED_FLAG';
21613:
21614: LOOP
21615: v_sql_stmt := 03;
21616: SELECT msc_st_batch_id_s.NEXTVAL
21617: INTO lv_batch_id
21618: FROM dual;
21619:
21620: v_sql_stmt := 04;

Line 22251: SELECT msc_st_batch_id_s.NEXTVAL

22247: ||'USING_ORGANIZATION_ID';
22248:
22249: LOOP
22250: v_sql_stmt := 11;
22251: SELECT msc_st_batch_id_s.NEXTVAL
22252: INTO lv_batch_id
22253: FROM dual;
22254:
22255: v_sql_stmt := 12;

Line 22701: SELECT msc_st_batch_id_s.NEXTVAL

22697: ||'USING_ORGANIZATION_ID';
22698:
22699: LOOP
22700: v_sql_stmt := 19;
22701: SELECT msc_st_batch_id_s.NEXTVAL
22702: INTO lv_batch_id
22703: FROM dual;
22704:
22705: v_sql_stmt := 20;

Line 23208: SELECT msc_st_batch_id_s.NEXTVAL

23204: ||'DELETED_FLAG ';
23205:
23206: LOOP
23207: v_sql_stmt := 03;
23208: SELECT msc_st_batch_id_s.NEXTVAL
23209: INTO lv_batch_id
23210: FROM dual;
23211:
23212: v_sql_stmt := 04;

Line 23714: SELECT msc_st_batch_id_s.NEXTVAL

23710:
23711:
23712: LOOP
23713: v_sql_stmt := 03;
23714: SELECT msc_st_batch_id_s.NEXTVAL
23715: INTO lv_batch_id
23716: FROM dual;
23717:
23718: v_sql_stmt := 04;

Line 24427: ' SELECT msc_st_batch_id_s.NEXTVAL '

24423:
24424: LOOP
24425: v_sql_stmt := 03;
24426: lv_cursor_stmt :=
24427: ' SELECT msc_st_batch_id_s.NEXTVAL '
24428: ||' FROM dual';
24429:
24430: OPEN c1 FOR lv_cursor_stmt;
24431: FETCH c1 INTO lv_batch_id;

Line 26283: ' SELECT msc_st_batch_id_s.NEXTVAL '

26279:
26280: LOOP
26281: v_sql_stmt := 03;
26282: lv_cursor_stmt :=
26283: ' SELECT msc_st_batch_id_s.NEXTVAL '
26284: ||' FROM dual';
26285:
26286: OPEN c1 FOR lv_cursor_stmt;
26287: FETCH c1 INTO lv_batch_id;

Line 27128: SELECT msc_st_batch_id_s.NEXTVAL

27124: ||'DELETED_FLAG';
27125:
27126: LOOP
27127: v_sql_stmt := 03;
27128: SELECT msc_st_batch_id_s.NEXTVAL
27129: INTO lv_batch_id
27130: FROM dual;
27131:
27132: v_sql_stmt := 04;

Line 27536: ' SELECT msc_st_batch_id_s.NEXTVAL '

27532:
27533: LOOP
27534: v_sql_stmt := 03;
27535: lv_cursor_stmt :=
27536: ' SELECT msc_st_batch_id_s.NEXTVAL '
27537: ||' FROM dual';
27538:
27539: OPEN c1 FOR lv_cursor_stmt;
27540: FETCH c1 INTO lv_batch_id;

Line 28560: ' SELECT msc_st_batch_id_s.NEXTVAL '

28556:
28557: LOOP
28558: v_sql_stmt := 21;
28559: lv_cursor_stmt :=
28560: ' SELECT msc_st_batch_id_s.NEXTVAL '
28561: ||' FROM dual';
28562:
28563: OPEN c1 FOR lv_cursor_stmt;
28564: FETCH c1 INTO lv_batch_id;

Line 29087: ' SELECT msc_st_batch_id_s.NEXTVAL '

29083:
29084: LOOP
29085: v_sql_stmt := 33;
29086: lv_cursor_stmt :=
29087: ' SELECT msc_st_batch_id_s.NEXTVAL '
29088: ||' FROM dual';
29089:
29090: OPEN c1 FOR lv_cursor_stmt;
29091: FETCH c1 INTO lv_batch_id;

Line 32980: SELECT msc_st_batch_id_s.NEXTVAL

32976:
32977: -- Dividing records in batches based on batchsize
32978: LOOP
32979: v_sql_stmt := 03;
32980: SELECT msc_st_batch_id_s.NEXTVAL
32981: INTO lv_batch_id
32982: FROM DUAL;
32983:
32984: v_sql_stmt := 04;

Line 35049: SELECT msc_st_batch_id_s.NEXTVAL

35045:
35046: LOOP
35047: v_sql_stmt := 01;
35048:
35049: SELECT msc_st_batch_id_s.NEXTVAL
35050: INTO lv_batch_id
35051: FROM DUAL;
35052:
35053: v_sql_stmt := 02;

Line 35816: ' SELECT msc_st_batch_id_s.NEXTVAL '

35812:
35813: LOOP
35814: v_sql_stmt := 03;
35815: lv_cursor_stmt :=
35816: ' SELECT msc_st_batch_id_s.NEXTVAL '
35817: ||' FROM dual';
35818:
35819: OPEN c1 FOR lv_cursor_stmt;
35820: FETCH c1 INTO lv_batch_id;

Line 36425: ' SELECT msc_st_batch_id_s.NEXTVAL '

36421:
36422: LOOP
36423: v_sql_stmt := 13;
36424: lv_cursor_stmt :=
36425: ' SELECT msc_st_batch_id_s.NEXTVAL '
36426: ||' FROM dual';
36427:
36428: OPEN c1 FOR lv_cursor_stmt;
36429: FETCH c1 INTO lv_batch_id;

Line 37564: ' SELECT msc_st_batch_id_s.NEXTVAL '

37560:
37561: LOOP
37562: v_sql_stmt := 28;
37563: lv_cursor_stmt :=
37564: ' SELECT msc_st_batch_id_s.NEXTVAL '
37565: ||' FROM dual';
37566:
37567: OPEN c1 FOR lv_cursor_stmt;
37568: FETCH c1 INTO lv_batch_id;

Line 38156: ' SELECT msc_st_batch_id_s.NEXTVAL '

38152:
38153: LOOP
38154: v_sql_stmt := 38;
38155: lv_cursor_stmt :=
38156: ' SELECT msc_st_batch_id_s.NEXTVAL '
38157: ||' FROM dual';
38158: OPEN c1 FOR lv_cursor_stmt;
38159: FETCH c1 INTO lv_batch_id;
38160: CLOSE c1;

Line 38896: ' SELECT msc_st_batch_id_s.NEXTVAL '

38892: -- Now processing by batch
38893: LOOP
38894: v_sql_stmt := 03;
38895: lv_cursor_stmt :=
38896: ' SELECT msc_st_batch_id_s.NEXTVAL '
38897: ||' FROM dual';
38898:
38899: OPEN c1 FOR lv_cursor_stmt;
38900: FETCH c1 INTO lv_batch_id;

Line 39762: ' SELECT msc_st_batch_id_s.NEXTVAL '

39758: LOOP
39759:
39760: v_sql_stmt := 20;
39761: lv_cursor_stmt :=
39762: ' SELECT msc_st_batch_id_s.NEXTVAL '
39763: ||' FROM dual';
39764:
39765: OPEN c1 FOR lv_cursor_stmt;
39766: FETCH c1 INTO lv_batch_id;

Line 39770: SELECT msc_st_batch_id_s.NEXTVAL

39766: FETCH c1 INTO lv_batch_id;
39767: CLOSE c1;
39768:
39769:
39770: SELECT msc_st_batch_id_s.NEXTVAL
39771: INTO lv_batch_id
39772: FROM dual;
39773:
39774: v_sql_stmt := 21;

Line 40626: ' SELECT msc_st_batch_id_s.NEXTVAL '

40622: ||' COMPANY_NAME';
40623:
40624: LOOP
40625: lv_cursor_stmt :=
40626: ' SELECT msc_st_batch_id_s.NEXTVAL '
40627: ||' FROM dual';
40628:
40629: OPEN c1 FOR lv_cursor_stmt;
40630: FETCH c1 INTO lv_batch_id;

Line 41529: ' SELECT msc_st_batch_id_s.NEXTVAL '

41525:
41526: v_sql_stmt := 53;
41527:
41528: lv_cursor_stmt :=
41529: ' SELECT msc_st_batch_id_s.NEXTVAL '
41530: ||' FROM dual';
41531:
41532: OPEN c1 FOR lv_cursor_stmt;
41533: FETCH c1 INTO lv_batch_id;

Line 42586: SELECT msc_st_batch_id_s.NEXTVAL

42582: ||'ORDER_NUMBER';
42583:
42584: LOOP
42585: v_sql_stmt := 03;
42586: SELECT msc_st_batch_id_s.NEXTVAL
42587: INTO lv_batch_id
42588: FROM dual;
42589:
42590: v_sql_stmt := 04;

Line 43670: ' SELECT msc_st_batch_id_s.NEXTVAL '

43666: -- Now processing by batch
43667: LOOP
43668: v_sql_stmt := 03;
43669: lv_cursor_stmt :=
43670: ' SELECT msc_st_batch_id_s.NEXTVAL '
43671: ||' FROM dual';
43672:
43673: OPEN c1 FOR lv_cursor_stmt;
43674: FETCH c1 INTO lv_batch_id;

Line 44925: SELECT msc_st_batch_id_s.NEXTVAL

44921:
44922:
44923: LOOP
44924: v_sql_stmt := 03;
44925: SELECT msc_st_batch_id_s.NEXTVAL
44926: INTO lv_batch_id
44927: FROM DUAL;
44928:
44929: v_sql_stmt := 04;

Line 46020: ' SELECT msc_st_batch_id_s.NEXTVAL '

46016:
46017: v_sql_stmt := 3;
46018:
46019: lv_cursor_stmt :=
46020: ' SELECT msc_st_batch_id_s.NEXTVAL '
46021: ||' FROM dual';
46022:
46023: OPEN c1 FOR lv_cursor_stmt;
46024: FETCH c1 INTO lv_batch_id;

Line 46943: ' SELECT msc_st_batch_id_s.NEXTVAL '

46939:
46940: LOOP
46941:
46942: lv_cursor_stmt :=
46943: ' SELECT msc_st_batch_id_s.NEXTVAL '
46944: ||' FROM dual';
46945:
46946: OPEN c1 FOR lv_cursor_stmt;
46947: FETCH c1 INTO lv_batch_id;

Line 47597: SELECT msc_st_batch_id_s.NEXTVAL

47593: ||' PRIMARY_COMPONENT_NAME' ;
47594:
47595: LOOP
47596: v_sql_stmt := 03;
47597: SELECT msc_st_batch_id_s.NEXTVAL
47598: INTO lv_batch_id
47599: FROM DUAL;
47600:
47601: v_sql_stmt := 04;

Line 48424: ' SELECT msc_st_batch_id_s.NEXTVAL '

48420: -- Now processing by batch
48421: LOOP
48422: v_sql_stmt := 03;
48423: lv_cursor_stmt :=
48424: ' SELECT msc_st_batch_id_s.NEXTVAL '
48425: ||' FROM dual';
48426:
48427: OPEN c1 FOR lv_cursor_stmt;
48428: FETCH c1 INTO lv_batch_id;

Line 50147: SELECT msc_st_batch_id_s.NEXTVAL

50143:
50144: LOOP
50145: v_sql_stmt := 05;
50146:
50147: SELECT msc_st_batch_id_s.NEXTVAL
50148: INTO lv_batch_id
50149: FROM dual;
50150:
50151: v_sql_stmt := 06;

Line 50762: SELECT msc_st_batch_id_s.NEXTVAL

50758: EX_PIPE_SND EXCEPTION ;
50759:
50760: BEGIN
50761: LOOP
50762: SELECT msc_st_batch_id_s.NEXTVAL
50763: INTO lv_batch_id
50764: FROM DUAL;
50765:
50766: v_sql_stmt := 01;

Line 53631: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

53627: FETCH c2 BULK COLLECT INTO lb_rowid ;
53628:
53629: IF c2%ROWCOUNT > 0 THEN
53630:
53631: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
53632: lv_batch_start := lv_batch_id;
53633: lb_batch.extend(lb_rowid.count);
53634:
53635: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

Line 53639: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

53635: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
53636:
53637: lb_batch(j):= lv_batch_id;
53638: IF MOD(j,v_batch_size) = 0 THEN
53639: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
53640: END IF;
53641:
53642: END LOOP;
53643:

Line 53871: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

53867: FETCH c2 BULK COLLECT INTO lb_rowid ;
53868:
53869: IF c2%ROWCOUNT > 0 THEN
53870:
53871: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
53872: lv_batch_start := lv_batch_id;
53873: lb_batch.extend(lb_rowid.count);
53874:
53875: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

Line 53879: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

53875: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
53876:
53877: lb_batch(j):= lv_batch_id;
53878: IF MOD(j,v_batch_size) = 0 THEN
53879: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
53880: END IF;
53881:
53882: END LOOP;
53883:

Line 53946: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

53942: FETCH c2 BULK COLLECT INTO lb_rowid ;
53943:
53944: IF c2%ROWCOUNT > 0 THEN
53945:
53946: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
53947: lv_batch_start := lv_batch_id;
53948: lb_batch.extend(lb_rowid.count);
53949:
53950: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

Line 53954: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

53950: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
53951:
53952: lb_batch(j):= lv_batch_id;
53953: IF MOD(j,v_batch_size) = 0 THEN
53954: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
53955: END IF;
53956:
53957: END LOOP;
53958:

Line 54028: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

54024: FETCH c2 BULK COLLECT INTO lb_rowid ;
54025:
54026: IF c2%ROWCOUNT > 0 THEN
54027:
54028: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
54029: lv_batch_start := lv_batch_id;
54030: lb_batch.extend(lb_rowid.count);
54031:
54032: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

Line 54036: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

54032: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
54033:
54034: lb_batch(j):= lv_batch_id;
54035: IF MOD(j,v_batch_size) = 0 THEN
54036: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
54037: END IF;
54038:
54039: END LOOP;
54040:

Line 54196: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

54192: FETCH c2 BULK COLLECT INTO lb_rowid ;
54193:
54194: IF c2%ROWCOUNT > 0 THEN
54195:
54196: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
54197: lv_batch_start := lv_batch_id;
54198: lb_batch.extend(lb_rowid.count);
54199:
54200: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

Line 54204: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;

54200: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
54201:
54202: lb_batch(j):= lv_batch_id;
54203: IF MOD(j,v_batch_size) = 0 THEN
54204: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
54205: END IF;
54206:
54207: END LOOP;
54208: