DBA Data[Home] [Help]

APPS.FND_FORM_CUSTOM_RULES_PKG dependencies on FND_FORM_CUSTOM_ACTIONS

Line 72: from fnd_form_custom_actions a , fnd_form_custom_rules r

68: */
69: delete from fnd_form_custom_params
70: where action_id in
71: (select action_id
72: from fnd_form_custom_actions a , fnd_form_custom_rules r
73: where a.rule_id = r.id
74: and nvl(r.rule_key, '*NULL*') = nvl(X_RULE_KEY,'*NULL*')
75: and ((X_RULE_TYPE = 'A' and r.rule_type = 'A' and r.function_name = X_FUNCTION_NAME) or
76: (X_RULE_TYPE = 'F' and r.rule_type = 'F' and r.form_name = X_FORM_NAME and r.id < g_curr_seq )));

Line 79: delete from fnd_form_custom_actions

75: and ((X_RULE_TYPE = 'A' and r.rule_type = 'A' and r.function_name = X_FUNCTION_NAME) or
76: (X_RULE_TYPE = 'F' and r.rule_type = 'F' and r.form_name = X_FORM_NAME and r.id < g_curr_seq )));
77:
78:
79: delete from fnd_form_custom_actions
80: where rule_id in
81: (select id
82: from fnd_form_custom_rules r
83: where nvl(r.rule_key, '*NULL*') = nvl(X_RULE_KEY,'*NULL*')