APPS.MST_AUDIT_REP_EXCP dependencies on MST_AUDIT_REP_EXCP

Line 1: PACKAGE BODY MST_AUDIT_REP_EXCP AS

1: PACKAGE BODY MST_AUDIT_REP_EXCP AS
2: /* $Header: MSTEAREB.pls 115.27 2004/05/05 21:40:19 jansanch noship $ */
3:
4: --global variables
5: distScaleFactor NUMBER;

Line 2157: create table mst_audit_rep_excp_debug(pk number, plan_id number,message_seq_num number, date_message date,message varchar2(255));

2153: --dbms_output.put_line(p_str);
2154:
2155: /*
2156: Use following to create table for debug:
2157: create table mst_audit_rep_excp_debug(pk number, plan_id number,message_seq_num number, date_message date,message varchar2(255));
2158: create sequence mst_audit_rep_excp_debug_s;
2159: Then uncomment code to insert messages to that table
2160: */
2161:

Line 2158: create sequence mst_audit_rep_excp_debug_s;

2154:
2155: /*
2156: Use following to create table for debug:
2157: create table mst_audit_rep_excp_debug(pk number, plan_id number,message_seq_num number, date_message date,message varchar2(255));
2158: create sequence mst_audit_rep_excp_debug_s;
2159: Then uncomment code to insert messages to that table
2160: */
2161:
2162: /*

Line 2163: insert into mst_audit_rep_excp_debug(pk, plan_id,message_seq_num, date_message,message)

2159: Then uncomment code to insert messages to that table
2160: */
2161:
2162: /*
2163: insert into mst_audit_rep_excp_debug(pk, plan_id,message_seq_num, date_message,message)
2164: values (mst_audit_rep_excp_debug_s.nextval, tp_plan_id, msg_seq_num, sysdate, p_str);
2165: msg_seq_num := msg_seq_num + 1;
2166: commit;
2167: */

Line 2164: values (mst_audit_rep_excp_debug_s.nextval, tp_plan_id, msg_seq_num, sysdate, p_str);

2160: */
2161:
2162: /*
2163: insert into mst_audit_rep_excp_debug(pk, plan_id,message_seq_num, date_message,message)
2164: values (mst_audit_rep_excp_debug_s.nextval, tp_plan_id, msg_seq_num, sysdate, p_str);
2165: msg_seq_num := msg_seq_num + 1;
2166: commit;
2167: */
2168: var := 0;

Line 2171: END MST_AUDIT_REP_EXCP;

2167: */
2168: var := 0;
2169: END debug_output;
2170:
2171: END MST_AUDIT_REP_EXCP;