APPS.BSC_METADATA_DESC dependencies on BSC_MESSAGE_LOGS

Line 36: INSERT INTO BSC_MESSAGE_LOGS (

32: g_row_num := 0;
33: end if;
34: g_row_num := g_row_num + 1 ;
35:
36: INSERT INTO BSC_MESSAGE_LOGS (
37: SOURCE,
38: TYPE,
39: MESSAGE,
40: CREATION_DATE,

Line 824: the table BSC_MESSAGE_LOGS that had been created by the currrent session.

820: END Run_Concurrent_Describe_kpi;
821:
822: /*------------------------------------------------------------------------------------------
823: -- ClearMessages: This procedure delete all row of metadata description from
824: the table BSC_MESSAGE_LOGS that had been created by the currrent session.
825: Additional delete all metadata description not created in the current day
826: -------------------------------------------------------------------------------------------*/
827: PROCEDURE ClearText IS
828: l_session_id number;

Line 833: DELETE FROM BSC_MESSAGE_LOGS

829: BEGIN
830:
831: l_session_id := userenv('SESSIONID');
832:
833: DELETE FROM BSC_MESSAGE_LOGS
834: WHERE SOURCE = G_PKG_NAME
835: AND ( CREATED_BY = l_session_id
836: OR CREATION_DATE <= (SYSDATE -1)
837: );

Line 848: BSC_MESSAGE_LOGS

844: END ClearText;
845:
846: /*------------------------------------------------------------------------------
847: getQuery: This procedure store a row of metadata description the table
848: BSC_MESSAGE_LOGS
849: ------------------------------------------------------------------------------*/
850: FUNCTION getQuery RETURN varchar2 is
851: l_sql varchar2(500);
852: l_session_id number;

Line 858: SELECT MESSAGE FROM BSC_MESSAGE_LOGS

854: l_session_id := userenv('SESSIONID');
855:
856:
857: l_sql := '
858: SELECT MESSAGE FROM BSC_MESSAGE_LOGS
859: WHERE SOURCE = ''' || G_PKG_NAME || '''
860: AND CREATED_BY = ' || l_session_id || '
861: ORDER BY LAST_UPDATE_LOGIN ';
862: