370: raise no_data_found;
371: end if;
372:
373: -- BUG 2056313
374: -- Delete the attached records from the HZ_CREDIT_USAGES
375: -- to prevent unwanted data that has no parent. This is important
376: -- to enable the validations in the Assign Usages Rules form to
377: -- function correctly.
378:
375: -- to prevent unwanted data that has no parent. This is important
376: -- to enable the validations in the Assign Usages Rules form to
377: -- function correctly.
378:
379: DELETE from HZ_credit_usages
380: WHERE credit_usage_rule_set_id = X_CREDIT_USAGE_RULE_SET_ID ;
381:
382: /*if (sql%notfound) then
383: raise no_data_found;