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_MIGRATION dependencies on BSC_LOCKS_PUB

Line 2192: BSC_LOCKS_PUB.Get_System_Lock (

2188:
2189: --Lock the entire target system
2190: BSC_APPS.Write_Line_Log('Locking Target System:', BSC_APPS.OUTPUT_FILE);
2191: BSC_APPS.Write_Line_Log('Locking the whole system', BSC_APPS.OUTPUT_FILE);
2192: BSC_LOCKS_PUB.Get_System_Lock (
2193: p_program_id => -800,
2194: p_user_id => BSC_APPS.apps_user_id,
2195: x_return_status => h_return_status,
2196: x_msg_count => h_msg_count,

Line 2240: h_sql := 'BEGIN BSC_LOCKS_PUB.GET_SYSTEM_LOCK@'||g_db_link||' ('||

2236: h_object_key := h_tabs_filter(h_i);
2237:
2238: BSC_APPS.Write_Line_Log('Locking SCORECARD '||h_object_key, BSC_APPS.OUTPUT_FILE);
2239:
2240: h_sql := 'BEGIN BSC_LOCKS_PUB.GET_SYSTEM_LOCK@'||g_db_link||' ('||
2241: ' p_object_key => :1'||
2242: ',p_object_type => :2'||
2243: ',p_lock_type => :3'||
2244: ',p_query_time => :4'||

Line 2267: h_sql := 'BEGIN BSC_LOCKS_PUB.GET_SYSTEM_LOCK@'||g_db_link||' ('||

2263: h_object_key := h_kpis_filter(h_i);
2264:
2265: BSC_APPS.Write_Line_Log('Locking OBJECTIVE '||h_object_key, BSC_APPS.OUTPUT_FILE);
2266:
2267: h_sql := 'BEGIN BSC_LOCKS_PUB.GET_SYSTEM_LOCK@'||g_db_link||' ('||
2268: ' p_object_key => :1'||
2269: ',p_object_type => :2'||
2270: ',p_lock_type => :3'||
2271: ',p_query_time => :4'||

Line 2292: h_sql := 'BEGIN BSC_LOCKS_PUB.GET_SYSTEM_LOCK@'||g_db_link||' ('||

2288: IF h_num_kpis_filter = 0 AND h_num_tabs_filter = 0 THEN
2289:
2290: BSC_APPS.Write_Line_Log('Locking the whole system', BSC_APPS.OUTPUT_FILE);
2291:
2292: h_sql := 'BEGIN BSC_LOCKS_PUB.GET_SYSTEM_LOCK@'||g_db_link||' ('||
2293: 'p_program_id => :1'||
2294: ',p_user_id => :2'||
2295: ',x_return_status => :3'||
2296: ',x_msg_count => :4'||

Line 2382: BSC_LOCKS_PUB.Get_System_Lock (

2378: x_db_link => g_db_link
2379: );
2380:
2381: --LOCKING: Call this api for backward compatibility
2382: BSC_LOCKS_PUB.Get_System_Lock (
2383: p_program_id => -800,
2384: p_user_id => BSC_APPS.apps_user_id,
2385: p_icx_session_id => null,
2386: x_return_status => h_return_status,

Line 2404: h_sql := 'BEGIN BSC_LOCKS_PUB.Get_System_Lock@'||g_db_link||' ('||

2400: execute immediate h_sql;
2401: h_sql := 'BEGIN BSC_APPS.Init_Bsc_Apps@'||g_db_link||'; END;';
2402: execute immediate h_sql;
2403: h_null := NULL;
2404: h_sql := 'BEGIN BSC_LOCKS_PUB.Get_System_Lock@'||g_db_link||' ('||
2405: 'p_program_id => :1,'||
2406: 'p_user_id => :2,'||
2407: 'p_icx_session_id => :3,'||
2408: 'x_return_status => :4,'||

Line 2457: BSC_LOCKS_PUB.Remove_System_Lock;

2453: RAISE e_warning;
2454: END IF;
2455:
2456: -- LOCKING
2457: BSC_LOCKS_PUB.Remove_System_Lock;
2458:
2459: -- Fix bug#4480209: need to call this in the source system too
2460: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2461: execute immediate h_sql;

Line 2460: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';

2456: -- LOCKING
2457: BSC_LOCKS_PUB.Remove_System_Lock;
2458:
2459: -- Fix bug#4480209: need to call this in the source system too
2460: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2461: execute immediate h_sql;
2462:
2463: EXCEPTION
2464: WHEN e_error THEN

Line 2468: BSC_LOCKS_PUB.Remove_System_Lock;

2464: WHEN e_error THEN
2465: ERRBUF := BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC');
2466: RETCODE := 2; -- Request completed with errors
2467: -- LOCKING
2468: BSC_LOCKS_PUB.Remove_System_Lock;
2469: -- Fix bug#4624462: need to call this in the source system too
2470: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2471: execute immediate h_sql;
2472:

Line 2470: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';

2466: RETCODE := 2; -- Request completed with errors
2467: -- LOCKING
2468: BSC_LOCKS_PUB.Remove_System_Lock;
2469: -- Fix bug#4624462: need to call this in the source system too
2470: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2471: execute immediate h_sql;
2472:
2473: --LOCKING
2474: WHEN e_system_lock THEN

Line 2478: BSC_LOCKS_PUB.Remove_System_Lock;

2474: WHEN e_system_lock THEN
2475: ERRBUF := h_msg_data;
2476: RETCODE := 2; -- Request completed with errors
2477: -- LOCKING
2478: BSC_LOCKS_PUB.Remove_System_Lock;
2479: -- Fix bug#4624462: need to call this in the source system too
2480: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2481: execute immediate h_sql;
2482:

Line 2480: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';

2476: RETCODE := 2; -- Request completed with errors
2477: -- LOCKING
2478: BSC_LOCKS_PUB.Remove_System_Lock;
2479: -- Fix bug#4624462: need to call this in the source system too
2480: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2481: execute immediate h_sql;
2482:
2483: WHEN e_warning THEN
2484: ERRBUF := '';

Line 2487: BSC_LOCKS_PUB.Remove_System_Lock;

2483: WHEN e_warning THEN
2484: ERRBUF := '';
2485: RETCODE := 1; -- Request completed with warning
2486: -- LOCKING
2487: BSC_LOCKS_PUB.Remove_System_Lock;
2488: -- Fix bug#4624462: need to call this in the source system too
2489: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2490: execute immediate h_sql;
2491:

Line 2489: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';

2485: RETCODE := 1; -- Request completed with warning
2486: -- LOCKING
2487: BSC_LOCKS_PUB.Remove_System_Lock;
2488: -- Fix bug#4624462: need to call this in the source system too
2489: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2490: execute immediate h_sql;
2491:
2492: WHEN g_error_synch_bsc_pmf THEN
2493: ROLLBACK;

Line 2510: BSC_LOCKS_PUB.Remove_System_Lock;

2506:
2507: ERRBUF := BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC');
2508: RETCODE := 2; -- Request completed with errors
2509: -- LOCKING
2510: BSC_LOCKS_PUB.Remove_System_Lock;
2511: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2512: execute immediate h_sql;
2513:
2514: WHEN OTHERS THEN

Line 2511: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';

2507: ERRBUF := BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC');
2508: RETCODE := 2; -- Request completed with errors
2509: -- LOCKING
2510: BSC_LOCKS_PUB.Remove_System_Lock;
2511: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2512: execute immediate h_sql;
2513:
2514: WHEN OTHERS THEN
2515: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 2532: BSC_LOCKS_PUB.Remove_System_Lock;

2528: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
2529: RETCODE := 2; -- Request completed with errors
2530:
2531: -- LOCKING
2532: BSC_LOCKS_PUB.Remove_System_Lock;
2533: -- Fix bug#4624462: need to call this in the source system too
2534: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2535: execute immediate h_sql;
2536:

Line 2534: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';

2530:
2531: -- LOCKING
2532: BSC_LOCKS_PUB.Remove_System_Lock;
2533: -- Fix bug#4624462: need to call this in the source system too
2534: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2535: execute immediate h_sql;
2536:
2537: END Execute_Migration;
2538: