APPS.FND_FORM_CUSTOM_RULES_PKG dependencies on FND_FORM_CUSTOM_RULES_S

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