APPS.FND_DEBUG dependencies on FND_DEBUG_OPTION_VALUES

Line 19: ( enable_routine FND_DEBUG_OPTION_VALUES.enable_routine%TYPE,

15: P_RULES rules_tab_type;
16: RULEC number := 0;
17:
18: TYPE rule_select_rec is record
19: ( enable_routine FND_DEBUG_OPTION_VALUES.enable_routine%TYPE,
20: disable_routine FND_DEBUG_OPTION_VALUES.disable_routine%TYPE,
21: debug_option_name FND_DEBUG_RULE_OPTIONS.debug_option_name%TYPE,
22: debug_option_value FND_DEBUG_RULE_OPTIONS.debug_option_value%TYPE,
23: debug_rule_id FND_DEBUG_RULES.debug_rule_id%TYPE,

Line 20: disable_routine FND_DEBUG_OPTION_VALUES.disable_routine%TYPE,

16: RULEC number := 0;
17:
18: TYPE rule_select_rec is record
19: ( enable_routine FND_DEBUG_OPTION_VALUES.enable_routine%TYPE,
20: disable_routine FND_DEBUG_OPTION_VALUES.disable_routine%TYPE,
21: debug_option_name FND_DEBUG_RULE_OPTIONS.debug_option_name%TYPE,
22: debug_option_value FND_DEBUG_RULE_OPTIONS.debug_option_value%TYPE,
23: debug_rule_id FND_DEBUG_RULES.debug_rule_id%TYPE,
24: repeation_counter FND_DEBUG_RULES.repeation_counter%TYPE,

Line 34: trace_file_routine FND_DEBUG_OPTION_VALUES.trace_file_routine%TYPE,

30: component_type FND_DEBUG_RULES.component_type%TYPE,
31: component_name FND_DEBUG_RULES.component_name%TYPE,
32: component_id FND_DEBUG_RULES.component_id%TYPE,
33: component_appl_id FND_DEBUG_RULES.component_appl_id%TYPE,
34: trace_file_routine FND_DEBUG_OPTION_VALUES.trace_file_routine%TYPE,
35: trace_file_node FND_DEBUG_OPTION_VALUES.trace_file_node%TYPE,
36: comments FND_DEBUG_RULES.comments%TYPE,
37: reqid FND_DEBUG_RULES.request_id%TYPE
38: );

Line 35: trace_file_node FND_DEBUG_OPTION_VALUES.trace_file_node%TYPE,

31: component_name FND_DEBUG_RULES.component_name%TYPE,
32: component_id FND_DEBUG_RULES.component_id%TYPE,
33: component_appl_id FND_DEBUG_RULES.component_appl_id%TYPE,
34: trace_file_routine FND_DEBUG_OPTION_VALUES.trace_file_routine%TYPE,
35: trace_file_node FND_DEBUG_OPTION_VALUES.trace_file_node%TYPE,
36: comments FND_DEBUG_RULES.comments%TYPE,
37: reqid FND_DEBUG_RULES.request_id%TYPE
38: );
39:

Line 90: fnd_debug_option_values DOV,

86: component_name, component_id, component_appl_id,
87: trace_file_routine, trace_file_node, comments, nvl(request_id,0) reqid
88: from fnd_debug_options DO,
89: fnd_debug_rules DR,
90: fnd_debug_option_values DOV,
91: fnd_debug_rule_options DRO
92: where ( DR.user_id = userid
93: OR (DR.responsibility_id = respid
94: and DR.Resp_appl_id = respapplid )

Line 138: fnd_debug_option_values DOV,

134: component_name, component_id, component_appl_id,
135: trace_file_routine, trace_file_node, comments, nvl(request_id,0) reqid
136: from fnd_debug_options DO,
137: fnd_debug_rules DR,
138: fnd_debug_option_values DOV,
139: fnd_debug_rule_options DRO
140: where ( DR.user_id = userid
141: OR (DR.responsibility_id = respid
142: and DR.Resp_appl_id = respapplid )

Line 272: fnd_debug_option_values DOV

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
276: AND DOV.debug_option_value=dr_rec.debug_option_value

Line 456: fnd_debug_option_values DOV,

452: trace_file_routine, trace_file_node, comments,
453: nvl(request_id,0) reqid
454: from fnd_debug_options DO,
455: fnd_debug_rules DR,
456: fnd_debug_option_values DOV,
457: fnd_debug_rule_options DRO
458: where ( DR.user_id = uid
459: OR (DR.responsibility_id = respid
460: and DR.Resp_appl_id = respapplid )

Line 509: from fnd_debug_option_values

505: -- at option values.
506: begin
507: select debug_option_value
508: into t_ftoken
509: from fnd_debug_option_values
510: where debug_option_name = dr_rec.debug_option_name
511: and is_file_token = 'Y';
512:
513: trace_file := get_ret_value(dr_rec.trace_file_routine);

Line 545: fnd_debug_option_values DOV

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
549: AND DOV.debug_option_value=dr_rec.debug_option_value