APPS.FND_FORM_CUSTOM_RULES_PKG dependencies on FND_FORM_CUSTOM_ACTIONS

Line 15: from fnd_form_custom_actions a , fnd_form_custom_rules r

11: RETURN;
12: else
13: delete from fnd_form_custom_params
14: where action_id in (select action_id
15: from fnd_form_custom_actions a , fnd_form_custom_rules r
16: where a.rule_id = r.id
17: and r.created_by <> 1
18: and r.function_name = X_FUNCTION_NAME
19: and (r.rule_type = 'A'or r.rule_type is null));

Line 20: delete from fnd_form_custom_actions

16: where a.rule_id = r.id
17: and r.created_by <> 1
18: and r.function_name = X_FUNCTION_NAME
19: and (r.rule_type = 'A'or r.rule_type is null));
20: delete from fnd_form_custom_actions
21: where rule_id in (select id
22: from fnd_form_custom_rules r
23: where r.created_by <> 1
24: and r.function_name = X_FUNCTION_NAME

Line 49: from fnd_form_custom_actions a , fnd_form_custom_rules r

45: RETURN;
46: else
47: delete from fnd_form_custom_params
48: where action_id in (select action_id
49: from fnd_form_custom_actions a , fnd_form_custom_rules r
50: where a.rule_id = r.id
51: and r.created_by <> 1
52: and r.form_name = X_FORM_NAME
53: and r.rule_type = 'F');

Line 54: delete from fnd_form_custom_actions

50: where a.rule_id = r.id
51: and r.created_by <> 1
52: and r.form_name = X_FORM_NAME
53: and r.rule_type = 'F');
54: delete from fnd_form_custom_actions
55: where rule_id in (select id
56: from fnd_form_custom_rules r
57: where r.created_by <> 1
58: and r.form_name = X_FORM_NAME

Line 86: from fnd_form_custom_actions a , fnd_form_custom_rules r

82: RETURN;
83: else
84: delete from fnd_form_custom_params
85: where action_id in (select action_id
86: from fnd_form_custom_actions a , fnd_form_custom_rules r
87: where a.rule_id = r.id
88: and r.created_by = 8
89: and r.rule_key = X_RULE_KEY
90: and X_FORM_NAME IS NULL or (X_FORM_NAME IS NOT NULL and

Line 92: delete from fnd_form_custom_actions

88: and r.created_by = 8
89: and r.rule_key = X_RULE_KEY
90: and X_FORM_NAME IS NULL or (X_FORM_NAME IS NOT NULL and
91: r.form_name = X_FORM_NAME));
92: delete from fnd_form_custom_actions
93: where rule_id in (select id
94: from fnd_form_custom_rules r
95: where r.created_by = 8
96: and r.rule_key = X_RULE_KEY