889: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
890:
891: print_time ( ' Number of rows in pji rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );
892:
893: DELETE FROM pa_rbs_denorm
894: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
895:
896: print_time ( ' Number of rows in pa rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );
897:
892:
893: DELETE FROM pa_rbs_denorm
894: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
895:
896: print_time ( ' Number of rows in pa rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );
897:
898: END IF;
899:
900: print_time('VALIDATE_SET_PR_PARAMS : end.. ');