APPS.FND_FORM_CUSTOM_RULES_PKG dependencies on DUAL

Line 9: ** because the individual personalization rules do not have a portable unique

5: ** Last Delete Context:
6: **
7: ** The Forms Personalization Loader (affrmcus.lct) uses a replace strategy
8: ** for upload (delete then insert) rather than the ususal merge. This is
9: ** because the individual personalization rules do not have a portable unique
10: ** key, and also for simplicity of operation.
11: **
12: ** Since there can be multiple rules per target form/function/rule key
13: ** combination, we must only delete the data for a particular context

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