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.BSC_UPDATE_LOCK dependencies on BSC_UPDATE_LOG

Line 28: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

24: h_lock_types(h_num_objects) := 'W';
25: h_cascade_levels(h_num_objects) := 0;
26:
27: FOR h_i IN 1..h_num_objects LOOP
28: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
29: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
30: BSC_UPDATE_LOG.OUTPUT);
31: END LOOP;
32:

Line 30: BSC_UPDATE_LOG.OUTPUT);

26:
27: FOR h_i IN 1..h_num_objects LOOP
28: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
29: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
30: BSC_UPDATE_LOG.OUTPUT);
31: END LOOP;
32:
33: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
34:

Line 85: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

81: END LOOP;
82: CLOSE c_periodicities;
83:
84: FOR h_i IN 1..h_num_objects LOOP
85: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
86: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
87: BSC_UPDATE_LOG.OUTPUT);
88: END LOOP;
89:

Line 87: BSC_UPDATE_LOG.OUTPUT);

83:
84: FOR h_i IN 1..h_num_objects LOOP
85: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
86: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
87: BSC_UPDATE_LOG.OUTPUT);
88: END LOOP;
89:
90: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
91:

Line 194: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

190: END LOOP;
191: CLOSE c_tables;
192:
193: FOR h_i IN 1..h_num_objects LOOP
194: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
195: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
196: BSC_UPDATE_LOG.OUTPUT);
197: END LOOP;
198:

Line 196: BSC_UPDATE_LOG.OUTPUT);

192:
193: FOR h_i IN 1..h_num_objects LOOP
194: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
195: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
196: BSC_UPDATE_LOG.OUTPUT);
197: END LOOP;
198:
199: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
200:

Line 262: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

258: END LOOP;
259: CLOSE c_sum_tables;
260:
261: FOR h_i IN 1..h_num_objects LOOP
262: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
263: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
264: BSC_UPDATE_LOG.OUTPUT);
265: END LOOP;
266:

Line 264: BSC_UPDATE_LOG.OUTPUT);

260:
261: FOR h_i IN 1..h_num_objects LOOP
262: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
263: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
264: BSC_UPDATE_LOG.OUTPUT);
265: END LOOP;
266:
267: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
268:

Line 300: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

296: h_cascade_levels(h_num_objects) := 0;
297: END LOOP;
298:
299: FOR h_i IN 1..h_num_objects LOOP
300: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
301: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
302: BSC_UPDATE_LOG.OUTPUT);
303: END LOOP;
304:

Line 302: BSC_UPDATE_LOG.OUTPUT);

298:
299: FOR h_i IN 1..h_num_objects LOOP
300: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
301: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
302: BSC_UPDATE_LOG.OUTPUT);
303: END LOOP;
304:
305: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
306:

Line 350: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

346: h_lock_types(h_num_objects) := 'W';
347: h_cascade_levels(h_num_objects) := 0;
348:
349: FOR h_i IN 1..h_num_objects LOOP
350: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
351: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
352: BSC_UPDATE_LOG.OUTPUT);
353: END LOOP;
354:

Line 352: BSC_UPDATE_LOG.OUTPUT);

348:
349: FOR h_i IN 1..h_num_objects LOOP
350: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
351: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
352: BSC_UPDATE_LOG.OUTPUT);
353: END LOOP;
354:
355: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
356:

Line 383: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

379: h_lock_types(h_num_objects) := 'W';
380: h_cascade_levels(h_num_objects) := 0;
381:
382: FOR h_i IN 1..h_num_objects LOOP
383: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
384: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
385: BSC_UPDATE_LOG.OUTPUT);
386: END LOOP;
387:

Line 385: BSC_UPDATE_LOG.OUTPUT);

381:
382: FOR h_i IN 1..h_num_objects LOOP
383: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
384: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
385: BSC_UPDATE_LOG.OUTPUT);
386: END LOOP;
387:
388: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
389:

Line 418: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

414: h_lock_types(h_num_objects) := 'W';
415: h_cascade_levels(h_num_objects) := 0;
416:
417: FOR h_i IN 1..h_num_objects LOOP
418: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
419: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
420: BSC_UPDATE_LOG.OUTPUT);
421: END LOOP;
422:

Line 420: BSC_UPDATE_LOG.OUTPUT);

416:
417: FOR h_i IN 1..h_num_objects LOOP
418: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
419: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
420: BSC_UPDATE_LOG.OUTPUT);
421: END LOOP;
422:
423: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
424:

Line 546: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

542: END IF;
543: END LOOP;
544:
545: FOR h_i IN 1..h_num_objects LOOP
546: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
547: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
548: BSC_UPDATE_LOG.OUTPUT);
549: END LOOP;
550:

Line 548: BSC_UPDATE_LOG.OUTPUT);

544:
545: FOR h_i IN 1..h_num_objects LOOP
546: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
547: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
548: BSC_UPDATE_LOG.OUTPUT);
549: END LOOP;
550:
551: --need to commit because it used bsc_tmp_big_in_cond
552: commit;

Line 610: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

606: END IF;
607: END LOOP;
608:
609: FOR h_i IN 1..h_num_objects LOOP
610: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
611: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
612: BSC_UPDATE_LOG.OUTPUT);
613: END LOOP;
614:

Line 612: BSC_UPDATE_LOG.OUTPUT);

608:
609: FOR h_i IN 1..h_num_objects LOOP
610: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
611: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
612: BSC_UPDATE_LOG.OUTPUT);
613: END LOOP;
614:
615: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
616:

Line 662: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

658: CLOSE c_indics;
659: END LOOP;
660:
661: FOR h_i IN 1..h_num_objects LOOP
662: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
663: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
664: BSC_UPDATE_LOG.OUTPUT);
665: END LOOP;
666:

Line 664: BSC_UPDATE_LOG.OUTPUT);

660:
661: FOR h_i IN 1..h_num_objects LOOP
662: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
663: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
664: BSC_UPDATE_LOG.OUTPUT);
665: END LOOP;
666:
667: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
668:

Line 735: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

731: END IF;
732: END LOOP;
733:
734: FOR h_i IN 1..h_num_objects LOOP
735: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
736: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
737: BSC_UPDATE_LOG.OUTPUT);
738: END LOOP;
739:

Line 737: BSC_UPDATE_LOG.OUTPUT);

733:
734: FOR h_i IN 1..h_num_objects LOOP
735: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
736: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
737: BSC_UPDATE_LOG.OUTPUT);
738: END LOOP;
739:
740: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
741:

Line 894: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

890: END LOOP;
891: CLOSE h_cursor;
892:
893: FOR h_i IN 1..h_num_objects LOOP
894: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
895: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
896: BSC_UPDATE_LOG.OUTPUT);
897: END LOOP;
898:

Line 896: BSC_UPDATE_LOG.OUTPUT);

892:
893: FOR h_i IN 1..h_num_objects LOOP
894: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
895: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
896: BSC_UPDATE_LOG.OUTPUT);
897: END LOOP;
898:
899: --need to commit because it used bsc_tmp_big_in_cond
900: commit;

Line 931: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

927: h_lock_types(h_num_objects) := 'W';
928: h_cascade_levels(h_num_objects) := 0;
929:
930: FOR h_i IN 1..h_num_objects LOOP
931: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
932: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
933: BSC_UPDATE_LOG.OUTPUT);
934: END LOOP;
935:

Line 933: BSC_UPDATE_LOG.OUTPUT);

929:
930: FOR h_i IN 1..h_num_objects LOOP
931: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
932: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
933: BSC_UPDATE_LOG.OUTPUT);
934: END LOOP;
935:
936: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
937:

Line 969: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

965: h_cascade_levels(h_num_objects) := 0;
966: END LOOP;
967:
968: FOR h_i IN 1..h_num_objects LOOP
969: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
970: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
971: BSC_UPDATE_LOG.OUTPUT);
972: END LOOP;
973:

Line 971: BSC_UPDATE_LOG.OUTPUT);

967:
968: FOR h_i IN 1..h_num_objects LOOP
969: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
970: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
971: BSC_UPDATE_LOG.OUTPUT);
972: END LOOP;
973:
974: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
975:

Line 1019: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1015: END LOOP;
1016: CLOSE c_indicators;
1017:
1018: FOR h_i IN 1..h_num_objects LOOP
1019: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1020: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1021: BSC_UPDATE_LOG.OUTPUT);
1022: END LOOP;
1023:

Line 1021: BSC_UPDATE_LOG.OUTPUT);

1017:
1018: FOR h_i IN 1..h_num_objects LOOP
1019: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1020: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1021: BSC_UPDATE_LOG.OUTPUT);
1022: END LOOP;
1023:
1024: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1025:

Line 1054: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1050: h_lock_types(h_num_objects) := 'W';
1051: h_cascade_levels(h_num_objects) := 0;
1052:
1053: FOR h_i IN 1..h_num_objects LOOP
1054: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1055: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1056: BSC_UPDATE_LOG.OUTPUT);
1057: END LOOP;
1058:

Line 1056: BSC_UPDATE_LOG.OUTPUT);

1052:
1053: FOR h_i IN 1..h_num_objects LOOP
1054: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1055: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1056: BSC_UPDATE_LOG.OUTPUT);
1057: END LOOP;
1058:
1059: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1060:

Line 1103: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1099: END LOOP;
1100: CLOSE c_indicators;
1101:
1102: FOR h_i IN 1..h_num_objects LOOP
1103: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1104: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1105: BSC_UPDATE_LOG.OUTPUT);
1106: END LOOP;
1107:

Line 1105: BSC_UPDATE_LOG.OUTPUT);

1101:
1102: FOR h_i IN 1..h_num_objects LOOP
1103: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1104: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1105: BSC_UPDATE_LOG.OUTPUT);
1106: END LOOP;
1107:
1108: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1109:

Line 1163: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1159: END LOOP;
1160: CLOSE c_indicators;
1161:
1162: FOR h_i IN 1..h_num_objects LOOP
1163: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1164: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1165: BSC_UPDATE_LOG.OUTPUT);
1166: END LOOP;
1167:

Line 1165: BSC_UPDATE_LOG.OUTPUT);

1161:
1162: FOR h_i IN 1..h_num_objects LOOP
1163: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1164: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1165: BSC_UPDATE_LOG.OUTPUT);
1166: END LOOP;
1167:
1168: --need to commit because it used bsc_tmp_big_in_cond
1169: commit;

Line 1229: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1225: END LOOP;
1226: CLOSE c_indic_tables;
1227:
1228: FOR h_i IN 1..h_num_objects LOOP
1229: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1230: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1231: BSC_UPDATE_LOG.OUTPUT);
1232: END LOOP;
1233:

Line 1231: BSC_UPDATE_LOG.OUTPUT);

1227:
1228: FOR h_i IN 1..h_num_objects LOOP
1229: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1230: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1231: BSC_UPDATE_LOG.OUTPUT);
1232: END LOOP;
1233:
1234: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1235:

Line 1286: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1282: END LOOP;
1283: CLOSE c_source_tables;
1284:
1285: FOR h_i IN 1..h_num_objects LOOP
1286: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1287: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1288: BSC_UPDATE_LOG.OUTPUT);
1289: END LOOP;
1290:

Line 1288: BSC_UPDATE_LOG.OUTPUT);

1284:
1285: FOR h_i IN 1..h_num_objects LOOP
1286: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1287: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1288: BSC_UPDATE_LOG.OUTPUT);
1289: END LOOP;
1290:
1291: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1292:

Line 1375: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1371: CLOSE c_source_tables;
1372: END IF;
1373:
1374: FOR h_i IN 1..h_num_objects LOOP
1375: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1376: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1377: BSC_UPDATE_LOG.OUTPUT);
1378: END LOOP;
1379:

Line 1377: BSC_UPDATE_LOG.OUTPUT);

1373:
1374: FOR h_i IN 1..h_num_objects LOOP
1375: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1376: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1377: BSC_UPDATE_LOG.OUTPUT);
1378: END LOOP;
1379:
1380: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1381:

Line 1432: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1428: END LOOP;
1429: CLOSE c_source_tables;
1430:
1431: FOR h_i IN 1..h_num_objects LOOP
1432: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1433: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1434: BSC_UPDATE_LOG.OUTPUT);
1435: END LOOP;
1436:

Line 1434: BSC_UPDATE_LOG.OUTPUT);

1430:
1431: FOR h_i IN 1..h_num_objects LOOP
1432: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1433: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1434: BSC_UPDATE_LOG.OUTPUT);
1435: END LOOP;
1436:
1437: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1438:

Line 1475: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1471: h_lock_types(h_num_objects) := 'W';
1472: h_cascade_levels(h_num_objects) := 0;
1473:
1474: FOR h_i IN 1..h_num_objects LOOP
1475: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1476: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1477: BSC_UPDATE_LOG.OUTPUT);
1478: END LOOP;
1479:

Line 1477: BSC_UPDATE_LOG.OUTPUT);

1473:
1474: FOR h_i IN 1..h_num_objects LOOP
1475: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1476: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1477: BSC_UPDATE_LOG.OUTPUT);
1478: END LOOP;
1479:
1480: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1481:

Line 1507: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1503: h_lock_types(h_num_objects) := 'W';
1504: h_cascade_levels(h_num_objects) := 0;
1505:
1506: FOR h_i IN 1..h_num_objects LOOP
1507: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1508: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1509: BSC_UPDATE_LOG.OUTPUT);
1510: END LOOP;
1511:

Line 1509: BSC_UPDATE_LOG.OUTPUT);

1505:
1506: FOR h_i IN 1..h_num_objects LOOP
1507: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1508: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1509: BSC_UPDATE_LOG.OUTPUT);
1510: END LOOP;
1511:
1512: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1513:

Line 1542: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1538: h_lock_types(h_num_objects) := 'W';
1539: h_cascade_levels(h_num_objects) := 0;
1540:
1541: FOR h_i IN 1..h_num_objects LOOP
1542: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1543: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1544: BSC_UPDATE_LOG.OUTPUT);
1545: END LOOP;
1546:

Line 1544: BSC_UPDATE_LOG.OUTPUT);

1540:
1541: FOR h_i IN 1..h_num_objects LOOP
1542: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1543: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1544: BSC_UPDATE_LOG.OUTPUT);
1545: END LOOP;
1546:
1547: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1548:

Line 1580: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1576: h_cascade_levels(h_num_objects) := 0;
1577: END LOOP;
1578:
1579: FOR h_i IN 1..h_num_objects LOOP
1580: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1581: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1582: BSC_UPDATE_LOG.OUTPUT);
1583: END LOOP;
1584:

Line 1582: BSC_UPDATE_LOG.OUTPUT);

1578:
1579: FOR h_i IN 1..h_num_objects LOOP
1580: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1581: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1582: BSC_UPDATE_LOG.OUTPUT);
1583: END LOOP;
1584:
1585: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1586:

Line 1615: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||

1611: h_lock_types(h_num_objects) := 'W';
1612: h_cascade_levels(h_num_objects) := 0;
1613:
1614: FOR h_i IN 1..h_num_objects LOOP
1615: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1616: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1617: BSC_UPDATE_LOG.OUTPUT);
1618: END LOOP;
1619:

Line 1617: BSC_UPDATE_LOG.OUTPUT);

1613:
1614: FOR h_i IN 1..h_num_objects LOOP
1615: BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
1616: ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
1617: BSC_UPDATE_LOG.OUTPUT);
1618: END LOOP;
1619:
1620: h_b := Request_Lock(h_object_keys, h_object_types, h_lock_types, h_cascade_levels, h_num_objects);
1621:

Line 1672: BSC_UPDATE_LOG.Write_Line_Log(x_object_keys(h_i)||' '||x_object_types(h_i)||': '||h_msg_data,

1668: ELSE
1669: IF h_return_status = FND_API.G_RET_STS_ERROR THEN
1670: -- It could not get the lock
1671: -- Commit to release the objects already locked so far
1672: BSC_UPDATE_LOG.Write_Line_Log(x_object_keys(h_i)||' '||x_object_types(h_i)||': '||h_msg_data,
1673: BSC_UPDATE_LOG.OUTPUT);
1674: COMMIT;
1675: ELSE
1676: -- This is an unexpected error in the locking api

Line 1673: BSC_UPDATE_LOG.OUTPUT);

1669: IF h_return_status = FND_API.G_RET_STS_ERROR THEN
1670: -- It could not get the lock
1671: -- Commit to release the objects already locked so far
1672: BSC_UPDATE_LOG.Write_Line_Log(x_object_keys(h_i)||' '||x_object_types(h_i)||': '||h_msg_data,
1673: BSC_UPDATE_LOG.OUTPUT);
1674: COMMIT;
1675: ELSE
1676: -- This is an unexpected error in the locking api
1677: -- Commit to release the objects already locked so far

Line 1679: BSC_UPDATE_LOG.Write_Line_Log(h_msg_data, BSC_UPDATE_LOG.OUTPUT);

1675: ELSE
1676: -- This is an unexpected error in the locking api
1677: -- Commit to release the objects already locked so far
1678: -- No reason to continue
1679: BSC_UPDATE_LOG.Write_Line_Log(h_msg_data, BSC_UPDATE_LOG.OUTPUT);
1680: COMMIT;
1681: RETURN FALSE;
1682: END IF;
1683: