DBA Data[Home] [Help]

APPS.PSP_AUTO_PKG dependencies on PSP_AUTO_RULES

Line 174: select null from psp_auto_rules

170: select null from psp_auto_params
171: where acct_id = X_Acct_Id;
172:
173: cursor rules_c is
174: select null from psp_auto_rules
175: where acct_id = X_Acct_Id;
176:
177:
178: BEGIN

Line 196: DELETE FROM psp_auto_rules

192: -- Delete the detail records (rules)
193: open rules_c;
194: fetch rules_c into v_Dummy;
195: if (rules_c%FOUND) then
196: DELETE FROM psp_auto_rules
197: WHERE Acct_Id = X_Acct_Id;
198: if (SQL%NOTFOUND) then
199: close rules_c;
200: Raise NO_DATA_FOUND;