APPS.AD_ZD_LOG dependencies on AD_ZD_LOG

Line 1: PACKAGE BODY ad_zd_log AS

1: PACKAGE BODY ad_zd_log AS
2: /* $Header: ADZDLOGB.pls 120.11.12020000.3 2013/03/06 10:52:54 shivaaga ship $ */
3:
4: -- create table APPLSYS.AD_ZD_LOG (
5: -- LOG_SEQUENCE NOT NULL NUMBER,

Line 4: -- create table APPLSYS.AD_ZD_LOG (

1: PACKAGE BODY ad_zd_log AS
2: /* $Header: ADZDLOGB.pls 120.11.12020000.3 2013/03/06 10:52:54 shivaaga ship $ */
3:
4: -- create table APPLSYS.AD_ZD_LOG (
5: -- LOG_SEQUENCE NOT NULL NUMBER,
6: -- MODULE NOT NULL VARCHAR2(255),
7: -- MESSAGE_TEXT NOT NULL VARCHAR2(4000),
8: -- SESSION_ID NUMBER,

Line 23: -- Insert record into ad_zd_logs table

19: -- x_module - varchar2 - calling code identifier (calling module)
20: -- x_log_type - varchar2 - the type of message being logged (see below)
21: -- x_message - varchar2 - the message being logged into the table
22: -- purpose:
23: -- Insert record into ad_zd_logs table
24: -- more on x_log_type:
25: -- This specifies the "level" of the log message. This is used to clarify
26: -- log messages by level of detail so that extraneous information can be
27: -- filtered from summary reports. ALL log messages are logged ALL the time

Line 57: insert into ad_zd_logs

53: l_message := SUBSTR(x_message,1, 3999);
54: l_module := SUBSTR(x_module,1, 254);
55: l_type := SUBSTR(x_log_type, 1, 10);
56:
57: insert into ad_zd_logs
58: ( log_sequence,
59: module,
60: message_text,
61: session_id,

Line 64: values (AD_ZD_LOGS_S.NEXTVAL,

60: message_text,
61: session_id,
62: type ,
63: timestamp)
64: values (AD_ZD_LOGS_S.NEXTVAL,
65: l_module,
66: l_message,
67: SYS_CONTEXT('USERENV', 'SESSIONID'),
68: l_type,

Line 91: execute immediate 'truncate table ' || l_applsys || '.ad_zd_logs';

87: from system.fnd_oracle_userid
88: where read_only_flag in ('E')
89: and rownum < 2 ;
90:
91: execute immediate 'truncate table ' || l_applsys || '.ad_zd_logs';
92: commit;
93:
94: end clear;
95:

Line 96: end ad_zd_log;

92: commit;
93:
94: end clear;
95:
96: end ad_zd_log;