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 DUAL

Line 3168: FROM dual

3164:
3165: BEGIN
3166: SELECT 1
3167: INTO lv_rec_count_cal
3168: FROM dual
3169: WHERE EXISTS(SELECT 1
3170: FROM msc_st_calendars
3171: WHERE sr_instance_id = v_instance_id
3172: AND process_flag = G_VALID);

Line 3182: FROM dual

3178:
3179: BEGIN
3180: SELECT 1
3181: INTO lv_rec_count_mtp
3182: FROM dual
3183: WHERE EXISTS(SELECT 1
3184: FROM msc_st_trading_partners
3185: WHERE sr_instance_id = v_instance_id
3186: AND process_flag = G_VALID);

Line 3977: FROM dual;

3973:
3974: v_sql_stmt := 1;
3975: SELECT msc_st_calendars_s.NEXTVAL
3976: INTO lv_transaction_id
3977: FROM dual;
3978:
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Refresh ID: '||v_refresh_id);
3980:
3981: --Update the transaction_id and the who columns

Line 4327: FROM dual;

4323:
4324: v_sql_stmt := 8;
4325: SELECT msc_st_workday_patterns_s.NEXTVAL
4326: INTO lv_transaction_id
4327: FROM dual;
4328:
4329: v_sql_stmt := 9;
4330: UPDATE msc_st_workday_patterns
4331: SET st_transaction_id = lv_transaction_id,

Line 4464: FROM dual;

4460: lv_shift_num := rec2.shift_name;
4461: ELSE
4462: SELECT msc_st_shift_num_s.NEXTVAL
4463: INTO lv_shift_num
4464: FROM dual;
4465: END IF;
4466:
4467: lv_return := derive_shift_details
4468: (p_transaction_id => lv_transaction_id,

Line 4501: FROM dual;

4497:
4498: v_sql_stmt := 13;
4499: SELECT msc_st_shift_times_s.NEXTVAL
4500: INTO lv_transaction_id
4501: FROM dual;
4502:
4503: v_sql_stmt := 14;
4504: UPDATE msc_st_shift_times
4505: SET st_transaction_id = lv_transaction_id,

Line 4578: ||' FROM DUAL'

4574: BEGIN
4575: v_sql_stmt := 17; /*Bug 2172537-Modified the satement*/
4576: lv_sql_stmt :=
4577: 'SELECT 1'
4578: ||' FROM DUAL'
4579: ||' WHERE NOT EXISTS(SELECT 1'
4580: ||' FROM msc_st_shift_times'
4581: ||' WHERE sr_instance_code = :sr_instance_code'
4582: ||' AND process_flag = '||G_IN_PROCESS

Line 4743: FROM dual;

4739:
4740: v_sql_stmt := 18;
4741: SELECT msc_st_calendar_exceptions_s.NEXTVAL
4742: INTO lv_transaction_id
4743: FROM dual;
4744:
4745: v_sql_stmt := 19;
4746: UPDATE msc_st_calendar_exceptions
4747: SET st_transaction_id = lv_transaction_id,

Line 4985: FROM dual;

4981:
4982: v_sql_stmt := 22;
4983: SELECT msc_st_shift_exceptions_s.NEXTVAL
4984: INTO lv_transaction_id
4985: FROM dual;
4986:
4987: v_sql_stmt := 23;
4988: UPDATE msc_st_shift_exceptions
4989: SET st_transaction_id = lv_transaction_id,

Line 5828: FROM DUAL;

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;
5831: lv_sql_stmt :=
5832: 'UPDATE msc_st_demand_classes '

Line 6648: FROM DUAL;

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;
6651: lv_sql_stmt :=
6652: 'UPDATE msc_st_trading_partners '

Line 7793: FROM DUAL;

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;
7796: lv_sql_stmt :=
7797: 'UPDATE msc_st_trading_partner_sites '

Line 8642: FROM DUAL;

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;
8645: lv_sql_stmt :=
8646: 'UPDATE msc_st_sub_inventories '

Line 8986: FROM DUAL;

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;
8989: lv_sql_stmt :=
8990: 'UPDATE msc_st_location_associations '

Line 9589: FROM DUAL;

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;
9592: lv_sql_stmt :=
9593: 'UPDATE msc_st_partner_contacts '

Line 9999: FROM dual;

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;
10002: lv_sql_stmt :=
10003: ' UPDATE MSC_ST_GROUPS '

Line 10286: select fnd_global.user_id into lv_user_id from dual;

10282: IF lv_return <> 0 THEN
10283: RAISE ex_logging_err;
10284: END IF;
10285:
10286: select fnd_global.user_id into lv_user_id from dual;
10287:
10288: IF NOT MSC_ST_util.IS_OPERATOR(lv_user_id) THEN
10289: lv_return := MSC_ST_util.GET_ERROR_MESSAGE
10290: (p_app_short_name => 'MSC',

Line 10665: FROM DUAL;

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;
10668: lv_sql_stmt :=
10669: 'UPDATE msc_st_group_companies '

Line 10866: select fnd_global.user_id into lv_user_id from dual;

10862:
10863:
10864: -- Only group owner or operator can update
10865:
10866: select fnd_global.user_id into lv_user_id from dual;
10867:
10868: lv_return := MSC_ST_util.GET_ERROR_MESSAGE
10869: (p_app_short_name => 'MSC',
10870: p_error_code => 'MSC_PP_INVALID_VALUE',

Line 11374: FROM dual;

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;
11377: lv_sql_stmt :=
11378: 'UPDATE msc_st_calendar_assignments '

Line 12691: FROM dual;

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;
12694: lv_sql_stmt :=
12695: 'UPDATE msc_st_visits '

Line 13110: FROM dual;

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;
13113: lv_sql_stmt :=
13114: 'UPDATE msc_st_wo_milestones '

Line 13709: FROM dual;

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;
13712: lv_sql_stmt :=
13713: 'UPDATE msc_st_wo_attributes '

Line 14309: FROM dual;

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;
14312: lv_sql_stmt :=
14313: 'UPDATE msc_st_wo_task_hierarchy '

Line 14881: FROM dual;

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;
14884: lv_sql_stmt :=
14885: 'UPDATE msc_st_wo_operation_rel '

Line 15565: FROM dual;

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;
15568: lv_sql_stmt :=
15569: 'UPDATE msc_st_planners '

Line 16221: FROM DUAL;

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;
16224: lv_sql_stmt :=
16225: 'UPDATE msc_st_interorg_ship_methods '

Line 17200: ||' FROM dual';

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;
17204: CLOSE c1;

Line 17811: FROM DUAL;

17807: LOOP
17808:
17809: SELECT msc_st_batch_id_s.NEXTVAL
17810: INTO lv_batch_id
17811: FROM DUAL;
17812:
17813: lv_sql_stmt :=
17814: 'UPDATE msc_st_zone_regions '
17815: ||' SET batch_id = :lv_batch_id'

Line 18393: ||' FROM dual';

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;
18397: CLOSE c1;

Line 18897: ||' FROM dual';

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;
18901: CLOSE c1;

Line 19327: FROM dual;

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;
19330: lv_sql_stmt :=
19331: ' UPDATE msc_st_category_sets '

Line 19777: FROM dual;

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;
19780: lv_sql_stmt :=
19781: 'UPDATE msc_st_units_of_measure '

Line 20287: FROM dual;

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;
20290: lv_sql_stmt :=
20291: 'UPDATE msc_st_uom_class_conversions '

Line 20857: FROM dual;

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;
20860: lv_sql_stmt :=
20861: 'UPDATE msc_st_uom_conversions '

Line 21446: FROM dual;

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;
21449: lv_sql_stmt :=
21450: 'UPDATE msc_st_designators '

Line 24406: FROM dual;

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;
24409: lv_sql_stmt :=
24410: ' UPDATE msc_st_item_substitutes '

Line 25107: FROM dual;

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;
25110: lv_sql_stmt :=
25111: 'UPDATE msc_st_item_suppliers '

Line 25742: FROM dual;

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;
25745: lv_sql_stmt :=
25746: 'UPDATE msc_st_supplier_capacities '

Line 26192: FROM dual;

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;
26195: lv_sql_stmt :=
26196: 'UPDATE msc_st_supplier_flex_fences '

Line 26699: FROM dual;

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;
26702: lv_sql_stmt :=
26703: ' UPDATE msc_st_safety_stocks '

Line 27205: FROM dual;

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;
27208: lv_sql_stmt :=
27209: 'UPDATE msc_st_item_categories '

Line 27917: ||' FROM dual';

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;
27921: CLOSE c1;

Line 29798: ||' FROM dual';

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;
29802: CLOSE c1;

Line 30644: FROM dual;

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;
30647: lv_sql_stmt :=
30648: ' UPDATE msc_st_resource_groups '

Line 31051: ||' FROM dual';

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;
31055: CLOSE c1;

Line 32115: ||' FROM dual';

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;
32119: CLOSE c1;

Line 32645: ||' FROM dual';

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;
32649: CLOSE c1;

Line 33221: ||' FROM dual';

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;
33225: CLOSE c1;

Line 33514: ||' FROM dual';

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;
33518: CLOSE c1;

Line 37697: FROM DUAL;

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;
37700: lv_sql_stmt :=
37701: 'UPDATE msc_st_reservations '

Line 39835: FROM DUAL;

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;
39838: lv_sql_stmt :=
39839: ' UPDATE MSC_ST_COMPANY_USERS '

Line 40601: ||' FROM dual';

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;
40605: CLOSE c1;

Line 41210: ||' FROM dual';

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;
41214: CLOSE c1;

Line 42349: ||' FROM dual';

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;
42353: CLOSE c1;

Line 42941: ||' FROM dual';

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;
42945:

Line 43681: ||' FROM dual';

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;
43685: CLOSE c1;

Line 44547: ||' FROM dual';

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;
44551: CLOSE c1;

Line 44556: FROM dual;

44552:
44553:
44554: SELECT msc_st_batch_id_s.NEXTVAL
44555: INTO lv_batch_id
44556: FROM dual;
44557:
44558: v_sql_stmt := 21;
44559: lv_sql_stmt :=
44560: ' UPDATE msc_st_routing_operations '

Line 45412: ||' FROM dual';

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;
45416: CLOSE c1;

Line 46406: ||' FROM dual';

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;
46410: CLOSE c1;

Line 47465: FROM dual;

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;
47468: lv_sql_stmt :=
47469: ' UPDATE msc_st_supplies '

Line 48548: ||' FROM dual';

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;
48552: CLOSE c1;

Line 49811: FROM DUAL;

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;
49814: lv_sql_stmt :=
49815: ' UPDATE msc_st_demands '

Line 50582: -- FROM DUAL;

50578: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50579:
50580: -- SELECT msc_st_operation_sequence_id_s.NEXTVAL
50581: -- INTO lv_local_id
50582: -- FROM DUAL;
50583:
50584: UPDATE msc_st_demands
50585: SET operation_seq_num =
50586: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),

Line 50905: ||' FROM dual';

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;
50909: CLOSE c1;

Line 51828: ||' FROM dual';

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;
51832: CLOSE c1;

Line 52483: FROM DUAL;

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;
52486: lv_sql_stmt :=
52487: ' UPDATE msc_st_job_requirement_ops '

Line 53309: ||' FROM dual';

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;
53313: CLOSE c1;

Line 55063: FROM dual;

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;
55066: lv_sql_stmt :=
55067: 'UPDATE msc_st_item_customers '

Line 55677: FROM DUAL;

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;
55680: lv_sql_stmt :=
55681: 'UPDATE '||p_table_name

Line 57484: FROM dual;

57480:
57481:
57482: SELECT msc_st_apps_instances_s.NEXTVAL
57483: INTO lv_transaction_id
57484: FROM dual;
57485:
57486:
57487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Refresh ID: '||v_refresh_id);
57488:

Line 57686: FROM DUAL;

57682: WHERE INSTANCE_ID= p_instance_id;
57683:
57684: SELECT MSC_COLLECTION_S.CURRVAL
57685: INTO v_last_collection_id
57686: FROM DUAL;
57687:
57688: RETURN TRUE;
57689:
57690: END IF;

Line 57859: select (SYSDATE- START_TIME) into lv_process_time from dual;

57855: EXIT WHEN is_request_status_running <> SYS_YES;
57856:
57857: -- ============= Check the execution time ==============
57858:
57859: select (SYSDATE- START_TIME) into lv_process_time from dual;
57860: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT;
57861: END IF;
57862:
57863: -- ============= Get the Task from Task Que ==============

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:

Line 59504: select (SYSDATE- START_TIME) into lv_process_time from dual;

59500: END IF;
59501:
59502: -- ============= Check the execution time ==============
59503:
59504: select (SYSDATE- START_TIME) into lv_process_time from dual;
59505:
59506: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
59507:
59508: END LOOP;

Line 59582: -- SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;

59578: RAISE EX_PIPE_RCV; -- If the error is not time-out error
59579: END IF;
59580:
59581: -- WHY ?
59582: -- SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
59583: -- EXIT WHEN lv_process_time > 10.0/1440.0; -- wait for 10 minutes
59584:
59585: END LOOP;
59586: