APPS.IEC_SQL_LOGGER_PVT dependencies on IEO_LNA_SOURCES

Line 41: l_source_id IEO_LNA_SOURCES.SOURCE_ID%TYPE;

37: )
38: IS
39:
40: PRAGMA AUTONOMOUS_TRANSACTION;
41: l_source_id IEO_LNA_SOURCES.SOURCE_ID%TYPE;
42: l_log_level IEO_LNA_SOURCES.LOG_LEVEL%TYPE;
43:
44: l_last_updated_by NUMBER;
45: l_created_by NUMBER;

Line 42: l_log_level IEO_LNA_SOURCES.LOG_LEVEL%TYPE;

38: IS
39:
40: PRAGMA AUTONOMOUS_TRANSACTION;
41: l_source_id IEO_LNA_SOURCES.SOURCE_ID%TYPE;
42: l_log_level IEO_LNA_SOURCES.LOG_LEVEL%TYPE;
43:
44: l_last_updated_by NUMBER;
45: l_created_by NUMBER;
46: l_last_update_login NUMBER;

Line 69: from IEO_LNA_SOURCES

65:
66: -- Check if a record already exists for this source.
67:
68: Select SOURCE_ID, LOG_LEVEL into l_source_id, l_log_level
69: from IEO_LNA_SOURCES
70: where facility_guid = P_FACILITY_GUID
71: and facility_name_msg_name = P_FACILITY_NAME_MSG_NAME
72: and facility_instance = P_FACILITY_INSTANCE
73: and facility_instance_uid = P_FACILITY_INSTANCE_UID

Line 83: update ieo_lna_sources

79: if ( l_log_level <> P_LOG_LEVEL )
80: then
81:
82: -- Update the log_level for this source id;
83: update ieo_lna_sources
84: set log_level = P_LOG_LEVEL,
85: last_update_date = sysdate,
86: last_update_login = l_last_update_login
87: where source_id = l_source_id;

Line 99: insert into IEO_LNA_SOURCES (

95: -- dbms_output.put_line('get_source Id: No data found.' );
96: l_date1 := sysdate;
97: l_date2 := l_date1;
98:
99: insert into IEO_LNA_SOURCES (
100: SOURCE_ID,
101: CREATED_BY,
102: CREATION_DATE,
103: LAST_UPDATED_BY,

Line 117: IEO_LNA_SOURCES_S1.NEXTVAL,

113: OS_USER_NAME,
114: LOG_LEVEL
115: )
116: VALUES (
117: IEO_LNA_SOURCES_S1.NEXTVAL,
118: l_created_by,
119: l_date1,
120: l_last_updated_by,
121: l_date2,

Line 205: from ieo_lna_sources

201:
202: -- dbms_output.put_line('log: begin' );
203:
204: select 1 into l_log
205: from ieo_lna_sources
206: where log_level >= P_LOG_LEVEL
207: and source_id = P_SOURCE_ID;
208:
209: BEGIN