APPS.FND_DEBUG dependencies on FND_DEBUG_RULE_OPTIONS

Line 21: debug_option_name FND_DEBUG_RULE_OPTIONS.debug_option_name%TYPE,

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,
25: start_time FND_DEBUG_RULES.start_time%TYPE,

Line 22: debug_option_value FND_DEBUG_RULE_OPTIONS.debug_option_value%TYPE,

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,
25: start_time FND_DEBUG_RULES.start_time%TYPE,
26: end_time FND_DEBUG_RULES.end_time%TYPE,

Line 91: fnd_debug_rule_options DRO

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 )
95: OR (DR.user_id is null and DR.Responsibility_ID is null) )

Line 139: fnd_debug_rule_options DRO

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 )
143: OR (DR.user_id is null and DR.Responsibility_ID is null) )

Line 333: DELETE FROM fnd_debug_rule_options WHERE debug_rule_id IN

329: CLOSE DRC_REQ;
330: end if;
331:
332: -- delete any old rules as a fix for bug 3787995
333: DELETE FROM fnd_debug_rule_options WHERE debug_rule_id IN
334: (SELECT debug_rule_id FROM fnd_debug_rules
335: WHERE (start_time IS NOT NULL AND end_time < sysdate)
336: OR (repeation_counter = 0)
337: );

Line 457: fnd_debug_rule_options DRO

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 )
461: OR (DR.user_id is null and DR.Responsibility_ID is null))

Line 577: FROM fnd_debug_rule_options DRO,

573: SELECT 'T' INTO db_rule_enabled
574: FROM DUAL
575: WHERE EXISTS(
576: SELECT *
577: FROM fnd_debug_rule_options DRO,
578: fnd_debug_options DO
579: WHERE DRO.debug_option_name=DO.debug_option_name
580: AND DO.type='D'
581: AND dr_rec.debug_rule_id=DRO.debug_rule_id);

Line 616: DELETE FROM fnd_debug_rule_options WHERE debug_rule_id IN

612: END LOOP;
613:
614:
615: -- delete any old rules as a fix for bug 3787995
616: DELETE FROM fnd_debug_rule_options WHERE debug_rule_id IN
617: (SELECT debug_rule_id
618: FROM fnd_debug_rules
619: WHERE (start_time IS NOT NULL AND end_time < sysdate)
620: OR (repeation_counter = 0)