APPS.BSC_APPS dependencies on BSC_MESSAGE_LOGS

Line 193: FROM bsc_message_logs

189: BEGIN
190:
191: SELECT count(*)
192: INTO h_count
193: FROM bsc_message_logs
194: WHERE type = 0
195: AND UPPER(source) = UPPER(x_calling_function)
196: AND last_update_login = USERENV('SESSIONID');
197:

Line 546: -- Insert the information in BSC_MESSAGE_LOGS table

542: h_status,
543: h_dev_phase,
544: h_dev_status,
545: h_message) THEN
546: -- Insert the information in BSC_MESSAGE_LOGS table
547: -- type 30 h_phase, type 31 h_status
548: -- type 32 h_dev_phase, type 33 h_dev_status, type 34 h_message
549: IF h_phase IS NOT NULL THEN
550: BSC_MESSAGE.Add(x_message => h_phase,

Line 1267: -- Insert the request_id in BSC_MESSAGE_LOGS table (type = 3, information) to VB program

1263: IF h_request_id = 0 THEN
1264: RAISE e_request_error;
1265: END IF;
1266:
1267: -- Insert the request_id in BSC_MESSAGE_LOGS table (type = 3, information) to VB program
1268: -- be able to get it.
1269:
1270: BSC_MESSAGE.Add(x_message => h_request_id,
1271: x_source => 'BSC_APPS.Submit_Request_VB',

Line 1462: bsc_message_logs

1458: CURSOR c_messages IS
1459: SELECT
1460: message
1461: FROM
1462: bsc_message_logs
1463: WHERE
1464: last_update_login = USERENV('SESSIONID')
1465: ORDER BY
1466: last_update_date;

Line 1468: h_message bsc_message_logs.message%TYPE;

1464: last_update_login = USERENV('SESSIONID')
1465: ORDER BY
1466: last_update_date;
1467:
1468: h_message bsc_message_logs.message%TYPE;
1469:
1470: BEGIN
1471: OPEN c_messages;
1472: FETCH c_messages INTO h_message;