APPS.FND_FORM_CUSTOM_RULES_PKG dependencies on FND_FORM_CUSTOM_RULES

Line 1: package body FND_FORM_CUSTOM_RULES_PKG as

1: package body FND_FORM_CUSTOM_RULES_PKG as
2: /* $Header: AFFRRULB.pls 120.6 2010/08/07 21:34:04 dbowles ship $ */
3:
4: /*
5: ** Last Delete Context:

Line 47: /* Bug 9975835 Added g_curr_seq and set to FND_FORM_CUSTOM_RULES_S.NextVal

43: **
44: ** Note: A NULL RULE_KEY is considered a valid, distinct context value
45: ** but the other values should not be null
46: */
47: /* Bug 9975835 Added g_curr_seq and set to FND_FORM_CUSTOM_RULES_S.NextVal
48: ** Once we have deleted all of the personalizations for a given form where the
49: ** rule type is F, we don't want to delete again if processing an ldt that has multiple
50: ** functions that with a rule type of F for a given form.
51: ** When we insert the data into the FND_FORM_CUSTOM_RULES, the id has a value of FND_FORM_CUSTOM_RULES_S.NextVal (see affrmcus.lct).

Line 51: ** When we insert the data into the FND_FORM_CUSTOM_RULES, the id has a value of FND_FORM_CUSTOM_RULES_S.NextVal (see affrmcus.lct).

47: /* Bug 9975835 Added g_curr_seq and set to FND_FORM_CUSTOM_RULES_S.NextVal
48: ** Once we have deleted all of the personalizations for a given form where the
49: ** rule type is F, we don't want to delete again if processing an ldt that has multiple
50: ** functions that with a rule type of F for a given form.
51: ** When we insert the data into the FND_FORM_CUSTOM_RULES, the id has a value of FND_FORM_CUSTOM_RULES_S.NextVal (see affrmcus.lct).
52: ** Since we delete before inserting the new rows will always have an id greater then the value of g_curr_seq
53: ** WHERE clauses modified for the X_RULE_TYPE = 'F' to only delete rows that have an id < g_curr_seq
54: */
55: if g_curr_seq = 0 then

Line 56: select FND_FORM_CUSTOM_RULES_S.NextVal into g_curr_seq from dual;

52: ** Since we delete before inserting the new rows will always have an id greater then the value of g_curr_seq
53: ** WHERE clauses modified for the X_RULE_TYPE = 'F' to only delete rows that have an id < g_curr_seq
54: */
55: if g_curr_seq = 0 then
56: select FND_FORM_CUSTOM_RULES_S.NextVal into g_curr_seq from dual;
57: end if;
58: if nvl(X_RULE_KEY, '*NULL*') = nvl(g_last_delete_rule_key, '*NULL*') and
59: X_RULE_TYPE = g_last_delete_rule_type and
60: ((X_RULE_TYPE = 'A' and X_FUNCTION_NAME = g_last_delete_function) or

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 82: from fnd_form_custom_rules r

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*')
84: and ((X_RULE_TYPE = 'A' and r.rule_type = 'A' and r.function_name = X_FUNCTION_NAME) or
85: (X_RULE_TYPE = 'F' and r.rule_type = 'F' and r.form_name = X_FORM_NAME and r.id < g_curr_seq )));
86:

Line 90: from fnd_form_custom_rules r

86:
87: delete from fnd_form_custom_scopes
88: where rule_id in
89: (select id
90: from fnd_form_custom_rules r
91: where nvl(r.rule_key, '*NULL*') = nvl(X_RULE_KEY,'*NULL*')
92: and ((X_RULE_TYPE = 'A' and r.rule_type = 'A' and r.function_name = X_FUNCTION_NAME) or
93: (X_RULE_TYPE = 'F' and r.rule_type = 'F' and r.form_name = X_FORM_NAME and r.id < g_curr_seq )));
94:

Line 95: delete from fnd_form_custom_rules r

91: where nvl(r.rule_key, '*NULL*') = nvl(X_RULE_KEY,'*NULL*')
92: and ((X_RULE_TYPE = 'A' and r.rule_type = 'A' and r.function_name = X_FUNCTION_NAME) or
93: (X_RULE_TYPE = 'F' and r.rule_type = 'F' and r.form_name = X_FORM_NAME and r.id < g_curr_seq )));
94:
95: delete from fnd_form_custom_rules r
96: where nvl(r.rule_key, '*NULL*') = nvl(X_RULE_KEY,'*NULL*')
97: and ((X_RULE_TYPE = 'A' and r.rule_type = 'A' and r.function_name = X_FUNCTION_NAME) or
98: (X_RULE_TYPE = 'F' and r.rule_type = 'F' and r.form_name = X_FORM_NAME and r.id < g_curr_seq ));
99:

Line 112: END FND_FORM_CUSTOM_RULES_PKG;

108: g_last_delete_form := X_FORM_NAME;
109:
110: END DELETE_SET;
111:
112: END FND_FORM_CUSTOM_RULES_PKG;