351: 'before deleting rows from itf table',
352: '');
353: end if;
354:
355: DELETE FROM fa_mass_changes_itf
356: WHERE request_id = h_request_id;
357: COMMIT;
358:
359:
593: SET status = 'FAILED_PRE'
594: WHERE mass_change_id = X_Mass_Change_Id;
595:
596: /* Delete rows inserted into the interface table. */
597: DELETE FROM fa_mass_changes_itf
598: WHERE request_id = h_request_id;
599:
600: /* Commit changes. */
601: COMMIT WORK;
637: SET status = 'FAILED_PRE'
638: WHERE mass_change_id = X_Mass_Change_Id;
639:
640: /* Delete rows inserted into the interface table. */
641: DELETE FROM fa_mass_changes_itf
642: WHERE request_id = h_request_id;
643:
644: /* Commit changes. */
645: COMMIT WORK;