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 5826: SELECT msc_st_batch_id_s.NEXTVAL

5822:
5823: -- Dividing records in batches based on batchsize
5824: LOOP
5825: v_sql_stmt := 03;
5826: SELECT msc_st_batch_id_s.NEXTVAL
5827: INTO lv_batch_id
5828: FROM DUAL;
5829:
5830: v_sql_stmt := 04;

Line 6646: SELECT msc_st_batch_id_s.NEXTVAL

6642:
6643: -- Dividing records in batches based on batchsize
6644: LOOP
6645: v_sql_stmt := 05;
6646: SELECT msc_st_batch_id_s.NEXTVAL
6647: INTO lv_batch_id
6648: FROM DUAL;
6649:
6650: v_sql_stmt := 06;

Line 7791: SELECT msc_st_batch_id_s.NEXTVAL

7787: -- Dividing records in batches based on batchsize
7788:
7789: LOOP
7790: v_sql_stmt := 21;
7791: SELECT msc_st_batch_id_s.NEXTVAL
7792: INTO lv_batch_id
7793: FROM DUAL;
7794:
7795: v_sql_stmt := 22;

Line 8640: SELECT msc_st_batch_id_s.NEXTVAL

8636: -- Dividing records in batches based on batchsize
8637:
8638: LOOP
8639: v_sql_stmt := 29;
8640: SELECT msc_st_batch_id_s.NEXTVAL
8641: INTO lv_batch_id
8642: FROM DUAL;
8643:
8644: v_sql_stmt := 30;

Line 8984: SELECT msc_st_batch_id_s.NEXTVAL

8980:
8981: -- Dividing records in batches based on batchsize
8982: LOOP
8983: v_sql_stmt := 36;
8984: SELECT msc_st_batch_id_s.NEXTVAL
8985: INTO lv_batch_id
8986: FROM DUAL;
8987:
8988: v_sql_stmt := 37;

Line 9587: SELECT msc_st_batch_id_s.NEXTVAL

9583:
9584: -- Dividing records in batches based on batchsize
9585: LOOP
9586: v_sql_stmt := 47;
9587: SELECT msc_st_batch_id_s.NEXTVAL
9588: INTO lv_batch_id
9589: FROM DUAL;
9590:
9591: v_sql_stmt := 48;

Line 9997: SELECT msc_st_batch_id_s.NEXTVAL

9993:
9994: -- Dividing records in batches based on batchsize
9995: LOOP
9996: v_sql_stmt := 54;
9997: SELECT msc_st_batch_id_s.NEXTVAL
9998: INTO lv_batch_id
9999: FROM dual;
10000:
10001: v_sql_stmt := 55;

Line 10663: SELECT msc_st_batch_id_s.NEXTVAL

10659: -- Dividing records in batches based on batchsize
10660:
10661: LOOP
10662: v_sql_stmt := 70;
10663: SELECT msc_st_batch_id_s.NEXTVAL
10664: INTO lv_batch_id
10665: FROM DUAL;
10666:
10667: v_sql_stmt := 71;

Line 11372: SELECT msc_st_batch_id_s.NEXTVAL

11368: ||'COMPANY_NAME';
11369:
11370: LOOP
11371: v_sql_stmt := 03;
11372: SELECT msc_st_batch_id_s.NEXTVAL
11373: INTO lv_batch_id
11374: FROM dual;
11375:
11376: v_sql_stmt := 04;

Line 12689: SELECT msc_st_batch_id_s.NEXTVAL

12685:
12686:
12687: LOOP
12688: v_sql_stmt := 03;
12689: SELECT msc_st_batch_id_s.NEXTVAL
12690: INTO lv_batch_id
12691: FROM dual;
12692:
12693: v_sql_stmt := 04;

Line 13108: SELECT msc_st_batch_id_s.NEXTVAL

13104:
13105:
13106: LOOP
13107: v_sql_stmt := 03;
13108: SELECT msc_st_batch_id_s.NEXTVAL
13109: INTO lv_batch_id
13110: FROM dual;
13111:
13112: v_sql_stmt := 04;

Line 13707: SELECT msc_st_batch_id_s.NEXTVAL

13703:
13704:
13705: LOOP
13706: v_sql_stmt := 03;
13707: SELECT msc_st_batch_id_s.NEXTVAL
13708: INTO lv_batch_id
13709: FROM dual;
13710:
13711: v_sql_stmt := 04;

Line 14307: SELECT msc_st_batch_id_s.NEXTVAL

14303:
14304:
14305: LOOP
14306: v_sql_stmt := 03;
14307: SELECT msc_st_batch_id_s.NEXTVAL
14308: INTO lv_batch_id
14309: FROM dual;
14310:
14311: v_sql_stmt := 04;

Line 14879: SELECT msc_st_batch_id_s.NEXTVAL

14875:
14876:
14877: LOOP
14878: v_sql_stmt := 03;
14879: SELECT msc_st_batch_id_s.NEXTVAL
14880: INTO lv_batch_id
14881: FROM dual;
14882:
14883: v_sql_stmt := 04;

Line 15563: SELECT msc_st_batch_id_s.NEXTVAL

15559:
15560:
15561: LOOP
15562: v_sql_stmt := 03;
15563: SELECT msc_st_batch_id_s.NEXTVAL
15564: INTO lv_batch_id
15565: FROM dual;
15566:
15567: v_sql_stmt := 04;

Line 16219: SELECT msc_st_batch_id_s.NEXTVAL

16215:
16216: -- Dividing records in batches based on batchsize
16217: LOOP
16218: v_sql_stmt := 03;
16219: SELECT msc_st_batch_id_s.NEXTVAL
16220: INTO lv_batch_id
16221: FROM DUAL;
16222:
16223: v_sql_stmt := 04;

Line 17199: ' SELECT msc_st_batch_id_s.NEXTVAL '

17195: -- Now processing by batch
17196: LOOP
17197: v_sql_stmt := 03;
17198: lv_cursor_stmt :=
17199: ' SELECT msc_st_batch_id_s.NEXTVAL '
17200: ||' FROM dual';
17201:
17202: OPEN c1 FOR lv_cursor_stmt;
17203: FETCH c1 INTO lv_batch_id;

Line 17809: SELECT msc_st_batch_id_s.NEXTVAL

17805: ||'DELETED_FLAG';
17806:
17807: LOOP
17808:
17809: SELECT msc_st_batch_id_s.NEXTVAL
17810: INTO lv_batch_id
17811: FROM DUAL;
17812:
17813: lv_sql_stmt :=

Line 18392: ' SELECT msc_st_batch_id_s.NEXTVAL '

18388: -- Now processing by batch
18389: LOOP
18390: v_sql_stmt := 03;
18391: lv_cursor_stmt :=
18392: ' SELECT msc_st_batch_id_s.NEXTVAL '
18393: ||' FROM dual';
18394:
18395: OPEN c1 FOR lv_cursor_stmt;
18396: FETCH c1 INTO lv_batch_id;

Line 18896: ' SELECT msc_st_batch_id_s.NEXTVAL '

18892: -- Now processing by batch
18893: LOOP
18894:
18895: lv_cursor_stmt :=
18896: ' SELECT msc_st_batch_id_s.NEXTVAL '
18897: ||' FROM dual';
18898:
18899: OPEN c1 FOR lv_cursor_stmt;
18900: FETCH c1 INTO lv_batch_id;

Line 19325: SELECT msc_st_batch_id_s.NEXTVAL

19321: ||'DELETED_FLAG ';
19322:
19323: LOOP
19324: v_sql_stmt := 03;
19325: SELECT msc_st_batch_id_s.NEXTVAL
19326: INTO lv_batch_id
19327: FROM dual;
19328:
19329: v_sql_stmt := 04;

Line 19775: SELECT msc_st_batch_id_s.NEXTVAL

19771: ||'DELETED_FLAG';
19772:
19773: LOOP
19774: v_sql_stmt := 03;
19775: SELECT msc_st_batch_id_s.NEXTVAL
19776: INTO lv_batch_id
19777: FROM dual;
19778:
19779: v_sql_stmt := 04;

Line 20285: SELECT msc_st_batch_id_s.NEXTVAL

20281: ||'DELETED_FLAG';
20282:
20283: LOOP
20284: v_sql_stmt := 12;
20285: SELECT msc_st_batch_id_s.NEXTVAL
20286: INTO lv_batch_id
20287: FROM dual;
20288:
20289: v_sql_stmt := 13;

Line 20855: SELECT msc_st_batch_id_s.NEXTVAL

20851: ||'DELETED_FLAG';
20852:
20853: LOOP
20854: v_sql_stmt := 25;
20855: SELECT msc_st_batch_id_s.NEXTVAL
20856: INTO lv_batch_id
20857: FROM dual;
20858:
20859: v_sql_stmt := 26;

Line 21444: SELECT msc_st_batch_id_s.NEXTVAL

21440:
21441: LOOP
21442: v_sql_stmt := 03;
21443:
21444: SELECT msc_st_batch_id_s.NEXTVAL
21445: INTO lv_batch_id
21446: FROM dual;
21447:
21448: v_sql_stmt := 04;

Line 24404: SELECT msc_st_batch_id_s.NEXTVAL

24400: ||'DELETED_FLAG ';
24401:
24402: LOOP
24403: v_sql_stmt := 03;
24404: SELECT msc_st_batch_id_s.NEXTVAL
24405: INTO lv_batch_id
24406: FROM dual;
24407:
24408: v_sql_stmt := 04;

Line 25105: SELECT msc_st_batch_id_s.NEXTVAL

25101: ||'DELETED_FLAG';
25102:
25103: LOOP
25104: v_sql_stmt := 03;
25105: SELECT msc_st_batch_id_s.NEXTVAL
25106: INTO lv_batch_id
25107: FROM dual;
25108:
25109: v_sql_stmt := 04;

Line 25740: SELECT msc_st_batch_id_s.NEXTVAL

25736: ||'USING_ORGANIZATION_ID';
25737:
25738: LOOP
25739: v_sql_stmt := 11;
25740: SELECT msc_st_batch_id_s.NEXTVAL
25741: INTO lv_batch_id
25742: FROM dual;
25743:
25744: v_sql_stmt := 12;

Line 26190: SELECT msc_st_batch_id_s.NEXTVAL

26186: ||'USING_ORGANIZATION_ID';
26187:
26188: LOOP
26189: v_sql_stmt := 19;
26190: SELECT msc_st_batch_id_s.NEXTVAL
26191: INTO lv_batch_id
26192: FROM dual;
26193:
26194: v_sql_stmt := 20;

Line 26697: SELECT msc_st_batch_id_s.NEXTVAL

26693: ||'DELETED_FLAG ';
26694:
26695: LOOP
26696: v_sql_stmt := 03;
26697: SELECT msc_st_batch_id_s.NEXTVAL
26698: INTO lv_batch_id
26699: FROM dual;
26700:
26701: v_sql_stmt := 04;

Line 27203: SELECT msc_st_batch_id_s.NEXTVAL

27199:
27200:
27201: LOOP
27202: v_sql_stmt := 03;
27203: SELECT msc_st_batch_id_s.NEXTVAL
27204: INTO lv_batch_id
27205: FROM dual;
27206:
27207: v_sql_stmt := 04;

Line 27916: ' SELECT msc_st_batch_id_s.NEXTVAL '

27912:
27913: LOOP
27914: v_sql_stmt := 03;
27915: lv_cursor_stmt :=
27916: ' SELECT msc_st_batch_id_s.NEXTVAL '
27917: ||' FROM dual';
27918:
27919: OPEN c1 FOR lv_cursor_stmt;
27920: FETCH c1 INTO lv_batch_id;

Line 29797: ' SELECT msc_st_batch_id_s.NEXTVAL '

29793:
29794: LOOP
29795: v_sql_stmt := 03;
29796: lv_cursor_stmt :=
29797: ' SELECT msc_st_batch_id_s.NEXTVAL '
29798: ||' FROM dual';
29799:
29800: OPEN c1 FOR lv_cursor_stmt;
29801: FETCH c1 INTO lv_batch_id;

Line 30642: SELECT msc_st_batch_id_s.NEXTVAL

30638: ||'DELETED_FLAG';
30639:
30640: LOOP
30641: v_sql_stmt := 03;
30642: SELECT msc_st_batch_id_s.NEXTVAL
30643: INTO lv_batch_id
30644: FROM dual;
30645:
30646: v_sql_stmt := 04;

Line 31050: ' SELECT msc_st_batch_id_s.NEXTVAL '

31046:
31047: LOOP
31048: v_sql_stmt := 03;
31049: lv_cursor_stmt :=
31050: ' SELECT msc_st_batch_id_s.NEXTVAL '
31051: ||' FROM dual';
31052:
31053: OPEN c1 FOR lv_cursor_stmt;
31054: FETCH c1 INTO lv_batch_id;

Line 32114: ' SELECT msc_st_batch_id_s.NEXTVAL '

32110:
32111: LOOP
32112: v_sql_stmt := 21;
32113: lv_cursor_stmt :=
32114: ' SELECT msc_st_batch_id_s.NEXTVAL '
32115: ||' FROM dual';
32116:
32117: OPEN c1 FOR lv_cursor_stmt;
32118: FETCH c1 INTO lv_batch_id;

Line 32644: ' SELECT msc_st_batch_id_s.NEXTVAL '

32640:
32641: LOOP
32642: v_sql_stmt := 33;
32643: lv_cursor_stmt :=
32644: ' SELECT msc_st_batch_id_s.NEXTVAL '
32645: ||' FROM dual';
32646:
32647: OPEN c1 FOR lv_cursor_stmt;
32648: FETCH c1 INTO lv_batch_id;

Line 33220: ' SELECT msc_st_batch_id_s.NEXTVAL '

33216: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code;
33217:
33218: v_sql_stmt := 01;
33219: lv_cursor_stmt :=
33220: ' SELECT msc_st_batch_id_s.NEXTVAL '
33221: ||' FROM dual';
33222:
33223: OPEN c1 FOR lv_cursor_stmt;
33224: FETCH c1 INTO lv_batch_id;

Line 33513: ' SELECT msc_st_batch_id_s.NEXTVAL '

33509: BEGIN
33510: LOOP
33511: v_sql_stmt := 01;
33512: lv_cursor_stmt :=
33513: ' SELECT msc_st_batch_id_s.NEXTVAL '
33514: ||' FROM dual';
33515:
33516: OPEN c1 FOR lv_cursor_stmt;
33517: FETCH c1 INTO lv_batch_id;

Line 37695: SELECT msc_st_batch_id_s.NEXTVAL

37691:
37692: -- Dividing records in batches based on batchsize
37693: LOOP
37694: v_sql_stmt := 03;
37695: SELECT msc_st_batch_id_s.NEXTVAL
37696: INTO lv_batch_id
37697: FROM DUAL;
37698:
37699: v_sql_stmt := 04;

Line 39833: SELECT msc_st_batch_id_s.NEXTVAL

39829:
39830: LOOP
39831: v_sql_stmt := 01;
39832:
39833: SELECT msc_st_batch_id_s.NEXTVAL
39834: INTO lv_batch_id
39835: FROM DUAL;
39836:
39837: v_sql_stmt := 02;

Line 40600: ' SELECT msc_st_batch_id_s.NEXTVAL '

40596:
40597: LOOP
40598: v_sql_stmt := 03;
40599: lv_cursor_stmt :=
40600: ' SELECT msc_st_batch_id_s.NEXTVAL '
40601: ||' FROM dual';
40602:
40603: OPEN c1 FOR lv_cursor_stmt;
40604: FETCH c1 INTO lv_batch_id;

Line 41209: ' SELECT msc_st_batch_id_s.NEXTVAL '

41205:
41206: LOOP
41207: v_sql_stmt := 13;
41208: lv_cursor_stmt :=
41209: ' SELECT msc_st_batch_id_s.NEXTVAL '
41210: ||' FROM dual';
41211:
41212: OPEN c1 FOR lv_cursor_stmt;
41213: FETCH c1 INTO lv_batch_id;

Line 42348: ' SELECT msc_st_batch_id_s.NEXTVAL '

42344:
42345: LOOP
42346: v_sql_stmt := 28;
42347: lv_cursor_stmt :=
42348: ' SELECT msc_st_batch_id_s.NEXTVAL '
42349: ||' FROM dual';
42350:
42351: OPEN c1 FOR lv_cursor_stmt;
42352: FETCH c1 INTO lv_batch_id;

Line 42940: ' SELECT msc_st_batch_id_s.NEXTVAL '

42936:
42937: LOOP
42938: v_sql_stmt := 38;
42939: lv_cursor_stmt :=
42940: ' SELECT msc_st_batch_id_s.NEXTVAL '
42941: ||' FROM dual';
42942: OPEN c1 FOR lv_cursor_stmt;
42943: FETCH c1 INTO lv_batch_id;
42944: CLOSE c1;

Line 43680: ' SELECT msc_st_batch_id_s.NEXTVAL '

43676: -- Now processing by batch
43677: LOOP
43678: v_sql_stmt := 03;
43679: lv_cursor_stmt :=
43680: ' SELECT msc_st_batch_id_s.NEXTVAL '
43681: ||' FROM dual';
43682:
43683: OPEN c1 FOR lv_cursor_stmt;
43684: FETCH c1 INTO lv_batch_id;

Line 44546: ' SELECT msc_st_batch_id_s.NEXTVAL '

44542: LOOP
44543:
44544: v_sql_stmt := 20;
44545: lv_cursor_stmt :=
44546: ' SELECT msc_st_batch_id_s.NEXTVAL '
44547: ||' FROM dual';
44548:
44549: OPEN c1 FOR lv_cursor_stmt;
44550: FETCH c1 INTO lv_batch_id;

Line 44554: SELECT msc_st_batch_id_s.NEXTVAL

44550: FETCH c1 INTO lv_batch_id;
44551: CLOSE c1;
44552:
44553:
44554: SELECT msc_st_batch_id_s.NEXTVAL
44555: INTO lv_batch_id
44556: FROM dual;
44557:
44558: v_sql_stmt := 21;

Line 45411: ' SELECT msc_st_batch_id_s.NEXTVAL '

45407: ||' COMPANY_NAME';
45408:
45409: LOOP
45410: lv_cursor_stmt :=
45411: ' SELECT msc_st_batch_id_s.NEXTVAL '
45412: ||' FROM dual';
45413:
45414: OPEN c1 FOR lv_cursor_stmt;
45415: FETCH c1 INTO lv_batch_id;

Line 46405: ' SELECT msc_st_batch_id_s.NEXTVAL '

46401:
46402: v_sql_stmt := 53;
46403:
46404: lv_cursor_stmt :=
46405: ' SELECT msc_st_batch_id_s.NEXTVAL '
46406: ||' FROM dual';
46407:
46408: OPEN c1 FOR lv_cursor_stmt;
46409: FETCH c1 INTO lv_batch_id;

Line 47463: SELECT msc_st_batch_id_s.NEXTVAL

47459: ||'ORDER_NUMBER';
47460:
47461: LOOP
47462: v_sql_stmt := 03;
47463: SELECT msc_st_batch_id_s.NEXTVAL
47464: INTO lv_batch_id
47465: FROM dual;
47466:
47467: v_sql_stmt := 04;

Line 48547: ' SELECT msc_st_batch_id_s.NEXTVAL '

48543: -- Now processing by batch
48544: LOOP
48545: v_sql_stmt := 03;
48546: lv_cursor_stmt :=
48547: ' SELECT msc_st_batch_id_s.NEXTVAL '
48548: ||' FROM dual';
48549:
48550: OPEN c1 FOR lv_cursor_stmt;
48551: FETCH c1 INTO lv_batch_id;

Line 49809: SELECT msc_st_batch_id_s.NEXTVAL

49805:
49806:
49807: LOOP
49808: v_sql_stmt := 03;
49809: SELECT msc_st_batch_id_s.NEXTVAL
49810: INTO lv_batch_id
49811: FROM DUAL;
49812:
49813: v_sql_stmt := 04;

Line 50904: ' SELECT msc_st_batch_id_s.NEXTVAL '

50900:
50901: v_sql_stmt := 3;
50902:
50903: lv_cursor_stmt :=
50904: ' SELECT msc_st_batch_id_s.NEXTVAL '
50905: ||' FROM dual';
50906:
50907: OPEN c1 FOR lv_cursor_stmt;
50908: FETCH c1 INTO lv_batch_id;

Line 51827: ' SELECT msc_st_batch_id_s.NEXTVAL '

51823:
51824: LOOP
51825:
51826: lv_cursor_stmt :=
51827: ' SELECT msc_st_batch_id_s.NEXTVAL '
51828: ||' FROM dual';
51829:
51830: OPEN c1 FOR lv_cursor_stmt;
51831: FETCH c1 INTO lv_batch_id;

Line 52481: SELECT msc_st_batch_id_s.NEXTVAL

52477: ||' PRIMARY_COMPONENT_NAME' ;
52478:
52479: LOOP
52480: v_sql_stmt := 03;
52481: SELECT msc_st_batch_id_s.NEXTVAL
52482: INTO lv_batch_id
52483: FROM DUAL;
52484:
52485: v_sql_stmt := 04;

Line 53308: ' SELECT msc_st_batch_id_s.NEXTVAL '

53304: -- Now processing by batch
53305: LOOP
53306: v_sql_stmt := 03;
53307: lv_cursor_stmt :=
53308: ' SELECT msc_st_batch_id_s.NEXTVAL '
53309: ||' FROM dual';
53310:
53311: OPEN c1 FOR lv_cursor_stmt;
53312: FETCH c1 INTO lv_batch_id;

Line 55061: SELECT msc_st_batch_id_s.NEXTVAL

55057:
55058: LOOP
55059: v_sql_stmt := 05;
55060:
55061: SELECT msc_st_batch_id_s.NEXTVAL
55062: INTO lv_batch_id
55063: FROM dual;
55064:
55065: v_sql_stmt := 06;

Line 55675: SELECT msc_st_batch_id_s.NEXTVAL

55671: EX_PIPE_SND EXCEPTION ;
55672:
55673: BEGIN
55674: LOOP
55675: SELECT msc_st_batch_id_s.NEXTVAL
55676: INTO lv_batch_id
55677: FROM DUAL;
55678:
55679: v_sql_stmt := 01;

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

58695: FETCH c2 BULK COLLECT INTO lb_rowid ;
58696:
58697: IF c2%ROWCOUNT > 0 THEN
58698:
58699: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
58700: lv_batch_start := lv_batch_id;
58701: lb_batch.extend(lb_rowid.count);
58702:
58703: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

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

58703: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
58704:
58705: lb_batch(j):= lv_batch_id;
58706: IF MOD(j,v_batch_size) = 0 THEN
58707: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
58708: END IF;
58709:
58710: END LOOP;
58711:

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

58960: FETCH c2 BULK COLLECT INTO lb_rowid ;
58961:
58962: IF c2%ROWCOUNT > 0 THEN
58963:
58964: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
58965: lv_batch_start := lv_batch_id;
58966: lb_batch.extend(lb_rowid.count);
58967:
58968: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

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

58968: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
58969:
58970: lb_batch(j):= lv_batch_id;
58971: IF MOD(j,v_batch_size) = 0 THEN
58972: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
58973: END IF;
58974:
58975: END LOOP;
58976:

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

59035: FETCH c2 BULK COLLECT INTO lb_rowid ;
59036:
59037: IF c2%ROWCOUNT > 0 THEN
59038:
59039: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
59040: lv_batch_start := lv_batch_id;
59041: lb_batch.extend(lb_rowid.count);
59042:
59043: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

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

59043: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
59044:
59045: lb_batch(j):= lv_batch_id;
59046: IF MOD(j,v_batch_size) = 0 THEN
59047: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
59048: END IF;
59049:
59050: END LOOP;
59051:

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

59117: FETCH c2 BULK COLLECT INTO lb_rowid ;
59118:
59119: IF c2%ROWCOUNT > 0 THEN
59120:
59121: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
59122: lv_batch_start := lv_batch_id;
59123: lb_batch.extend(lb_rowid.count);
59124:
59125: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

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

59125: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
59126:
59127: lb_batch(j):= lv_batch_id;
59128: IF MOD(j,v_batch_size) = 0 THEN
59129: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
59130: END IF;
59131:
59132: END LOOP;
59133:

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

59285: FETCH c2 BULK COLLECT INTO lb_rowid ;
59286:
59287: IF c2%ROWCOUNT > 0 THEN
59288:
59289: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
59290: lv_batch_start := lv_batch_id;
59291: lb_batch.extend(lb_rowid.count);
59292:
59293: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP

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

59293: FOR j IN lb_rowid.FIRST..lb_rowid.LAST LOOP
59294:
59295: lb_batch(j):= lv_batch_id;
59296: IF MOD(j,v_batch_size) = 0 THEN
59297: SELECT msc_st_batch_id_s.NEXTVAL INTO lv_batch_id FROM dual;
59298: END IF;
59299:
59300: END LOOP;
59301: