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;