APPS.BSC_UPDATE dependencies on BSC_MESSAGE_LOGS

Line 4042: --FROM bsc_message_logs

4038: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4039: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4040: --SELECT count(*)
4041: --INTO h_count
4042: --FROM bsc_message_logs
4043: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4044: --IF h_count > 0 THEN
4045: -- RAISE e_system_lock;
4046: --END IF;

Line 4066: FROM bsc_message_logs

4062: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4063:
4064: SELECT count(*)
4065: INTO h_count
4066: FROM bsc_message_logs
4067: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4068:
4069: IF h_count > 0 THEN
4070: RAISE e_update_error;

Line 4227: --FROM bsc_message_logs

4223: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4224: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4225: --SELECT count(*)
4226: --INTO h_count
4227: --FROM bsc_message_logs
4228: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4229: --IF h_count > 0 THEN
4230: -- RAISE e_system_lock;
4231: --END IF;

Line 4285: -- clean bsc_message_logs

4281: end if;
4282: end if;
4283: end if;
4284:
4285: -- clean bsc_message_logs
4286: BSC_MESSAGE.Clean;
4287:
4288: -- Run loader
4289: Execute_Update_Process(TO_NUMBER(x_process_id), PC_LOADER_PROCESS, NULL);

Line 4295: ' FROM bsc_message_logs'||

4291: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4292:
4293: /*
4294: h_sql := 'SELECT count(*)'||
4295: ' FROM bsc_message_logs'||
4296: ' WHERE type = :1'||
4297: ' AND UPPER(source) = :2 AND last_update_login = :3';
4298: OPEN h_cursor FOR h_sql USING 0, h_source, h_sessionid;
4299: FETCH h_cursor INTO h_count;

Line 4304: FROM bsc_message_logs

4300: CLOSE h_cursor;
4301: */
4302: SELECT count(*)
4303: INTO h_count
4304: FROM bsc_message_logs
4305: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4306:
4307: IF h_count > 0 THEN
4308: RAISE e_update_error;

Line 4442: --FROM bsc_message_logs

4438: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4439: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4440: --SELECT count(*)
4441: --INTO h_count
4442: --FROM bsc_message_logs
4443: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4444: --IF h_count > 0 THEN
4445: -- RAISE e_system_lock;
4446: --END IF;

Line 4467: ' FROM bsc_message_logs'||

4463: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4464:
4465: /*
4466: h_sql := 'SELECT count(*)'||
4467: ' FROM bsc_message_logs'||
4468: ' WHERE type = :1'||
4469: ' AND UPPER(source) = :2 AND last_update_login = :3';
4470: OPEN h_cursor FOR h_sql USING 0, h_source, h_sessionid;
4471: FETCH h_cursor INTO h_count;

Line 4476: FROM bsc_message_logs

4472: CLOSE h_cursor;
4473: */
4474: SELECT count(*)
4475: INTO h_count
4476: FROM bsc_message_logs
4477: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4478:
4479: IF h_count > 0 THEN
4480: RAISE e_update_error;

Line 4620: --FROM bsc_message_logs

4616: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4617: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4618: --SELECT count(*)
4619: --INTO h_count
4620: --FROM bsc_message_logs
4621: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4622: --IF h_count > 0 THEN
4623: -- RAISE e_system_lock;
4624: --END IF;

Line 4645: FROM bsc_message_logs

4641: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4642:
4643: SELECT count(*)
4644: INTO h_count
4645: FROM bsc_message_logs
4646: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4647:
4648: IF h_count > 0 THEN
4649: RAISE e_update_error;

Line 4801: --FROM bsc_message_logs

4797: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4798: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4799: --SELECT count(*)
4800: --INTO h_count
4801: --FROM bsc_message_logs
4802: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4803: --IF h_count > 0 THEN
4804: -- RAISE e_system_lock;
4805: --END IF;

Line 4911: FROM bsc_message_logs

4907: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4908:
4909: SELECT count(*)
4910: INTO h_count
4911: FROM bsc_message_logs
4912: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4913:
4914: IF h_count > 0 THEN
4915: RAISE e_update_error;

Line 5089: --FROM bsc_message_logs

5085: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
5086: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
5087: --SELECT count(*)
5088: --INTO h_count
5089: --FROM bsc_message_logs
5090: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5091: --IF h_count > 0 THEN
5092: -- RAISE e_system_lock;
5093: --END IF;

Line 5228: FROM bsc_message_logs

5224: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
5225:
5226: SELECT count(*)
5227: INTO h_count
5228: FROM bsc_message_logs
5229: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5230:
5231: IF h_count > 0 THEN
5232: RAISE e_update_error;

Line 5379: --FROM bsc_message_logs

5375: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
5376: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
5377: --SELECT count(*)
5378: --INTO h_count
5379: --FROM bsc_message_logs
5380: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5381: --IF h_count > 0 THEN
5382: -- RAISE e_system_lock;
5383: --END IF;

Line 5447: FROM bsc_message_logs

5443: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
5444:
5445: SELECT count(*)
5446: INTO h_count
5447: FROM bsc_message_logs
5448: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5449:
5450: IF h_count > 0 THEN
5451: RAISE e_update_error;