APPS.FND_DEBUG dependencies on FND_DEBUG_RULE_EXECUTIONS

Line 261: -- insert row about execution in fnd_debug_rule_executions

257: sql_str := 'begin ' || dr_rec.enable_routine || '; end;';
258:
259: execute immediate sql_str;
260:
261: -- insert row about execution in fnd_debug_rule_executions
262: trans_id := get_transaction_id(FALSE);
263:
264: log_file := get_ret_value(dr_rec.trace_file_routine);
265:

Line 271: FROM fnd_debug_rule_executions DRO,

267:
268: -- added repetition_counter as a fix for bug 3787995
269: -- repetition_counter is the number of actual occurances for this rule
270: SELECT NVL(MAX(DRO.repeation_counter),0) INTO repetition_counter
271: FROM fnd_debug_rule_executions DRO,
272: fnd_debug_option_values DOV
273: WHERE DRO.debug_option_name=DOV.debug_option_name
274: AND DRO.debug_option_value=DOV.debug_option_value
275: AND DOV.debug_option_name=dr_rec.debug_option_name

Line 279: insert into fnd_debug_rule_executions

275: AND DOV.debug_option_name=dr_rec.debug_option_name
276: AND DOV.debug_option_value=dr_rec.debug_option_value
277: AND DRO.rule_id=dr_rec.debug_rule_id;
278:
279: insert into fnd_debug_rule_executions
280: (transaction_id, rule_id, component_type, component_name,
281: component_id, component_appl_id, start_time, end_time,
282: repeation_counter, debug_log_file, log_file_node_name,
283: user_id, responsibility_id, resp_appl_id,

Line 535: -- insert row about execution in fnd_debug_rule_executions

531:
532: debug_str := debug_str || ' ' || trc_option_nmval ||
533: NVL(dr_rec.separator,' ') || trace_file_str || ' ';
534:
535: -- insert row about execution in fnd_debug_rule_executions
536: trans_id := get_transaction_id(TRUE, comp_type, comp_inst_id,
537: comp_appl_id, user_id, resp_id, resp_appl_id);
538: log_file := trace_file;
539: node_name := get_ret_value(dr_rec.trace_file_node);

Line 544: FROM fnd_debug_rule_executions DRO,

540:
541: -- added repetition_counter as a fix for bug 3787995
542: -- repetition_counter is the number of actual occurances for this rule
543: SELECT NVL(MAX(DRO.repeation_counter),0) INTO repetition_counter
544: FROM fnd_debug_rule_executions DRO,
545: fnd_debug_option_values DOV
546: WHERE DRO.debug_option_name=DOV.debug_option_name
547: AND DRO.debug_option_value=DOV.debug_option_value
548: AND DOV.debug_option_name=dr_rec.debug_option_name

Line 552: insert into fnd_debug_rule_executions

548: AND DOV.debug_option_name=dr_rec.debug_option_name
549: AND DOV.debug_option_value=dr_rec.debug_option_value
550: AND DRO.rule_id=dr_rec.debug_rule_id;
551:
552: insert into fnd_debug_rule_executions
553: (transaction_id, rule_id, component_type, component_name,
554: component_id, component_appl_id, start_time, end_time,
555: repeation_counter, debug_log_file, log_file_node_name,
556: user_id, responsibility_id, resp_appl_id,

Line 758: update fnd_debug_rule_executions

754: procedure assign_request(transaction_id IN number,
755: request_id IN number) is
756: PRAGMA AUTONOMOUS_TRANSACTION;
757: begin
758: update fnd_debug_rule_executions
759: set log_request_id = assign_request.request_id
760: where transaction_id = assign_request.transaction_id
761: and debug_option_value = 'PLSQL_PROFILER';
762: