APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_LOG

Line 1261: select qa_skiplot_log_id_s.nextval

1257: PRAGMA AUTONOMOUS_TRANSACTION;
1258:
1259: x_logid number;
1260: cursor id is
1261: select qa_skiplot_log_id_s.nextval
1262: from dual;
1263:
1264: cursor c (x_id number)is
1265: select 1 from qa_skiplot_log

Line 1265: select 1 from qa_skiplot_log

1261: select qa_skiplot_log_id_s.nextval
1262: from dual;
1263:
1264: cursor c (x_id number)is
1265: select 1 from qa_skiplot_log
1266: where log_id = x_id;
1267:
1268: existing_flag number;
1269:

Line 1277: -- qa_skiplot_log_id_s is a cycle sequence

1273: fetch id into x_logid;
1274: close id;
1275:
1276: --
1277: -- qa_skiplot_log_id_s is a cycle sequence
1278: -- the purpose is to control log table size
1279: --
1280: open c (x_logid);
1281: fetch c into existing_flag;

Line 1285: insert into qa_skiplot_log(

1281: fetch c into existing_flag;
1282: close c;
1283:
1284: if existing_flag is null then
1285: insert into qa_skiplot_log(
1286: LOG_ID,
1287: MODULE_NAME,
1288: ERROR_MESSAGE,
1289: COMMENTS,

Line 1306: update qa_skiplot_log

1302: sysdate,
1303: fnd_global.user_id,
1304: fnd_global.login_id);
1305: else
1306: update qa_skiplot_log
1307: set MODULE_NAME = p_module_name,
1308: ERROR_MESSAGE = p_error_message,
1309: COMMENTS = p_comments,
1310: LAST_UPDATE_DATE = sysdate,